Net Invoiced Quantity and ACIE

dynuser

Dear All,
I need some clariffication on Net invoiced qty in the item card and how it is releated to Adjust Cost item Entries. Today, I had an item having "NET INVOICED QTY" as -194. There were some Released production orders for that item. Then I have finished the production orders except for 10 Nos.i.e, I have 10 Nos available in Released production order. Tell me if i am wrong. After the producion order status are changed to finished production orders, the net invoiced qty should change by that qty. But even after changing the production order to finished status, there is no change in net invoiced qty.After the batch job is run, the unit cost is not updated. All the purchase invoices are posted.
I want to know where is the problem. We are using FIFO as the Costing method.
10x in advance

chengalasettyvsrao

Why your Net Invoiced qty field will show negative value. :


U purchased a item 100 PCs ( Just received only ) - so item ledger entry will update.
So Invoiced qty for that entry is Zero.

Now u sold the items from that entry 50 PCS.

So system automatically Invoiced qty for that sales entry = 50.

So in item card Net Invoiced qty field will show = - 50.


This same for Production also.

Let's u post the production that means out Put = 500

But u did not change the staus of that production order from Relesed to Finished.

In item ledger entry for that entry Invoiced qty = 0

so Now u consumed that material qty = 100

so Invoiced qty for that entry in Item ledger entry = 100

But in Item card - Net invoiced qty = - 100.


so this is the reason .

this is applicable for Postive & negative also.

dynuser

I have finished the production order. But even then the invoiced qty for that ledger entry is zero. Why the invoiced qty is not changing in the item ledger entry for the finished production orders is the bother.

chengalasettyvsrao wrote:

Why your Net Invoiced qty field will show negative value. :


U purchased a item 100 PCs ( Just received only ) - so item ledger entry will update.
So Invoiced qty for that entry is Zero.

Now u sold the items from that entry 50 PCS.

So system automatically Invoiced qty for that sales entry = 50.

So in item card Net Invoiced qty field will show = - 50.


This same for Production also.

Let's u post the production that means out Put = 500

But u did not change the staus of that production order from Relesed to Finished.

In item ledger entry for that entry Invoiced qty = 0

so Now u consumed that material qty = 100

so Invoiced qty for that entry in Item ledger entry = 100

But in Item card - Net invoiced qty = - 100.


so this is the reason .

this is applicable for Postive & negative also.

moonlight

Please ensure you've run adjust cost and post cost to G/L.