Frozen Cost Eval

[vbajock]

I have a client request to change the EOY Invetory frozen costs, and produce a report showing the value of the frozen inventory using the new costs. Is there a canned report in Macola that reports valuations based on the frozen costs? Are there any gotchas in changing the frozen cost itself?

Thanks

 

[maccrystal]

Macola does have a Stock Status (Frozen report). It uses the value captured by the Freeze Inventory process and stores the date, time, qty and cost in the Item location record. As far as I know you can change this value without any problem. It should only impact the stock status frozen report. Typically it is updated each month when you freeze the stock status for month end reporting. The only consideration is if the auditor is smart enough to compare Inventory transaction history cost to your modified frozen cost, the client may have some explaining to do. This process is totally seperate from Freezing inventory for Physical or Cycle count purposes.

http://www.appstratinc.com

 

[MacolaHelp]

1. The frozen qty on hand would not be correct with your actual counted EOY inventory until you posted the count tags. Until you post, it reflects a picture of the QOH on the day you froze inventory on the processes menu plus/minus any trx affecting inventory w/a document date on or before the freeze date that you used when running the freeze process. You want to be sure that you have a good frozen stock status report with a total that matches the value of the inventory asset account(s) on the financial stmts (for audit purposes) before changing the frozen cost values. The canned valuation report is nice as it gives you avg, last & std costs, but is not modifiable as an ICR to point to frozen QOH/cost instead of current QOH/cost. Too bad.

2. The frozen cost field is not accessible through the macola user interface. If you want to change this value, you must modify the data in the table. Then you have no audit trail, unless you write a report on the changes you are making.

3. How about unhiding a user defined field, calling it 2004 cost or something like that, populating this field w/ the frozen cost amt? Then you can modify that field easily in the macola user interface & write a crystal report to add it all up w/o doing external file modifications. You've already had a lot of fun w/finding the typo needle in the haystack in the oeordhdr. This idea would only work if the client has screen designer, of course.

 

[vbajock]

The user field idea is a good one, but the company has 3,000 skus, so they are not going to be real thrilled with the idea. In addition, Macola interfaces to a system of ours that allows the user to track various laided in cost components of an item, and this system rolls up the cost components it tracks to adjust the raw material and end item costs for the EOY std cost change on std cost based systems. The CFO wanted us to interface this program to the Frozen Cost instead of the SC so he can do what-if type stuff on the cost factors and see what effect it would have on his end of year inventory valuation. Since my first post, we've solved a lot of the problem on this by talking him into setting up a dummy company for this instead of playing these kinds of games with his live data.