Sage 100

The main tab under Item Maintenance is showing "on bk ord"=0 however on the orders tabs I am showing a total of 2 "on bo". I just rebuilt the sort files Sunday night, and users are saying this just started happening recently, I cant think of anything…

Hi, i’m trying to retrieve date difference from issued date to current date in Sage but somehow I must have my formula wrong, need some help. I’m hoping someone can let me know what I’m doing wrong. PrmChg.chgdte is the date field from Prime Change…

In SO Entry on the lines tab we have "total amount" then on the totals tab we have "taxable amount". These two fields are off and I can't figure out why, says order is out of balance. It is a price quote right now.

We are continuously having issues with our users not noticing that the vendor discount amount on the receipt of invoice entry does not match what the vendor actually allows. When miscellaneous non inventory items are included in the lines of the receipt…

Noticed an issue where the Item Inquiry On SO quantity does not match the Orders tab total quantity. I did some digging in the sage knowledge base and saw some articles surrounding this, mainly this one Item Inquiry On SO quantity does not match the Orders…

Hi I am having an issue were a figure on an item we have is not being reflected properly. Under orders it shows we have 100 + 80 on purchase order but when we look at PO field it only shows 100. I have ran the rebuild sort files for both item maintenance…

This may be better accomplished by a crystal report, but I don't have access to create those. I'm looking to calculate the final GP Margin on a job including credits which are often $0 to the customer with negative costs of goods so they greatly improve…

I have created a couple of databases out of MAS and back into Crystal. I'm needing to know how to find the average of how many items we have sold. something like this. if LY01_BeginningQ is Greater or equal 1 then count LY01_Sales then count if LY02_BeginningQ…

I need some help wrapping my head around creating this AR Terms Code. This is what I need: Invoice dated 1st - 15th payable 15th following month Invoices 16th-31st payable 30th following month Thanks for any suggestion!

What is the purpose of the Invoice History button (up in MORE) ?? and why is it .. We had Customer A .. and we were trying to find out information as to how some invoices were paid. Normally I click on the binoculars, and click the box that states…

Hi all, we are on Sage 100 4.4. We want to set up a terms code with a discount for 3 day pay. The trouble it, the terms code discounts every line item. We want to only discount product, not freight. Frieght is an item we setup in Inventory. It seems not…

Does anyone know if any Sage 100 Add-ons for food producing companies? I have a client that would like to record Safe practice information and make tracking Inventory easier. For example: Mixing raw ingredients sometimes causes tweeking so instead…