Sage 300

I know in OE can do something like OEdet1.gotorecordnumber 3 for example to go to 3rd line in grid but when I try this in PODET1 view (POPORL) I get an automation error i can podet1.gotop and podet1.gonext and browse all the details how do i go…

Hi all, I am making a macro program to insert OE transactions in bulk by reading a csv file with a lot of Order transaction. Some of the Order might have error while trying to insert. So, I need an indicator that this specific transaction failed or…

Hi all, I am developing an app using ACCPAC libraries: I have difficulty to do an Order Entry from my application, especially on setting the value of CUSTOMER (OE0520) and ITEM(OE0500), to do RecordCreate(ACCPAC.Advantage.ViewRecordCreate.Insert…

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 all, I try to add new Order Entry with ship all & auto create invoice using API with the following json {"CustomerNumber":"2347", "OrderDetails":[{"LineNumber":0, "Item":"A11030", "QuantityOrdered":10 , "PriceList":"WHS"}], "ShipmentNumber": "CASH0003…

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.

Note the is a .NET application written in C#. I have an application that imports orders, purchase orders and inventory items into Sage. The customer supplies a file that contains all of the purchase orders w/items. The file is parsed into purchase orders…

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 have modified the original invoice footer with 2 format options by parameter field on Bill Type for user to select the format when printing. Example Footer A for Standing Billing Footer B for Tenant Billing Below is the formula from the existing sage…

Hi, this is continuation from my question "Web SDK - generating multiple code type, and set fix Index.cshtml to be display" which is solved. Below is my screen. After user sign the signature pad, I want to 1. Save the signature (DONE) 2. add new…

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.

Hi All, is there any automatic way to remove code generated by Code Generation Wizard? Thank you.

Hi All, I have a custom table/view that I create using Orchid Extender module Table name: VIOEDEL View ID: VI0704 Is is possible to add view composition to custom view linking them by ORDNUMBER. I want to add OE0520 (ORDDH). The reason is…

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

Hello I Want to get the opened company id on my custom program, which argument can i use? i'm using Sage 300 2012

Hi All, what is LINENUM? In OEORDD, Initially I though of it as the line number of the items in an Order Entry. So I was expecting the value would be LINENUM=1,2,3 and so on. But the value is 32, 64, 96, in so on in increment of 32. So what is it…

Dear All, I am developing a project using Sage 300 Solution Wizard from Web SDK. When I am trying to generate code with ROTOID=OE0692 which is Shipment Header, using Code Generation Wizard, I get the following error. How to solve this? Thank…

Dear All, I am creating a new tab on OE Shipment Entry. I achieve the UI that I want, and now I want send post request on a click of a button. Instead, I am getting an error: Unexpected Error: Your request could not be completed within the time…

Dear All, how to remove the customization in the admin screen? It has too many unused test and I would like to delete it from the list. Thank you.

Dear All, I am working on Solution Wizard with Web SDK. I successfully created 2 modules, CU and SG. But the only problem is the modules is not displayed correctly. SG module is not showed in the navigation menu. But the content of SG modules is displayed…

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

I have developed a 'payment' process that calls Sage 300 API APPaymentAndAdjustmentBatches for vendor payments and ARReceiptAndAdjustmentBatches for customer payments. I'm currently running these processes (one for each API call) multiple times a day…

Does any have a Payroll tax inquiry already made at the level of each state tax type, per Quarter for current fiscal year? Yesterday we found out that Sage PR was not calculating taxes correctly and we need to make adjustment, but I can't find correct…