As many know, sometimes the Vendors invoice does not arrive until a few weeks after the merchandise has arrived. This causes havoc with the Unit costs - some items show really crazy costs when the invoice has not arrived yet. Even when we run Adjust Costs & post to g/l reports there are always about 100 or more items sitting in limbo at any given time. So i wanted to create My own Avg cost based on the Item ledger entries. So at least we know “where we are” in terms of reporting on inv & such. I want this Number to be based on: Entry Type: Purchase in the item lesdger entries I want to add up all Purchase:Quantity and add up all Adjusted Cost (Expected) fields and divide them to give me my new Avg cost. I’m looking at the Codeunit 5804 ItemCostManagement to get some ideas on how to tackle this. Specifically Prodedure:CalculateAverageCost & use Item Ledger Entries instead of value entries. Note our costs on the PO’s are always accurate so Adjusted Cost (Expected) is correct. And this field fills in without invoicing needed. Now i was thinking about creating a new code unit to do this so not to mess with standard Navision. I was just wondering before I jump into this If anyone had thoughts on the best way to do this or if my path is a good one. And any reasons why using these two fields would NOT give me an accurate result. All Comments Welcome…thanks
Just a few questions before everyone lead you to the path of infinite misery that is average cost… 1. Why not just turn on expected cost? It uses the receipt cost as the actua cost until the real invoice arrives. 2. Why not use the Inventory to G/L Reconcile report that gives you the expected costs coming. That you can do accruals in your G/L?
1)Turn on expected costs? - i’ll have a look - not at work now. we are on 3.10B database w 3.6 executables. It has always been a problem - i’ll laugh my A$$ off if it’s been a simple check box all these years. I wanted to calculate a sep avg cost just for our own knowledge and compare all of our items to see where it’s really far off from the unit cost. one of the easiest solutions was to generate a report in Crystal Reports to calculate the correct cost and simply import the “My Cost” via a dataport once a week into a new field on the item card. I’m leaning that way now… 2)there are not enuf hours in the day to run inv->g/l report - it literally needs to be run overnight. Crystal does it in a minute. It doesn’t care if it’s a flowfield and sumindex’s don’t need to get involved or keys. It just does what you want when you want it. buy i’m still keeping all options open 
Ok I found the Expected Cost Check Box Sounds great but…
quote:
Warning Enabling both automatic cost posting and expected cost posting to G/L means that the amount of entries the system creates and the level of detail produced every time you post something will increase. This may reduce the performance of your database considerably.
Given that…
quote:
Expected costs are posted to interim accounts in the general ledger. If you want to post expected costs, you must set up interim accounts for the relevant posting groups.
In the Inv Posting Setup - I do not have any accounts under Inv Account (Interim). I’m assuming I should creat new account #'s and not post them directly to the regular INV ACCT. Am I correct here? Once an PO Invoice is posted what exactly happens in the interim account? Should I have both : Automatic & Expected costs checked off? should this be done NOW or should I wait till Jan 1 2006? I don’t want to freak the system out! Thanks…