Skip to main content
Question

Consignment Process using Sales Order (Type: TO) Integration with SPS Commerce EDI

  • September 30, 2026
  • 1 reply
  • 28 views
Freshman I

Hi everyone,

We have a consignment sales process where, upon receiving a PO from a consignment customer, we manually create a Transfer Order (TO) sales order in Acumatica. This process transfers inventory from our warehouse to the consignment warehouse.

Subsequently, every two weeks, we create a regular sales order based on the actual quantities sold during that period.

We are currently integrating with SPS Commerce EDI and would like incoming customer POs to automatically generate TO orders in Acumatica. However, we have encountered an issue: the “Destination Warehouse” field on the TO header is mandatory, and the EDI-generated order does not populate this value.

 

Has anyone implemented a similar consignment process with Acumatica and SPS Commerce EDI? If so:

How did you handle the Destination Warehouse requirement?
Were you able to configure it through standard functionality?
Or did it require customization on the Acumatica side?

 

Any insights or recommendations would be greatly appreciated.

Thanks in advance!

1 reply

Freshman I

This reply has been created with the help of AI, and I've checked it against the docs and earlier threads.

From earlier threads here (2023, and again this January), there's nothing out of the box that defaults Destination Warehouse by order type, so there are two places to fill it.

1. On the way in. Each 850 from a consignment customer carries a ship-to. If each ship-to maps to one consignment warehouse, ask SPS whether their Acumatica connector can map ship-to to Destination Warehouse for that trading partner when it creates the TO. That keeps Acumatica standard.

2. In Acumatica. A small customization that defaults SOOrder.DestinationSiteID on TO orders from the customer, for example from a "Consignment warehouse" field you add to the customer or its location, using FieldDefaulting. Then the EDI order saves with it filled.

I don't think a business event alone will do it, since it fires after a save and the order can't save without the field.

For the second half, check whether the customer sends EDI 852s (product activity data). SPS describes retailers using them to report sales so the supplier can invoice in scan-based trading, which is basically your consignment setup. If they do, the biweekly sales order could come from the 852 instead of being keyed.

Terms & ConditionsAccessibility statement
About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved