Sage 100

Howdy Sage City community. Is there a native report in Sage 100 2019 Manufacturing that will allow you to query for a specific item and show a list of Work Tickets in which it was used? If not, I would like to try and create a custom report. Thanks…

Is there a PO Return of Goods History Report? I see Inventory Sales History, Inventory Receipts History, and Inventory Issue History Reports under IM module, but I don't see an Inventory Return of Goods History Report. Nor do I find one under the PO…

Good afternoon, This question is related to inventory management. I work for a company which has several locations treated as separate warehouses in the inventory management module. We use physical counts to determine materials usage for Cost of Goods…

Hello! i'm hoping you can help me with something that i'm sure is a very simple fix. We run small inventory counts usually to confirm and reconcile backorders or questions about shipments through the month. Usually, we run an inventory valuation report…

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,

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…

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

Hello, Is there a way to show which PO's that have been received in are missing an invoice? We just switched over from Sage 50 and when the warehouse would receive material in, they would check off the box "waiting on bill". That way I could then just…

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…

Trying to get a very simple report from IM. Item Number, Reorder Point, Quantity Sold YTD and PY along with a calculated field. The Reorder Point prints fine as do other fields such as Quantity On Hand and Quantity on Sales Order but I get nothing…

The back order fill report included drop ship line items from sales orders. It would seem best to exclude drop ship as those lines will not be filled from the warehouse. Rich Garrett DSG, Inc.

Every month, we send a "Top 100 Best Sellers of the Year" email newsletter to our customers. In Sage 50, we could create a "best sellers" list simply by creating a Stock Report, selecting to add the column for Sales Qty Year to Date, exporting to Excel…

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…