When we add a new supplier bank account and make the original one inactive when their details change, we have the issue that although the supplier account is now set up correctly (and the BACS payment bank ref updated too) the old bank account is attached to the open invoices that come up for payment, as that was the correct bank at the time the invoices were posted.
We then get a message when generating payments that one or more payments are using an inactive bank account. We then have to do a manual lookup in excel to try to find the supplier payment account who's bank account has changed recently out of maybe 100 or more payment lines and then manually update the bank account on the supplier account transaction for each open invoice on the Payment tab.
We set up a new bank account when supplier details change to get full tracking on what changed when rather than overtyping the same bank account, but it seems this has replaced one issue with another.
Any Ideas how to get around this or show more easily at least which payment line has the issue?
Can we make AX take the bank account that's active at the time pf generating the payment proposal, rather than picking up the bank account at the time of posting the invoice?
thanks
*This post is locked for comments
I have the same question (0)
