Notifications
Announcements
No record found.
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 559 Most Valuable Professional
André Arnaud de Cal... 464 Super User 2025 Season 2
Sohaib Cheema 250 User Group Leader
