Sage 300

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…

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…

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 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, 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

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…

Does anyone here encounter an error for the SUBVIEW.DLL? We created a WEB API, when deployed it is fine when creating single calls. But when doing multiple calls simultaneous we got w3wp.exe error. Upon analyzing the dump file it shows: \ vi65a\SUBVIEW…

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

Hi, In older version I remember there is a possibility for us to custom and add more inquiry into the web screen. Now in 2019 is this features is still available? That we can add more data to be part of the standard Inquiry which is available. If yes…

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've recently installed 300c Webscreens which has a nice interface to it, albeit a bit limiting. The first thing everyone in the office asked, why do I have to have pages of records rather than being able to scroll through the entire list at a time…

I need to make a minor change to the L-PB Detail with Stored contract invoice format. The CNAME in TS Billing Field Names is giving our group name instead of the Company name. We have 5 companies and I need it to give the correct Company name based on…

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…