Welcome to the Sage 300 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.
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…
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 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,
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…
Client wants the cheque advise to have 2 columns on the cheque advise in Sage 300, as Sage 50 gave him 36 items on the remittance stub. (Just Doc # and Amount paid)
How do i setup the sub report to do this?
Sam
I designed a report based on ICITEM,ICREORD and ICILOC that gives reorder quantities and some calculated columns for a parameterized input of location and item segment (from segment and to segment). These are dynamic parameters.
The report DOES NOT…