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

Announcements

Check out the Community Spotlight Video Series
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Some Retailtransaction...
Microsoft Dynamics AX (Archived)

Some Retailtransactiontable records did not sync

(0) ShareShare
ReportReport
Posted on by B.W 505

Good day.

i have a strange issue.

A few records in the RetailTransactionTable did not sync to AX from the beginning of the month. i can see the records in the RetailtransactionSalesTrans and RetailTransactionPaymentTrans. How can i replicate these transactions to AX in order to post them?

Any help in this regard would be appreciated.

Version AX 2012 R2

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    Have you tried running the P-job?

  • B.W Profile Picture
    B.W 505 on at

    Good day.

    Yes i have, P Jobs run every 10 minutes. other transactions have replicated since then for that particular store. how do i replicate just the missing transactions.  

  • Community Member Profile Picture
    Community Member on at

    Maybe you can try "Post Statement" you can find that under Retail>Periodic>POS Posting>Post Statement. Then select the store you want to post.

  • B.W Profile Picture
    B.W 505 on at

    Good day Ducle91.

    The posting is not the problem.

    the problem appears to be that not all information for certain transactions for that particular day has replicated correctly. i can see information regarding the particular transactions in the RetailtransactionSalesTrans and RetailTransactionPaymentTrans tables but not in the RetailTransactionTable.

    i would like to know how to replicate the missing data in the RetailTransactionTable.

  • Rodolfo Recalde Profile Picture
    Rodolfo Recalde on at

    Hi B.A.

    Take a look in incident  3211092 - Transactions are not getting pulled to store HQ in LCS:

     

    MITIGATION

    How does Async Client know what records to upload during a P job?

    In the channel database the following table is checked for each table:

    SELECT ISNULL(MAX(FilterMax), 0) FROM crt.TABLEREPLICATIONLOG WHERE TABLENAME='ax.RETAILTRANSACTIONSALESTRANS' AND FILTERFIELDNAME = 'REPLICATIONCOUNTERFROMORIGIN'

    This check is done with all the tables that is sent to the HQ.
    So one thing you could do is to force the Channel Database into thinking that the records haven’t been uploaded to Async Server. If that table was cleared out it would “reset” the channel database and it would re-upload all records into a new RPF file.  This should be OK since any duplicate transactions would be ignored by AX.

    Follow this steps:


    1. Stop the AsyncClient in the StoreDB machine
    2. Make a backup of the Channel Database
    3. Delete records from the table crt.TABLEREPLICATIONLOG
    4. Start the Async Client
    5. Run the P-job

     

    3211092 Transactions are not getting pulled to store HQ

     

    See this Links:

    https://community.dynamics.com/ax/f/33/p/218402/586395

    https://community.dynamics.com/ax/f/33/t/212770

    https://community.dynamics.com/ax/f/33/t/147643

     

    I Hope this Helps!

    Regards,

    Rodolfo Recalde.

     

  • B.W Profile Picture
    B.W 505 on at

    Good day Rodolfo.

    Thank you for your reply. Where is this crt.TABLEREPLICATIONLOG table?

    what is the Channel Database?

    i have checked the AX database and the POS_Msg database.

    could i just set the replication counter to 0 for the particular table in AX? would that replicate everything in the table up to AX again?

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    Hi,

    crt.TABLEREPLICATIONLOG will be available in store database. This table wont be available in AX and Message database. Rodlfo is asking you to check in Store (Channel) database.

    Sridharan J

  • Rodolfo Recalde Profile Picture
    Rodolfo Recalde on at

    Channel DB is in the store. Sridharan Jeyaram said.

    For now, just take the step by step of the incident 3211092 in LCS.

    Do not change the replication counter.

  • B.W Profile Picture
    B.W 505 on at

    Good day Sridharan and Rodolfo.

    Thank you for your response. i do not have a table like that in the store DB.

    when i run the script against the store DB, i get 'Invalid object name'

    We are using AX 2012 R2.

  • Rodolfo Recalde Profile Picture
    Rodolfo Recalde on at

    Sorry, this procedure is only for R3 version.

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

Check out the Community Spotlight Video Series

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