Small and medium business | Business Central, N...

Customer credits not showing on Statements

(0) Share

Report

Posted on by Community Member

Hello,

We're running the customer statements however the credit notes are not appearing. We run them for the date period of 01.01.2020 - The current date to pick up any outstanding invoice. New credits however are not appearing in the list, unless we tick the toggle 'Include Closed Entries'. However when we select that we get the credits to show but also any other document dating back to 01.01.2020.

What are we doing wrong please?

We just would like the statement to show all outstanding invoices and credits not yet 'used' by the customer so the balance matches that on the customer card 'Balance YTD'

Thanks,

Amy

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

Marco Mels on at

Like (0)

Report

Hello,

The following comes from our Docs:

Generates a customer statement for a specified time interval. It's usually sent to the customers to give them an overview of outstanding amounts and also as a reminder to pay any overdue amounts. You can choose to show the overdue amounts in a separate section. You can include an aging band similar to the one used in the Aged Receivables report. For the aging band, you typically set 30D, which means 30 days intervals such as30, 60, 90, and 90+ days overdue, from the ending date, or 1M+CM, which will be the current month in a separate interval and then monthly intervals for the preceding months. Note: In the customer list, this report also has a separate action, Scheduled Statements. This option does not filter to the customer you have selected. It's the same report but used when you want to send statement to all/more customers.

If the statement should include more, you can ask your partner to develop it for you.

Thanks.

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

Amy,

Adding to Marco's reply... When you runt the Customer Statement, what do you fill out on the Option Page?

Just to be clear on your issue, you have a Customer that has an open Balance but also a Credit Memo that you expect to appear on the Statement (like below example), yes?

Thanks,

Steve

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thank you both for your feedback.

These are the filters we are applying when running the statements -

The balance for this particular customer in our test system is as follows -

However on their statement it appears as follows -

It's not taking into account the 1no credit they have on their account so rightly so the customer would argue that they don't owe that much, which they don't. They only owe the value in the screen shot above.

I think it might be something to do with either the way we are running it, some criteria in the set up (though cannot find anything in Sales & Receivables Set Up) or the way the credits are being raised?

Thanks as always for your assistance.

Amy

Was this reply helpful? Yes No
JAngle 133 on at

Like (0)

Report

What way are credits being raised? Most likely to do with that. Be the condition of the data

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

Amy,

Adding to Josh's reply... Check the box Include Unapplied Entries. Also, I normally uncheck the Show Overdue Entries since you are printing a Statement.

Thanks,

Steve

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thank you Josh & Steven,

It appears it is the fact that we are applying the credit to the invoice meaning it is therefore closed. I realise that i need to select the checkbox 'include closed entries'.

Thanks to you both for your suggestions which got me to this point.

Amy

Was this reply helpful? Yes No