web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Export of transactions...
Microsoft Dynamics AX (Archived)

Export of transactions and open transactions

(0) ShareShare
ReportReport
Posted on by jihane 1,264

Hello community,

I want to export Customer transactions from AX Database

Would it be better to use the ledger journal trans table and then find the referenced CustTrans and CustTransOpen records, or should I extract data directly from CustTrans and CustTransOpen and completly neglecting the ledger Journal trans Table?

which approach is more suitable and correct?

*This post is locked for comments

I have the same question (0)
  • jihane Profile Picture
    jihane 1,264 on at
    RE: Export of transactions and open transactions

    Thank you Sohaib for your answer. this gives me hints for better understanding of how custTrans and CustTransOpen are related

  • Verified answer
    Sohaib Cheema Profile Picture
    Sohaib Cheema 48,590 User Group Leader on at
    RE: Export of transactions and open transactions

    well in CustTrans there ate two fields 1) AmountCur means transation amount in currency and other is SettledAmountCur

    Both of these can identify if transaction has been fully paid of still something remaining

    have a look at next two methods

    \Data Dictionary\Tables\CustTrans\Methods\remainAmountMST

    \Data Dictionary\Tables\CustTrans\Methods\remainAmountCur

    also you can know if a transaction if fully settled or still open

    \Data Dictionary\Tables\CustTrans\Methods\transOpen

    here in above method you will notice an important point that DueDate. Each Invoice has due date based on payment terms such as N30 i.e. to be paid in next thirty days. so payment become due/mature based on that date. you can keep this parameter empty or dateNull()

    From Functional Point of view you can look at below path to know which invoices are still open and how much is remaining

    USMF/Accounts receivable/Common/Customer invoices/Open customer invoices

    if you want to get list of all Customer Transactions you can open form named as Transactions, which can be assed from Customer Master, It can show you open closed all kind of transactions

  • jihane Profile Picture
    jihane 1,264 on at
    RE: Export of transactions and open transactions

    Thank you Sohaib,

    How can I tell Records from CustTrans that are not settled yet?

    I want to extract transactions not yet settled so I believ i should extract records from custTrans which are referenced in CustTransOpen?

    P.S: I am Using ax 2012 R3

  • Sohaib Cheema Profile Picture
    Sohaib Cheema 48,590 User Group Leader on at
    RE: [Dynamics ax 2012 ] export of transactions and open transactions

    Exporting CustTrans should be enough.

    Itself CustTransOpen is nothing. CustTransOpen records are kids/children of CustTrans. CustTransOpen(unsettled customer trans) are meaningless without CustTrans(origin)

    Ledger represents financial impact or voucher transactions related to customer transactions. so overall it depends what you want to show exactly in your export. don not include LedgerJournalTrans if you don't need to show financial posting or subLedger

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.

Helpful resources

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Guy Terry Profile Picture

Guy Terry 2 Moderator

#1
Martin Dráb Profile Picture

Martin Dráb 2 Most Valuable Professional

#1
Community Member Profile Picture

Community Member 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans