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.
Hi all,
I have a custom module ID that I have create, build, and copied to sage300 installation folder. The module ID only consist of dll to create flat view. I am able to activate it on Sage 300 v70a. then I want to install it on test server with v69a…
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&…
Hi alll,
I am trying to compile my module ID but having this error:
makefile(19) : fatal error U1052: file 'ACCPAC.MAK' not found
- Sage 300 SDK 70A is already installed and activated to few companies (I have ~15 companies, SDK is activated on…
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…
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…
Is that possible to add CS0120 data to accpac finder in COM API, after browse the sql statement.
mDBLinkCmpRW.OpenView("CS0120", out csQry);
sSQL = "Select Name, Description from MYDB.dbo.Table";
csQry.RecordClear();
csQry.Browse(sSQL, true);
…
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…
I have modified the original invoice footer with 2 format options by parameter field on Bill Type for user to select the format when printing. Example Footer A for Standing Billing Footer B for Tenant Billing Below is the formula from the existing sage…
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.
Dear All,
I am working on Solution Wizard with Web SDK. I successfully created 2 modules, CU and SG. But the only problem is the modules is not displayed correctly.
SG module is not showed in the navigation menu. But the content of SG modules is displayed…
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 need to make a minor change to the L-PB Detail with Stored contract invoice format. The CNAME in TS Billing Field Names is giving our group name instead of the Company name. We have 5 companies and I need it to give the correct Company name based on…
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,
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…