My ABA files for supplier payment runs are not being created in Alphabetical order. It is something MYOB is doing because when I look at the file in Notepad its all over the place. I don't know why this has suddenly happened, could have been when we upgraded to the online version recently, I am not sure.
It is a pain when we do our EOM payments (lots of suppliers)!
How do I fix this?
Hi Tinks1,
The bank file isn’t really designed to be opened or reviewed in Notepad, so the order it appears there wouldn’t usually be the best way to check whether anything is wrong.
If you’re looking for a reference of which suppliers and payments are included in that electronic payment batch, it’s best to review that from within your MYOB file instead.
If the payment batch is creating successfully and the bank is accepting the file, the order shown in Notepad on its own wouldn’t normally indicate an issue.
Regards,
Genreve
Thank you for your reply.
Regardless of whether or not its designed to be opened in Notepad, the file CAN be viewed in Notepad. We have always done this with various files (not just ABA) as a way of checking if something seems to be incorrect. I did this to investigate where the issue might be.
As suspected, the order it appears in Notepad is the order it is showing in MYOB, AND the order it is loading into the ANZ bank..... NOT in alphabetical order.
I enter the payments in MYOB in alphabetical order and even sort again in alphabetical order before creating the ABA file and MYOB it still creates the ABA out of alphabetical order.
My question is how do I fix this?
Why is MYOB suddenly creating the ABA file out of Alphabetical Order? It has never done this to me before. Is there somewhere in the settings this can be changed?
If anyone can please assist with this it would be appreciated.
Hi Tinks1,
Thanks for explaining it so clearly. The ABA file order is generally driven by how the file is generated in MYOB, and there isn’t normally a setting that lets you manually control or force the payment order within it. So while you can recreate the file, there isn’t currently a way in MYOB to sort or customise the ABA file order the way you’d like.
I came across this forum post where another user shared a suggestion around changing the order. That said, if this has only just started happening and you’ve always done it the same way before, it’d be worth contacting our team to investigate further. So they can investigate whether something has changed. You could also pop this on our Ideas Board as a feature request for more control over ABA file sorting, so other users can vote on it and add support as well.
Cheers,
Princess
