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.

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

Optional Field Value. Attempt to modify a different record than was retrieved. Im getting this error while trying to enter new value for the optional field. Kindly help. Thank you

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

We are using Sage 2016 pu1. Want to know what is required to use Optional Fields in I/C Control Module? I gather from what I've read online that Optional Field Creator is required to be installed, but this is this bundled or is this additional cost?

Has anyone ever had a need to create a manual cheque number? For example, wanting to use a cheque that was used for a payment but wasn't actually in the printer at the time? I'd like to be able to take a cheque number like #00179 and modify it slightly…

How do I add sub-accounts in my chart of accounts? EX; Account 64000 - Marketing shows I want to add travel, meals, supplies, freight all under this account. Marketing Shows Travel Meals Supplies Freight

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…

Hi, Is it possible to change the Extend Price Calculation in Order Entry? Right now, our products are sold by the item number and the length. For example, a wood pole may have an item number called,"WP". We cut the WPs based upon the customer's request…

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