• Payment Terms Set-up Pays 10th of month for Previous month

    I have a customer that would like to pay the 10th of each month for the previous month, in addition to a 2% discount off invoice at time of payment. Is there a way to do this in Sage without making custom field calculations? I am using Sage 100 2022…
  • Sales Tax Exemption Expiration Logic

    Hello all. I'm new here, so I'm stumbling my way through some of this...it has been enlightening to say the least! Here in Oklahoma, agricultural sales tax exemptions expire periodically. For audit purposes, we must maintain records of our customers…
  • Customizing "Ship to Address" Field

    Within the Sales Order ----> Sales Order Entry Module, I am trying to add some customized fields related to "Ship to address" within the button itself. (Shown Below) Is there any way to customize the Panel shown above?
  • SO_SalesOrderMemo_bus SetValue on field Attachment not work

    we use a external BOI to maintain sales order memo, to validate attachment file path is valid, below script works for all other memo fields except Attachment. Does SetValue not work on field Attachment? retChk(oSS.nSetDate("S/O", Today.ToString("yyyyMMdd…
  • Certificate of Insurance from my customers

    Is there a way to record Certificate of Insurance from my customers in Sage 100 Premium version 2020?
  • Comments

    How are comments/Message Text carriage returns stored in Sage 100. For example, this is a customer memo: ****ADDRESS UPDATED 2/16/17*** HEADED: LOWEST POSSIBLE SS HEADED: COST X 1.9 ---- FOB VENDOR D-BAR: 1 COLUMN OVER THREADED: " J " COLUMN…
  • UDFs in Transaction Entries

    I'm attempting to make a UDF that will appear on the 8. Cost Detail Tab in Item Maintenance and be available to report on for some government requirements. I've been able to add the UDF in IM_Transaction Tier Distribution Entry, PO_Receipt Tier Distribution…
  • UDF is Added to SO Detail but Doesn't Display on the Screen

    UDF is Added to SO Detail but doesn't display on the screen. Verified the UDF is not marked as hidden. Below is what I tried so far: Removed all of the UDFs from the SO lines panel. Deleted the ###-### and all other folders from the SO\custom folder…
  • A/R Repetitive Invoice - Change Reference?

    Is there a way to revise/change the reference code listed for a repetitive invoice? Or, do I have to delete and re-create a new one? Thank you!!
  • National Accounts and effect on Date of Last Activity

    Am I correct that if we turn on the National Accounts feature, that for those "sold-to" customers we have assigned to a "bill-to"/National Account, the DATE OF LAST ACTIVITY will only update on the Bill-To Account, and not on the Sold-To account because…
  • Is there any advantage/disadvantage to numbering vendors with numbers or using alphabetical?

    Any suggestions on whether it is better to use numbers or alphabetical method for numbering vendors? We can use 1, 2, 3, etc, or we could use the first letters of a vendor's name? Thanks.
  • What is the easiest way to re-number vendors?

    When the AP vendors were originally setup, they didn't leave enough space for additions. I'm considering re-numbering. We have hundreds of vendors. I'd also like to number any duplicate vendor in different companies with the same numbers. What…
  • Suppress Printing on a Customer Invoice

    We do service work that in some instances calls for a "fixed" price per job. We will bill for the total cost of the project on one line item. We add additional items to the SO for costing purposes. Does anyone know of a way to suppress the print on the…
  • account numbering

    Setting up new company in Sage 100c. Setting up main accounts with 5 digit numeric - XXXXX I will be adding a 2 digit numeric for departments: XXXXX-XX My question is when I come to setting up inventory I will be adding more fields for inventory…
  • Time off remaining is incorrect on paycheck stubs

    I customized my paycheck stubs to list the remaining time off for employees. Once I was able to get the form to print properly, I discovered that the time off remaining is incorrect, and I can't seem to figure out how to get it to show up accurately.…
  • What is the 'best' way to auto populate "UDF" City and "UDF" State from "UDF" Zip Code

    I am currently using the following (which works), but is there a 'better' way to do this? (I don't like hardcoding the connection string with username and password.) '-------------------------------------------------------------------------------…
  • Customizer salesperson UDF

    Is it possible to create a field (UDF) that replicates the salesperson lookup using business object fields for salesperson? I need to add this secondary salesperson lookup in AR_Customer and SO_Shiptoaddress. I was hoping against hope that I could do…
  • Picking Sheet Printing History

    I have been working on a way to track who prints a picking sheet and when, I have this script working perfectly when connected to a button but I am trying to tie it to an event. I have tried tying it to Column - Pre Validate on the PickingSheetPrinted…