• SAGE ERP 500 2019 - Cash Management Entry - Currency Exchange Rate Error

    When entering a Cash Management transaction on the "Bank Transaction Entry" screen there is a grayed out field to the middle right called "Transfer To Exch Rate" and it should display a "1.00" all the time for us. While entering a number of transactions…
  • Purchases Clearing Report

    Purchases Clearing Report can be used to simplify month-end reconciliation of the purchases clearing account balance with open amounts on purchase order. The purchases clearing account is a liability holding account that contains inventory received in…
  • Bank Reconciliation Hints and Tips

    Here are some hints and tips about Bank Reconciliation that will make it easier for you to perform and understand Bank Reconciliation in Sage 500: The ‘Book Balance’ is the balance in Cash Management Module. It is not the General Ledger balance in…
  • AP GL vs AP Vendor Trial Balance vs AP Aged Payables.

    I am new to Sage and my company and just starting to dig in. I am looking at the AP general ledger and comparing it to the subledgers and they do not agree. AP GL = 3,085,390. AP Vendor trial balance = 3,087,464. AP Aged payables = 3,338,490. I would…
  • Credit Card (CC) Import files from Credit Card companies for Sage 500

    Hello, We are looking to restructure our Credit Card Payables process. Currently we enter a voucher to a Credit Card Vendor and pay it through the AP that way. We can continue to do that if we can get a decent transactions download that can be easily…
  • 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…
  • 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?
  • 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