How to settle all open transactions for customer and vendor in one click

(0) Share

Report

Posted on by Anirban Basu

102

Dear Experts,

I have a requirement. My customer wants to settle all open customer and vendor transactions in one click.

Basically they have few customers and vendors who are having huge open transactions from past year 2019. But while passing payment journals, they did not settle any open transactions and due to that, all such are showing as open.

Now before the closing of 2019, they want to settle all these in one shot. Is there any standard option available other than customization?

Thanks.

Anirban

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

SouravDam 11,730 on at

Like (0)

Report

RE: How to settle all open transactions for customer and vendor in one click

Hello Anirban Basu,

I don't think you can achieve this through standard. You may have to go for customization.

Which version you are using?

With the help of developer, you can create a form and set the logic like; when running the form based on certain date ranges in 2019, system will fetch those open transactions for that time frame for all or selected customer / vendor and set the Marked check box enabled for these transactions available in the Settle transactions form.

But here you have to build the logic for both partial and full settlement. Also, you may have to ask your customer to provide the list of all such open transactions which need to be settled against which invoice / invoices posted in 2019. After that only, you will be able to do such customization.

Kindly check and update.

Best regards,
Sourav Dam

Kindly mark this thread 'Yes' if this is answered your query which may help other community members in this forum.

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: How to settle all open transactions for customer and vendor in one click

Hi,

You could go the the open transaction editing form for each customer/vendor, select all records and settle them. Yet, this is a tedious process as you have to go through all customers/vendors one by one if the payment journal is already posted.

The other option is writing some code doing that for you.

Best regards,

Ludwig

Was this reply helpful? Yes No
Anirban Basu 102 on at

Like (0)

Report

RE: How to settle all open transactions for customer and vendor in one click

Thanks Ludwig for the suggestion.

This is tedious work of course to go through each vendor or customer separately. I already discussed this with the customer and they are not willing to do this as they are more concerned to close the FY2019 soon.

I also discussed with my technical colleague if we can create such option as Sourav Dam pointed. This is feasible and customer also ready to share the details of what are the payments should be settled with which invoices. It will of course will take some time but customer is atleast happy not to settle manually!!

Thanks.

Was this reply helpful? Yes No

Join the conversation

Community site session details

How to settle all open transactions for customer and vendor in one click

Helpful resources

News and Announcements

Quick Links

Responsible AI policies

Abhilash Warrier – Community Spotlight

Congratulations to the September Top 10 Community Leaders!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates

Community site session details

How to settle all open transactions for customer and vendor in one click

Helpful resources

News and Announcements

Quick Links

Responsible AI policies

Abhilash Warrier – Community Spotlight

Congratulations to the September Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates