Auto-check “Calculate Tax” based on Subsidiary and Vendor country (US)

function countrySearch(internalId, type) {

      try {

        let countryValueSearch = search.create({

          type: type,

          filters: [

            [“internalid”, “anyof”, internalId]

          ],

          columns: [

            search.createColumn({ name: “country”, label: “Country” })

          ]

        });

        let searchResult = countryValueSearch.run().getRange({ start: 0, end: 1 });

        if (searchResult.length > 0) {

          return searchResult[0].getValue({ name: “country” });

        }

        return null;

      } catch (e) {

        log.error(“error@countrySearch”, e);

        return null;

      }

    }

if ((fieldId === ‘subsidiary’ || fieldId === ‘entity’) && (currentRecord.type === ‘vendorbill’)) {

          subCountry = subsidiary ? countrySearch(subsidiary, “subsidiary”) : null;

          vendCountry = entity ? countrySearch(entity, “vendor”) : null;

          if (subCountry === US_SUBSIDIARY && vendCountry === US_SUBSIDIARY) {

            currentRecord.setValue({ fieldId: ‘custbody_ste_use_tax’, value: true });

          } else {

            currentRecord.setValue({ fieldId: ‘custbody_ste_use_tax’, value: false });

          }

        }

Leave a comment

Your email address will not be published. Required fields are marked *