Browse By Tags

  • Import inventory list with stock

    Hello - I know this article shows how to upload your inventory listing ( https://ca-kb.sage.com/portal/app/portlets/results/viewsolution.jsp?solutionid=220924150010124 ). But how I update the stock currently on hand as part of the upload? I can't make…
  • Tracking external processing item costs Sage 50 Quantum

    Hi, I'm trying to determine what the best way to track the costs of external processes on inventory items? hoping some folks around here could chime in. RM=RAW MATERIAL AS=ASSEMBLY FG=FINISHED GOOD EXAMPLE: 1. 10 x Widgets item number (RMWIDGET1…
  • 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…
  • 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…
  • How to append a Lot # when transferring from 1 Whs to another?

    To start off, we are on Sage 100c Advanced v2018.2 How can we append an original Lot # when transferring qty from 1 whs to another? Create PO for Qty = 100,000. ROG the full Qty 100,000 to an offsite warehouse ("OFF") with Lot # 12345. When when…
  • Crystal report formula to show zero on base "im_transaction history" issued

    I was wondering if any one has done this type report I did a custom crystal report that i'm able to see specific item code, but for some reason when i'm running the report those item codes that doesn't have any transaction history is not showing and…
  • Inventory adjustments and return of goods

    Greetings everyone, I'm new to the community and have been lurking for a bit on subjects that I'm unaware of. I decided to register and stick to the community. Welcome! Before my time, some of the books were a complete mess. We are slowly correcting…
  • how to change UOM for item already in inventory

    I have a few items in inventory that were purchased at one UOM and I would like to change them to a different UOM. What would be the correct way steps to do that?
  • 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…
  • 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…
  • 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…
  • 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…
  • system will not let me delete/change an item in inventory

    operating in Sage 100 i have old "incorrect" part numbers that i need to just completely delete out of our system. i tried to go to item maintenance and just delete it while everyone was out of the system and it wouldnt let me. Pop up window came…
  • Inventory Management

    I am new to Sage and still getting to know how things work in it. We run a plastic chemical company and our final products come from 4 different raw materials. For example lets say 70% of Product A, 27.5% of Product B, 0.5% of Product C and 2% of Product…