Browse By Tags

we are using BOM to build Kits which sell multiple items that we drop ship. The Kit item that is created is to hold the inventory of how many of the child items that can be sold. when we receive a sales order for the kit item. it explodes correct and…

Hi, I am using SAGE 50, I have been recording sales against individual product codes. When I post the invoices I can see the revenue is recognised but no value for COGs is provided. Have I set the products up wrong or does SAGE not facilitate this…

Looking for any insight. As far as I can tell there is not direct report that links COGs to deliveries. I've created a quick SQL query that provides me the necessary details from GACCENTRYD based on the TYP = stock. This works for a very base understanding…

Je ne sais pas ce que j'ai fais mais les factures et les achats d'hier ne sont plus dans le rapport pour consultation, le système reviens toujours a la date de fin d'exercice sans information ou consulation.....

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…

Hi We are pretty new to using Sage 50 Cloud and have found that on the P&L account all purchases of stock are being charge straight to cost of goods sold despite the fact that we are using the inventory module to track stock. Is it possible to change…

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…

I am looking to see if this is possible on the built in reporting, or if it possibly is something that Intelligence Reporting offers ( which we do not have )- Run a report of invoices, with a column with the COGS for each invoice line. The invoice register…

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…

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…

Hello, I am currently trying to consolidate my Income Statement so that I just have roll-up accounts for the 3 main sections of my business. I would like to move all of the direct labor expenses from the " Wage Expense" account on my income statement…

We are considering purchasing this module to use for a new manufacturing division that is schedule to open soon. I was hoping to get some advice on how the installation went well or poorly for your organization and whether you would recommend the purchase…

I am running a COGS report for the week ending 4/15/16; however, not all of my invoices are coming up. I verified that one particular invoice in question was correctly posted in that time period, and the items are allocated to the correct GL accounts…

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…

Hi, I'm trying to setup Sage 50 and I'm becoming more and more confused! I do use Sage at my day job for entering payables and receivables, so I'm familiar with a lot of the program, but not familiar how to set it up to use for my side business making…

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…

I'm new to Sage, I've used quickbooks in the past and I work as an accounting clerk using Microsoft products so I have some knowledge but not formal accounting training. I'm just setting up in sage, I have sage 50 premium so that I can do FiFO inventory…

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…

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…

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…

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…