• #ofDetail Lines printing Cheques

    when I adjust the MaxDetails formula field in the APCHK01 crystal rpt for printing cheques it does not move the total of the net paid up. I have the section set to print at the bottom of the page. If I click that off the total will print directly below…
  • GL Transaction and AP vendor Transaction report totals do not match

    How can I filter both of reports to match the total. GL Transaction and AP vendor Transaction report totals do not match for same month.
  • AP Pre-Cheque Register cutting off information

    We have a customer running Sage 300 2019 , Product update 1 in a client server environment. The AP Pre-cheque Register, when it has more than 1 entry , does not display the first entry completely, it only has a line and the total, so it is not possible…
  • 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…
  • 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
  • Problem with check remittance advice maximum length

    FormerMember
    FormerMember
    Is there a way to print remittance advice invoice data on a separate page after the checks are printed if the number of invoices exceeds the remittance advice line maximum.
  • AP Reports requesting Parameters following upgrade to Sage 300 2016

    Client was upgraded from version 6.0a to 2016 yesterday. Since the upgrade none of the Accounts Payable reports will print. When we try to run any reports a screen comes up requesting a number of parameters be entered. All other modules (GL/AR/PO/CP)…
  • 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…
  • AR and AP Aged Trial Balance

    I have a need to age credit notes just like Invoices in both the AR and AP aged Trial Balance reports. The default report places all Credit notes as current regardless of the credit note dates. There is a need to aged the credit notes just like the invoices…
  • Running a check history report for bank upload

    I need to run a check history report at the end of each month to upload to the bank for their files. Currently I can only run a report within AP and another within Payroll. I am looking to be able to run one report that would cover all activity. Any suggestions…