Announcements
Hi,
I am looking for the entity that gets the data from the table CustInvoiceJour.
I tried Customer invoice journal line and header but it does not contain the data I am looking for. I am looking for the manual invoices.
I also know there is a composite entity Customer invoice journal, but every time I try to export it to check, I get an xml.
Thanks
Astrid
Hi Astrid,
Could you please elaborate on what you mean by manual invoices?
I went into account receivables module and then I went into Invoice journal. (I am not sure where to find all the invoices). And I selected invoices that started with FTC (which I imagine is something used only in our company). When I checked where the data came from, it was from the table CustInvoiceJour. So I look for the tables in the browser and I found the entities customer invoice journal line and header. I exported to see if I can find the data I am looking for, but it is not there.
You can use SalesInvoiceHeaderV2Entity (Sales invoice headers V2) and SalesInvoiceLineV2Entity (Sales invoice lines V2).
You should be able to find the records in these entities.
Also, about using the composite entity, it is true that you will get an xml when you export it. XML is the only supported format for composite entities.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 341 Most Valuable Professional
CU10121822-0 312
André Arnaud de Cal... 262 Super User 2026 Season 2
