Hello @lubos @Tut … URGENT
For our total accounting & Inventory solution, we have started using MANAGER exclusively. Now, about two months into usage, we have become a bit concerned in noting unusual & unexplained behavior in some instances as described below. Can you give us an explanation or solution for this?
We reproduce below screen shot of the report “Inventory Quantity by Location As at 27/07/2018” See the encircled item: M/CTN DEER 10Y & quantity: -1149 in unspecified location.
Clicking on the quantity of unspecified location, we can see the transaction displayed as below. Therein, it is seen that each of the transaction record is by “Production Order”.
Clicking on view, the date 10/0718, the “Production Order” is displayed showing quantity consumed (allocated) of each material for the Finished Item. As it may be seen, the reference item M/CTN has been consumed (used) 400, see below screen shot
Clicking on the edit in the** “Production Order”**, we can see the input made for the production. There, it may be seen, the quantity input for the carton is 400 and the location has been selected as "Production (Factory)"
Then viewing the transaction of location “Production (Factory)”, it is seen that out of 400 (used), 70 is adjusted here and the rest quantity was adjusted in unspecified location. We don’t know why and we don’t see any reason/logic for the system to put it in a different “unspecified location” when we have specifically selected a location for this transaction.
Initially, we thought that it could be due to not enough quantity being in the selected located, so the balance (excess of available quantity) was adjusted in unspecified location. However, we found out that our reasoning was wrong. As you may see in location “Production (Factory)” above, there are two entries of received quantity of item M/CTN by “Goods receipt”. Even, after the quantity being available, the system continued to adjust the used quantity in unspecified location though we had carefully selected a specific location “Production (Factory)” for each of the “Production Order”. As a result, the quantity received in that location continues to exist unadjusted.
We have other concern too but we will post here later one by one not to make confusion.
However, at this moment, I need your guidance for the above unusual transaction adjustment in a different location ignoring the selected location for that transaction.