Announcements
Hello Community,
Might you please explain to me how and when records are created in CustTransOpen?
Kind regards,
Jihane
*This post is locked for comments
Hello jihane,
Do you just need to create a record in this table through a transaction in the AX client or is it something else that you are looking for?
To create a transaction in the CustTransOpen table you can e.g. post a free text customer invoice or a sales order invoice.
All the best,
Ludwig
"Customer Open Transitions" refer to un-paid customer invoices. Irrespective of source, whether they came via Free text invoice or via sales invoice.
Based on customer Payment Terms & Discount, number of records of records are created in CusTransOpen Table.
In short CustTransOpen table contains transaction information for customers which are not settled yet
Hello Ludwig,
I want to understand how records are generated in CustTransOpen.
Now I know, thank s to you and Sohaib, that records are automatically created in custTransOpen, when an invoice is created and not paid yet
Is there a data Entity that references the CusTransOpen Table? I only have access to Odata and am looking to build a report of Open Invoices.
CustTransOpen contains one or more records for all transactions in CustTrans that are not. completely settled against other transactions.
To determine whether a CustTrans record is open.
A reason for separating the CustTransOpen table from CustTrans table is that its possible for custTransOpen to have multiple records for the same CustTrans table in case of Payment schedule on customer invoice. Another is that this separation means that search is faster for open transactions, or total balance of the client.
The relation between CustTransOpen and CustTrans is the RefRecId in CustTransOpen that is a foreign key to the RecId of the related CustTrans.
The invoice and the actual settle amount are referred from the table CustTransOpen (from the relation CustTrans). So these fields have the values of TableId and RecId of CustTransOpen. The field Balance01 denotes the amount that is being settled. If there is partial settlement, then this field has the value of settled amount.
Hi jihane,
Table CustTransOpen is created by method Classes/PaymSchedCalc/createCustVendTransaction according to payment schedule.
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.
Jump in, show your community spirit, and win prizes!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
CP04-islander 21
dekion 4
Virginia99 4
