Browse By Tags

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…

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…

Can we create a SOC 1 Type II report in which service auditors test the internal controls over Sage reporting?

Howdy - I have had 3 separate upgrades where the client is upgrading from 2018/2019 with fairly recent Payroll updates (2.21.1 and greater) to Sage 2021 PU2 with PR 2.21.3, and after data conversion, if they have any Payroll custom reports from the previous…

I need to create a sales order form for KnowledgeSync. I can't get the lines to print in the correct order. The standard sales order form created from the sales order work table has a "Group" that I'm assuming is what gets order lines to print as displayed…

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…

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…

Hi everyone, I'm wondering if anyone knows how to generate a list of all customers that have special pricing methods set, including: Cost Markup Amount, Cost Markup %, Price Discount Amount, Price Discount % and Price Override. The one that's chiefly…

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 working on a Crystal Report that shows a grid with sales history and would like to graph the history by sales period. For instance showing each period in 2018 as blue, 2019 as red, 2020 as green. So you will see each year clearly in each period.…

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.

Hello, I want to use the report "Bank Account in Ledgers Report" for petty cash accounts as well. While printing the report under parameter section, i can see the petty cash accounts but when i click on bank selection it says record does not exists…

We recently upgrade Sage fixed Assets from 2016.1 to 2019.1, today a users reported issues generating reports from Sage 100 2016, that's all the relevant changes that we have made recently. May Sage could be affected because of this?

Hello, I'm working on creating a barcode that needs to meet USPS requirements. Currently the formula I am using is: BarcodeUCC128("420" & "56901" & "92" & mid({SO_InvoiceHeader.UDF_TC_USER_8},3,24)) The font for the barcode Code128. …

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…

Hello, I am creating a report for our accounting department which shows all A/P batches that either remain open, or were created today. I have the first part, where I can pull up all active batches through GL_CompanyActiveBatch. However, I am having…

We have Sage 300c installed and the Web Screens are accessible. However, none of the standard reports display on the web screen if accessing them from a workstation that doesn't have Sage workstation installed on it already. Is there a fix for this…

Hi! i´m trying to edit the SBONFACP crystal report with the parameters values. So i tried to print it in rpt format and later open with the SAP crystal reports. When i tried to open it i have this error: "Unable to find language and/or path in…

Does anyone have details notes on how to add a new crystal report to show up in SAGEX3. The report has been developed on crystal but I want it to show up as an option under printer in PO. It is a copy of BONCDE report with a little modification but I…

I have a report I built from scratch. Pretty simple, only 4 tables and one parameter to fill. I added it to the directory, then thereport dictionary, then set up the default values and then the print code. The report is visible after I hit "Record…

We currently have customer that accept Back orders. On the sales order the user is able to input items that are on back order. However, if a product is on back order the invoice form drops that product. The sales order: This is the invoice: The…

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…

I know there's still some fellow "old school" CR users here ... I am updating our check form - simply making a couple of minor alterations to PAYRLCHQ.rpt I want to replace 47/100 with 47 Cents The form has no 'Page Header' when I begin. I click somewhere…

We are looking for a good source for Crystal Reports XI training. Does anyone have recommendations?