Acumatica – Sales Order History Data From ERP to CIMcloud

Overview

CIMcloud syncs all sales orders to the CIMcloud platform regardless if the order was placed through the website or entered into Acumatica manually or through other sources. As part of the initial integration CIMcloud will work with the client on any specific sales order types that are requested to not sync to the CIMcloud platform. When an order is placed on the CIMcloud platform the CIMcloud order record is not directly viewable by the end user, they will see the order record once it has synced back from Acumatica. Any modifications made to the order will sync to the CIMcloud platform and be viewable to the end user.

Sales Order History Data Synced to CIMcloud

There should be no reason to manually update sales order history data on the CIMcloud platform and all data should sync from the ERP. Below are the fields in Acumatica and the corresponding display on the CIMcloud platform.

Acumatica

CIMcloud

 

1. Order Number – The order number from Acumatica it does not include the order type
2. Order Status – The order status – We currently only set to Open, Complete, Backordered, or Cancelled.
3. PO # – This is the Purchase Order Number on the website and Customer Order Number in Acumatica
4. Customer Number – Customer number
5. Order Total – Order Total amount
6. Order Date– Order Date
7. Order Header Comment – Order Comment
8. Terms Code – Terms code. Currently this is the code and not the full description
9. Payment Type – Payment type
10. Product Total – The line/product total for the order
11. Tax Total – The tax total for the order
12. Shipping Total – The shipping total for the order
13. Billing Address – the billing address from the order
14. Shipping Address – The shipping address from the order
15. Item # – The itemcd (sku)
16. Item Description – Item description
17. Quantity – The full order quantity
18. Status – This show the qty open, shipped, and/or backordered
19. Unit Price – We sync over the line discounted price if the a line level discount was applied to the order line
20. Line Total – We sync over the discounted line amount if line level discounts are being used.