Sage 300

Hello community, On SAGE 300, there is a way to have a "PAY NOW" button directly on the invoices sent as pdf to customer by email. Then when the customer click on it, he got redirected to a secured web portal transiting between Sage money and third…

I am trying to have a calculated cost - ie. Ic most recent * 1.8 rounded up to the next 100. Say I get 2445 that would print 2500 and then I am trying to substruct 1.00 from 2500 to get a new sales price of 2499. I am using two formulas one to get the…

So, so I have a custom report to display a list of costs, and each list displays the total cost per category and there is a navigate function using the on-demand subreport to display detailed costs per category. when I want to export the custom report…

I am attempting to add ICITEMO fields to my OE picking ticket, but some how I cannot select the ICITEMO table in my sub report. I do not see any of the optional field table being able to be selected. Any ideas of what I am doing wrong.

Customer wants a report to be run from Sage which gives the following 5 columns . Currently they export users and they print user authorizations report and then mix and match data but since its a bank involved in Identity access management and they want…

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…

Hi, We're running Sage 300 2022. We just got Paya installed and did our first Credit Card transaction. I'm still fairly new to the usage of Sage and Crystal Reports. How do I customize our receipt confirmation report to include Order Number or an Invoice…

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

Hi, I wanted to add "invoice transaction description" into it original report file ARTBAL.RPT using Crystal Reports. But there is no description field found from it existing table in this report. The field that I want to add is in table AROBL.DESCINVC…

I want to customise the Crystal reports to indicate which user keyed and/or posted batches in AR and AP. Which tables should i be looking at?

I am new in crystal report. I want to create a crystal report of customer aging report. I want in column only (docdate,docnum, balance due, but not incoming payment of customer, days in the form of (duedate to getdate shows in days e.g. 90 days)

Hi I have a standard invoice format that use among few database but now it need to add the company logo for each database. Any suggestion to addin for each databse and still share the same standard invoice ?

I took over a client who created a number of crystal reports that output to printboss. Very nice, but they do something strange with the crystal variable that evaluates to the trigger string 'PB#INFO '+Chr (247)+{@PrintBossForm}+Chr (247)+', '+ …

Hi I have added few parameter in the Invoice footer for Users to select the relevant info when printing. example : Email Address, Bank Details, Online Banking Details. which these additional info is not from Sage fields. With this method I find that…

I need to put the customers items numbers as entered in "I/C Customer Details" in to a custom invoice form used for export to print boss. The print boss form (rpt) seems to use a DB "OEINPR3" which I assume is piped values rather than a direct connection…

We are trying to customize our APCHK02 checks by added the information entered into the PO Number field on the A/P invoice entry screen. I am having difficulties locating and linking that field. Could someone please advise which table I can locate this…

Custom report developed for AR invoices . User enters parameters and executes reports and all the data comes on print preview , approx 15 pages . As soon they click on export button the following error is received. generally user tends to run the…

Our client upgraded from Sage 300 2014 PU5 to Sage 300 2019 PU1. We had developed a specialized invoice form for OE for them. After the upgrade everything is out of alignment. Any ideas why? Sam

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…

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…

Hi, I created a custom report in Crystal Reports for Sage 300. It works fine outside of Sage 300. When I put it inside of Sage 300, it does not work. Any suggestions? Thanks.

We have a number of Custom reports that require some user paramaters to be inputted for selection criteria. these reports was originaly written in crystal 8 and accpac 5.4 over the years the reports has been updated without an issue and even the change…

Hi, The client is using a custom form (not written by me). In Inventory Control, when printing labels from 'Received' or 'On File' the quantities are never what is specified - except when it is one quantity. The out put for multiple quantities is…

Hello all, We have a custom crystal report for Order Entry order confirmations. We have been printing Line Numbers on the report by using the special field "Record Number". However, we can no longer use this because if someone inserts a comment and…