D365FO - Only allow one supplier bank account to be active at a time

Hi,

D365FO - Only allow one supplier bank account to be active at a time

In many companies, there are multiple bank accounts. A vendor can have different ones per currency.

Vendor bank accounts are used when you pay a vendor electronically. You can modify the active and expiration dates for a vendor bank account to specify when a bank account is available to accept payments. You might modify the dates when a vendor no longer uses a specific bank account, or when a bank account exists but you cannot yet send payments to it.

By default, all bank accounts have blank active and expiration dates, so that they are always active.
  1. Click Accounts payable > Common > Vendors > All vendors.
  2. Select the vendor whose bank account you are modifying.
  3. On the Action Pane, on the Vendor tab, click Bank accounts.
  4. On the General FastTab, enter a date in the Active date field to specify when the bank account is available to accept payments. Leave the field blank to specify that the bank account is available immediately.
  5. Enter a date in the Expiration date field to specify when the bank account is no longer available to accept payments. Leave the field blank to specify that there is no known date when the bank account will no longer accept payments.

InActive Bank Account


Active Account for same supplier


X++ Code for Reports to fetch active account

  //-->Getting only active bank account for supplier
            select vendBankAccount where vendBankAccount.VendAccount ==vendTable.AccountNum
                && vendBankAccount.ActiveDate !=Global::utcDateTimeNull() && vendBankAccount.ExpiryDate ==Global::utcDateTimeNull() ;

Comments

  1. If you're attempting to lose kilograms then you certainly need to try this brand new personalized keto plan.

    To create this keto diet service, certified nutritionists, fitness couches, and professional cooks joined together to produce keto meal plans that are productive, convenient, money-efficient, and fun.

    Since their first launch in 2019, 100's of clients have already completely transformed their figure and well-being with the benefits a good keto plan can give.

    Speaking of benefits; in this link, you'll discover eight scientifically-tested ones provided by the keto plan.

    ReplyDelete

Post a Comment