I have an invoice missing from a sales report even though the invoice exists...Not sure why this has occurred?

  • 1
  • Problem
  • Updated 3 years ago
Our freight company has invoiced us for a delivery that doesn't show up on the sales report for that day. When I go to the customers account the invoice exists. I'm not sure why this has happened, if anyone has any ideas on this matter it would really help as I use the sales report to double check statements from the freight company, thank you.
Photo of holysmoked

holysmoked

  • 232 Points 100 badge 2x thumb

Posted 3 years ago

  • 1
Photo of Ian McLennan

Ian McLennan, Accredited Partner

  • 200 Points 100 badge 2x thumb

Are you on cash or accrual for your report?  The other issue is if your freight company has invoiced you, then aren't you talking about suppliers, and bills not invoices?

Ian

Photo of holysmoked

holysmoked

  • 232 Points 100 badge 2x thumb
Hi Ian,
We use accrual. With each dispatch we send our freight company a customer sales report that they use to check off all the POD's from their drivers. They then invoice us based on the amount showing on the sales report.
And so in this situation they had a driver return a POD which wasn't showing on the sales report. When I redo the sales report the missing invoice doesn't show up however when I go into the customers account the invoice exists for the given date.
Anthony
Photo of Adrian

Adrian

  • 3,640 Points 3k badge 2x thumb
The report you run is it a customised report?

Check the filters for the report you are running, there may be a filter set on the report that is excluding that invoice.

Has the invoice been marked as Pending, it will not show up on sales reports.

Adrian
Photo of holysmoked

holysmoked

  • 232 Points 100 badge 2x thumb
Hi Adrian,

Thanks for the advise.  I checked the customers details and they had been set up incorrectly!

Anthony