Sage 300

Hi all, I have a custom module ID that I have create, build, and copied to sage300 installation folder. The module ID only consist of dll to create flat view. I am able to activate it on Sage 300 v70a. then I want to install it on test server with v69a…

I have some problem in macro the case was, i want to get 2022-01 (yyyy-mm) fiscal period status of my IC module in ACCPAC using macro Can anyone have some solution for this? thanks in advance

We are rolling out the Project Management module and want to require certain fields so our Project Managers are required to enter the information before they can create the new job. Is this possible?

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…

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

Hi All, I'm making a macro to post receipt entry based on PO number and the receipt number is pre-generated. For the detail line, I do not want to receive all. But so far did not success. How to prevent receive all? Below is my code. I have set…

Hi All, I am making a project where I generate code Shipment OE0434 as Flat But it is not showing any Shipment Entry. I can confirm that the company have Shipment Entries. Can anyone guide me on how to solve the problem? Thank you.

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…

Hi All, I would like to select data by field other than ID. Can guide me how to do it? So far I can only get it by Id. Also, how to get a list of items? for example select top 10 * from OEORDD where ORDUNIQ=1 will generate rows of result. …

Hi all, I want to add new url to call from js to controller. but it return status 302 found. On xxxBehaviour.js on XXXController.cs Is there any out of the ordinary way to add new function on controller? or anyone know what is the problem…

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.

I recorded a macro and this was the line that was recorded for the date. GLCRE2Fields("DATERUN").Value = DateSerial(2016, 8, 31) I want to be able to input a date and tried this. I tried this below; Date1 = InputBox("What is the month end", "yyyy…

To all Sage300 Report and/or Crystal Report gurus: I have an item optional field that holds a number value that I need to use to compute a quantity for each line item for which I need a running total in the footer in the OE invoice report (OEINV01.rpt…

It seems as though the problem would not exist if I could just start a clean session each time. I am using a simple script to initiate a Macro but it apparently does not end the session when done. Thanks for any help. Bill Domke

Hi, I have created several optional fields in Inventory Control to an Item. When I link the table ICITEMO to the Order Entry Lines by Item, I do not know how to pick the correct optional field from ICITEMO. I have 5 optional fields, but it seems to…

Hi, Can I add the user name who is printing the form on the form? Thank you!

Hi Accpac Gurus, Development Environment: Windows 7, 32bit, visual Studio 2005 VC++, Accpac & SDK 2014 MS SQL Server 2008 Client Environment: Windows 8, 64bit, Sage 300 ERP 2014, MS SQL Server 2008 I am trying to upgrade one of my custom module (Add-on…

Hello, We are in the process of designing new customer statement format. In the statement, we want to display the "Customer Payment Description". how difficult is it to display the payment description. Thanks,