Using Navision Attain 3.60A I have a situation where I have Finished Prod. Orders that are not being completley invoiced. The Prod. Order Line IS NOT Completely Invoiced. The Output for the Prod. Order IS NOT Completely Invoiced. But, all the consumption for the Prod. Order IS Completely Invoiced. The above mentioned Output generally has “Applied Entry to Adjust” checked. However, it never gets adjusted when Adjust Cost - Item Entries is run. We have Automatic Cost Posting turned on, so we don’t run the “Post Cost to G/L” routing. Any help would be appreciated.
Hi From the Item Ledger Entries against the finished production order are you sure all consumption lines are flagged as completely invoiced? I do not know of any other reason they will not be brought through.
Yes. All consumption is completely invoiced.
Without being able to look at the data, the next thing I would check is the Item Application Entry Table (339). The Output is Adjusted and Output Invoiced Date should be blank. Just a shot in the Dark.
Do you also have negative output for same prod. order?
Are there any subcontracting capacity ledger entries on the prod. order? If so, they must also be completely invoiced before the output will. Also, I suggest you run the Post Cost to G/L.
Yup - You are not alone with this problem. In fact I was at a customer site last week, trying to figure out. We had this issue: Output was posted, the Production Order was finished - Adjust Cost / Post Cost had been run - The Production order was still in WIP. Then I looked at the components - I investigated them, and found this: Both components were made parts (i.e. The manufacture the components them selves - AND the Production Order for them was Finished also. - HOWEVER some of the components used for the components [B)] (did you follow that one) was output from a Production Order that hadn’t been finished yet! The conclusion must be, that ALL levels of the Production order has to be ‘finished’ before adjust cost / post cost will take care of it. As I write this e-mail, I am developing a ‘WIP Investigation’ report / function, that can help a Controller understand why some entries hasn’t cleared the WIP Account. I will let y’all know, once completed.
quote:
…Both components were made parts (i.e. The manufacture the components them selves - AND the Production Order for them was Finished also. - HOWEVER some of the components used for the components [B)] (did you follow that one) was output from a Production Order that hadn’t been finished yet! The conclusion must be, that ALL levels of the Production order has to be ‘finished’ before adjust cost / post cost will take care of it…
Originally posted by Hhelgesen - 2005 Mar 29 : 16:50:48
This was actually the first question that Steven asked. In your case, the Consumption Item Ledger Entries would not be flagged as completely invoiced. Although when I re-read the answer is there a difference between the Item Ledgers being flagged as completely invoiced (this is the important definition of Completely Invoiced) and the components being completely invoiced.