open invoice report

Options
Indah
Indah Member Posts: 4 ✭
edited July 2018 in Reckon Accounts (Desktop)
just recently we update our reckon product 2018/2019.
Today I realized that there is something wrong when i want to know open invoice for our customers. The balance in the open invoice report is different to the balance sheet.
seems that the open invoice not pop in once it been paid in July .
It never happen before.
I need help

Comments

  • John G
    John G Reckon Staff Posts: 1,570 Reckon Staff
    edited July 2018
    Options
    Welcome to the Reckon Community, Indah.

    Does the discrepancy occur when you
    • set the Balance Sheet Report to Accrual.
    • date range is set to All Dates?
    Hope htis helps.

    regards,
    John


  • Indah
    Indah Member Posts: 4 ✭
    edited July 2018
    Options
    Hi John,
    This discrepancy happen after we update  tax rate 2018/2019.We I check open invoices Customers & Receivables (Report-->Customers & Receivables--> Open Invoices), the total amount is different to the balance sheet.By end of June 2018 the total amount of account receivables in the balance sheet is $600 but only $300 the total amount in Open Invoices.I received payment from some customers $300 in July 2018 to pay their June invoices. I entered this payment into Reckon in July 2018.I don't understand why after I enter this payment on July 2018 the total amount in Open Invoices by end of June 2018 is $300 only.
  • John G
    John G Reckon Staff Posts: 1,570 Reckon Staff
    edited July 2018
    Options
    Thanks Indah,

    Does the discrepancy occur when you set the Balance Sheet Report to
    • Accrual?
    • date range is set to All Dates?
    regards,
    John
  • Indah
    Indah Member Posts: 4 ✭
    edited July 2018
    Options
    Does the discrepancy occur when you set the Balance Sheet Report to
    • Accrual? Yes
    • date range is set to All Dates? custom
  • John G
    John G Reckon Staff Posts: 1,570 Reckon Staff
    edited July 2018
    Options
    Thanks Indah,

    Does the discrepancy occur when you have the Date Range at All Dates?

    regards,
    John.

  • Indah
    Indah Member Posts: 4 ✭
    edited July 2018
    Options
    Hi John,
    Yes, the discrepancy happen when i have the date range at all dates too
  • John G
    John G Reckon Staff Posts: 1,570 Reckon Staff
    edited July 2018
    Options
    Thanks Indah,

    Please Rebuild your company file (Files > Utility > Rebuild) and follow up on errors.  Also, open the the QBwinlog file (Ctrl1 >Ctrl2 > Open file >) in Notepad, scroll to the bottom and then work up and follow up on any unrepaired errors.  Finish by doing a Verify to ensure no errors are left in teh file.  then try your reports again.  

    regards,
    John

Categories