Once in a while someone will ask me: could you reset “BACS Exported” on Payment Journal for me? When faced with this question for the first time, my first though was – but why?
And scenario is quite simple. Imagine that you are working on a payment journal, applying entries to be paid, and you export BACS file to be sent to bank. However, when exporting the file, you received some funny error message (usually, if you try to save a file in the folder, where you do not have permissions to write), and the file was not exported. So, what do you do?
If you will try to export the BACS file, you will get a message saying that there is nothing to export.
Which is fair enough, system knows that you already exported the BACS file and there is no need to export a duplicate. If you will try to delete the payment journal, with an idea of starting from scratch again, you will get another error message, saying that BACS Exported must be No.
And then, if it has been a long day, Eureka! moment might hit you – let’s manually set “BACS Exported” to No and let’s export the BACS file again. But, if you will add “BACS Exported” field to the payment journal, you will see, that field is not editable.
In fact, even if you will go to Gen. Journal Line table directly, and try to change the field “BACS Exported” to No in Object Designer, you will not be able to do that – field is not editable!
And there is a reason for that is – when you export BACS file, BACS Ledger Entries are created. Therefore, by setting “BACS Exported” to No, you would do only half of the job required. Instead, you need to Void BACS for all lines and export file again.
How to set “BACS Exported” field to No in Payment Journal in Dynamics NAV
1. Go to Financial Management > Cash Management > Payment Journals.
2. Click Payments > Void all BACS (if you will click Payment > Void BACS, it will only void active payment journal line).
3. Click Payments > Export BACS again.