Browse By Tags

  • 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…
  • INVENTORY VALUATION AND GL ACCOUNT DIFFERENCE

    My inventory valuation report is pulling around $9 million dollars and my GL account inventory is pulling around $ 1 million. anyone know how i can fix this or see what the difference is ? Thank you,
  • How to obtain Quantity of Items Sold and Issued with Custom Date Range

    I am trying to export a report, by vendor (or product line), of the quantity of items sold AND issued for the last 12 months. We would like to be able to export it using any custom date range that we want. What is the best way of getting this data? I…
  • Setting up Raw Materials and Sub-Contracts for Inventory Items

    Hi, We are a small company. We purchase raw materials, inventory them in Sage with RM codes, and then we add some services/ cost (printing, perf, or slitting) and sometimes forward RM to sub-contractors for slitting; which are then returned to us…
  • UPC Code Units vs Cases

    Hello, Our business buys all product by the cases, which have a UPC Code. When we sell the product, it can be by the case or by the unit. The unit also have a UPC Code, different from the case one. What is the best way to link both, units and case…
  • Inventory items that are the same except for the colour

    Hello I have a couple of hundred inventory items that I want to import to Sage 50 Premium using .csv Many of the items I am referring to come in multiple colours. Can I import just the "master" item (as I like to call it) and somehow differentiate the…
  • 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…
  • barcode scanning

    I have a client who runs a hair salon and is in the process of adding a clothing boutique. She would like to use barcode scanning using the barcodes that already come on all the product she purchases. I phone Sales early this week and was told Sage 50…
  • Receipts and invoices I wrote for customers are not affecting the inventory amount it remains the same not deducted.

    I started using peachtree sage 50 US 2013 edition, I started with entering all the inventory, Customers and their beginning balances starting from 7/4/2016. Then from yesterday I started entering the sales made from 11/4/2016 when I started setting up…
  • Importing Inventory Records

    When attempting to import inventory records we get an error "Category Cannot Be Blank" We have an entry in the category field. We even updated the inventory record with the value manually and then again attempted to import and we still get the error.…
  • Direct Labor Costs Built into Bill of Materials for Items Sold as a Kit (always explode)

    We have a packaging company with a large variety of items which are packed to order. As we don’t prepack, virtually all our sales are through kits with the option selected to “always explode”. We do have a bill of materials (BOM) for each kit as items…
  • Inventory Category

    Hi there, Our accountant has raised a query about the Inventory control category code setup. By default, the category is used to group items together and assign sales and COGS account. Is there any other purpose for the category code? Can it also…
  • What is the best explanation of how OVERDIST (over distribution) tiers that are created using FIFO?

    I understand how negative OVERDIST tiers occur, but a bit fuzzy on how positive OVERDIST tiers occur. Is there a good write up that someone has done that explains this process for both myself and my clients?
  • Looking for WMS to integrate with Sage 100

    Hello, We are a distribution company that is looking to implement a WMS that can integrate with Sage 100. Preferably one that can stand alone as well. We are going through some growing pains and may also be looking to a new ERP in years to come. May…
  • Unable to delete a PO

    Hello everybody, need your help here. First, I'm using Sage 50 Quantum 2013. So here's the problem ; I'm trying to flush 2 PO out of our system but they don't want to go. Here's the error I get : "Sage 50 can not find the stock part of this transaction…
  • Inventory Stock Status Report vs. Physical Count Variance Register

    We are currently using MAS 200 for inventory reconciliation. I use the stock status report to balance our physical counts to MAS, giving us a potential variance amount. Once I enter the physical count numbers into physical count entry I am finding that…
  • Bulk Import of Items in I/C

    I'm wanting to add about 600 items to an already existing list of products in our datasbase. So, I exported 3 lists: I opened I/C “Items”. I created a script that would contain all the columns we use in that first tab (of the Items Module), and the…
  • Mechanical Shop looking for feedback on PO & Inventory Control System Management using SAGE 300 ERP - 2014

    I am looking to make contact with a similar service company that is currently using the SAGE 300 ERP PO & Inventory Control Systems. We are using SAGE 300 ERP AR, AP, & GL but are using a 3rd Party software for our Inventory Control System and Excel …
  • Mass change of inventory item numbers, while keeping old number for reference?

    Hi, My company is looking to completely overhaul its inventory numbering system, meaning that 1000+ inventory items are going to be receiving brand new numbers in our system. We want to still have the old part numbers on record as we will have to be…
  • Combining an Inventory & Service Item

    Setting up our company file. We are not live yet (January 2015) so I have an opportunity to set things up correctly from the beginning. I want to make an inventory item that is a combination of an inventory item (product) and service item (labour). We…
  • MAS90 -EDI 846??

    Hi, Let me start by saying I am new to MAS90. The issue we have is trying to create an 846 doc (using Gentran Director). We have a report called Inventory Stock Status Report, that give's the information that I need for my 846 document. but when I try…
  • Inventory Viewing

    Is there a way to allow for viewing of inventory on a single screen as opposed to the tabs. The company I am working for is looking to be able to see all the information for the sales staff, so they are not having to switch back and forth to answer customer…
  • product dimesions

    Are there any fields in inventory management to enter a product's case dimensions, legnth, width, height? also block and tier for pallets? Or is the only way to create UDF's for these? Thanks