We have set up an outside App that calls the Generic Print Report (GWSGPRTRPT). You pass the report name, language, destination, and an array of parameter names and values separated by "~". We have gotten this process to work, but only if the specific…
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…
Hi all,
We do most of our customer reports based off the GL_DetailPostings table.
I have a few reports filtered to only show "SO" module transactions and I pull in some additional data from the InvoiceHistoryHeader table but now am being asked to…
Have a client that upgraded from Sage 100 2019 to Sage 100c Advanced 2023 PU1. They run several reports outside of Sage using Crystal Reports Writer version 2020. They can run these reports with no issues some of the time, but then later in the afternoon…
I'm very new to Sage X3. Does anyone know if it's possible to have an image that is attached to a product print on the Job Ticket report maybe as a subreport? I have tried everything I can think of in Crystal Reports but I'm not getting anywhere.
Thanks…
Hello community, I am in desperate need of HELP !
We use Sage Business Vision for small business version 2023. We installed it on 1 new computer with Windows 11 operating system in November 2022. Originally, there was an immediate C++ runtime error…
Hi, my company is in the middle of a migration from SAGE X3V5 to SAGE X3V12. R093.001.00019
When running a report in X3V12, the querying part (Job Started Phase with the green bars) takes an extra 1-3 minutes on average than it did in X3V5. In X3V5…
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…
Hi Citiers,
I have searched around and and followed all the tips found here there there with no uck.
I decided to knock on your door to check if you have any solution, hint, tips and a clue on how to debug this error.
We got an Windows Server…
Created a custom crystal report for client with Date from and Date to and customer number as parameters in order for sending all invoices to a particular customer for a specific month or range of dates.
The custom crystal report on the sage server…
Is anyone familiar with linking the MACHINES (Installed base) and CONTSERV (Service Contracts) tables? I am trying to create a crystal report to print from the installed base screen with a summary of all the related service contracts.
From the installed…
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…
In the standard report - BALAGEHIST and normal BALAGEGRP - the detail aged balance is showing currency revaluation as a separate line. Can this revaluation entry show at individual invoice instead as for audit purpose - it will not be transparent to show…
We use a custom crystal report for our AIA type billing. Previously the items in the ITEM NO. column printed in the order that they appear in the Contract (which is correct). Recently certain items are printing seemingly randomly out of order. We did…
I am using Sage X3 V11 with Crystal 2013 to create a new label. Is it possible to prompt for report parameters when using the Print Stock Labels function? I am hoping to enter values for the label that are not currently stored in Sage as parameters.
Is there a canned report (or a canned report that would require minimal manipulation) to determine the total count of commitments that were issued in any/all jobs over a given period of time?
We're trying to determine:
1) How many commitments were…
Hi All,
As per the requirement we are working on the translation(to traditional Chinese-Taiwan language) and were able to translate the most of the text, screens, windows.
We are now working on the translation of all reports. We would like to know…
I need a report to show me any AR that was billed prior to 7-1-2017, but NOT paid as of 12/31/2018. Is there a report in TS that will give me this info? Or a combo of a couple reports that I can then put the info together in Excel? I use TS Premium
…
I am looking for a formula (in Report Designer) to pull out the first name & another to pull out the middle initial. I know it's fairly easy to do in Crystal. However, I'm trying to avoid completely re-writing this report.
Any & all help is greatly…
For the past weeks, I have been working on generating a report that will provide the inventory amount per Category and should match it with the Inventory balance per Trial Balance or G/L or Financial reporter.
Does anybody built a report on this using…
Good afternoon.
With the need of one of my clients to send all kind of reporting by email we came across a problem.
We used the ARP event to manage the workflows so they could send the message with their report as an attachment.
This worked smoothly…
Hello,
I'm looking to re-create a Crystal report so that it can be run by Knowledge Sync. I initially wanted to just use the report provided by SAGE, but it looks like I can't use this report as the information the SAGE report pulls is only generated…
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…
