Remaining quantitty

Mahak

Hi!! In Which circumstances remaining quantity and the invoiced quantity are different.

Please reply.. waiting for your reply

Regards
Mahak

DenSter

I'd say they are always different, unless you've invoiced exactly half of the original quantity.

navuser1

In which Table ?

Mahak

In item ledger entry

DenSter

navuser1 wrote:

In which Table ?

You tell me. Are you looking at purchase orders? Sales orders? Item Ledger?

Mahak

In the item ledger entry (there is both remaining quantity and invoiced quantity).

DenSter

When you run the ILE table, you can press F1 while your cursor is in either one of this fields, and this explains how to interpret the value and how they are populated.

Try it yourself. Create a positive and a negative adjustment, post it, and see what happens with the field values in the ILE. Create a purchase order and receive it. Then post a partial invoice, and check the ILE. Then invoice the remaining quantity and check again. Do the same with a sales order.

navuser1

If remaining quantity is greater than zero in ILE table that's mean the Line is still Open
And the Line Entry / remaining quantity is still open to consume or sale.

The entry is made from Purchase/Output Journal/Sales Return or any Journal that increase the Inventory.