open invoice report

  • 1
  • Question
  • Updated 2 months ago
  • Answered
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
Photo of Indah

Indah

  • 100 Points 100 badge 2x thumb

Posted 3 months ago

  • 1
Photo of John G

John G, Information Support Analyst

  • 27,280 Points 20k badge 2x thumb
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
Photo of Indah

Indah

  • 100 Points 100 badge 2x thumb
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.
Photo of John G

John G, Information Support Analyst

  • 27,280 Points 20k badge 2x thumb
Thanks Indah,

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

regards,
John
Photo of Indah

Indah

  • 100 Points 100 badge 2x thumb
Does the discrepancy occur when you set the Balance Sheet Report to
  • Accrual? Yes
  • date range is set to All Dates? custom
Photo of John G

John G, Information Support Analyst

  • 27,280 Points 20k badge 2x thumb
Thanks Indah,

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

regards,
John.
Photo of Indah

Indah

  • 100 Points 100 badge 2x thumb
Hi John,
Yes, the discrepancy happen when i have the date range at all dates too
Photo of John G

John G, Information Support Analyst

  • 27,280 Points 20k badge 2x thumb
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