• GL Statistical Accounts

    1. How do we clear GL statistical accounts in Sage 500 at yearend 2. Can we use GL statistical accounts in Sage 500 for budgets
  • Importing purchase requistion details from an external csv file into the grid field

    Newbie here. I am entering items details manually into the different fields of a purchase requisition. I have a csv file with data from an MSC shopping cart. How do I transfer this data into the Purchase requisition grid without copy and pasting field…
  • SO to PO

    HI, I have a HOW TO question. Is there any way to automatically create a Purchase Order from a Sales Order when certain items or drop ship items are on the Sales Order? Has anyone done this or is this core functionality? Thank you. -Robyn
  • When closing a Work Order, the Qty on WO field did not update

    I have a Closed work order that is still showing a quantity in the "Qty on WO" field (timInventory.QtyOnWO). I see it when i look at Explore\Inventory view. I've looked at the two previous WO for the same part and there was no issue that I can see and…
  • Can you prevent AP / AR from using certain accounts?

    Is there a way to prevent AP from using revenue accounts and a way to prevent AR from using AP related accounts?
  • Batches stuck as "in use"

    We have run into an issue a few times with both AP and GL batches. The status changes and is stuck on "in use". We check that there are no users in the batch, but the status gets stuck, we can't delete it or post it. The only resolution we are able to…
  • Cash Receipts & National Account

    Hi, I posted same question under a different category, I tried to simplify it here. We currently receive thousands of payments (cash receipts) that need to be applied to open invoices as cash receipts payments from our customers; this is taking us forever…
  • Using Data Porter for Project Transactions

    I'm in Finance / Accounting at an international consulting firm. We're trying to find a way to accrue revenue at a project level without having to record credit memos and reversing debit memos that would actually impact accounts receivable. We're therefore…
  • 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.
  • AP vouchers

    Our AP department continues to put invoices into the incorrect batch (ex February invoices in a January batch). Is there a way to prevent that? If not, is there a way to search to see if it has happened? Is there a way to fix it without making a journal…
  • 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…
  • Bank Transaction Posting resulted in GL imbalance

    I have posted a standard CM Check transaction and when I went to reconcile the bank account, the amount showed up in my DEBIT column (as though I had made a deposit instead of a CM Check). Looking at the G/L detail for the batch, the system recorded improperly…
  • What to do with an Invoice System Batch?

    We have a system batch with several hundred pending invoices tied to it. What should be done with these invoices to get them posted or cleaned up? And what causes them to be kicked into the system batch? Thanks for any help.
  • Paying AP Invoices by Credit Cards

    Currently we enter AP Invoices under the company name then on the due date we pay by credit card and make a flip to remove from the vendors name into the appropriate Credit card AP account.. Is there an easier way to complete the flips without entering…
  • General Ledger Import ignores required reference codes

    We have reference codes required on some of our GL accounts. When we import a journal entry, it is possible to post the entry without the reference code. Is there a way to stop this?