Question

Logic to retrieve current qty in supplier agreement

  • 29 June 2023
  • 1 reply
  • 32 views

Badge +1

Hi all,

This issue is related to Supplier agreement.

In the supplier agreement report, part details there is a field named Current Qty as shown in below screenshot.

I calculated the sum of quantities in purchase order lines by using the same part no, site, agreement no, agreement line no (all orders lines except cancelled lines). But the sum I got from there is not equals to the current qty in the supplier agreement report. There is a difference of 4160.

 

I checked the valid period of supplier agreement and created date of po lines as well. There I identified that all PO lines are within the valid period.

 

 

 

the current qty of the supplier agreement and the sum of the quantities of the po lines. But the previous difference of 4160 remains the same.

 

Should these current qty and summation in PO Lines equal?

 

Customer needs to know exact logic used to retrieve current quantity in supplier agreement.

 

If anyone has an idea on this, it would be a great help.

Thanks


1 reply

Userlevel 7
Badge +18

Hi, 

This may get better attention if this was entered in the procurement area. This not Finance. 

 

Reply