• Contractor Inventory Materials and Labour

    Hi All, We're a small contracting company, and we just closed our first year. Last year we didn't link our sales invoices to inventory accounts, rather manually adjusted which wasn't a big deal because we have fewer, larger invoices given our industry…
  • Unable to fix negative COGS due to adjustments in inventory module ?

    We are a factory using Sage 50 Quantum. We use average cost and quantities were not negative. I managed to set the correct quantities and values of the inventory by using the inventory module, by first resetting the value to 0 in the module and then adding…
  • Need Help Please...Inventory costing nightmare

    Our year end is March 31 ......and we use average costing of inventory allowing for negative values. I cannot figure out how to fix this, and it's completely messing with my inventory and financial statements. What is creating this variance line? How…
  • Inventory Variance and Discrepancy between Balance sheet GL account and Summary

    Hi all, I have a question regarding inventory variance that appeared after correcting inventory location in a purchase invoice. Instead to take out an inventory item from one location and put in to other the system created a huge inventory variance entries…
  • Fix incorrect item cost due to inventory going negative

    I have an item cost that has been messed up for a couple of years now. Sage is currently setup for average costing and to allow inventory to go below zero. This item price fluctuates a bit from suppliers and was being sold before the purchase invoices…
  • Report to show sales vs cogs by department by invoice

    Company has four departments, each representing a physical store front. Inventory is setup to the main revenue, cogs, asset and accounts. The department can only be determined at the time of sale. So the invoice is generated, revenue department is chosen…
  • How to I enter our opening inventory of finished goods and raw materials so COGS will calculate?

    We are a small manufacturer. We've just finished creating all of our inventory items, including raw materials and finished goods. For finished goods, we used the "build" tab to create our BOMs, which identify the quantities of raw materials required for…
  • Inventory/COGS

    Hi, Has anyone encountered an issue with COGS not showing for on reports for Sales details for some of the inventory items? I have 8 inventory items that are not showing the COGS. And what's really odd is that it only started in the May reports and…
  • Inventory Issue

    I did an inventory adjustment after a count about a month ago, but because we use the average inventory cost the cost of the product was extremely skewed. To fix it we took our inventory down to zero and then moved in the appropriate number / cost…
  • Recording Opening Inventory

    In a recent post to Sylvie Su I found the following link very helpful. http://www.accounting-basics-for-students.com/periodic-inventory.html But when a new business is started, using periodic inventory, in which account is the opening inventory posted…