Sage 300

Is there an AP code automation where If a vendors first letter starts with an H the auto generation vender code is H-00001 if the vendor start with a Q it is auto created to a Q-00001.

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…

Hello, Getting the below issue while activating the newly developed module. I am able to create a flat view that is independent but when it comes to creating a join subclass view in the below tables like ARCUS, ARIBH, OEORDH. I am getting RVSPYTRACE…

Is there a way to add fields to Enter Invoices in the AP module?

We are running Sage 300 Premium version 2022. When we go to Customer Inquiry screen and use the Invoice Drill down - the view has a tab for Optional Fields - but the O/E Invoice optional fields are not being displayed. If I pull up the Invoice from the…

In Sage 300 2022 when I try to add Optional Fields to Account and Transaction Details in the General Ledger, I come across a error message that reads as follows: "Cannot insert, update, or delete General Ledger Optional Fields until all other Users…

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 all, I am making an AR Receipt Entry import to import the receipt in bulk from an excel file. I follow the recorded macro to create it. And I see that the ARPOOP (in recorded macro is using ARRECMAC1detail4) set the APPLY value to "Y" on line 124…

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, Can I have optional fields in ITEMS set as required only in certain scenarios, such as an item category? We dont need all optional fields for all types of items but when we do need it I want to require it. Whats the best way to set that up?…

Dear Experts, I wanted to check what is the best workaround for overcoming the 60 Character limitation for Optional fields? is there a way we can alter directly the table and add a field to load the full length description of the Item and using some trigger…

Hi all, I want to make the email field in AR Customer unique, means only 1 email for 1 customer only. How can I do that? I assume I just set the email to be unique in database level, is there any implication to expect? Thank you

Hello, I have an AP optional field set at the Invoice Detail level, with the "Settings" set to "GL Accounts - Distribution." I have the same optional field set up in GL. I set "Required" to Yes in bot AP and GL. However, I cannot get the optional field…

Hi All, I am making a new Financial Report. After 1st FR View, all the columns and rows lets say column A-E, row 1 to 5, are showing. Then I add more columns (F-H) and row (6-10), the new columns and rows are not showing after FR View. IT even remove…

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.