Dynamics AX POS Data Missing ,Step to Get it back to AX HQ from POS

Issue Description : 

Dynamics AX POS Store transaction is Missing only for 2 days  In AX HQ . all other Data are fine.

Data may be missed Pulling due Connectivity Loss or disaster at Store and many more reason 

Issue Deep dive

The goal is to check if there is a way to retrieve transactions for this missing specific day, data in HQ which is only available in POS 

Solution :

1-     Step to grab all available transactions from store DB (not a specific day) which still helps in this situation, since AX HQ will re-apply transactions with no duplicates if there are transactions already available, below what you need to do

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:

o    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 the table content crt.TABLEREPLICATIONLOG

4.       Start the Async Client service

5.       Run the P-job

As said before, it is important that you run through this steps first in a test environment to prevent any possible side effect