Sage 300

I have modified the Packing LIst to show a total of items being shipped per page. On my system everything works fine. It prints 8 lines per page and shows the page totals very nicely. On my clients computer it only prints 7 lines per page, but the page…

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…

Hi everyone, I dont remember exactly but Im sure we could copy some folders/files (\USER I think so) of Sage actual installation at server (they have Sage 300 ERP 2012) to new server installation (Sage 300 2022) so we can recreate icons users run -…

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…

Hello, I want to ask about a custom report that I made using crystal report. So my custom report has been completed. The report uses a stored procedure because it saves time, compared to using a table / view. then I put the custom report into sage 300…

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…

Is there any documentation on best practices for upgrading Crystal Reports to a newer version? I can't find anything especially helpful in KnowledgeBase or elsewhere.

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…

I am trying to print an invoice, in retail POS, but I am getting the error above.

Using MyAssistant, I am trying to create an excel doc that contains the "Current Month" in the top row. If I go into JC and select File > Company Settings > JC Settings, I can see in the Accounting Date section the Current Month is "September" (even though…

Hi everyone, A customer change its PC - we have all programs ate server and we run workstation setup - and suddenly a custom crystal report we create from scratch doesn't work !!!! Error...."The remaining text doesn't not appear to be part of formula…

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…

Hi, I'm using SAGE 300 Premium (Version 2018) and SAP Crystal Reports 2013. I'm working on a Crystal report and using the following table linkings: OEAUDH linking to OEINVH (Linking field- ORDNUMBER, Join- Inner Join) OEAUDH linking to OECRDH (Linking…

This is one of those crystal oddities. I have a custom report that works fine in preview mode. When printer destination is set to printer, the admin user can run it ok, but all the other users can't run it. The report fails before it prompts for the first…

I have a client entering purchase orders in different currencies, but when I print the purchase order, it does not display the currency being used on the order. Is there a simple way to add that information to an order?

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…

Hi, is there anyone using the Orchid's Extender module in Accpac 2019? I want to display a message box when the next button is clicked.

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…

I have a custom crystal report from Sage 300 2012 and am getting it to work with Sage 300 2020. If I run the report with print destination set to preview, it prompts me for the date range and works properly. If I have the print destination set to Printer…

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 ?