I thought I read a post about this, but now I cannot locate one.
When we have Vendors with SSNs, like in this ABC Vendor below, we expect the First Name and Last Name fields to be filled out, but they are not:
Of course we get this message, which…
First time in 12 years that the report I maintain is getting an error.
Failed to retrieve data from the database.
Details: s0000:[ProvideX][ODBC Driver][PVKIO]Data page header contains invalid record offset information. [Database Vendor Code: 109…
Hi,
My client wants to filter the transaction date range within a specific statement date on AR Statement Printing Report.
I tried to filter the date range using 'select expert' which set the between from to transaction parameter.
If I press F5…
Has anyone had success in exporting a report from Crystal to Excel - Data Only format and have Excel format columns with string values as 'TEXT' and not 'GENERAL'? I can't seem to come up with a way to do this in Crystal. Thought I would check here before…
Hello Everyone,
Our CS dept have been reporting to use that they are receiving a popup message in SAGE when try to print a pick sheet from the Sales Order module. Please see below. I can't figure out what could be causing this. I have checked permissions…
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…
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…
Is there a way with Crystal Reports to string together 3 different sales order form codes to print at once?
either for a single order of for multiple orders?
Hello New to Sage. Creating a Job Cost report. I want to key the listing on JC_JobBillingHistory to pull all the open and closed records. Using JC_Job for Open and JC_JobBilling for Closed. I can't get both of the tables to link to key table. It will…
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 have been trying to figure out the best way to get a report that would describe something like Item “Usage” by Customer. The trick with the report is that not only do we have to recognize items that are SOLD to specific customers, but we must contemplate…
Using Sage 100 Premium 2017
Using Crystal Reports 2011
I have six production SQL databases, all structured identically (for regional purposes).
I have created a Crystal Report using a Connection based on OLEDB using one of the 6 databases. It uses…
Upgraded sage accpac 6.0 (200) to sage 300 Advanced 2018.
When trying to print preview any default sage reports get error message.
Not implemented. Error in File . Operation not yet implemented. Attached image snap . Anyone faced this issue and…
Hello,
For starters, I'm using Simply Accounting 2012. We can't upgrade at this time because we also use integration to ACT! which is no longer supported by Sage. All computers (15 or so) are running Windows 7 Pro 64-bit.
For years we've been printing…