Skip to main content

Synchronizing Retail Transactions from Store to Dynamics AX

Hi, In my previous post, I have discussed about the details of downloading data from Head Office to Retail Store. Today, let’s discuss the process of synchronizing transactions from Retail Stores to Head Office.

In a hindsight, the Async Client service in store is responsible in creating the RPF files and saving it in the Upload File Path Working folder. The RPF files of the retail transactions are created every interval as specified in the Async Client Configuration.

Running the P-Job is unnecessary to create the RPF files, what we need is a secure connection between Async Client and Async Server every upload interval. Basically, the P-Job is for importing the transactions from the Upload Working Folder to Dynamics AX.

So how does the Async Client know which record to include in every creation of RPF files?


In AX 2012 R3, the Channel Database is maintaining the table called crt.TABLEREPLICATIONLOG. This table contains the following field:

FIELD
PURPOSE
UPLOADSESSIONID
This is the session id that will be used when importing the transactions to Head Office. This is also the field that you may use to identify the created RPF file.
TABLENAME
All tables that must be sent from Retail Stores to Head Office is listed here.
FILTERFIELDNAME
This is used to identify which records did the Async Client already created. This is usually REPLICATIONCOUNTERFROMORIGIN. You should be able to see this field in every table that must be sent to the Head Office.
FILTERMIN
This is the minimum value of the field FilterFieldName.
FILTERMAX
This is the maximum value of the field FilterFieldName.

So basically, this the TABLEREPLICATIONLOG table contains the retail transaction records that has been exported already by the Async Client into an RPF file with the value based on REPLICATIONCOUNTERFROMORIGIN between  FILTERMIN and FILTERMAX .

Now, when the next upload interval kicks in, the Async Client will check what is the maximum value as specified in the FilterMax per TableName. And it will created an RPF file again with retail records between FILTERMAX value and the current MAX REPLICATIONCOUNTERFROMORIGIN of the transaction table.

This also means that if you want to recreate RPF files, you could just delete records from crt.TABLEREPLICATIONLOG or modify the FILTERMAX value per table according to the record you want to include in the RPF file.

I hope this helps!


KR, Lyka
Labels:

Comments

  1. AnonymousSeptember 20, 2019 at 2:14 PM

    Here is the investors contact Email details,_   lfdsloans@lemeridianfds.com  Or Whatsapp +1 989-394-3740 that helped me with loan of 90,000.00 Euros to startup my business and I'm very grateful,It was really hard on me here trying to make a way as a single mother things hasn't be easy with me but with the help of Le_Meridian put smile on my face as i watch my business growing stronger and expanding as well.I know you may surprise why me putting things like this here but i really have to express my gratitude so anyone seeking for financial help or going through hardship with there business or want to startup business project can see to this and have hope of getting out of the hardship..Thank You.

    ReplyDelete
  2. AIB FUNDING.March 15, 2020 at 3:41 AM

    I now own a business of my own with the help of Elegantloanfirm with a loan of $900,000.00 USD. at 2% rate charges, at first i taught with was all a joke until my loan request was  process under five working days and my requested funds was transfer to me. am now a proud owner of a large business with 15 staffs working under me. All thanks to the loan officer Russ Harry he is a God sent, you can contact them to improve your business on.. email-- Elegantloanfirm@hotmail.com.

    ReplyDelete
  3. AnonymousMay 22, 2020 at 10:54 PM

    Hello everyone, I'm Patricia Sherman in Oklahoma USA right now. I would like to share with you my experience of borrowing USD $185,000.00 to clear my bank draft and start a new business. It all started when I lost my house and I took my stuff because of the bank policy and I met some bills and some personal needs. So I became very desperate and started looking for funds in every way. Fortunately for me, a friend of mine, Linda told me about a credit company firm, I was intrigued by the fraud, but I was intrigued by my situation and had no choice but to get advice from my friend about this company. contacting them really doubted me because of my past experience with online lenders, did you know that little? '' Elegantloanfirm@hotmail.com This company has been very helpful to me and my colleague and today, thanks to this credit company, the proud owner of well-organized work and responsibilities, they smiled back at me. So if you really need to grow or start your own business, or if you really need to borrow money in any financial hardship, we recommend you find a financial development opportunity in your business today. {E-mail:} Elegantloanfirm@hotmail.com / whats-app number +393511617486.... online for credit not a victim of scam Thank you.

    ReplyDelete
  4. UnknownJune 5, 2021 at 7:56 AM

    My name is Mr. Klaus Dieter, I work for the French financial institution Crédit Mutuel with the partnership of the bank BNP Paribas, we offer you offers at an interest rate of 3% per year, to start with new projects:
    - You have unpaid debt.
    - Buying a new house.
    - buy a new car.
    - Buying a new apartment or property.
    Get personal loans, business loans.
    If you would like loans for setting up your business and project, do not hesitate to send us an email:
    bnpfinanzenhilfe@gmail.com

    Whatsapp: +4917694954827

    ReplyDelete
  5. CLARA DAVIDJune 24, 2021 at 1:56 PM

    I was searching for loan to sort out my bills& debts, then i saw comments about Blank ATM Credit Card that can be hacked to withdraw money from any ATM machines around you . I doubted thus but decided to give it a try by contacting (smithhackingcompanyltd@gmail.com} they responded with their guidelines on how the card works. I was assured that the card can withdraw $5,000 instant per day & was credited with$50,000,000.00 so i requested for one & paid the delivery fee to obtain the card, after 24 hours later, i was shock to see the UPS agent in my resident with a parcel{card} i signed and went back inside and confirmed the card work's after the agent left. This is no doubts because i have the card & has made used of the card. This hackers are USA based hackers set out to help people with financial freedom!! Contact these email if you wants to get rich with this Via: smithhackingcompanyltd@gmail.com or WhatsApp +1(360)6370612

    ReplyDelete
  6. BENITO FAUSTOMarch 26, 2022 at 2:46 AM

    Hack and take money directly from any ATM Machine Vault with the use of ATM
    Programmed Card which runs in automatic mode. email
    oscarwhitehackersworld@gmail.com
    whatsapp..+1(510)-777-9243 or call/Text him +1(510)-984-6924

    ReplyDelete
  7. MICHAELOctober 20, 2024 at 4:07 PM

    HOW TO RECOVER YOUR FUNDS/BITCOIN FROM FAKE INVESTMENT BROKER !

    Good day Audience, I want to use this great medium to announce this information to the public about JETWEBHACKERS few months back, I was seeking an online BTC investment plan when I got scammed for about $142,000. I was so down and didn?t know what to do until I came across a timeline about JETWEBHACKERS, so I reached out to him and to my greatest surprise, they were able to recover all the funds which I had previously lost to the Devils. I am so glad to share this wonderful news with you all because it cost me nothing to announce a good and reliable Hacker as JETWEBHACKERS.

    Quickly reach out to JETWEBHACKERS, on their

    EMAIL:jetwebhackers@gmail.com

    TELEGRAM: @jetwebhackers

    ReplyDelete

Post a Comment

Popular posts from this blog

Opening RPF Files

In Dynamics AX 2012, we have this concept of pushing and pulling the data for Retail between Head Office and Store. The data is written in XML form, compressed into an rpf file then saved to a working folder.  These rpf files or data packages can be opened using DDPackView.exe which is available if you install Async Server (Head Office) or Async Client (Store). You may find it in: C:\Program Files (x86)\Microsoft Dynamics AX\60\CDX\Async Server\Package If you execute it from here, you will need to specify the actual rpf file you want to check and click Convert . You might encounter an error: Could not load file or assembly 'Microsoft.Dynamics.Retail.StoreConnect.RequestHandlerManager, Version=6.3.0.0, Cuture=neutral, PublicKeyToken=xxxx or one of its dependencies. The system cannot find the file specified. Usually, I just copy the following in the same folder of DDPackView: DDPackView.exe.config Microsoft.Dynamics.Retail.EventTraceProvider.dll Microsoft
Post a Comment
Read more

Importing Retail Transactions from POS to AX

Hi, regarding the synchronization of retail transaction from stores to HO, I received some inquiries what are the alternatives when there is an issue in the store that will prohibit Async Client from sending data to HO – for example, network issues, hardware failures. Well, there is always the ever helpful DMF entities . It is limited – however, the 3 main tables needed to successfully Calculate Statements every end of day are all provided as standard entities. If you are using the demo data from Contoso, chances are you will not be able to see these entities. However, go to Data import export framework à Setup à Target entities , just click New and drop down to Entity field and select as what has been provided above. This should automatically populate the columns Staging table , Entity Class and Target . Note : If you have a legacy POS with transactions which you want to integrate with AX, you can just use this and just make sure that it will follow th
4 comments
Read more