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.
On Sage 100 Advanced 2021 sp5.
I created a container with only the AR_InvoiceHistoryHeader file.
added 4 fields. set the filters to a single date and only Source Journal "SO"
the invoices are all duplicated. I tried the same thing on a different…
I'm looking for assistance on an Inventory Valuation Report. I'd like the report to sort via valuation. The highest values descending to lowest. I can't export to Excel and sort that way because of serial numbers.
Does anyone have ideas on how to…
Can the reports "GL Transactions incl BegBalances" & "GL Transactions Incl Open Balances" be converted to Consolidation reports?
Or, is there a way to set the company code and add the 8 companies as sub-reports?
Hello Everyone,
Looking for a little help on how to print the sales order line number on Packing Slips & Invoices.
We are finding every time a partial order is shipped the line numbers are renumbered starting at one based on the remaining lines…
Wrote a Positive Pay report using the Intelligence a couple of years ago for a client.
The report contains the Bank Account Number from the GL_Bank file.
They just upgraded to Sage 100 2019 ran the report and the Bank Account Number is blank.
Searched…
I need help with this error message.
This particular file worked fine on Friday. Now, on Monday, it won't open. My other files seem to work just fine.
I get this error:
Excel cannot open the file "file name" because the file format or file extension…
Hello,
i am trying to create a report, and want to supply the TimeUpdated String(8) field from the IM_PriceCode table.
can i create a formula field to convert that Field to a 12 hour time field? if so.. how?
Thanks for reading.
Peter
I need BI Tools menu in Excel to export reports. It keeps disappearing from the tabs at the top. If it goes away, I have to reboot my whole computer to get it going again. Any help would be much appreciated. There are no warnings or dialogs that pop up…
I have a client experiencing some errors I have never seen...
They are heavy Sage Intelligence users. We just upgraded to Sage 100c 2016 a few weeks ago and since then their Sage Intelligence has been more error prone than I would like...
Here is…