Sage 100

Sage 100 c - We noticed on an inventory item in inventory inquiry that the amount on PO was incorrect...meaning that when we looked at the open POs for this item, they totaled 7 on order, but the inquiry screen is showing 24 on order. In the past in MAS200…

Hi, I am hoping the SAGE community can help with this request. We have a standard wholesale price, say $10 for a SKU, and we have a range of price levels for our customers. If a customer has a price level of 20% off wholesale, the SKU would appear on…

We have a 9/30 Year End. The 10/01/2018 beginning balance for just one balance sheet account does not match the 9/30 YE balance. If I run a detailed GL for the account using the selection criteria of "by date" - it is correct. But if I run it just for…

In Customer Maintenance, on the 'History' tab, we are seeing that the 'Profit %' and 'Profit $' columns are being calculated using the sales + tax. Should it be? Is there any way to change how these numbers calculate? (Meaning exclude tax)? Thanks!

I'm needing some help with crediting freight back to the customer from a return. It seems like the system can do this without me having to manually add in freight charged to the original invoice. My question's: Do I need to create a default reason…

Does anyone know at what point amounts get added to the Period to Date Purchases field located on the Summary tab in A/P Vendor Inquiry? Is it when a PO was written, receipts against a PO were entered, a check was written to that vendor, or something…

Minnesota has some changes in sales tax categories (transit tax to be specific). We set up brand new tax codes and then had to change all of our customers to use these new tax codes. For the most part, things went well. However, we have been having…

We are having an issue with a specific 2% Net 30 Vendor whose invoices frequently arrive too late for us to make the discount. When we do our invoice payment selection for the vendor, the discount is applied. This happens even when we set a specific discount…

The company calculate salesperson commission rate is by salesperson. Such as Salesperson A has a commission rate 10%, then he can get 10% commission from his all invoice. Now the company wants to change the rule, the commission is calculated by items…

How do you set up the deduction for the New York Paid Family Leave that is being implemented?

We recently found out that our city tax is computed by the first $5000.00 spent being 2.5% and then every dollar above $5000.00 spent on the same invoice is only at 2.0%. How is this possible to set the tax rate based on the total dollars of the sale…

We've been using Avatax since Feb of 2016 and have run into issues that is causing us problems, we're at the point where we are considering cancelling Avatax. Is there any alternative to Avatax? How else do companies deal with sales tax that have…

There is preliminary discussion in our company about changing our inventory valuation method in Sage 100. All skus are currently at Average Cost and discussion is to change to LIFO. I have been looking to find more information on the technical/system…

Is there a way to disable sales tax calculation on SO sales orders? You may think it a strange question.... but we use Avatax and we get dinged for each "transaction" hitting their server. Sales orders count as a transaction and each time we update…

My company is a distributer/reseller and we do not manufacture anything. However, there are times when we buy products and then send them to a 3rd party company to have additional treatments done, thereby increasing our cost of goods. How do I account…

I was wondering how others are implementing the 110% taxation required on drop shipments to California locations. Does anyone have a good system for handling this with AvaTax?

When is the statistics tab updated? We noticed the Balance and aging buckets do not always show the correct totals, so there must be some process to run to update them?

We have a vendor who has asked us to provide products for a customer, bill the customer directly, and add 10% to our prices as payment for the vendor for their services installing the products. My question is, how do we set this up to track it properly…

Is there a way to post sales tax paid to the same account as the item purchased? For capital goods expenditures the entire cost, including tax, needs to be depreciated. The tax can't be expensed in the current year. Currently the tax for all purchases…

We have recently noticed a negative amount (overpayment) on our Sales Tax Payable general account. We have been submitting sales tax based on the "sales tax collected" amount in the Sales Tax Summary Report. We have had large projects going thru SAGE…

We implemented Avatax a week ago and were told to run the AR Sales Tax Calculation utility after changing the customer's sales tax schedules to Avatax. When I run the utility I get some errors, namely "Unknown country name or code (BER)", "City not…

One of my auto deductions did not deduct from payroll. There has been no changes and the check is in the box. Ran it through in a test company and it worked. I guess I will double up on the monthly deduction, but as I mentioned now if no resolution…

I have added an OHIB record in payroll and it posted to my checking account even though the record shows a zero net check. What happened?

Hopefully, I posted this question in the correct area. We just upgraded to Sage 100 ERP 2015 and are on version 5.2. However, I went back to our prior version 4.4 (yes we were slow to upgrade) and I had the exact same problem. I need to void a Direct…

We have Several items that will only have 2.5% commission where the sales person has a commission rate if 9%, sages docs are on clear on how the SO line item commission maintenance works and what effect it has on the sales person to customer relationship…