Sage 300

I created vb.net application which run some macros, as desktop application it is working well, then I converted it to Windows Service also it is working well on my device but when I moved it to Client server I got : "Connect System.Runtime.InteropServices…

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 unable to HIDE the delete button in A/R receipt batch and A/R receipt entry screen using UI profiles. The method works with A/P and other screens. but, not with A/R. Any Advice would be appreciated. Thanks Nish

I was recently asked if there was a way that one could change the default sorting method for the selection of documents in an A/R Receipt Entry. It defaults to "Order By: PO Number" however, it was requested that I change this to default to "Order By…

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

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…

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.

In previous version, SAGE 2017. This code works fine. But after upgrading, it crashes. Dim oRpt As AccpacCOMAPI.AccpacReport oRpt = oSession.ReportSelect("APWMSSOFTRMT[APWMSSOFTRMT.RPT]", " ", " ") Dim oRptPrintSetup As AccpacCOMAPI.AccpacPrintSetup…

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.

[sage300erp 2018] I will build custom report AR aging with addtional descripstion and project in crystal report. what table will be used ?

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

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…

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'm trying to reimburse a customer, usually I could choose my my check template... now I can see where to change it because we moved our templates to another drive and I don't see where I can change it.. When I click on "browse" it stays in that folder…

Custom report developed for AR invoices . User enters parameters and executes reports and all the data comes on print preview , approx 15 pages . As soon they click on export button the following error is received. generally user tends to run the…

We are looking for a software for our university. Can sage customize based on our requirement.

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…

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,

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…

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…

We have a client on Sage 300 2014. They have macs they use to RDP into a server to run Sage. A recent update to RDP causes the AP check logo, which is Red, to print in black and white. Has anyone seen an issue like this before?

Hi, I have encounter this error when add the OCX screen into Visual Studio window form, using .Net Framework 3.5. Error: Failed to import the ActiveX Control. Please ensure it is properly registered Any solution to this?

Every time I try to "Get Info" from UI Info for PO Entry (PO1210) it crashes. I've tried several different machines and the same thing every time. I've tried uninstall and reinstalling. No luck. Sage 300 2017 PU5