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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Tables affected by cre...
Microsoft Dynamics AX (Archived)

Tables affected by creating retail statement and posting it.

(0) ShareShare
ReportReport
Posted on by Community Member

Hello Everyone !

I am working on a task related to retail statement. 

I need to track down all the tables that get affected by creating the retail statement.

and also the tables that get affected when we post a retail statement.

Any idea will be appreciated.

By affecting the table i mean data insertion deletion or updating.

*This post is locked for comments

  • Verified answer
    Mea_ Profile Picture
    Mea_ 60,286 on at

    Hi Muhammad Gulfam,

    You can trace retail statement posting with trace parser technet.microsoft.com/.../hh272149.aspx

    https://blogs.msdn.microsoft.com/axinthefield/dynamics-ax-trace-parser-part-3/

    Then you can review trace and see what tables were used and affected by posting.

  • Verified answer
    Oksana Kovaliova Profile Picture
    Oksana Kovaliova 3,597 on at

    Hi Muhammad,

    I would recommend to have a look at AX classes responsible for statement processing.
    This will help you to understand what tables are affected and also understand the logic of statement processing.

    Statement posting is quite complex process, that includes the creation and posting of sales orders, payment journals, transferring of inventory transactions, etc.

    Statement calculate classes:

    1. RetailStatementCalculate

    Statement clear classes:

    1. RetailStatementClear

    Statement posting classes:

    1. RetailStatementPost
    2. RetailStatementPostSalesOrders
    3. RetailStatementPaymentJournal
    4. RetailStatementSalesOrderCreator

    Regards,
    Oksana

  • Community Member Profile Picture
    Community Member on at

    Thank you  very much Oksana and Ievgen !

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

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans