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?
I created a Sales Report in Crystal Reports 2016 that has 20 columns of Summary and then those 20 columns have sub-reports that I have linked to provide the Details by simply clicking on the hyper-link of the Sub_Report name. I added the Sales Report…
Does a profit and loss report exist in Sage 50?
Web search shows it exists in new cloud versions, but I cannot find one for Sage 50 US. If not, does anyone have one I can purchase and import into Sage?
I would like the report to include income, cost…
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…
Does anyone know what happened to the Additional Reports for Sage 50 Canadian Intelligence Reporting? It seems only US and Pastel reports are available.
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…
We've always wished that we could export or print the transaction detail that we see under the Transaction tab in G/L Account Maintenance and Account Inquiry. Yet that's not possible. What's most frustrating is that a Print button is staring you in the…
I've been using the Purchase Analysis intelligence report, however I want to add the "Purchase Order No." (not JobID) in the report.
Sage has to be storing it somewhere, because we fill it out on every PO we input, same with "Unit Price". It is not…
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
Hi,
In Sage 50, I was able to pull a report showing me all the payments we made to a particular vendor quite easily, but in Sage 100 I'm not sure how to go about it. I would like for example to see what we've paid to Vendor XYZ from August 1, 2018 to…
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…
Sage 300 2014 Intelligence Report getting an sa login failure when attempting to run a report with terminal server. Any ideas? Everything else appears to be working.