Dear Expert,
I have not come across this situation before. I have not really sift through the database table for clues as to what can be causing this.
Just out of curiosity and I hope someone can help enlighten me on this, I have a situation as described below:-
1) A user posts a Goods Issue of 19 units for Item A.
2) When I fetch the Inventory Posting List for Item A, it lists the Goods Issue as 2 separate transactions.
E.g.
This is what the user posted:-
Goods Issue 101 --> Item A --> 19 units.
This is what is shown in the inventory posting list:-
Goods Issue 101 --> Item A --> -18 units
Goods Issue 101 --> Item A --> -1 units
Bear in mind that in the Inventory Posting list, both lines refer to the same Goods Issue document if you click on the Drill Down arrow. Opening the Goods Issue document itself confirms that there is only one line for Item A in that particular Goods Issue document.
My question is, what could be causing the Inventory Posting List report to split that 1 transaction into 2 transactions?
My client is on SAP Business One 8.81 PL00 SP04. They are also not keeping track of item costing per warehouse. In any case, there is only 1 warehouse set up in the system.
Any idea here would be greatly appreciated as my client is asking me this question but I am also at a lost as to what is causing this.
Regards,
Alvin Chong
Edited by: Alvin Chong on Dec 5, 2011 7:32 AM