Skip to main content
Question

Shortage Date API

  • September 27, 2023
  • 3 replies
  • 39 views

Forum|alt.badge.img+8
  • Sidekick (Customer)
  • 21 replies

Does anyone know of an existing API in IFS that can be used to calculate a shortage date for inventory? 

 

Thanks!

3 replies

PRODQ
Superhero (Customer)
Forum|alt.badge.img+17
  • Superhero (Customer)
  • 474 replies
  • September 27, 2023

Can I ask what you mean by ‘shortage date’?

 

Linda


Forum|alt.badge.img+8
  • Author
  • Sidekick (Customer)
  • 21 replies
  • September 27, 2023
PRODQ wrote:

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. 


PRODQ
Superhero (Customer)
Forum|alt.badge.img+17
  • Superhero (Customer)
  • 474 replies
  • September 28, 2023

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


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings