Sage 300

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…

Report might look like this: Fiscal year: Fiscal period: Due date: Vendor Number: Order no: BS GL code (Header): Expense GL (line): Transaction currency: Gross amount: Tax amount: Net amount:

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.

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 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…

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…

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…

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…

Hi, I wondered if I could tap in to sage city for some advice, as I am frustrated with support.na.sage The whole reason I am here, is that when I search the support site, I get to a issue, on the topic I want to learn about, and the article has a an…

I am having an issue where the Consolidated Designer report is not showing any amounts for one account in a particular company even though it has activity. I can only get it to return an amount if I type the actual company code into the formula dialog…

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 using…

A/P Payment Inquiry comes up blank regardless of input parameters Sage 300 2017 PU5 Running as ADMIN

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…

When clicking the "Print" button on a report options window, the window closes and nothing shows. This is happening with all reports. User is on v2018. This is happening on multiple machines. Appreciate if anyone has seen this before and has a solution…

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

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…

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…

Trying to customize the "Commitment Cost Status with Full Detail report to show invoices and check numbers on one row, instead of listing in separate rows. Not sure if this can be done.

Greetings! If this is the right forum, I have been having a perplexing issue with printing payroll cheques using either CPCHECK4 and CPCHK4A forms - regardless of the Advice Lines per page and MaxDetails field in the Crystal Report Design tab being…

My company is looking into the possibility of developing an ASP.Net MVC application to view custom reports that are designed & created by our users through Sage 300 ERP Suite. I believe there is the .Net library to integrate with Sage. Can we develop…

I am building a custom crystal report off the AP Invoice Table. When I grab the APIBH.DATEINVC file, it shows 20,110,101.00. I want to convert it to 1/1/2011. I tried using the following formula: date({APIBH.DATEINVC}) but it does not work. Any suggestions…

We would like to take some of the existing reports in 300 and modify them to run for multiple databases from one company. Is this possible without writing a whole new report? We do have a connector license. Thanks! LeShel Rich

Hi all, I am working on a report, somehow got stuck. Here is the simplified yet detailed description of the problem. I created two formula out of OESHIHO table: formula A: if {OESHIHO.OPTFIELD}='A' then {OESHIHO.VALUE} else '' formula B: if…

After key in a new PO and print it out, but the item codes are missing. Anyone has experienced same issue?