Tuesday, March 12, 2019

Account with Electronic Bank Payments Bundle requires Company Bank and EFT Template Details (ABA) displayed on Invoice printout.

Steps to reproduce:

1. User requires "Company Bank Details" and "EFT Template Details (ABA) > Bank Code, Bank Company Id, BSB Number (Bank), BSB Number (Branch), Bank Account Number" displayed in Invoice and when printed.  These information varies based on associated Customer's Subsidiary set in an Invoice: 

  • Client #1: Australia Subsidiary
  • Client #2: New Zealand Subsidiary

Note: Each Subsidiary has different Company Bank Details.


2. Bundle Electronic Bank Payments is installed in a OneWorld account:

  • Navigate to Setup > Customization > Search & Install Bundles > List
  • NameElectronic Bank Payments
  • Bundle ID211453
  • Version2018.1.3


3. Navigate to Customization > Lists > Records & Fields > Record Types

  • Get ID of Company Bank Details (e.g. customrecord_2663_bank_details)


4. Navigate to Payments > Setup > Bank Details

  • Fields > EFT Template Details (ABA) > Bank Code, Bank Company Id, BSB Number (Bank), BSB Number (Branch) & Bank Account Number" (all IDs are not exposed)


5. Navigate to Payments > Setup > Bank Details

  • View an Australian Bank that has Currency: Australia and EFT TemplateABA:
    - Name (e.g. AU First Bank)
    - Subsidiary (e.g. ABC Ltd.: AU Subsidiary)
    Bank Code: (e.g. ABC)
    - EFT Template Details (ABA) > Bank Company Id: (e.g. 12345)
    - BSB Number (Bank): (e.g. 100)
    - BSB Number (Branch): (e.g. 550)
    - Company Bank Details page > Bank Account Number = (e.g. 987654321)


Recommendation:

1. Create a custom field that would link both the invoice and the Custom Record Type:

  • Navigate to Setup > Customization > Transaction Body Fields > New
  • Enter Label (e.g. Company Bank Details)
  • Type: List/Record
  • List/Record: Company Bank Details
  • Store Value: Checked
  • Applies To > Sale:Checked
  • Sourcing & Filtering 
      • Filter Using: Subsidiary
      • Compare Type: Equal
      • Value
    Subsidiary (Main)
  • Click Save & Apply to Forms
  • Look for the preferred invoice form and set Print: Checked and assign a value for the Width (e.g. 1.25).
  • Click Save

Note: Take Note of the ID created (e.g. custbody1)


2. Create another custom body field that is only marked to print at the transaction PDFs of Invoice record:

  • Navigate to Setup > Customization > Transaction Body Fields > New
  • Give it a name (e.g. Bank Code)
  • Type: Free-Form Text.
  • Store Value: False.
  • Applies To > Sale: Checked
  • Validation & Defaulting > Default Value:{custbody1.custrecord_2663_eft_template_details.custrecord_2663_bank_code}

    where
    :
    - custbody1 is the custom transaction body field ID of Company Bank Details of the custom body field created in Steps 1
    custrecord_2663_eft_template_details.custrecord_2663_bank_comp is the field ID of Bank Code  of the custom field created within the custom record type Company Bank Details.
  • Click Save & Apply to Forms
  • Look for the preferred invoice form and set Print: Checked and assign a value for the Width (e.g. 1.25)
  • Click Save


3. Repeat Steps 2 to create next custom body fields (Bank Company Id, BSB Number (Bank), BSB Number (Branch), Bank Account Number) to also be included in the transaction PDFs of the Invoice record:

  • Navigate to Setup > Customization > Transaction Body Fields > New
  • Label (e.g. Bank Company Id)
  • Type: Free-Form Text
  • Store Value: Unchecked
  • Applies To > Sale: Checked
  • Validation & Defaulting > Default Value:
    Name: Bank Company Id
    {custbody1.custrecord_2663_eft_template_details.custrecord_2663_bank_comp_id}
    NameBSB Number (Bank){custbody1.custrecord_2663_eft_template_details.custrecord_2663_bank_num}
    Name: BSB Number (Branch){custbody1.custrecord_2663_eft_template_details.custrecord_2663_branch_num}
    Name: Bank Account Number
    {custbody1.custrecord_2663_eft_template_details.custrecord_2663_acct_num}


4. Edit an existing Sales Invoice

  • Select Custom subtab
  • "Company Bank Details" field > select  (e.g. AU First Bank)
  • Click Save
  • Notice that all custom fields such as the field Bank Code auto populates value (e.g. ABC)
  • Click Print

Note: Notice that Company Bank Details and Bank Company Id are printed correctly.

  • Additional Note: Apply Custom Field to Forms page only displays in Custom Forms. This is not applicable on Standard Forms because we do not alter standard forms themselves. 
  • User requiring printing of the field EFT Template to a different subsidiary needs to create separate custom field for every subsidiary. 

 

No comments:

Post a Comment