Sage 300

Sage 300 2019 For modules where the user has no authorization for can the empty module folder be removed from their desktop?

Have a v2018 PU2 macro running fine for months; suddenly 2 view lines of code do not work I get run-time error '-2147467259 (80004005)' Method 'OpenView' of object 'IAccpacDBLink' failed here is the punch line Public OEHdr As AccpacCOMAPI.AccpacView…

Hi, We intend to have a feature to upload a file to the server from Sage 300 Web Screen. Is there anyone who knows how to do this? Regards, David

When you click "Print Receipt" on the AR receipt entry screen or from the batch list, the default is for the delivery method to be "Print Destination". I want to change it to "Customer". How do I do that?

It would need to prompt for from bank, to bank, amount, and transfer date. then offer OK or cancel. The rest of the stuff on the bank transfer screen I find not helpful.

Is anyone encounter this issue? We created a custom screen using VB6 for Order Entry. But when we Post > (Select Serial/Lot Numbers) > Print. Got an error.

Hi, We have a custom macro which uses the 2016 OE Order Entry form front-end with a bit of custom code to handle some odd edge cases in the background. For some reason the table of line items in the custom macro version stretches off the edge of the…

Does anyone know how to customise Sage 300 web screens to run custom functions eg. auto print warehouse pickslip, email customer invoice and end shipment file to 3rd party warehouse when the O/E order entry post button is clicked. On the desktop version…

HI, Is there a way to programmatically code an objecthandle without passing it as a parameter in the Program Argument? Here is the scenario: 1. I have a vb6 program (.exe) that is supposed to run on Sage 300. This .exe program passes $objecthandle…

Hi, Is it possible to lock Sage Desktop from exiting when we run a custom .exe program? If we run a custom macro and try to exit Sage, there will be a prompt to close the opened window first. But for an .exe program, there is no such prompt. Is there…

Hello, We are a Canadian Company with Sage 300 ERP. Looking for contacts for Ontario consultants to help us modify the product. Thanks! Tina

I have a macro at a client that shows a (Not Responding) message at the top of the screen while the macro is running. It still works and completes its process. This message does NOT show on their old server when the exact same macro is run. Same version…

I've recently installed 300c Webscreens which has a nice interface to it, albeit a bit limiting. The first thing everyone in the office asked, why do I have to have pages of records rather than being able to scroll through the entire list at a time…

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 all, I am customize Order Entry screen, I want to get the pop up screen name when close the pop up screen but it seems like not working. Private Sub AccpacOE1100UICtrl1_OnPopupClosed(ByVal strPopupName As String) MsgBox strPopupName End Sub May…

Hi, Is there a way to add a link to an external web page within Sage 300 web screens? Ideally, we would like to add a group button in the Home column and then link that to a page that we have developed.

I have successfully captured events on PMCOSTH and PMCOSTD. but there is this Detail/Tax button where you don't have to use the grid. And I want to put an edit on the CATEGORY field on the non-grid window; have it working on the grid window Public…

I dropped the PM2010.OCX on a userform and it works fine for entering PM/PCJ costs but there are no menus on the top left like File Import, Export etc. Seems this way from v5.6 to v6.4 at least Any info about this ? Thanks

This is all about PJC Categories, when marked INACTIVE can still be used on AP Invoice Input. I have a custom AP screen macro where I can capture OnRecordChanged and OnRecordChanging I can use the pField argument to extra error check the CATEGORY…

Hello all, Is there any possible way to automate the Sage 300 item number change process? I know there's a way to automate the database dump (using OrchidSystems Process Scheduler) prior to running it, but having the ability to schedule the item number…

Hi all, I faced the issue at 1 or the user pc, her pc is Windows 10, 64 bits. When want to load the customization program, error will occurred in line sessMgr.CreateSession, it will prompted error "Method '~' of object '~' failed" first, then only prompted…

Hi, I'm trying to create a macro which uses AccpacGrid, i wanted to add a column which contain a check box or Yes or no option in the column. I can seem find the way to achieve it. Could it be done actually? Any help will be appreciated thanks

I am using a vb app to run a customised order entry screen. We capture the post order event and then run vb code to introduce an automated workflow. One issue I'm having is how to identify if the OE Credit Check screen has been displayed, as when it…

i want to know the status of my 3rd period in 2014 is locked or not i had tried using code below Dim mDBLinkCmpRW As AccpacCOMAPI.AccpacDBLink Set mDBLinkCmpRW = OpenDBLink(DBLINK_COMPANY, DBLINK_FLG_READWRITE) Dim mDBLinkSysRW As AccpacCOMAPI…

We are auto generating our OE Shipment/Invoice using VB6. Is it possible for us to capture payment when generating the shipment? All of our credit/debit card orders are pre-authorized at the order stage using Sage Payments. Sage 300 2017 PU 5 Sage …