Missing invoice, not correct calculation

Self-Hosted | v5
1

I have client where it shows paid to date 2560
But it shows 7 invoices with amounts 500, 500, 300, 300, 100, 300, 60. (2060)

Where is the 500 missing?
There is no Archived or deleted invoices for this client.

2

Hi,

What do you see if you run php artisan ninja:check-data

Also, are you using the web app or the desktop app?

3

2024-09-24 07:31:46 2024-09-24 07:31:46 Running CheckData… on Connected to Default DB Fix Status = Just checking issues
2024-09-24 07:31:46 0 clients with incorrect balances
2024-09-24 07:31:46 Client 1 id = # 13 - Client Paid To Date = 1690.240000 != Invoice Payments = 1695.15 - 1695.150000 +
2024-09-24 07:31:46 The client id = # 31 - Client Paid To Date = 2845.000000 != Invoice Payments = 3795 - 3795.000000 +
2024-09-24 07:31:46 2 clients with incorrect paid to dates
2024-09-24 07:31:46 0 contacts without a contact_key
2024-09-24 07:31:46 0 clients without any contacts
2024-09-24 07:31:46 0 contacts without a contact_key
2024-09-24 07:31:46 0 vendors without any contacts
2024-09-24 07:31:46 0 wrong invoices with bad balance state
2024-09-24 07:31:46 0 Contacts with Send Email = true but no email address
2024-09-24 07:31:46 126 Payments with No currency set
2024-09-24 07:31:46 Fixing - exchange rate for expense :: 21
2024-09-24 07:31:46 Fixing - exchange rate for expense :: 66
2024-09-24 07:31:46 Fixing - exchange rate for expense :: 176
2024-09-24 07:31:46 0 users with duplicate oauth ids
2024-09-24 07:31:46 Done: FAILURE
2024-09-24 07:31:46 Total execution time in seconds: 0.075825929641724

I am using desktop app.

Also for some reason it was showing amount in Dashboard last 30days less than this month. But it shows ok now.

4

You can add --fix to fix these issues but it doesn’t look like it includes the 500 client.

If you have a large account you may need to increase the number of years to load on Settings > User Details. You may also want to check in the web app.

5

I checked the web app switched to react:
And it shows the missing 500eur!
It was the first invoice for this client in 2021.

Also it shows balance like this:

Standing

Paid to Date
€ 2,560.00
Outstanding
€ 0.00
Credit Balance
€ 0.00
Payment Balance
€ 60.00

Not sure why Payment Balance is 60

you may need to increase the number of years to load on Settings > User Details.

That was set to 3. I set it to 5 and it resolved the issue.

thanks!

6

php artisan ninja:check-data --fix

It does not fix the data. Still same result.

7

Try this instead

php artisan ninja:check-data --fix=true --client_balance=true