Sage 300

I am trying to get my macro to allow entering a price manually. The price is not on the customers assigned price list, nor on any other price list. It is essentially a price override, which we are able to do in the UI. Get the following warning 'Information…

Is there a plan to get the sage 300 macros to run in 64 bit excel? If someone has them running in 64 bit, what was your solutions? I find the macros will only run in 32 bit and cannot get the out of box macros to run in 64 bit. Also Sage intelligence…

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

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…

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…

Good Day, our client upgraded there office from 32bit to 64bit. But now we are getting a class not registered error when trying to open macro to display user form. We have tried to reg edit the fm20.dll file and that also gave us an error. …

I was doing some research and came across this blog post from Stephen Smith talking about the hidden Crystal parameters. Thought I'd add it here to be picked up by the Sage forum search engine. (From: https://smist08.wordpress.com/2012/09/15/reporting…

Hi All, I was trying to print the SSRS report from sage. If anyone have tried this please help me with this.

I'm trying to create a macro to print/save all my open G/L batches at the end of each month. I want the file name for each batch to be the G/L batch description and batch number. I'm having a problem getting the file name right - I'm not including the…

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.

I have customization of AP Payment made from VBA. when the user changes the payment day, they select a date earlier than the acceptable range date, so as we know there is a warning message, but whatever user click Yes or No. Warning message unknown…

Hi, The requirement is to to be able to run the Crystal Report on a preset day and email it out - without manual intervention. The report is not parameterized. I have hard coded the dates. Is this possible using Windows Task Scheduler or is there…

When i run my accpac session init, as part of the arguments for that function it requires i put an arbitrary number for the version CompanySession.Init "", "CS", "CS0001", "60A". Regardless of what version the computer is using the macro now reads…

Please contact me if you are interested in partnering up. We've been a Sage VAR on the east coast since 2006, and are looking to add more VBA and macro experts to our team. Thanks very much! Kellie Pitt, ERP Practice Manager Brainsell Technologies…

Dear all i wrote a macro in order entry module the macro doing order entry and ship all when post the OE transaction in Macro its make OE, invoice and shipment automatically but the problem sometimes its make order entry only i must restart the server…

i have the below Exception please any help ????

Hi all, I'm new to Sage 300 (although I have experience with Sage 200) so please excuse what might be a basic question: how do I add a button to the Customer form? Similar to where the Save and Delete buttons are (see attached), if possible. I've…

Hi all, I hope someone will be able to help me with this issue. I currently have a form that has a FEC that displays and controls the PO number, and then a AccpacViewlist that displays some of the details for that PO (e.g. Exp Arrival Date, item number…