Sage 100

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…

Hi There, Is there a way to run a batch file to change all items entered into inventory with a none reorder method to reorderpoint? Thanks in advance, \\shane\

Hello Everyone, Our CS dept have been reporting to use that they are receiving a popup message in SAGE when try to print a pick sheet from the Sales Order module. Please see below. I can't figure out what could be causing this. I have checked permissions…

Hi. How do I generate a report that will show me how a cash receipt was applied? I need to know what invoices were paid by each individual cash receipt in the year 2020 and early 2021. During the early days of COVID ach payments were sent in randomn…

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 am working on a Crystal Report that shows a grid with sales history and would like to graph the history by sales period. For instance showing each period in 2018 as blue, 2019 as red, 2020 as green. So you will see each year clearly in each period.…

Where does the QuantityOnHand value come from in the SO_OpenOrderWrk file? The field value is always zero when I try to use it in an Open Order Report. I would like to pull the QuantityOnHand from the IM_ItemWarehouse file based upon the WarehouseCode…

"Invoice History Printing" let's you reprint invoices. Is there an equivalent tool for Purchase Orders? We are an importer. We send the original purchase order to our vendor overseas. Once the goods ship, we add the container number as a comment on…

Hello, I'm working on creating a barcode that needs to meet USPS requirements. Currently the formula I am using is: BarcodeUCC128("420" & "56901" & "92" & mid({SO_InvoiceHeader.UDF_TC_USER_8},3,24)) The font for the barcode Code128. …

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.

Sage 100 ver 2015 The items within the kit are included in the inventory sales history, but not included in the Inventory Reorder Report as either qty sold or qty issued. How do we get these sales to be included on the reorder report?

We have been using Sage100 (formerly MAS90) for many years now and always felt the Sage Intelligence Reporting and Dashboards were a bit outdated. With the development and deployment of many companies that provide integration into the data for KPI development…

I have a SO with 14 line items. When I print the picking list, it only shows 13 items. Item #3 from the SO is missing. The picking list shows #1, #2, #4, etc. Any ideas on what might be happening?