• Get Rates macro and rates url

    Anyone have clients using the GetRates macro and having an issue with the website it pulls the data from? It appears the default fx.sauder.ubc.ca site as been down for a few days. Does anyone have an alternate site we can replace it with?
  • run macros using Windows Service (local system) - Session Could not be opened

    I have Windows Service which read some data from database then run macros to generate some reports as pdf files automatically (statement of account, Customer Aging....), when I run the service as "local system" the service can read the data from database…
  • open session in Windows Service

    I created vb.net application which run some macros, as desktop application it is working well, then I converted it to Windows Service also it is working well on my device but when I moved it to Client server I got : "Connect System.Runtime.InteropServices…
  • Error printing custom report: Culture not supported

    We're printing a custom report (PJC) built using Crystal Report 16 and running Sage300 Premium v7.0 2023 How can we resolve the error below?
  • Stock APLETT01.rpt customization

    This is hopefully a simple request. Trying to use the stock APLETT01.rpt form and have it filter out all "inactive" vendors. Focusing on the {APVEN.SWACTV}=1 field as a record selection but cannot get it to filter. I assume it has to do with the APSLVEN…
  • Pay now button on invoice sent by email

    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…
  • VB.Net report printing is not happy with a sage 300 session created by the program

    I have a Sage 300 program, developed in VB.Net, that generates crystal report PDFs. When I run the program from the Sage 300 desktop on my client's server, it works just fine by passing the session token as a parameter. It also works fine running…
  • Print report from C# program error Unknown error 0x80040200

    Hi All, I have an error when trying to print custom report from my C# program. System.Runtime.InteropServices.COMException (0x80004005): Unknown error 0x80040200 at AccpacCOMSVR.AccpacSvrReportClass.PrintReport(Boolean& pWebReportGenerated, String&…
  • Sage ERP AccPac 500

    Does anyone know if this program is capable of inserting a signature on a cheque? if so how? If not what do others use to do this?
  • Adding AR Invoice Number to E-mail Template

    Hi all, A client wants to add the A/R invoice number to the email template. I've tried to search from F1 Help -> E-mail Message Variables, but there's no such variables named AR Invoice Number. Does anyone has any idea? Thank you. Yours Faithfully…
  • Crystal reports

    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…
  • Anyone know how to Insert AR Invoice C# ACCPAC.Advantage

    I can insert a customer, i can insert a Vendor, but when i try to insert an invoice into AR, i get object set to null errors lol no matter what i do. I've been doing permutations of the code in hopes of finding WHY the error happens, i tried their RVSpy…
  • Sage 2017 How to insert AR Customer into Sage with C#

    Does anyone have a sample C# example of how to insert a customer into the AR Customers section of Sage 2017 ? I have the Visual Basic macro sample, but it looks so complicated, don't know where to start.
  • Adding a DataSource Control and Field Edit Control Using COMAPI in C#

    I've added the DataSource Control and FEC control to my Form ok. My COMAPI session is working fine. I'm running into a couple of issues getting the FEC working. I'm getting the following error trying to set the DataSource control to active. Also I…
  • How to create on-demand subreports caption into number value

    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…
  • Using ACCPAC.Advantage and Error updating OE Views

    Hello We have a C# program that takes as its input a text file, processes the file and then posts the OE Order using the class ACCPAC.Advantage. We open the OE Views to create the OE Order. The programs runs every 15 minutes on a Windows Server with…
  • FRAMTA formula for specific fiscal period 1 year ago

    I can't find any functionality for coding a specific period from 1 year ago in a fixed 12 month financial. I've got multiple columns set-up with FRAMTA ("NET1P"), NET2P, etc. and I want to add the same period from 1 year ago. All I can find is formulas…
  • Printing macro where the tray selection doesn't work

    I have a client that i upgraded from Sage 300 v2014 to Sage 300 v2022. They have some macros where some of them needed some minor changes. One of them prints a bunch of forms and they print them to different trays of the printer based on a screen selection…
  • When printing a report for A/R Invoices, how do I get a value from a batch different from the current batch?

    I need to add a summary section to my invoice report with the value of the invoice from the previous year (if there is one). I plan on storing the batch number for the previous years invoices in the invoice optional fields. Here’s my formula to get…
  • Users and User Authorizations Report

    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…
  • AccpacReport object leaks memory (badly)

    If you have to print multiple instances of a (seemingly any) form (with different parameters, order number, invoice number) using the COM AccpacReport and AccpacReportSetup types they leak a lot of memory. In the space of 200 iterations there is about…
  • Sage 300 check customization

    Hi Team Is possible to create a QRCode with (check number, date, customer name and amount) information to make it easy to index and store in a document management system? Any idea ? Melvin
  • Error HRESULT E_FAIL has been returned from a call to a COM component.

    Hi, I need some help figuring this one out. I am trying to automatically export I/C Internal Usage reports from Sage 300 using a C# console app. I have recorded a macro in Sage 300 and have used the macro to successfully export the report to PDF.…
  • Automating transaction export using standard Crystal reports

    Hi, I was asked to create a custom service that will do the following: 1. Get Purchase Orders based on specific criteria 2. Export each Purchase Order using the standard Crystal Report file to a PDF document Getting the purchase orders is…
  • Using Crystal Reports to customize Ardinvo, how do I add database tables and fields from those tables?

    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…