Standard Costing

Hi,

My customer is on Sage 300c 2017. They were using User costing before, changed to avg costing and some lot costing. They now want to use Standard Costing.

I have done multiple tests and talked to a data repair company, standard costing does not seem to work the way the documentation says it should:

Standard Costing: This costing method is defined by you, the user, and is entered in the Inventory Control Location Details. When the item is created, the Standard Cost is zero. What this method is primarily used for is assigning cost “targets” or gauging performance against industry “standards”. Items are received at the actual cost and are valued using Weighted Average Cost. When the items are shipped, Sage 300 ERP uses the Standard Cost. The difference between Actual and Standard Cost is recorded against the item’s Cost Variance Account.

The lines that I highlighted in Orange does not seem to be true. I have tested with the customer data and the Sample company. When you create an order for an item set to use standard cost, it shows the extended cost as using standard cost on the Order but when you post it, it posts the cost as average cost.

The customer is hoping to see the cost posted on the job/order as standard cost and does not mind it going to inventory as avg cost. I wish it would do what it states above but it does not. Am I understanding this wrong? Can an expert please tell me how this is supposed to work, I have been running around in circle.

Thank you!

Parents
  • 0

    Standard Costing in Sage is a hybrid of moving average and standard -- and as you've discovered, it can be so confusing that we rarely find a reason to use it. Your PJC scenario might be one of those cases where it would make sense, but I don't think it will work.  

    The Order retains the Standard Cost, even after shipment. Shipment and Invoice show actual / average cost.  When they hit the GL, the costs are removed from inventory at Actual, posted to COGS at Standard, and the difference is properly recorded in Cost Variance.  But subledgers (OE / IC / PO / PJC) are recorded at Actual.

    Not the answer you were hoping for, but it might help you stop hitting your head against that wall :-(

Reply
  • 0

    Standard Costing in Sage is a hybrid of moving average and standard -- and as you've discovered, it can be so confusing that we rarely find a reason to use it. Your PJC scenario might be one of those cases where it would make sense, but I don't think it will work.  

    The Order retains the Standard Cost, even after shipment. Shipment and Invoice show actual / average cost.  When they hit the GL, the costs are removed from inventory at Actual, posted to COGS at Standard, and the difference is properly recorded in Cost Variance.  But subledgers (OE / IC / PO / PJC) are recorded at Actual.

    Not the answer you were hoping for, but it might help you stop hitting your head against that wall :-(

Children