Sage 300

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…

I recently added a notice about accepting credit cards to our custom AR Statement via Report Designer. However, It only prints on the last Statement. I see I should be able to change it in the Print Controls way at the bottom, however, when I go to the…

Hello, Which change do we need to do to the unit price formula in the OE invoice form to go from 6 decimals to 4? This is the formula in our Crystal form: IF {OEINPR3.LINETYPE} = 1 THEN IF {OEINPR3.PRPRICEBY} = 1 AND {OEINPR3.INVDISC} = 0 THEN //…

Hi - I have a program that is importing orders (downloaded from an ecommerce site) and sometimes there is a general discount applied to the order. Sometimes there is a taxable item on the order. When I import the order into sage I am using all of the…

I am writing some reports on a machine that does not have Sage installed. Can I find the dll that has the custom Sage formulas like pwFormatDate() and istrue() somewhere on a machine with sage in order to copy it over?

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…

There must be a simple formula for the FR date function on 12 month rolling income statements that crosses fiscal years. If I have the current selected period =@FR("End") in the first column and want the 11 preceding months in the next 11 columns, what…

I need a crystal report that I enter an invoice number and other details and get the invoice copy. I need to drive the report inside crystal reports editor and not from sage. I checked in "PROGRAMS\OE62A\ENG" for oeinv01 ~ oeinv05 and none seem to allow…

Hi, we get an error message while trying to run an AR invoice for a newly setup company, all of the settings appear to be fine but the only issue is when we try to generate an invoice using the ARINVO.rpt file unofrutnately i keep getting a Vendor Code…

Hi all, May I know is there any ways to get Sage User Id based on username provided? Many thanks.

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…

I need to replace my budget macro because it has been overwritten by an excel worksheet. How do I do this?

Hi all, how do I do data filtering in macro? Lets say I want to filter by invoice number in OE0520

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

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

Having an error on my VBA "Class does not support Automation or does not support expected interface" when assigning Set dsGLJEH = AccpacGL2100UICtrl1.UIDSControls("dsGLJEH") On "OnUIAppOpened()" Public WithEvents dsGLJEH As ACCPACDSControl Private…

Having problem with my SAGE 2020 (300 Premium) (Build 0) When I tried to add COM Components for example AP2100 (AccpacAP2100.AccpacAP2100UICtrl) and drag that to my Empty Project .NET (VB), it show's the error below (Failed to import the ActiveX…

Hi We have difference details input in "Doing Business As" and "Legal Name" in the Company Profile. And we wanted to add these 2 field in our FR. But the field name "CoName" from FR Paste is linked to "Doing Business As". I can't hardcode this…

Hi, we have a customized order confirmation form. i added to the webscreens reports. it prints fine but the parameter prompt does not allow you to search or select options such as check delivery method. values must be entered. any help resolving this…

A sage 300 company with 15 users runs into the commonly seen problem where users forget to logout at the end of the day. There is a nice feature where you can sign out users from the lanpaks licenses screens manually, but has anybody written a macro to…

GL Transaction Listing Report looks like a dll type report. Can someone tell me from which tables it takes the data, we require this to make our own customized report.

Hi, is there anyone using the Orchid's Extender module in Accpac 2019? I want to display a message box when the next button is clicked.

I wrote a .NET application for a customer that created Orders/Purchase Orders. No problems with doing that. Now I need to update those Order/Purchase Orders. The problem that I am having is that I can't insert detail items where I want them to go. For…

We have a database for Company A with 10 branches and another database for Company B with 6 branches. Both using the same COA with Segment-1 as GL Code and Segment-2 as Branches. We need an Income Statement to show the comparison of branches in one…