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

receive customer payments is lower than the invoice amount

(0) Share

Report

Posted on by dmt747400

104

I am attempting to post a payment on an invoice. The customer does have a payment term with a discount date 1M(8D). However, in this case the invoice posting date is 11/13/2022, the discount date is 11/11/2022 and today is 11/18/2022. In the customer general ledger, it shows that there is still a $27.00 discount possible even though it is now 15 days since the invoice was posted. I have checked my working date and it is set for today 11/18/2022, I even tried to change my working date to 11/21/2022 yet the discount stays.

Any ideas???

Categories:

Dynamics 365 Business Central

All responses (10)

Answers (0)

Suggested answer

Dallefeld 175 User Group Leader on at

Like (0)

Report

RE: receive customer payments is lower than the invoice amount

Totally agree with Inge.

It seems you need some experienced assistance and hopefully your partner will step up to the plate for you.

Business Central is a full blown ERP. I have seen customers that try to make the transition from QuickBooks fail. The processes are designed very differently and much more for enterprise based, auditable requirements. Having said that, you can keep is simple, you just need to learn the tips and tricks and have the setup that meets your needs.

Good Luck.
Suggested answer

Inge M. Bruvik 1,029 Moderator on at

Like (0)

Report

RE: receive customer payments is lower than the invoice amount

After working with Dynamics NAV and Business Central for more than 25 years it makes me sad to read your post.

Maybe a good idea to have a meeting with your partner and have an open discussion with them around the assistance you need and evaluate if they are the best partner match for you and your business.

I am not saying that a change of partner always is the answer to every challenge, but sometimes it is the right thing and the best thing to do both for the customer and for the partner.
dmt747400 104 on at

Like (0)

Report

RE: receive customer payments is lower than the invoice amount

It has been 11 months (01/01/2022) since we started using this, after 6 months of set up (07/01/2021) we are no were even close being able to use this by itself. We still have to run everything in parallel with QB and use spreadsheets to keep up with the books because of this worthless program
Suggested answer

Dallefeld 175 User Group Leader on at

Like (1)

Report

RE: receive customer payments is lower than the invoice amount

When I hear some one say that they regret moving to Dynamics, I am almost certain that they need more assistance.

1. Yes, you only adjusted the discount date for one invoice, if you want discounts taken on the other invoices, you have adjust those dates also.

2. There is a payment discount tolerance date calculation that you can apply. Its part of Setup and it applied globally.

There are many things that can be done to improve your processes and efficiencies in the system....don't give up hope yet!
dmt747400 104 on at

Like (0)

Report

RE: receive customer payments is lower than the invoice amount

When I do that, all the other invoices do not have the discount taken off, just this one invoice.

I will just open a ticket with my partner, this is just one of many reasons to regret moving to Dynamics
Suggested answer

Dallefeld 175 User Group Leader on at

Like (0)

Report

RE: receive customer payments is lower than the invoice amount

You to make sure that your document type is Payment. The Applies to screen will not change. Do your input and Preview Posting that's the only place that you will see the discount being taken.
dmt747400 104 on at

Like (0)

Report

RE: receive customer payments is lower than the invoice amount

I have moved the discount date to the future, no change. Moved it to the day after the invoice, no change. I have manually removed the remaining payment discount possible, no change. Nothing I have tried as made any difference what so ever. This invoice was created the exact same way all other invoices were created. It was posted the same way as all the others, there is no explanation that I can come up with that will explain this.
Suggested answer

Dallefeld 175 User Group Leader on at

Like (0)

Report

RE: receive customer payments is lower than the invoice amount

Sorry, didn't understand.

1.Push the Discount Date into the future

2.Make sure that your line in your cash receipts journal has document type of payment
dmt747400 104 on at

Like (0)

Report

RE: receive customer payments is lower than the invoice amount

[quote user="Dallefeld"]
Just because it shows as possible it will not be applied unless you change the discount date.
[/quote]
That is the issue, it is trying to apply the discount.
Suggested answer

Dallefeld 175 User Group Leader on at

Like (0)

Report

RE: receive customer payments is lower than the invoice amount

Just because it shows as possible it will not be applied unless you change the discount date.