Sage 100

Is there a solution out there to track ETAs of items in a PO when it involves multiple shipments from the same PO? I know that the required dates in PO Header/Detail (not sure of the precedent) are used in the Expected Delivery Report. But when multiple…

Solution ID: 111860 dated 8/24 - would love to see a hot fix on this SOON......

I would like to produce a report that shows what price level each of our customers is entitled to, but I can't find this on any of the reports. Is there a way to create this report?

I like the appeal of the Report Server because you can: 1.) Share reports to users without a Power BI account; and 2.) I can have control user access rights My Question I've installed the SQL server, PowerBI for Report Server & the Report Server…

I cannot seem to find a report like this. I can query the "qty in shipping" value from the IM_ItemWarehouse but that is only the sum for all orders that are shipping. I want to know the qty for each sales order line which appears to be stored in the SO_InvoiceDetail…

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,

I would like a report which shows me the total quantity used of items for a selection of Sales Orders, not all the items used for each sales order individually. Two reports somewhat serve this function, but not effectively. One is Open Sales Order Report…

Not sure if this is possible but I have a report that Groups by buyers code and Visual Cut send emails to each of the buyers. But I would like a email with all the data from all the buyers. Is there a way to create a another buyers code that combines…

We need a report (preferably one that would easily import into Excel) that breaks out the allocated cost for inventory receipts by lot. You can look at this information in the cost detail tab, but I cannot find a report that shows this information separately…

Do i want to have the zero quantity show up when doing physical count and if not why?

On my MRP report, I am getting a line item of "InvBill". This shows up where SO and PO are shown. This "InvBill" quantity appears under demand. What does this mean? Is it a true demand? Thanks in advance for any insight!

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…

Has anyone experienced the Daily Shipping Report reflecting $0.00 for a customer in the Sales Order module? We've seen this a few times now. Due to the turnover in our Shipping Department, we can't find any consistency in how the shipments are being processed…

We need an MRP report that is just a small subset of the entire 154 p. report and in a format more readily readable by our purchasing buyers. Using a silent connection string, I created a MSQuery table in Excel that brings in the filtered results of MRP…

I've added a grid to the report footer in the picking sheet to capture pallet/box #, dimensions, and weight. This grid always prints to a new page even when there may be one or two items on in the group detail section -- leaving plenty of room for the…

Does Sage 100 2019 have native functionality to print a multi level BOM Picking Sheet? (We are not (yet) using work orders and always print the Indented BOM, which is at a Qty of 1)

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

Hello Sage People, We are encountering with an issue in Open PO report We are seeing completed orders in Open PO list Is there a way we can fix this ? - Kindly advise regards, Bala

Hello all, I have run into a frustrating situation and I can't seem to find anything similar on the forums. We have several companies in our Sage 100 system and, when we run an Open Sales Order Inquiry on one company, it returns only two or three entries…

I am trying to write a report in Crystal. I want to select by Bill Number and it give me what makes up the bill of materials. Below is a sample of the report and the files I am using. I cannot figure out how to get all the levels on the report. I…

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.…

When running the Costed Bill of Materials Report some items will print displaying all components. Others do not. Bills are all setup as Standard. BOM Options: Maximum number of levels is 10, but these are not levels, just components listed in the lines…

I know this is a basic question...But I at a lost. We create about 100 Work Orders a day and we have a ODCB connection in order to print our travelers. However, when I try to print the travels directly from SAGE it tells me there is no traveler to…

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…

Is there a standard report that would give you this information in the IM Module? If someone is looking at the GL and wants to see the details that generated an entry with say, an 'IA' source journal, where is the best place to find this (paperless office…