How to take discount out for multiple invoices while settlement

(0) Share

Report

Posted on by Community Member

We're using clearing control vendor account in which all our flooring vendor’s liability booked and then we move the liability to actual vendor account and here comes the problem, we have debit and credit in that clearing control account and we have to manually settle these liabilities one by one and take the discount out by going to cash discount tab for each transaction. Is there any possible way that we can take discount off for all transaction in one go.

. 72207.Capture.JPG

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (0)

Sort by

Suggested answer

Khaled Alloud 3,658 on at

Like (0)

Report
Copy link

Link copied!

Hello,

- Have you tried to add Cash discount on the Vendor form? try this on Test to see if the system will add the cash discount to all payments when settlement

- What is the posting schema resulting from the Cash discount? can you please share it here. Another thing you can try to add the same schema to the Payment journal manually.

Thank you,

Was this reply helpful? Yes No
Community Member on at

Like (1)

Report
Copy link

Link copied!

Hi Kaled,

I do not have rights to add the cash discount on Vendor from.

Posting schema is that if we do not remove the cash discount while settlement, AX takes discount on Credit Balance (means invoices).

Screen Shot 1 ( See both Debit and Credit amounts are not equal as AX incorporates discount on all credit balance (means invoices)

Screen Shot 2 (Discount Amount showing)

Screen Shot 3 (When i manually change the discount to Zero in cash discount tab)

Screen Shot 4 (Now you see after making discount to zero now both sides are equal and ready for settlement).

My question is does any one know how to take off the discount amount on both debit and credit balance in one go without doing above steps.

Thank you

Was this reply helpful? Yes No
Khaled Alloud 3,658 on at

Like (0)

Report
Copy link

Link copied!

Can you please go to Vendor form > Payment fasttab , in the Cash discount fields what do you see?

As far as i know Cash discount can be set here, and in AP parameters under settlement.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hello Khaled,

I don't see any payment form in below given tabs. Thank you

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hello Ayaz Hassan,

Can't you simply set the vendor account take discount parameter to never?

Doing that should not bring up a discount amount that have have to cleanse later on.

Best regards,

Ludwig

Was this reply helpful? Yes No
Khaled Alloud 3,658 on at

Like (0)

Report
Copy link

Link copied!

Was this reply helpful? Yes No