Hello Adrian,

Understanding the Challenge

• The invoice_id field in payment accounting entries doesn't directly display the invoice sequence number. It primarily shows the ID for accounting entries originating from customer invoice journals.

Possible Solutions & Approaches

1. Direct Database Query (Technical)
   • If you're comfortable with direct database queries, you could construct a query that joins the payment accounting entry table with the invoice table.
   • The goal is to link the payment to the invoice using the relevant relational fields (likely involving journal entries and reconciliation models).
   • Once linked, you can retrieve the invoice sequence number.
2. Odoo Studio (If you have Odoo Enterprise)
   • Odoo Studio allows you to customize models and views.
   • You might be able to add a computed field to the payment accounting entry that fetches and displays the related invoice sequence number. This would likely involve writing a Python function to perform the lookup.
3. Custom Report (Potentially the most flexible)
   • Create a custom report in Odoo.
   • Within the report definition, you can define the relationships between payments and invoices.
   • This allows you to include the invoice sequence number in your exported report.

Key Considerations

• Reconciliation: The link between a payment and an invoice is often established through the reconciliation process. Make sure to consider the reconciliation models in your approach.
• Journal Entries: Understand how journal entries are created and linked in Odoo's accounting modules.
• Odoo Versions: The exact table names and field names might vary slightly depending on your Odoo version.

Example Scenario (Conceptual - Requires adaptation to your specific Odoo setup)

Let's imagine you want to create a custom report. The report would:

1. Start with payment journal entries.
2. For each payment, identify the reconciled entries.
3. Trace those reconciled entries back to the original customer invoice.
4. Extract the invoice sequence number from the customer invoice.
5. Include all this information in your report.

Important Note: This is a somewhat complex task that might require technical expertise in Odoo development, particularly if you choose the database query or custom report approach. If you're not comfortable with these approaches, consider consulting with an Odoo developer or partner.

🚀 Did This Solve Your Problem?

If this answer helped you save time, money, or frustration, consider:

✅ Upvoting (👍) to help others find it faster

✅ Marking as "Best Answer" if it resolved your issue

Your feedback keeps the Odoo community strong! 💪

(Need further customization? Drop a comment—I’m happy to refine the solution!)