Browse By Tags

I need to make a minor change to the L-PB Detail with Stored contract invoice format. The CNAME in TS Billing Field Names is giving our group name instead of the Company name. We have 5 companies and I need it to give the correct Company name based on…

Hi everyone, I see many examples of processing a report in BOI, like this one . But all of them are VB/.NET or C#. Could someone please help me translate the syntax to UDS work with Events like Column_PostValidate? Below is Bret's example of Previewing…

Hi All, I had an issue with my receipt of goods entry... Basically the Goods entered as Received in Warehouse 008 but its balances is reflected in warehouse 001 in Inventory valuation report. What causes this and how do i rectified it?

Getting the following error message while printing the invoice report from Sage 300 2012, product update 1 on the client machine: Faulting application name: A4WCONTAINERXP.EXE, version: 6.1.0.0, time stamp: 0x503da4ab Faulting module name: ntdll.dll…

Hi, One of the workstation, the print preview of any reports, the screen is printing at the center in a very small pages. Attachment is here. Thanks in advance.

i used this function: ProperCase( ToWords(10000, 0) ) //Dix Mille but how can i convert in two language french and english

Trying to do up a Crystal report that will give the opening and closing balances for 4 GL accounts so that an employee (who I don't want to give Financial Reporter or GL access to) can run a report monthly to determine some tax payments. We are not using…

Hello everybody I want the steps to add a report to Sage x3 V11 please.

Before upgrade: Sage 300 v.2012; 2 pc with 2 printer (same model), User share the same OE invoice & cn/dn Pre-printed forms on dot matrix, no problem with alignment.. After upgrade to V.2018 – Alignment is wrong for both pc. I changed the alignment…

Where do I find stock crystal report forms? I'm using 300 v2017 and looking for the most up to date version of oeinv.rpt

Our inventory Items have a structure "Style" (8 char)-"Colour" (5 Char)-"Size"-(3 Char) We want to separately show the segment description in a field on the invoice for the style and the colour. I have tried a little sub report for style connected…

We are migrating Sage to a new server. When I move over the custom crystal forms, some of them are prompting for a sa password before running. I have checked all my database connections. There is one difference between the two database connections - when…

Hi Sage family I have done some simple customization and format in the existing Sage 300 Reports of Vendor Transactions Report (apvtrn01) and Customer Transactions Report (arvtrn01) and it works well. But I have an important information that i also…

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…

Customer has a new Win7 laptop and their IT folks installed the Sage 300 client 'as usual'. Users normally preview reports then prints or sends to PDF if a copy is needed. When they choose 'export' option from the preview, instead of getting the window…

I am a complete newbie to Crystal Reporting and have watched several tutorials, but they are all for stand alone spreadsheets. I have no clue how to use information within Sage to create a custom Crystal report and how to connect the two of them.

Hi Everyone, Our company has ~20 custom reports setup in Sage 300 as well as a handful of Sage Inteligence reports created by our finance team. Recently, 2 of the custom reports have started prompting for SQL login credentials at the same time Sage…

Am working from the DEMO folder I modified the file SBONFAC.rpt in crystal report 2013 to include a field from a table in sage x3. the original file is located at : Since sales invoice RPT files are in : C:\ProgramData\Sage\Safe X3 Client\V1\Data…

How do I connect to the same database set: This is what I need to connect to. When I click on the left list. It is bringing in the table from different set.

Hi, The requirement is to to be able to run the Crystal Report on a preset day and email it out - without manual intervention. The report is not parameterized. I have hard coded the dates. Is this possible using Windows Task Scheduler or is there…

When I put a range invoice to print, which I do by going to an invoice and changing the parameter, I am getting the following errors.

First, let me say, we are a long time Sage user. Started with Mas90 back in the mid 90's. I'm really tired of the way Sage has handled their accounts. This newest issue is so annoying. Each year end we run vendor labels for files. I just find the custom…

Hi, My report opens in Crystal but not in Sage - it tries to open, there is a quick glimpse (flashes on the screen) of it opening and then nothing. No error message. I tried creating reports from different tables - all with the same result. Any…

Hi, i need to print two report in just one click transaction. I have created two separately reports that take the same parameters. How can i to print one after another? As shown in the preview image I added a row in "Crystal Report" section in Dictionary…