• Is there a way to memorize multiple project allocations to one vendor?

    I have 7 projects that encompass the entire revenue and expenses of the company. When I allocate, for example, electricity costs, I need to allocate to 7 projects, in unequal amounts, but the same unequal amounts each bill. Currently, I'm manually allocating…
  • Item Assembly and Inventory.

    Artisan using Sage 50 Pro 2017. 40 items on the inventory list. Each item was built with Item Assembly from raw materials. 1. How do I add more when I sell them? Do I go through Item assembly each time I make and sell more? Do I use Inventory Adjustment…
  • Inventory Sub ledger out of balance to GL

    Inventory sub ledger out of balance to GL. Sub ledger is higher than GL. Is there a way to post a one time entry to the Inv GL to bring into balance. Over 4000 items so no idea what is the issue. Thanks
  • Fix Inventory count without adjustments?

    FormerMember
    FormerMember
    I realize this question may be very similar to others, I did look around though the forums... the answers to me didn't seem like they were what I was looking for, but I'm not an accountant in any stretch and started using Sage 3 weeks ago so please bear…
  • Inventory Balance Without Inventory

    FormerMember
    FormerMember
    I'm new to bookkeeping and have taken over from someone else who set up the books. I am unable to close history due to Inventory B having a value of $1,000 entered into history but not having any actual inventory linked to it. Error reads: The total…
  • Inventory Variance

    In the purchases journal, I have purchased inventory 272400grams for $60,000. Pretty straight forward. But it is posting and additional $70320.09 to variance and $130,320.09 to Inventory Asset. If I look at the transaction detail for that material, I…
  • Year End can not start a new year due to the inventory value not balanced

    I am stocked and can't start a new year, due to this 0.02 and I can't find out who to make it balanced, does anyone can help me?
  • Can you have a system that works with only one PST account?

    I have taken over a system that has been setup all wrong and I am trying to fix it. In ever system I have worked on in the past I have always had a PST account for Sales and one for Purchase. I noticed today that for some strange reason that this system…
  • 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…
  • Can't process sales invoice due to cost of inventory items change

    Hi, all: While I modified a sales invoice, this is error message: "The cost of one or more items has changed since you started processing this transaction. If you recently printed this transaction's Detail report, reprint the report to see the effect…
  • Inventory Standard Costing

    FormerMember
    FormerMember
    Hi fellow Sage 50 CA members. I just joined. I've never used Sage 50 before. Can anyone please provide input on Inventory Standard Costing capabilities in Sage 50, and if possible, in the context of a small owner managed construction business? By input…
  • UN-LINK Inventory Account from real estate project

    Hi, I got this sage backup from a new client (Real Estate Development company). They have two of the inventory accounts (1502, 1503) linked to some of the projects. Now, I want to adjust both of the inventory (account balance), but the two accounts…
  • Inventory - not the moduel

    Does anyone know if Sage50 will handle quarterly inventories? When I post the entry for March 31 (DR. inventory CR. ending inventory) the asset value of inventory increases by the amount of the entry. Perhaps my journal entry is incorrect. Any help…
  • Sage 50 Project Costing

    We use Sage 50 job costing and allocate all of our project costs. Recently, some of our postings have become unallocated and replaced with (Unknown Project). The error message on the entry says "One or more Projects on line 1 have been removed". We did…
  • 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…
  • Build from Bill of Materials or Build from item Assembly

    Hi, We are an automotive and small engine sales and repair shop. We bought some forklifts but it came as separate parts and on the purchase invoice they charge us by parts. I entered each single item in the inventory but now I don't know if I put them…
  • Negative Inventory, using average cost valuation

    Hi All I have the same issue recurring over and over. It's not a Sage issue per se, just seems to be a lack of understanding on my part. We do product distribution (ie: buy from wholesaler, sell to dealers) and manufacturing. As most companies are,…
  • Inventory and item cost problem

    Hi We have a problem with my inventory. We do house and buidling wiring. We sold and install different type of cable and sometime it's sold foot by foot or in a package and I have an ''service'' item for that purpose. Also since we are in canada…
  • Do I need to do an entry for something a company is lending us at no cost?

    We just got tanks and equipment to put oil in for an oil change (We are an auto and small engine sales and repair shop). They don't charge us for the equipment as long we buy X amount L of oil per year. Do I still need to make an entry for the equipment…
  • 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…
  • Suggested Linked Inventory Accounts for New inventory

    When I enter a new inventory item under the Linked tab I am able to assign the item to various accounts based on four categories: Asset, Revenue, COGS, and Variance. My question is how "granular" should I be in regards to the assignment of these inventory…
  • 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…