Browse By Tags

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…

Hi everyone, I came across these excellent and useful to improve navigation on X3 V12. A. Right Panel Actions ESC + N – new ESC + B - save ESC + C - create ESC + D - delete ESC + E - cancel ESC + ALT + U - refresh ESC + ALT + P - print…

I would like to take action in a screen based on which transaction code was use to enter the screen. Is there a variable available that will show which transaction was chosen when launching the function?

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 created a custom screen where I am displaying images related to a driver. I am using a datatype of ABB, input of Display, and Graphic object of Photo.I have an issue on how to store those images. I know that it is stored in the CBLOB table. In the screen…

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

Hi, I would like to create more representations using Views/Tables. Requestors are very quick to create in X3V12 using Views/Tables, but very limited functionality specially on Landing Pages. The goal is to give user far more interactive dashboards…

I have a custom field in the STOALL table that I would like to transfer to the STOJOU table when the transaction is validated/posted. I've been looking for an entry point to do this, but I can't seem to find it. Does anybody know if there is an entry…

Sage X3 allows a parameter to warn user for duplicate values in BPRVCR. How can this warning be change to an error?

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

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…

how to retrieve vendor number values ​​on the PO Order screen using macros Thanks,

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.

[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?

On X3 V12, I want to add a button or menu item that opens an attachment on an object without opening the attachments popup window. I know all of the parameters of the attachment and want to know what the code is for viewing the attachment. I see GOBJTXT…

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…

How can the three buttons in the top button row V12 UI be customized. For example, in the Sales Order screen, buttons available on top (out of the box) are Allocation, Preparation and Delivery. We don't do any of that and would like those to be Invoice…

Hi, I`ve created some fields on the table BPARTNER, after that, I`ve cloned the BPR2 screen and renamed to BPR3 with the new fields: ----------------------------------------------------------------------------------------- After add all fields and…

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, I would like to know if there is a way to increase the number of buttons showing on the screen header. As example: On Suppliers, I added 2 new buttons, Test 1 and Test 2, but on the header there are only 3 buttons ----------------------…