x Want to participate? Join the group to interact

  • Moving an overpayment from one customer to another

    I have a customer that has about 10 different divisions in different states. I received a few checks today , and while applying payments i accidentally over received in one account. So now that account shows -$239.40 , however i need that to be transferred…

  • How Avalara Calculates Sales Tax

    I have invoices that have the tax schedule on the header tab as NONTAX ​ and the ship to location code (tab 2) has AVATAX as the tax schedule. No tax is calculated. If I change the header tab tax schedule to AVATAX then tax gets calculated. Shouldn't…

  • Where is UnitCost in SalesOrderDetail and SalesOrderHistoryDetail from?

    Hello, I'm working with Sage 100 and currently working on figuring out job cost. I have a question as in the subject--Where is UnitCost in SalesOrderDetail and SalesOrderHistoryDetail from? Would someone please help me understand the calculation logic…

  • Sage 100: Announcing Sage 100 Payroll 2.20.2

    What's new in Sage 100 Payroll 2.20.2 COVID-19 Legislation support Emergency Leave Worksheet Employee Retention Credit Worksheet Updates to Quarterly Tax Report Updates in Federal and State Tax Reporting International Address Support…

  • Credit card not Processing on Sales Journal Update

    Hello, I am having an issue processing credit cards through Sales Order Invoice Data Entrybin Sage 100c 2018. I can preauthorize a credit card charge in Sales Order Entry and it preauthorizes in Paya. When I invoice the sales order the credit card authorization…

  • Merging items, "cannot merge Sales Kit to an Item" but no BOM exists

    Hello everyone, I've got myself a peculiar situation and wondering if you could lend me your brain a bit. This is 100c Advanced 2017 5.4 I'm trying to merge hundreds of Kit items into a corresponding new item code. In order to merge them, I initialized…

  • After a report opens, it gives a #nameerror for every single formula I've used in the report

    I am able to open reports just fine on my computer. My boss, however, is getting #name errors on all forumulas when he runs the same reports. The 3 add-ins are turned on in his Excel. It worked fine for him yesterday. Any idea what the problem…

  • Some items received and others not - Receipt of Invoice entry

    Hi guys We posted a receipt of invoice batch earlier and some items seem to have updated to item maintenance and other items have not. Some items are showing as received in Receipt of invoice but not showing on IM. We ran a rebuild for the PO and…

  • Two separate errors: Sales Order Batch Authorization (oScript.UIObj error, and 'Referenced statement invalid')

    Hello, We have been having issues with Sales Order Batch Authorization. Nothing errors out until the final step where accounting actually tries to process the credit cards .Here is the first, which I'm unfamiliar with: The second one, I have…

  • How to clear Misc Charges on Purchases Clearing Report

    Working with Sage 100c Advanced v2019 and need to clean up Purchase Clearing Report where some PO's on report have Misc Charges on them, they go back years. Example: Qty Ordered = 7.00 Qty Received = 0.00 (Can't receive Qty on a Charge) Qty Invoiced…

  • Sage 100: Announcing year-end updates for Sage 100

    What's new in Payroll 2.20.0 Compliance with revised Form W-4 Revised Arkansas Filing Statuses Note: Keep in mind that the Payroll module is a standalone installation. You can upgrade the Payroll module without upgrading Sage 100. Sage 100 Payroll…

  • CR Entry not matching Customer Inquiry 'Invoices'

    Hello, We have an issue where we are trying to adjust an invoice balance. We are trying to set the balance due to 'x', but the adjustments keep showing up as 0 under customer inquiry (picture below). The amount is adjusted correctly in the Cash Receipts…

  • Processes showing up in the master console that don't exist on the system

    I have processes showing up in the master console that don't exist on the system. How do i get rid of them in the master console? They are both country code maintenance programs

  • Misc item charges not being billed?

    Hello, We have a miscellaneous charge we add to certain customers sales order. I was just informed that although these are showing up on the Sales Order, the customer is not being billed for this. How would I go about ensuring that this miscellaneous…

  • Sage Accountants Network (SAN) Client Advisory Services (CAS) Program

    Deliver more value. Increase profitability. The Sage Accountants Network Client Advisory Services Program , created in partnership with Boomer Consulting, guides you to create a clear and concise strategy for increasing value and profitability by providing…

  • Freight rate as a percentage of sales order $ total

    Since Sage100 does not offer out-of-the-box an option to calculate freight based on order $ total, has anyone found a work around? We have different freight percentages established and would like to somehow designate a customer to a particular freight…

  • MapQuest Outage Update. Fix ETA?

    It seems that the Compass Icon (=MapQuest lookup) in the Accounts Receivable Customer Maintenance/Inquiry has not been working for at least two months. (Error: "Sorry, we are having trouble with that URL"... KB # 110829) Has anyone else have this experience…

  • Is there a way to track who/when deleted a line item in a Sales Order?

    We are having an issue where line items are being deleted from active sales orders either manually or via our pick/allocation process. We can see these deleted line items in Sales Order History, but is there a table with history as to when/who deleted…

  • When printing the Receipt of Goods Register, incorrect volumes are printed.

    Running on Sage 100 Premium ERP 2015 (Version 5.20.5.0) The expectation is that on the Receipt of Goods (ROG) Register, where it is labeled "Volume" or "Weight", the volume or weight for that item would be displayed, regardless the number of lines on…

  • Serialized item on hand but not available.

    I am trying to assign a serial number that shows it is on hand, but when I try to assign it to the sales order, it is not available? How do I correct this? Sage 100 v.2017 v 5.40.1.0 Any suggestions on how to correct this would be appreciated.

  • Cash Receipts Journal: Full amount is posted in General Ledger, but not to accounts?

    Hello, We had a strange event occur a few days ago. For one of our batches, the Cash Receipts Journal processed all of our checks except for the last 4 in the batch. However, the full batch was posted to the General Ledger, and the full amount shows…

  • Sales Order Entry Freezes when clicking accept.

    Hello, We have recently had many complaints about Sales Order Entry freezing when users click accept after creating a sales order. We plan on restarting the servers this weekend but I am not confident that this will resolve the issue. I have searched…

  • Error 15: OS System command failed

    Hello, We are encountering the following error during cash journal printing. This happens on almost any cash receipt journal we try to print, I have only had one successfully go through. Help would be very much appreciated as I have no idea where to…

  • How to make Cash Receipts hit GL, not just sub-ledger?

    Hello, Our accounting department recently brought to my attention that entering data inside of Cash Receipts Entry only posts to the sub-ledger. They must then go into the daily transaction register in order for this to process to the General Ledger…

  • Year End and Data

    Hello, I have been searching for and can't seem to find the information that I am looking for. My question is, what exactly does Year End Processing do to the data inside of SAGE? Does this make it so that fields can no longer be changed in that fiscal…

*Community Hub is the new name for Sage City