Sage 100

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…

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?

We need to have the ability to use Penny Test to verify bank accounts for a vendor instead of Pre-Notes. There are too many ways that fraud can occur by just using Pre-Notes. I created the following idea. If you agree, please vote for this. www5…

How would I go about creating a popup for invoicing department when they are invoicing orders and some line items have a "0" for price? The goal is to eliminate giving things away for free by accident.

I am looking to customize customer statements in the A/R Period End section. I can set up basic customizing by setting up a new form and going into design and making my changes, but I want to limit which customers are generated without having to enter…

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…

We have upgraded to Sage100 Premium (SQL version). We have been using a separate Excel workbook for special coding we like to use. We would now like to get all those special codes into Sage100 into the rollup codes and UDF's. We do not want to manually…

i have created a VI Job that I am trying to use to reverse a large amount of checks. Each check has one invoice. I do not want to recall original invoices but create a distribution amount to a GL acct. When the job is ran it automatically recalls the…

I am wanting to build a cash flow report that can also serve as a place to tweak projections. The current Sage 100 - Bank Rec- Estimated Cash flow report doesn't drill down enough, detail GL accts, and allow enough flexibility?

Hi, I have several customers with special requests regarding the sending of their invoices (mail, fax, e-mail to specific parties, etc). We created memos that pop up during Sales Order Entry. Unfortunately, that department doesn't always remember to…

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…

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.

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…

Is there a way to produce a remittance advice when making payments using AP manual check and payment? We are not set up yet to pay ACH's through Sage check printing and electronic payments, so we are entering ACH payments through manual check and…

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…

Hello, I'm new to SAGE 100 and trying to find out newly received all purchase orders in any given month. Can some one please help me to get this list? If you have any T-sql query and willing to share that would great. Hope to get someone's help…