D365 Finance & Operations and Dynamics AX Forum

Expand all | Collapse all

Vendor Pre-Notes Got Wiped Out

  • 1.  Vendor Pre-Notes Got Wiped Out

    Posted Sep 16, 2020 02:24 PM
    One of our users changed our existing bank account numbers and this wiped out all of our pre-notes.  Is there a way to run this for all vendors? I have tried going to General Ledger > Periodic Tasks > Create PreNotes on Vendors, but if there is one vendor that doesn't have a bank setup it errors out and cancels the job.  I have also looked at exporting this in Data Management(we have a environment where the prenotes still exist), but I cannot find an entity that this belongs to.  Any help or guidance here would be helpful.
    Thank you in advance!

    Tabitha Arneson
    BlueCrest Inc

  • 2.  RE: Vendor Pre-Notes Got Wiped Out

    Posted Sep 17, 2020 07:49 AM
    The entity I believe is called VendorBankAccount.   Have you tried the Excel Workbook Designer?  That will pull only bank accounts that exist for vendors.

       You can download the accounts to Excel, make a small change to one field for all accounts, then publish them back.  I believe this would have them all as having a change thus you can run new prenotes on all of them.

    Jonathan Struble
    Campus Management Corp.

If you've found this thread useful, dive deeper into User Group community content by role