Skip to main content
Solved

AP Vendor Cash Account update

  • December 30, 2024
  • 2 replies
  • 39 views

In the initial set-up of Acumatica and Vendor Classes, a cash account was entered in the “Default Financial Settings” for each class.  Now, we are using a new cash account to pay vendors.  We have removed the default cash account in all classes so feel new Vendors added will not have a default cash account.  We were able to mass update the cash account for all open AP bills using GI.  We would now like to update all Vendor records either by removing the old cash account default (i.e. default cash account would be blank) or the new cash account. We tried using GI, adding the “location” data to the Vendor record but were unsuccessful in creating the needed relations to accomplish the mass update.  Any and all help to get this update completed as a mass update is appreciated.

Best answer by Laura02

Hello,

Import Scenarios can be used to remove the Default Bank Account from Vendors. This simple example uses an Excel sheet with one column labeled “Vendor 1” that contains vendor ID’s:

Laura

View original
Did this topic help you find an answer to your question?

2 replies

Laura02
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3132 replies
  • Answer
  • December 30, 2024

Hello,

Import Scenarios can be used to remove the Default Bank Account from Vendors. This simple example uses an Excel sheet with one column labeled “Vendor 1” that contains vendor ID’s:

Laura


  • Author
  • Freshman I
  • 1 reply
  • January 8, 2025

Thanks Laura.  I finally had time to do this and it worked great.  Newbie to Acumatica so I am sure this is the 1st of many questions I will pose.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings