I can insert a customer, i can insert a Vendor, but when i try to insert an invoice into AR, i get object set to null errors lol no matter what i do. I've been doing permutations of the code in hopes of finding WHY the error happens, i tried their RVSpy…
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 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…
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…
Hi, I need to do filtering using the "NOT IN" just like in SQL SERVER, but with Browse() function in ACCPAC library. I try using NOT IN with browse but got error, I guess its not supported. Is there other way to filter similar to "NOT IN"? Thank you.
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…
Hi All,
I am creating a new customize program to import invoice in bulk from excel file while referring to a recorded macro on Sage. The import of Shipment number and its detail lines are fine. But when I try to insert to OEINVH, I got this error "The…
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…
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…
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.
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…
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…
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
----------------------…
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…