Does anyone know of an existing API in IFS that can be used to calculate a shortage date for inventory?
Thanks!
Userlevel 6
+13
Can I ask what you mean by ‘shortage date’?
Linda
Can I ask what you mean by ‘shortage date’?
Linda
From my understanding, they use shortage date as a date they will no longer have inventory available. So if they have inventory today and they look up the shortage date it could show a date of a month from now and that’s the date we can expect to run out. The date I am using currently is for sure a customization so it’s possible nothing like it exists in out of box API’s.
Userlevel 6
+13
It feels like you’d be looking to return the date when Projected hits zero? This is on the Inventory Parts Availability Planning/All tab
If it’s any help - this is from Apps9. Can you extract the date for when projected = 0?
Logical Unit: OrderSupplyDemand
View: &AO.ORDER_SUPP_DEM_EXT_TMP_VIEW
Package: &AO.ORDER_SUPPLY_DEMAND_API
FUNCTION Get_Projected_Quantity (
contract_ IN VARCHAR2,
part_no_ IN VARCHAR2,
configuration_id_ IN VARCHAR2,
date_required_ IN DATE,
order_no_ IN VARCHAR2,
line_no_ IN VARCHAR2,
rel_no_ IN VARCHAR2,
line_item_no_ IN NUMBER,
order_supp_demand_type_ IN VARCHAR2) RETURN NUMBER
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.