Skip to main content

Notifications

Microsoft Dynamics AX (Archived)

Tables affected by creating retail statement and posting it.

Posted on by Microsoft Employee

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

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Tables affected by creating retail statement and posting it.

    Thank you  very much Oksana and Ievgen !

  • Verified answer
    Oksana Kovaliova Profile Picture
    Oksana Kovaliova 3,595 on at
    RE: Tables affected by creating retail statement and posting it.

    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

  • Verified answer
    Mea_ Profile Picture
    Mea_ 60,278 on at
    RE: Tables affected by creating retail statement and posting it.

    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.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,219 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,056 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans