Sage 100

Does anyone remember off the top of their head when IM was changed so that you couldn't change the standard cost without using the utility?? TIA!

Thank you!!

It was v4.40 when IM, PO and BOM were updated to the new Business Framework.

I think it was 4.40

Do you know if you can still import a new standard cost into CI_Item or does it not allow it for std cost items?

To expand on that .... the utility is only needed if the valuation method is standard

Understood @RobertWhite.

I thought you could import if quantity on hand was 0. I normally import into the utility (a CI file) for all standard cost changes rather than worrying about one way for items with something on hand and another way when there is none

Yeah, if I'm doing it, that's what I would do. I'm wondering if an employee of a customer was doing it - they are quite lax on the VI security and the customer is wondering why the IM Trial Balance for an item varies from the Valuation report. ""Because the valuation report is looking at the current std cost while the TB gets written to with whatever the std cost is at the time of updating things??

You can choose to use Historical Cost when you run the Valuation report and then compare it to the TB.

Oops- it's the TB that has that option. That's what I get for answering without looking before I have my coffee.

So the logic of using historical on the TB is to tie to the GL, correct? How does it track the historical costs?? Does it go back and look at transaction detail??

To Reconcile Valuation to TB you should run the reports in this way- TB: Select to print trial balance as of 'last day of last year setup in Fiscal Maintenance' in GL (to catch future dated transactions) Select 'unit cost to use for Std Cost Items on TB as Current not historical if any standard valuation items (I) Valuation: Select to print O qty tiers and Yes to all transactions.

I believe a zero quantity, $ only entry will be put into transaction history when a standard cost change is done (utility).

This is what I found in the KB about how the trial balance quantities are calculated: The Trial Balance is calculated as follows: Beginning Balance = (this is written during period end) Ending Balance = (Current quantity on hand * **Current Costs**) - Future Dated Transactions Activity = Ending Balance - Beginning Balance Notice it says Current Costs. How is it calculated if you select to use historical costs?? WHERE would it get those??

From the Help Files: Note: When Historical is selected, the beginning balance unit cost is calculated using the following formula: (Beginning balance dollar amount for period 1 + Change dollar amount for subsequent periods) / (Beginning balance quantity for period 1 + Change quantity amount for subsequent periods) When Current is selected, the beginning balance unit cost is the current standard cost for the item defined in Item Maintenance.