My SO has already fully invoiced (1500 pieces), but when I check invoice journal, one invoice line have 2 transactions (1 sold (1500 pieces); 1 deduction (1500 pieces). I don’t know how to reverse deducted transaction since my on hand report also deduct 3000 pieces for this SO.
Please help me, since we have an counting inventory by 15th of August.
My SO is fully invoiced. Status of all SO line is invoiced. When I check in inventory transaction; this SO still have 1 deducted transaction with quantity 1500 piece like I described above. I don’t know how to reverse this transaction since SO is fully invoiced. The deducted quantity also counted on my on hand.
In inventory transaction, the SO still have one line have physical value but not financial value. It seems that this line is just delivered not invoiced. But in fact, my SO is fully invoiced; and in my packing slip journal and invoice journal, this line doesn’t exist. That’s why I cannot reverse this transaction. But it deducted my inventory
You can see in my screen shot the SO is fully invoiced.
I checked the quantity on order lines, I saw that inventory quantity is 3000 pieces and invoice remainder is 1500 pieces (it should be inventory quantity: 1500 pieces and invoice remainder: 0 pieces). How could I invoice the remainder because the order line status is invoiced.
Not quite the quantity “tab” but it gives us the information causing the issue seeing that it is driven from the sales line itself. I presume the quantity tab would also show 3000 delivered, but you said on the dispatch/shipment note there was one for 1500? So any customizations in this area at all - shipping/invoicing, becayse I am pretty sure I could not replicate as standard an invoiced line with an invoice remainder >0
Out of curiosity i tried replicating this and succeeded. Could you confirm, by chance you are seeing any over delivery percentage for the specific Line.
@Adam - Seems like during the packingslip update “Line details” has a fieldgroup “inventory” under which the “quantity” field is editable. Probably in that field, user gave 3000, it created inventory trans of 3000 but packing slip got updated for 1500.
Isn’t it a bug because SO status is invoiced and no further posting can be done whereas Invoice remainder has some value which gives wrong information about inventory.
I am wondering what will happen if we manually update invoice remainder to 0 or is there any other ay to update inventtrans.
May you explain your solution more detail? Because I already reversed, but the 1500 deducted transaction still pending. I thought inventory journal resolution (movement, adjustment…); but I don’t know whether it will affect inventory cost or not.