|
How is the Total Received calculated for each receipt line item?
The Total Received represents the total number of items or total amount received for each line item. Your site uses the following calculation to determine the Total Received value:
Total Received = Accepted + Rejected
This is true if your Order has only one receipt, if your order has multiple receipts, then the Total Received will be calculated as follows:
Total Received = Previously Accepted + Previously Rejected + Accepted + Rejected
This calculation is performed for each line item.
If you're attempting to perform negative receiving, note that it's can be done on the Accepted, or Rejected. This will depend on which of these values you need to reverse.
Keep in mind that Rejected doesn't mean the negative of Accepted. Use the below table for better understanding of how the calculation overlaps among multiple receipts:
Receipt Number | Previously Accepted | Previously Rejected | Accepted | Rejected | Total Received |
RC1 | 0 | 0 | 10 | 5 | 15 |
RC2 | 10 | 5 | 0 | -5 | 10 |
RC3 | 10 | 0 | -3 | 0 | 7 |
RC4 | 7 | 0 | -7 | 0 | 0 |
Note that the Previously Accepted & Previously Rejected are the sum of all that was Accepted or Rejected on the previous Receipts, positive & negative. e.g. RC3 has the Previously Accepted set as 10 + 0 = 10, and Previously Rejected set as 5 + (-5) = 0 (zero). While RC4 has the Previously Accepted set as 10 + 0 + (-3) = 7, and Previously Rejected set as 5 + (-5) + 0 = 0 (zero).
Purchasing > Receiving