Sage 100

Sage 2021.2 Advanced IRP 7.00.2.0 with PM and PO Generate based on Plan by-Inventory / Procurement type Purchase and Selection of Warehouse Code to single warehouse 13K inventory items company wide across 7 warehouses taking 8 hours to generate…

My question is what's the correct way to bad debt an inventory item? We have an item that we want to take out of inventory and put to bad debt. I have played different scenarios in my head but not sure which way is the proper way and which GL's it's going…

Hello All, I've been trying for the last two months to figure out a way to automatically distribute lot numbers by FIFO in S/O invoice data entry using visual integrator. We don't create a sales order before creating the invoice. Each of our inventory…

We are showing a serialized item on hand and available, but it was sold in November 2021. History shows the item was received and sold, with no further movement on this serial number It's still showing on the Inventory Valuation Report - item in…

Trying to figure out if there is a way to reserve a portion of a LOT Number for Make to Stock finished goods. For instance: The company I work for makes paint. If we make a batch of a particular color, give that batch a LOT Number and enter it into…

Has anyone seen this before? The Lot/Serial Column, which is normally blank for a FIFO Inventory Item Code, shows a random serial number, from a random Serialized Item Code (in our case this serial number that's showing up really is a serial number of…

Hello everyone, Does SAGE have an option to not allow inventory for warehouses to go negative regardless of the transaction type? We are running into issues with multiple warehouses. Thank you

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,

Does Sage 100 (v. 2019) provide a method for specifying minimum order quantities by vendor for inventory items? We know how to set minimum order quantities for an item at the warehouse level using "Reorder Maintenance," but we have not found a facility…

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…

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…