Sage 300

I'm customizing the Ardinvo report in crystal reports. I took a copy of the report, saved it as a different file name.

Now I want to add some fields to it that are not in the set of data tables already in the report. 

In the "Field Explorer" I right…

 Anyone Please share the process to Integrate Custom made filter Based Crystal Report  / exe in Sage 300 Web Screen.

Hey Everyone, 

I am new to Sage 300 and crystal reports but have a decent handle on both.  We recently implemented a yes/no optional field for PO line details, everything tested fine for a few days but now it seems like the value remains as 1 no matter…

Hi - how do I find this in crystal reports to add it in:

So, where do I find that "Item" in the field explorer in crystal reports so I can map it to the invoice

Thanks!

Dan

Hi,

A customer has a custom report we create from scratch for AP transactions a long time ago. After they update workstations to Windows 10 in some of them that custom report doesn't work but in others its OK. So not sure what's the issue to fix. They…

I made a report with crystal report on my local, it all went well but when running on the client pc the following message appears

Hi, refer to the below, row 193 is the total from row 194 & 195 What formula should I put in cell A193 if I want to sum the range as show in row 194 & 195 and it will not show or print when it is Zero? Same goes to A203.  Any advice?

We have a Sage 300 2020 PU2 installation that works on most workstations, but one virtual machine running windows 10 Pro 64bit does not work. 

The issue is that when we print a report - any report, it runs the database record select and then stops before…

In previous version, SAGE 2017. This code works fine. But after upgrading, it crashes.

Dim oRpt As AccpacCOMAPI.AccpacReport
oRpt = oSession.ReportSelect("APWMSSOFTRMT[APWMSSOFTRMT.RPT]", " ", " ")

Dim oRptPrintSetup As AccpacCOMAPI…

Hi All,

I have problem with printing report from macro. 

this is my code in macro

this is my parameter in the Crystal Report and this is the only parameter.

But it still prompt for connection authentication and parameter

Is there any other thing…

Hi there,

This is my first post in Sage 300 online Community, woohoo. I find myself in uncharted waters.

I am putting together a custom date formula, where the date has DDD field, which means 3 digits for "day in year".

Example would be that…

I have modified the original invoice footer with 2 format options by parameter field on Bill Type for user to select the format when printing.

Example 
Footer A for Standing Billing
Footer B for Tenant Billing

Below is the formula from the existing sage invoice…

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…

[sage300erp 2018]

I will build custom report AR aging with addtional  descripstion and project in crystal report. what table will be used ? 

HI I new in the Crystal report area and I would like to modify some standard reports that came out the box and when I do this, as soon I run the parameters input change complete, How I can maintain the same format.   for example: 
this is the original report…

We have a customer that has used APCHK03 for many years and then after an upgrade to Sage 300 2018, that form does not display the cheque text amount.  The report itself looks OK in Crystal.  Any suggestions?  It is a standalone machine running Windows 10…

Is there an alternate method to get the same functionality as TsRange when using Crystal reports against the SQL replicator? I was thinking I could use a from-to command but not exactly sure of the syntax.

Hi All,

Problems found when we had started doing new forms/reports for Sage 300 2019.

Recently we found out that when using View Table as Data Source, the reports are unable to generate any results in Sage 300 2019, while Sage 300 2018 or earlier version…

Sage 300.  I have written a report in Crystal which runs great from crystal  but generates nothing when I add it to the reports Menu in SAGE. I get a bit of an hourglass but no output.  It is setup for preview..  Any tips on how to troubleshoot this?

I am trying to insert miscellaneous costs in invoice totals but my formula is not working. I am using OEINVD table and my formula is:

IF {OEINVD.MISCCHARGE} = "UPS" THEN {OEINVD.EXTINVMISC} 

Any help is highly appreciated

Hi guys, so I am trying to add a crystal report to Sage 300 ERP however whenever I add same and run the report after entering the date range parameters, the report just freeze, wont load and also wont close when I try to close it. 

I've unchecked the option…

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,

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.

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…

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…