I'm trying to write a guide on how to read the inventory transactions reports, and I'm stuck on PCOUNTADJ transactions.
For example, here's an entry for a physical count and reconciliation in the Inventory Adjustments Transaction report from last year:
| Item: |
100019 |
Description: |
Aerator, 287C, 15/16" ID, 400020, STK |
| Trans Type |
Date |
Qty |
Old Balance |
New Balance |
Physical Count |
| RECBALADJ |
Sep 27 14:51:22 2023 |
-1 |
8 |
8 |
7 |
| PCOUNTADJ |
Sep 27 14:14:25 2023 |
-4 |
8 |
8 |
7 |
I can see that for RECBALADJ transactions, curbal is the item count before the physcnt and the quantity is the change in the item count that caused the reconciliation. (Although I think Old Balance and New Balance as presented are confusing at least.)
But for PCOUNTADJ I can't figure out the relationship between quantity, curbal, and physcnt. How does a change of -4 come out of those numbers? I have to think that it's calculating from some previous balance or transaction, but I can't figure out which. Help?
Thanks.
#EndUser#EverythingMaximo#Inventory------------------------------
Robert Goff
Xanterra Travel Collection
------------------------------