• Reverse a posted journal entry

    Hello, Is there a way to reverse a journal entry in Sage? (Sage 500 ERP 2014 January 2015 Update (Version 7.60.5.0)). I'm not referring to an auto-reversing entry; the situation is - someone posts a journal entry with many lines and then it is discovered…
  • Freight taxes

    Our company needs to start taxing certain customers and I'm very familiar with how to use Sales Tax for items. I remember also taxing freight - many years ago - but I cannot remember how to set it up to include freight as well. Can anyone remind me how…
  • journal entry review prior to posting

    For Sage 500, within a subledger transaction (i.e. accounts receivable invoice batch , accounts payable payment batch, etc.), I would like to review the journal entry (see the debit and credit sides in a traditional journal format) before posting the…
  • Changing salesperson on AR commission plan

    Question. Our Finance department is attempting to remove one of two salespersons (50/50 split on commissions) assigned to a commission plan. At the time of attempting to save the changes, the system states that unposted invoices exists and cannot save…
  • Cost Tier Adjustments

    Zennon or anyone, We are about to roll out a new costing program. To begin our project we must post a cost tier adjustment for all tiers of our inventory. The only problem is that we have 290+ inventory items and some have more then one tier. Is their…
  • Pre Auth with Debit Card

    Hello! A customer used a debit card for payment. We processed the pre-auth successfully and then processed the dropship successfully. This charged the customer's card twice. Sage 500 doesn't show it, but we see the duplicate transaction on Sage Exchange…
  • Allocating through Statement posting

    Hi, I've manually posted bank statement details using Cash Management > Tasks > Statements > I use Cheque numbers in the description/reference field and it matches (and allocates) the line to the cheque in the AP module. However last time it also allocated…
  • O2 Process Manufacturing Users - Strange Material Variances

    When I close a production batch, sometime I get a strange material variance which caused my unit cost to increase dramatically. This happens once in a while. Has anyone had this issue? Thanks Allan. [email protected]
  • Cause of the error in Edit Shipments "The quantity distributed is greater than the quantity picked" - are there any workarounds ?

    When using "Edit Shipments" I get the error "The quantity distributed is greater than the quantity picked" and its game over. I have not been able to determine what drives the error or how to get past it. Thanks in advance for any suggestions.
  • Cash Management Bank Reconciliation - First Time

    After using Sage 500 over the last 4 years, I want to start utilizing the bank reconciliation feature. How do I handle my current outstanding check list?
  • Accounts Payable System Check Register EFT: Not Assigned

    In one of my new companies I recently set up, I am having an issues with Accounts Payable, System Check Register NOT ASSIGNING numbers. I have looked but just see what is not checked or set up incorrectly. All of my other companies work find.
  • Is there a fix for when users fail to associate a Customer Return with a Shipment?

    There are some transactions in Sage 500 that, if done incorrectly, cannot be undone and cannot be fixed. Is this one of them? The problem is that if a Customer Return is entered without being associated with a previous Shipment it will cause the Sales…
  • AR Average Days to Pay calculations

    In doing some research for a client, I discovered an apparent inconsistency in the methods used within Sage 500 to calculate the values in tarCustStatus.AvgDaysToPay and NoInvcInPmtAvg . When calculated in sparModPostPmtApplCS (called from sparModPost…
  • Partial Payments/Decimal Quantities for Serialized Items

    We have a serialized item in our inventory (a cooling tower) that is currently the only line item on an open PO and has a quantity of 1.00. We have setup progress payments with the vendor, received the first invoice, and need to make the first payment…
  • GL Fiscal Calendar Issue

    We are at the end of the fiscal year 2015 and accounting noticed that instead of 12 periods there are 24. Can the 12 periods that fun into 2016 be deleted?
  • Drop Ship Voucher Problem

    An voucher for a drop ship purchase order was entered in error and I am not sure how to fix the issue. The "Release Drop Ship to AR Invoicing" step has not been run. What is the solution?
  • ap trial balance query

    does anyone have a query that returns the value of the AP trial balance? We want to extend that functionality to show line dist level detail of vouchers
  • Availability of 1099's for 2015 Tax year?

    When with the 1099 updates be available for tax year 2015?
  • Credit card deposit amount not showing up in cash management (bank Reconciliation)

    When I run a credit card deposit and post it into cash receipts and general ledger, the deposit amount does not show up in cash management (bank reconciliation). Help! Thanks
  • We have 2 old pick lists that are stuck. The pick numbers show up in Explore-Pick Lists (show as status = pending) but when I type the pick list numbers no records are found.

    We have 2 old pick lists that are stuck. The pick numbers show up in Explore-Pick Lists (ship status = pending and there is a shipment number) but when I type the pick list numbers to reprint pick list, cancel pick list or confirm picks the pick numbers…
  • Renumbering GL Accounts - Naturals

    It doesn't look like there is a way to rename Naturals? We are extensively reworking our GL and it looks like all we can do is create a new natural then use the rename accounts utility. That gets a little complicated when you're moving everything around…
  • Import A/R transactions into Sage 500 ERP

    I'm a new user to Sage and am not in the IT field. My goal is to create an import file (.CSV or excel) containing each invoice number, payment amount, account info, etc to credit each invoice paid by an ACH remittance (money was already deposited into…
  • Cust PO number on CC statement?

    We're using Sage Payment Solutions to charge customer's cards for shipments. The customer ID appears on the customer's credit card statement. Is there a way to get the PO number to show also/instead? tia,
  • Error Creating Cost Tiers

    While trying to commit so transactions we received an error creating cost tiers. The quantity in the selection was just over 1000. The TotRunVarCost was 18.01. I figured out that the amount was too small and zero'd it out. This allowed the commit so transactions…
  • We want your input!

    We are conducting a quick survey of Sage 500 ERP companies to determine the AR payment options you offer to your customers. If you would like to participate, click here to access the form. Thanks for taking the time to respond!