Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX (Archived)

Tables affected by creating retail statement and posting it.

(0) ShareShare
ReportReport
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,597 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!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,445 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans