Easy way to COGS?

slmaluwa

hi
Our scenerio!
1. No Manufacturing module. So, Finihsed Goods are entered using Item Journal with manually calculated cost.
2. After a month, we want to increase the cost due to previous month expenses (like overheads) to all FGs posted during that previous month.
3. This cost may vary depends on the FG category.
4. FGs may have already been sold

How do we do it in navision? If a standard method is not available, how can we customise it.

Any help on finding a direction for a solution is really appreciated

TIA

slmaluwa

cnicola

Depending which Navision version you have there is Reevaluation Journal that allows you to change the cost of certain Item Ledger Entries (in 3.70 + or maybe 3.60).

Depending on how legal it is you can also use Purchase Orders against a fake vendor for the FGs (you can setup the vendor posting group and general posting setup so that the PO invoice is a G/L wash or have it automatically paid to generate the G/L wash).
The advantage with that is that you can add Item Charges to that PO receipt after the fact. I like this because it makes it much more user friendly and easier to track the additions. Usually this is used for outside contractors.

Cristi

slmaluwa

Our version is NAV 4.0 SP3.

In this implementation, there is no direct link between the materials used and finished goods.

Finished goods are entered manually as Positive Adjustments using Item Journals.

TIA

slmaluwa

Kowa

Use the Revaluation journal, enter the item no. and then go to the field "Applies-to Entry". Select the positive adjustment entry you want to revalue. This will automatically fill in all the other non-editable fields as well as the posting date. Then fill in the new unit cost in "Unit Cost (Revalued)" and post the journal. This will add a value entry to the positive Item ledger entry to modify the "Cost Amount (Actual)" of the ILE. Then run report "Adjust Cost - Item Entries" to revalue the COGS of the goods already sold.

Note that you should not use the function "Calculate Inventory Value..." of the journal for this. This is for revaluing remaining quantities. You need to revalue the whole original quantity of the positive adjustment, otherwise only the COGS of goods sold after this revaluation will be correct.