Welcome to the Sage 100 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.
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…
Hello fellow Sagers!
Happy Holiday's or Merry Christmas! I need a report that shows all inventory items WITH "Inventory Cycle" and "Active/Inactive" status displayed. I have years of incorrect inventory items/status modifications that were entered and…
We are on Sage 100 Advanced v2022.1 and I don't see anywhere a Sales Forecasting report or option to enter numbers or imported via VI.
We have a new Sales Executive and he wants me to import sales forecast numbers, by Customer and Item to produce a…
Where can I find the information I need to calculate customer aging over time? Usually when I get stuck I can copy something one of my predecessors did, but no one knows of any report like this previously.
I want to be able to show a sales person, for…
As the title says, we'd like to separate our year end aje's. We'd like to have an unadjusted trial balance, aje's, then the final trial balance. Sage was not setup with a period 13, and I'm not sure if that can be added at this point.
Our Sage guru…
Hello,
I'm working on a project and I need to be able to pull the same information the "Invoice History Printing" report pulls for a date. For my selected date, in our database we have about 3,000 invoices. The report, however, only pulls about 140…
I run an open PO report each week. My problem is that it shows PO's that items have been received but just not invoiced. For example, the part shows ordered and received but because it hasn't been invoiced yet, the PO is still open. I am okay with that…
If you're a Sage Intelligence user and would like to keep up to date on handy ways to use the product for your business reporting, then why not subscribe to our SI Tips and Tricks and Excel Tips and Tricks mailers?
By subscribing to the SI mailer you…
Hello Sage 100 Community.
I was wondering if any of you know a way to view an inventory snapshot of a particular date in history (historical inventory quantity). I'm just trying to see the quantities for all items at a particular date in the past. …
Hello All,
Below is my pass through query. This is how I extract data from MAS and upload to Axiom to do my P/L reporting. This works flawlessly. The unfortunately part of this query is that I have to open each query and change start & end dates.…
I am attempting to write a report that needs to list the on hand qty of an inventory item for a given closed period. The same information you see in the History tab of Item Maintenance/Inquiry. I need to be able to look back at period 1 of this year for…
I had this same problem last year. My AP Aging for 12/31/13 does not match the GL Balance for AP at 12/31/13. I checked the setting in the report parameters to exclude future dated transactions but they still do not balance. Could someone help me with…
Running standard report in Sage 100 and the report is not calculating the % that is put in the discount column of the order.
example:
qty 1 list price 100 discount 10% extension 90.00
the report will read qty 1 list 100 but then it will say the…
