• How to fix a messed up inventory?

    I have taken over a system set up by someone else. It is a small bar. They use AccuPos as their POS. The flaw in the way things were setup is that the UOM are all screwed up which results in things like -1.24mil being in a draught beer item. I have uncovered…
  • Setting up the inventory item

    FormerMember
    FormerMember
    Hi, Please help. We buy kit which consist of different parts. And sell each part to customers. How can I set up this in Sage. Right now we can only by kits and sell kits, not parts in kits. Thank you
  • inventory adjustment

    I have a new client, converting from peachtree to sage50 pro when they contacted me they had already imported gl accounts, vendors, customers, inventory instead of using the history tab on the inventory ledger to set the opening qty/value they posted…
  • 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…
  • trying to get inventory correct

    Last year there were adjustments made to add inventory using the date of 12/31/16 (NOT ME) adding parts that were just not here or really old parts. I need to get them off my bottom line because we do not have that much inventory. I know since I closed…
  • Remove an item from inventory that was given fro free

    Hi, We are an auto and small engine repair shop. My boss(the owner) gave a small engine part to a customer for free because that customer helped him a lot when he started the business. I entered the purchase invoice and the inventory like I was supposed…
  • Adding first inventory items for new company

    I am a newbie at accounting and SAGE and am looking to get off on the right foot with regards to entering my newly purchased inventory into my system. With that said, I recall my accountant mentioning in our last meeting that he recommends managing inventory…
  • Inventory - Batches for the same products

    In Sage 50 Premium I cannot distinguish different batches under the same product without creating a separate product, which is inconvenient. Does any of your platforms has this option like in Quick Books?
  • Allocation to projects

    I have recently set up projects for a client. Some transactions have already been entered into the system. Is there a way to bulk allocate posted transactions to a project, without opening each one up individually and allocating.
  • How to delete an inventory?

    How can I delete an inventory item? The items I want to delete all have a zero balance, but when I try I get the following message "This item is currently being tracked and cannot be removed until inventory & services tracking data is cleared. (On the…
  • Donating cars from inventory

    We are a car dealership, we have donated some cars marked in inventory to Teen Challenge. I wanted to show it as a donation in our Donation Expense line. So I used the sales journal as a cash entry and picked the car from inventory and then put in the…
  • Inventory Costing - Correcting Average Cost

    We have thousands of items which have been sold "by the case" instead of "by the each", resulting in massive cost of goods sold problems. Selling when there is no inventory has made the problem worse. Correcting the inventory valuation and cost of goods…
  • Obsolete Inventory-Remove - Last date used?

    I have thousands of old inventory items I would like to remove from the system. Trying to run a report to see the last date sold or purchase? Can anyone help with this. Second once Identified what is process to remove from database. Thanks
  • Inventory

    I am using the inventory part of Sage for vehicles for a car lot. The value in the Genereal Ledger is different than the Inventory Summary details that I am printing. How can I adjust the General Ledger amount to agree with the summary details? I need…
  • Adjust Inventory for tax exemption after invoice

    I have a tech support business and order goods based on customer need. I record all goods as inventory upon receipt and then add to the client invoice as billed. I have realized that with filing PST (British Columbia), all of these items should have…
  • Inventory and Services out of balance

    Hi! I really need some help! I have been searching Sage City for a solution and found a few topics surrounding this issue...but I really need it clarified for me. Essentially, background to my dilemma...We sell used cars...When I was setting up…
  • How to add an inventory purchase that will be paid over time but a customer invoiced will be issued right away?

    Here's a scenario I need help entering into Sage 50 Canadian: We purchase a piece of inventory on a "lease" program (we make equal payments over 36 months) from a US supplier. Let's say the inventory piece is $36K USD, CDN equivalent would be $48,600…
  • Project expenses and revenue

    We do longer term projects where our costs are sometimes in one month and revenue is in another,. For example; Project costs are in December/January (payable invoices) and revenue is recognized in February. I know we can do revenue accruals so we can…
  • We will be during 1st inventory count with Sage 50

    I'm looking how we adjust inventory and more importantly how to allocate it to a different chart of account? I see the Adjust Inventory but I'm looking for the place to send my adjustments?
  • How to convert raw material into inventory

    how can we convert inventory into finished products in the sage 50. we buy raw material and enters as inventory in the system, So different raw material is used to make final product which is subsequently sold to the customers. Now if I sell the finished…
  • 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…
  • How to fix item that was input on purchase invoice incorrectly

    I am looking to correct an issue with my inventory where a product was entered under the wrong item number when a purchase invoice was processed. I have two items that are quite similar but different brands. Brand A is currently at +10 and Brand B is…
  • Mass update item costs, wholesale and retail price

    Hey guys, I currently am editing my 2016 Sage 50 Premium because when we first put it together we had it only setup for Wholesale so technically all of our inventory has Wholesale price now we are launching a website which we will be selling to the public…
  • Inventory Service Item

    I have been making some changes to my inventory service items. I have deleted some items as I will not be using these going forward. However I have run into an issue as I need to adjust a previously posted invoice. The system with not let me void or adjust…
  • Inventory adjustment

    I have an item in my inventory list with a quantity of .000854.....I would like to adjust this amount out but when I try to do an adjustment I can only enter in 4 decimal places....so how do I get rid of this quantity?