Sage 100

I'm looking for some data. Don't know which file has it. When I go to the General Ledger module, there is an Account Inquiry screen. It has a nice tab on it that shows the transaction history for a given account: I'd like to know which file…

Sage 100c Advanced 2018 (Version 6.00.10.0) I have modified a Work Order Traveler form. I needed to add a conditional text field. No problem Now, back in Sage, when we print the WO Traveler, it prints ALL travelers, even though I have a selection With…

Here is the reorder report I am requesting: Here is the reorder maintenance screen for the item about which I am asking: Here is a relevant snip of the reorder port for the said item: As can be seen, the quantities indicated in the second picture…

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…

Sales Order/Sales Order Entry/Print Order and Print Pick Ticket. These two options for the Sales Order, when previewed only have the words :(BILL OPTION 1 OPTION CODE), no item listings and no totals. Can anyone help!

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 have had several clients report to me this week the inability to email their invoices from Sage 100. It is happening in versions 2019, 2020 and 2021. They all use Office 365 and have been using the outlook.office365.com in their setup for quite some…

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…

My organization has been running Sage 100 ERP for nearly 7 years (currently on the 2017 release), and by and large it's been good and suites our needs. But still, there are some quirks and things about it that just make me scratch my head. The latest…

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