Skip to Content
0
Former Member
Dec 05, 2011 at 06:31 AM

Inventory Posting List Is Listing 1 Transaction As 2 Separate Transactions

49 Views

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