Sage 300

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?

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…

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

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…

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.

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

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…

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 All, I am creating a new customize program to import invoice in bulk from excel file while referring to a recorded macro on Sage. The import of Shipment number and its detail lines are fine. But when I try to insert to OEINVH, I got this error "The…

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

Note the is a .NET application written in C#. I have an application that imports orders, purchase orders and inventory items into Sage. The customer supplies a file that contains all of the purchase orders w/items. The file is parsed into purchase orders…

Hi, Is there a way to block the Print Transfer Slip Confirmation Dialog box from appearing for IC Transfer. We have created a custom Print form and wish to suppress the standard Print confirmation alert box which appears after Saving or Posting a Transfer…

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

I wrote a simple macro in VBA that enters an order and then posts it. On post, SAGE 300 assigns the next order number. How do I return that order number to the macro? I want to put it in the message box for the user.

Hi, I'm running Sage 300 V2020- Running on a VM accessed by RDP and with SQL 2017 databases running on Azure. I redirected the Custom Reports to the new Azure server with the SQL sa user name and passw and it's working fine inside the SAP Crystal…

Hi everyone: I have a macro that prints invoices to preview destination ; in past versions I was selecting what invoices are printed by changing the @Selection_criteria parameter and was able to print a particular invoice, group of invoices not in a…

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

Can anyone recommend a Sage Specialist for writing reports in the Financial Reporter in Canada? I need help and it can't be someone who is just learning to write these things, its a little complex.

A client wants to add the invoice number to the emails subject line not only the $COMPANY_NAME. Is there a way to incorporate the invoice number either on the subject line or the pdf name without doing it manually? Thank you,

Our inventory Items have a structure "Style" (8 char)-"Colour" (5 Char)-"Size"-(3 Char) We want to separately show the segment description in a field on the invoice for the style and the colour. I have tried a little sub report for style connected…

Hi Sage family I have done some simple customization and format in the existing Sage 300 Reports of Vendor Transactions Report (apvtrn01) and Customer Transactions Report (arvtrn01) and it works well. But I have an important information that i also…

Hi folks, I work for a foster care/adoption agency and we're trying to modify our child care cost sales invoice templates in Sage. Usually our invoices have the client listed as a county department of jobs and family services, and billed to the foster…

Hi, My report opens in Crystal but not in Sage - it tries to open, there is a quick glimpse (flashes on the screen) of it opening and then nothing. No error message. I tried creating reports from different tables - all with the same result. Any…