Hello everyone,
I trying to create the PO Receipt Report on BAQ. One of the columns I want to create is the PO’s receipt quantity column. This column must be the cumulative quantity up to the relevant receipt. But, the receipt quantity in the DB field will continue to be updated each time it is received in the future.
I think I need to create a calculated field for the accumulated PO receipt quantity on the receipt date. Even if additional receipts are made for this PO in the future, a field is needed so that the cumulative receipt quantity on that date does not change.
Can anyone please help me on how to create this calculated field?
Thanks in advance!