Incorrect Period Processing

[Sheena]

Good Morning

We use a Transport Management System for our invoicing and then we import batches into Pastel.

There were batches which were imported to Pastel, however they were processed under the incorrect period - i.e Period 1 - March 2021.

The invoices were then credited off the incorrect period and re-imported under the correct period - i.e Period 13 - March 2022.

All the Customer Ledgers are now showing all March 2022 Invoices correctly, however the Customer Statements and Customer Age Analysis still show the current invoices in 120 days.

Please advise what the issue could be and how to correct.

Many thanks

[Neville Bailey]

Hi Sheena,

Are you using Open Item matching or Balance Forward on your customers?

If Balance Forward, please go to Setup...Company Parameters and open the Formats tab. Then make sure the option under "Age Balance Forward Journal Credits" is set to "From Oldest Down".

If Open Item, please email me so that we can set up a TeamViewer session.

[Sheena]

Hi Neville

We adjust according to Customer Requirements but most Statements are set to Balance Forward.

I will email you my Team Viewer details