Reference Agreement Lines When You Import Sales Orders

Reference an agreement line on an order line when you import a sales order through REST API or FBDI.

Use this feature when you need to apply a different price for the same item. For example, apply a different price according to date or to the physical location where you sell the item.

You can use the new Sales Agreement Line Identifier attribute or Sales Agreement Line Number attribute on the order line to specify the agreement line that you want to use on the order line.

Assume you sell frozen food and you need to adjust price according to the warehouse on the order line. You need to keep that food frozen during transit, so the longer the transit time, the higher the price. To meet this need, go to the Contracts work area, then create a sales agreement and give it a number, such as 123675. Add two agreement lines and specify different pricing for each one:

Attribute	Agreement Line 1	Agreement Line 2
Number	Mochi 1	Mochi 2
Type	Product	Product
Name	Mochi Ice Cream	Mochi Ice Cream
UOM	Each	Each
Adjustment Type	Markup Percent	Markup Percent
Adjustment	5	10
Start Date	6/1/25	7/1/25
End Date	6/1/25	7/1/25

Next, reference the agreement lines when you import the order line. For example, use these values on the DOO_ORDER_LINES_ALL_INT worksheet of SourceSalesOrderImportTemplate when you import through FBDI:

Source Transaction Line Number	Product Number	Product Description	Ordered UOM	Sales Agreement Number	Sales Agreement Line Number
1	MOCHI_123	Mochi Ice Cream	Each	123675	Mochi 1
2	MOCHI_123	Mochi Ice Cream	Each	123675	Mochi 2

Or if you use the Sales Orders for Order Hub REST API:

Line 1

  "SourceTransactionLineNumber" : "1",
  "ProductNumber" : " MOCHI_123",
  "ProductDescription" : "Mochi Ice Cream",
  "OrderedUOM" : "Each",
  "AgreementNumber" : "123675",
  "AgreementLineNumber" : "Mochi 1",

Line 2

  "SourceTransactionLineNumber" : "2",
  "ProductNumber" : " MOCHI_123",
  "ProductDescription" : "Mochi Ice Cream",
  "OrderedUOM" : "Each",
  "AgreementNumber" : "123675",
  "AgreementLineNumber" : "Mochi 2",

Note

You can import through the SalesOrdersforOrderHub REST API, SalesOrdersforOrderHubRequests REST API, or FBDI with REST API. See Guidelines for Using REST API, Web Services, and FBDI to Integrate Order Management.
You can reference an agreement line on an order line or an unreferenced return line.
For more, see Set Up Sales Agreements in Order Management.