Pastel: Matching historical invoices and payments

[TravisZA]

Is there anyway to match invoices and payments for periods longer than 4 months ago? I'm trying to clean up the matching however I'm battling with those older items

[Mike C]

Hi TravisZA. I am not too sure that you can. Neville Bailey would be the best person to advise on this.

A possible alternative that might work is to change that Customer/Supplier to a "balance brought forward" account. Once that has been done, change it back to a "match open item" and work from there.

[TravisZA]

Hi TravisZA. I am not too sure that you can. Neville Bailey would be the best person to advise on this.

A possible alternative that might work is to change that Customer/Supplier to a "balance brought forward" account. Once that has been done, change it back to a "match open item" and work from there.

THanks Mike, I'll give that a go and see.

[TravisZA]

Hi TravisZA. I am not too sure that you can. Neville Bailey would be the best person to advise on this.

A possible alternative that might work is to change that Customer/Supplier to a "balance brought forward" account. Once that has been done, change it back to a "match open item" and work from there.

Hi Mike, I had a look at trying to do this the other day without any luck. How exactly do I change this setting - it was greyed out on the supplier when I looked?

[Mike C]

Hi Tavis - go to "Change - Open Item/Balance Forward Conversions"

You will need to enter your password. If there are any open batches you will be asked to update them.
The next screen asks which type of conversion you want to do eg open item to Balance forward or the other way round.
The following screen asks whether for customers or suppliers, and which one you want.

Make your selection and continue.


As always with these things - make a backup before you try and change something in case it doesn't work as you expect, or something goes wrong. You can then always back up your company to its previous state.