Total Material Cost in Cost of Sales

Looking into a way to have Sage automatically calculate the Total material cost by taking beginning inventory plus purchases, less ending inventory and incorporating this into the financials cost of sales. Is there a way to have this done?

Also, if I am wanting to reorganize our financials and change some G/L accounts from Operating Expense to Cost of Sales, how can this be done?

  • 0

    Sage 100 is a perpetual inventory system, not periodic inventory system.  Each transaction, as it happens, properly debits and credits the inventory and debits and credits cost of goods sold.  Inventory item GL Accounts come from the item product line.

    If the GL Accounts in the Operating Expense Area have GL Postings in history, you will not be able to change that from Operating Expense to Cost of Sales.  Instead, create a new GL Account in the Cost of Sales and then journalize the ending balance from the old account to the new account.