• Paid customer and job remain on AR Aging Detail reports (not crystal)

    Our AR Aging Detail by Job is showing a job that has no balance, and our AR Aging Detail by Customer is showing that customer with no balance. There's nothing that I can find to adjust on this customer. I found some forum posts on receipts and invoices…
  • Aged Payables Report - Functional Currency Issue

    I am trying to print the aged payables report in functional currency as at March 31. The problem is, that its showing some documents with dates after March 31, just because those documents were applied against prepayments with dates before March 31. This…
  • ALL AR/AP INVOICES

    Hello Team, Our client who uses sage 300 ERP requested for a report of all AP invoices and AR invoices for a vendor and customer respectively. Specifically, the invoices that have been paid for in the past and yet to paid. What report can we spool…
  • A/P Payment Inquiry comes up blank regardless of input parameters 2017 PU5

    A/P Payment Inquiry comes up blank regardless of input parameters Sage 300 2017 PU5 Running as ADMIN
  • For the month Trial Balance

    I want to prepare monthly profit & loss account (Income statement for the month) and Balance sheet (statement of financial position) from sage ACCpac in Excel. hence I need to generate for the month Trial balance. How to go about this now, because in…
  • Sales Tax on a Cash Basis

    How do I create a sales tax report on a cash basis? In Illinois small companies may file their sales tax return on a cash basis. How can I see the items that have sales tax that have been fully paid.
  • Non AR Cash Receipt

    How do I generate a report that shows me the non AR cash receipts? Or how do I generate a report of only the MISC cash receipts? Currently the only way I know how to do this is to print the AR journal and ignore any transactions that include the AR account…