Please add field to POPORL Table to inform Last Receipt Date and Last Invoice Date, because we need create KPI fron vendor how long we receipt the item compare to PO from Vendor.
Now we have information only from PO Header (POPORH) but not for detail
Example
PO001 --> 1 January 2024
Item A 10 PCS
Item B 10 PCS

PO Receipt
RCP001 --> 10 January 2024
Itam A 10 PCS

PO Receipt
RCP001 --> 15 January 2024
Itam B 10 PCS

Now we have data Last Receipt 15 January 2024, we can't get last receipt for detail

Comments

  • Idea lodged date - August 2024