Table of Contents

Get available to promise (ATP) quantity

This example shows how you can create a calculated attribute which gets the avaible to promise (ATP) quantity on a particular date using the AvailableToPromise view.

In the example, you'll learn how to get the ATP quantity in a shipment order line on its required delivery date.

Note

The repository of the attributes is Logistics.Shipment.ShipmentOrderLines


10	GETOBJVALUE	EXP:20	ATTRIB:ATPBaseValue		
20	FIRST	EXP:30				
30	SORT	EXP:40	ATTRIB:FromDate	CONST:DESC
40	SELECT	REPO:Logistics.Inventory.DemandManagement.AvailableToPromise	EXP:50		
50	WHERE	EXP:80	EXP:60		
60	AND	EXP:110	EXP:70		
70	AND	EXP:140	EXP:170		
80	EQUAL	ATTRIB:ProductId	EXP:90		
90	GETOBJVALUE	INPUT:10	EXP:100		
100	GETOBJVALUE	REF:ParentSalesOrderLine	ATTRIB:ProductId		
110	EQUAL	ATTRIB:StoreId	EXP:120		
120	GETOBJVALUE	INPUT:10	EXP:130		
130	GETOBJVALUE	REF:ParentSalesOrderLine	ATTRIB:LineStoreId		
140	EQUAL	ATTRIB:EnterpriseCompanyId	EXP:150		
150	GETOBJVALUE	INPUT:10	EXP:160		
160	GETOBJVALUE	REF:ShipmentOrder	ATTRIB:EnterpriseCompanyId		
170	LTE	ATTRIB:FromDate	EXP:180		
180	GETOBJVALUE	INPUT:10	EXP:190		
190	GETOBJVALUE	REF:ShipmentOrder	ATTRIB:RequiredDeliveryDate

Explanation:

  • 10: Get the ATPBaseValue of the AvailableToPromise record returned by EXP:20
  • 20: Get the first record of the list returned by EXP:30
  • 30: Sort the list returned by EXP:40 - descending by the value of the FromDate attribute
  • 40: Select the AvailableToPromise records which are matching the clauses of EXP:50
  • 50: Filter the the records for which EXP:80 and EXP:60 are True
  • 60: Filter the the records for which EXP:110 and EXP:70 are True
  • 70: Filter the the records for which EXP:140 and EXP:170 are True
  • 80: Return 'True' if the ProductId of the AvailableToPromise record is equal to EXP:90
  • 90: Get EXP:100 from the repository of EXP:10 i.e. of the current shipment order line
  • 100: Get the ProductId of the ParentSalesOrderLine
  • 110: Return 'True' if the StoreId of the AvailableToPromise record is equal to EXP:120
  • 120: Get EXP:130 from the repository of EXP:10 i.e. of the current shipment order line
  • 130: Get the LineStoreId of ParentSalesOrderLine
  • 140: Return 'True' if the EnterpriseCompanyId of the AvailableToPromise record is equal to EXP:150
  • 150: Get EXP:160 from the repository of EXP:10 i.e. of the current shipment order line
  • 160: Get the EnterpriseCompanyId of the ShipmentOrder
  • 170: Return 'True' if the FromDate of the AvailableToPromise record lower or equal to EXP:180
  • 180: Get EXP:160 from the repository of EXP:10 i.e. of the current shipment order line
  • 160: Get the RequiredDeliveryDate of the ShipmentOrder
Suggest improvement to this page