Sup.statement unpaid invoices ignores journal reconciliations entries

I was explaining why @Mark’s solution worked to clear the invoice as he was doing it via the Payments tab which in essence is what you were trying to do via direct journal entries.Asexplained Manager does not allow such using direct journal entries.You may have noticed that @Mark righly kept the bank accounts empty to kind of make this work but you will notice that both entries in his case now are in the suspense account and it is thus not a real solution either as one must clear anything in the suspense account.

So the issue remains, you can not settle invoices without payments or receipts against them.

That’s true.

It’s not supposed to be like that, we should be able to use Journal entries like @Ealfardan said:

I am not sure which version your are using, but everything works fine in version 22.1.3

as you can see, the Supplier Statements (Unpaid Invoices) report does not show any invoices related to Supplier2 or Supplier3.

EDIT: checked on version 22.1.13 and still no issues found. everything shows as expected.

Sorry that I didn’t check it before as I thought you had done it correctly but now that I’ve deleted the entry under the Payments tab and made a journal entry, I see that it in fact does remove the invoice from the unpaid invoices report.

Before the journal entry:

The journal entry by which supplier1 settles the invoice of supplier2:

The unpaid invoice report after the journal entry:

The difference between the Invoices total and the Balance due is the amount of the journal entry (because no invoice was selected for supplier1). The accounts payable balance is correct.

image

1 Like

Check your suspense account!

I’m using ver 22.1.13

updated to 22.1.13 and checked. no issues found.

I think you might have created some other transaction which is hindering the journal entry and creating issues. I recommend you to check the complete transactions list for both the suppliers.

There’s no suspense account, i.e. the balance is 0. But why don’t you check it yourself?

I haven’t tried to reproduce it because I’m not with my computer right now. But, I don’t know why you would want to include an invoice in this type of transaction. The debit is not supposed to be directed at the original invoice. The Debit is supposed to be directed at ABC’s account. The invoice will still show as paid/settled/cleared.

I found my mistake here:
Invoice dated 31/12/2021
Journal entry dated 31/01/2022
the report is till today 29/01/2022
Then the transfer didn’t calculated in the unpaid report.

Sorry for all. that was my mistake.
and thanks for @sharpdrivetek. he did asked the right question but I didn’t noticed that until @Mark last reply.

Sorry again.

1 Like

Correct, although there’s nothing that prevents you from selecting a specific invoice.

All the transaction recorded correctly, the mistake was in the report dates.
Thanks @Abeiku

it can be if the supplier paid specifically for that particular invoice of the other supplier. in my opinion there is nothing wrong in selecting the invoice.

1 Like

3 minutes in the naughty corner. :stuck_out_tongue_winking_eye:

2 Likes

3 days
Sorry :pray:

1 Like