Duplicate Order Check – Unique Reference IDs
Enabling the system to verify a unique reference ID upon receipt of an external data exchange provides an additional layer of data integrity, minimizing order duplication.
Enable this Feature
-
Go to the Sales Orders workspace.
-
Select Sales Orders Preferences, under the Preferences menu.
-
Go to the Order Uniqueness section.
-
Select the Unique External Reference Number checkbox.
-
Select the screen acronym(s) in the Order Types drop-down field. This enables the External Reference Number field to display on selected screens in Acumatica.
-
To view the list of order types, go to the Sales Orders workspace, then click Order Types. The Order Types screen will appear listing all available order types.
-
Custom Order types may be created using one of the default order descriptions, enabling the recently created Order type to behave as a default type.
-
-
-
Click Save.
The system will verify a unique customer order number during the import process from the merchant site.
How to Apply
-
Create a Sales Orders on an eCommerce site.
-
Make sure the eCommerce site is configured via an Acumatica Connector.
-
If using the BigCommerce or Shopify Connector:
-
Go to the Connector’s Exchange screen.
-
Run the import orders exchange, for the eCommerce store.
-
Go the Request Log screen to verify all imported sales orders were assigned a unique reference ID.
-
Magento Connector users can validate the unique external reference IDs on the eCommerce site.
Unique customer order numbers are generated in the eCommerce site upon the completion of an order.
-
The customer’s unique order number is sent to Acumatica during the integration process to identify the order as unique.
-
The customer’s order number from the eCommerce site is received and displays on a customer’s sales order screen.
-
For non eCommerce merchants (B2B), this unique order number is the same as the purchase order number.
-
External reference ID’s can be verified on the Sales Order screen.
-
Open a Sales Order number in the Request Log, then view the External Reference field.
-
This field will only be populated after a data exchange.
-