Skip to main content
Solved

Inventory Turnover displayed in Purchase Order or Requisition

S
Sidekick (Customer)
Forum|alt.badge.img+6
  • sibouc
  • Sidekick (Customer)
  • 10 replies

Hello all,

@pekkan asked an interesting question 2 years ago which was never answered, and for which I’d like feedback on as well.

“I was wondering whether somebody has good tips on how to provide our buyers with Inventory turnover figure to purchase requisition line to help them sanity check the future PO line and planning data in general. 

I’ve been looking at API’s and available views but a good candidate for the information source has not popped up… 

This information would be really helpful for reducing the inventory levels in long term.”

 

I totally agree this would be great information, either in the Purchase Requisition (PR) or directly within the Purchase Order (PO). Since “Inventory Turnover Rate” runs as a job in IFS, could IFS be set up to pull on past Turnover results to display for a part in a PR or PO?

Best answer by Lane

It would just a standard custom field, it’s nothing horribly complex. It’s going to be something like what’s below for the purchase req lines. You would remove the ifsapp. and add v. in front of the columns from the base view, such as contract, requistion_no, line_no, release_no. The section that is “2022,12,2023,1” is the period range for the turnover calculation.

 

DECODE(NVL(ifsapp.Inventory_Part_Period_Hist_API.Get_Avg_Inventory_Value(CONTRACT, ifsapp.purchase_req_line_part_api.get_part_no(requisition_no,line_no,release_no), '*', 2022, 12, 2023, 1), 0),
       0, 0,
       NVL(ifsapp.Inventory_Part_Period_Hist_API.Get_Issued_Value(CONTRACT, ifsapp.purchase_req_line_part_api.get_part_no(requisition_no,line_no,release_no), '*', 2022, 12, 2023, 1), 0) /
           DECODE(NVL(ifsapp.Inventory_Part_Period_Hist_API.Get_Avg_Inventory_Value(CONTRACT, ifsapp.purchase_req_line_part_api.get_part_no(requisition_no,line_no,release_no), '*', 2022, 12, 2023, 1), 0),
           0, 1,
           ifsapp.Inventory_Part_Period_Hist_API.Get_Avg_Inventory_Value(CONTRACT, ifsapp.purchase_req_line_part_api.get_part_no(requisition_no,line_no,release_no), '*', 2022, 12, 2023, 1)))

 

View original
Did this topic help you find an answer to your question?

3 replies

L
Hero (Customer)
Forum|alt.badge.img+9
  • Lane
  • Hero (Customer)
  • 39 replies
  • July 11, 2023

The Inventory Turnover Rate on the Inventory Turnover Rate per Period screen is a calculated field. You could use that same calculation in a custom field on the po req lines or po lines. The only challenge may be feeding the calculation the from/to year & period.

S
Sidekick (Customer)
Forum|alt.badge.img+6
  • sibouc
  • Author
  • Sidekick (Customer)
  • 10 replies
  • July 11, 2023
Lane wrote:

The Inventory Turnover Rate on the Inventory Turnover Rate per Period screen is a calculated field. You could use that same calculation in a custom field on the po req lines or po lines. The only challenge may be feeding the calculation the from/to year & period.

It means it needs to be programmed by our support team, there’s no easy inclusion of a new field into the PO/PR table, correct?

L
Hero (Customer)
Forum|alt.badge.img+9
  • Lane
  • Hero (Customer)
  • 39 replies
  • Answer
  • July 12, 2023

It would just a standard custom field, it’s nothing horribly complex. It’s going to be something like what’s below for the purchase req lines. You would remove the ifsapp. and add v. in front of the columns from the base view, such as contract, requistion_no, line_no, release_no. The section that is “2022,12,2023,1” is the period range for the turnover calculation.

 

DECODE(NVL(ifsapp.Inventory_Part_Period_Hist_API.Get_Avg_Inventory_Value(CONTRACT, ifsapp.purchase_req_line_part_api.get_part_no(requisition_no,line_no,release_no), '*', 2022, 12, 2023, 1), 0),
       0, 0,
       NVL(ifsapp.Inventory_Part_Period_Hist_API.Get_Issued_Value(CONTRACT, ifsapp.purchase_req_line_part_api.get_part_no(requisition_no,line_no,release_no), '*', 2022, 12, 2023, 1), 0) /
           DECODE(NVL(ifsapp.Inventory_Part_Period_Hist_API.Get_Avg_Inventory_Value(CONTRACT, ifsapp.purchase_req_line_part_api.get_part_no(requisition_no,line_no,release_no), '*', 2022, 12, 2023, 1), 0),
           0, 1,
           ifsapp.Inventory_Part_Period_Hist_API.Get_Avg_Inventory_Value(CONTRACT, ifsapp.purchase_req_line_part_api.get_part_no(requisition_no,line_no,release_no), '*', 2022, 12, 2023, 1)))

 

S
1 person likes this
  • S
    sibouc

Reply


Terms & ConditionsCookie settings

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