Sage 100

We are using Sage 100c Advanced 2018 6.00.5.0 with Scanco for warehouse. All modules except GL are in December 2020. Every time I try to run the IM Trial Balance it is all zeros. Our items show up with zero quantites and zero for value. The runs for 12…

I don't know if anyone experienced this: I setup a price code for our product. with price level 1 being the heaviest discount, level 2 being the lesser discount and so forth. i applied the price code to our product lines. however i notice in the price…

What is the recommended length of time to retain inventory history in Sage 100?

When I enter the purchase order, I s elect the standard order type as shown below. And the PO already has been issuing invoice and batch also has been run. So now the amount of PO shows as inventory G/L account. But it should be purchase G/L account…

Is it possible to get the Inventory Valuation Report by Period in a summary format?

I am trying to use the Delete and Change Items Utility, (Module>Inventory Management>Utilities> Delete and Change Items). When I try to open the utility, a window appears saying, "You cannot proceed with unposted data in Item Valuation Selection entry…

Hi All - I am running MAS 200 v 4.30.0.21 and am trying to update Vendor Alias numbers in Inventory Maintenance. When I try to update it, it just creates a second alias. I can delete the one I just created, but not the Primary, the delete button is greyed…

Hello, my company currently uses inventory management to track in house supplies. We are a medical facility, that has 70+ departments. We do not sell the inventory outside of the company, however as departments need supplies we do an "Inventory Issue…

Hello All, We are using SAGE 100. Somehow On PO qty coming in Stock status report is not Open PO Qty. SAGE is pulling a open PO qty from somewhere - SAGE ppl kindly share your thoughts In the below example, in main I m seeing a open PO qty but in…

All, I am new to Sage 100 and have been impressed with it so far. I currently have an issue I have been wrangling for a bit now and would like to hear my options on the subject. I would like to know if there is a way to add inventory to a PO. So here…

Hi! We have recently created a second warehouse in our system and are trying to find the most efficient/effective way to transfer the inventory in the system as well as physically. I know there is a transfer option in inventory management, but we are…

I have a lot going on in this pic but a recent upgrade to v2019 Adv with Production Management show on the Item Maintenance Orders tab the choices Work Ticket (s/b Purchase Order and they are under there) Sales Order and Work Order (looks like it should…

We have a finished good that is serialized, however we will now be selling this item with an additional component that we would like deducted from inventory automatically. We had considered changing the serialized item into a 'kit', however that would…

Which Sage 100 IM table contains the Standard Cost field? I need it for a Crystal report, but can't seem to locate it.

I'm trying to understand exactly what is in the the PPV amounts (and how calculated) on our Sage income statement so we understand the information reported, if the manual JE's are correct,a and if we need to change our processes. We have two GL accounts…

Hello, I am trying to come up with a counter for the number of orders (Standard or Backorders) that an item is on. So far I have tried a script that counts the line inside of SO_SalesOrderDetail but it won't write to the two UDFs made in CI_ITEM. Has…

When we enter a new item code into "Item Maintenance," it used to create a new product in the system. However now when we enter a new product code, everything goes blank, but it says "NEW" right by the Description (as it would do before). Everything else…

Hi, Is there a way to track inventory by both a "Job number" and by the Bin location? There is nothing that I have seen in Inventory that would allow the Job Number to be defined at the unit level, and nothing in Job Cost that allows for tracking…

Hi guys Like I mentioned above when I try to re-build the sort files on Inventory management, I'm getting the following error "You cannot proceed with unposted data in Item Transaction Tier Distribution entry". Can anyone tell me please how can I fix…

We are having an issue with a part not being updated in our inventory after a work ticket is invoiced. We can manually do an adjustment but there is another issue with a button greyed out. This is for Sage 100 v2017. Any help would be appreciated.

I've recently started opening up can of worms when I was assigned "inhouse sage specialist". I know some things in sage and the rest is picked up as I go along. I have come across our Negative Tier Report and holy cow, 163 pages. I've done some research…

Has anyone found a way to have Item Cost show in the line information during an Inventory Management Issue transaction? Thanks, Erin

Sage 100 manufacturer, but only has been using the Distribution modules. Has not had a perpetual inventory in place. Company now is wanting to move to perpetual inventory within Sage 100 and then into the Manufacturing modules. Inventory items need…

Does anyone know how to change the valuation default in Item Maintenance from Standard to Lot? Trying to prevent incorrect entries when setting up a new inventory item. Thanks for your help!

Is it possible to search by alias number within Item Inquiry or Item Maintenance? How?