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.

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…

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

We are using Sage Payments with our Sage 300. We'd like to change the Card ID on the Credit Cards tab in AR Customers for a specific customer. We will just be appending zeros to the existing number. I see that IDCARD exists in OEORDH1, YPPMTINF and…

Hi All, I am practicing to add custom fields on Order Entry - Shipment Entry Screen. I have followed tutorial in Sage300-SDK-web-2019\docs\customization\Sage300SDK_WebScreenOrderEntryCustomizationTutorial.docx, except the I change the screen to Shipment…

Hi All, At first, I created an Optional field in the common services. Second, I created the Optional fields in the "I/C Setup". The optional field is visible in the serial number under the optional fields tab. I am trying to create a report…

We have a number of products that may include several options and I was looking for a good way to track them. For each product we order around 36 specifications for it. At times customers may request a particular specification and we will add that to…

When we issue purchase orders for new stock inventory, there is a delay of up to 3 months (for production, testing, and shipping) before we actually receive the items. During this time we allow our sales people to place orders against the items even though…

I am upgrading a client and I have run into the issue that somewhere along the way optional fields was activated in the company data. But they have in fact never owned it so it must have been done with a 30 day trial license. Now when I upgrade the data…

How do I set-up Box 12 DD for W2 reporting?

Good day Is there a way or a 3rd party program that can track to see which stock has been shipped from accpac but awaiting collection by the customer and still in our warehouse? Also how best can we have committed stock to show the customer and for…

Our customers provide our company with product to be processed through various manufacturing lines and return them once completed. Most of the customers provide us with lot numbers that must be tracked through our processes and are required to appear…

Our company processes customer supplied product using various specific methods. Each of the different processes have their own Item Code to specify the type of work as well as providing the customer specific pricing for a process. Example: PROC001,…

Hi all, When Value "yes or no" was entered in this optional field, how exactly do we extract this piece of information? or instance, we entered "yes/no" in PO Entry optional field. Value in POPORHO shows " ...". please help.