I'm trying to create a batch job that collect orders from my website (Magento) and automatically create them (using TSQL) in RMS database.
The batch job contains script that collect data from a CSV file and execute some queries to insert data into below tables:- Order- OrderEntry
What I need to do is doing exactly the same as creating an order on RMS UI but it appears that it is not what I expected especially when opening Report to see Sales summary by Cashier, Customer ... it doesn't show up at all. The only thing showed up correctly is the Item Movement History.
Is there any information that I missed? Do all tables above enough for creating an order (assuming that I already have all order information such as sku, price, qty ordered, tax, grand total, sub total)?
P/s: I'm using Microsoft Dynamic Retail Management System version 2.0
You can achieve this by integrating RMS and Magneto.
Hi, if you are familiar with sql server profiler, you can get the snapshot of how RMS creates a purchase orders (update and insert in tables).
Business Applications communities