Hello everyone
When I create a SQL trigger on a table in SQL management studio the trigger will be deleted when the table is validated or a new release is patched.
Is there any way to create SQL triggers so that they are protected? Like activity codes…
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
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 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…
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,
Is there a way to block the Print Transfer Slip Confirmation Dialog box from appearing for IC Transfer. We have created a custom Print form and wish to suppress the standard Print confirmation alert box which appears after Saving or Posting a Transfer…
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.
Hello All,
Please am having issue with PAYMENTH description Table not flowing to GACCENTRYD description table.
I did a transaction on payment screen which was ok and generated a journal number, so i tried designing a report (Supplier statement) which…
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…
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…
When calling a Subprog from a button action on a Window, it executes a number of data validations, one of these validations does select in in SQL.
When I execute the query in SQL, it returns the correct results. For example:
When testing the same…
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…
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?
Hello all,
I'm trying to create a SQL expression to view the value from an optional field in the APIBDO table. The report being used is a GL Transaction Detail report with the following source container join:
((([GLPOST] INNER JOIN [GLAMF] ON [GLPOST…
Greetings,
I created a custom label report in Crystal using the Mailing Label and Report Wizard and it works well in Crystal. I saved it and am trying to open it from within Sage 300 2014 PU3 and I am getting the Error:LoadLibrary message.
Has anyone…