Sage 300

I used a VBS script to login to Sage300 with task scheduler this technique has worked for many sites and many years Client went to Azure hosting and now...... this line: Set Signon = CreateObject("A4wSignonMgr.AccpacSignonMgr") Makes this :…

I am trying to create a shipment in Sage v6.0. I did a recording first and feel like I have replicated in C#. the issue is that I get an error when trying to update the shipment detail after I add the lot numbers to an item. shipments.Init(); shipmentFields…

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 already created C# program using Accpac Advantage to import AR and AP Batches into sage in Ready to Post Mode. But my client wants it to auto post after import to sage. So, is there any tutorial or example that I can reference for doing…

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.

Hi, Does anyone know who can create macro to import autosimply MF Issuance and MF Assembly Receipt? We have a different system to control manufacturing and I need to import this automatically and periodically (so ideally we need .exe file to execute…

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…

Getting below error when calling API for AR module. The 2 config files are enabled ( https://www.sagecity.com/support_communities/sage300_erp/f/sage-300-general-discussion/110205/unable-to-make-a-get-call-using-sage-300-web-api ) and in Sage 300 USER…

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…

Hello, I'm fairly new to Sage and I'm hoping someone can help me. I am trying to build either a custom report or inquiry, I need to be able to access the JC-Job and JC-Transactions index's and I'm not sure how to do it. It needs to be similar to a…

Installed PU8 on server and now a macro with OCX dropped on userform1 does not work on the server where macro is being developed does weird stuff now like 1. no longer generates _OnRecordChange event 2. Set oHeader = AccpacOE1100UICtrl1.UIDSControls…

on OE/CN screen you fill in OE/Invoice number and Sage loads details I have certain customers where all OE/CN are on account, trouble is once you erase the OE Invoice# the screen details erase (can we stop this from happening?) I did not want to manually…

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…

I have a client who needs to run their inventory with negative levels allowed. We are running Sage 300 2021 with update 2 I recorded a macro of doing an inventory transfer from location 1 to 2 with a qty=5. Location 1 had zero of these items and so…

How to I store preauthorization information into Sage that I have gotten from an external tool? I see that tables like YPTRAN and OEPAUTH get populated but I can't get the macro record to show me how it is done.

I'm trying to add 2 new optional fields to about 4000 standing orders, because Sage does not auto-insert opt fields when activating from a Standing Order. I have a macro that works for one, or when I "mailmerge" to repeat the code for a certain number…

Hi !!, Need help on above thrown the message from one of the UIAppControls of AccpacAR3100UICtrl1 Awaiting soonest reply. thanks and regards, Joshua

Hi, I encounter this odd behavior while creating a macro to do an OE Invoice Entry. I did not even set the "HDRDISC" value but this error 1144 " Invoice Detail Attempt to change read-only field 'Header Discount'. " keep popping up and I am not able…

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…

How does I get the detail record of an order or purchase order if I only have the item number? Item Number is not a Key field. Rob

I know in OE can do something like OEdet1.gotorecordnumber 3 for example to go to 3rd line in grid but when I try this in PODET1 view (POPORL) I get an automation error i can podet1.gotop and podet1.gonext and browse all the details how do i go…