D365 Finance & Operations and Dynamics AX Forum

Expand all | Collapse all

Vendor Pre-Notes Got Wiped Out

  • 1.  Vendor Pre-Notes Got Wiped Out

    SILVER CONTRIBUTOR
    Posted Sep 16, 2020 02:24 PM
    All,
    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

    ------------------------------
    Tabitha Arneson
    BlueCrest Inc
    Danbury
    ------------------------------
    The first step toward cloud success. - Migrate from AX to D365 with expert guidance from Microsoft. I'm Ready


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

    SILVER CONTRIBUTOR
    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.
    ------------------------------

    The first step toward cloud success. - Migrate from AX to D365 with expert guidance from Microsoft. I'm Ready


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