Modifying a vendor's preferred payment method

[Lee Savidge]

Hi @Sterio, Louis

This is not so much a question but more a "why is it like that?" Updating a vendor via the API to alter the preferred payment method is simple enough, but why do the values in the preferred payment method picklist not follow the same logic as other picklists? Let me explain. If I have a picklist that has the following values available:

• One potato
• Two potato
• Three potato
• Four

If I wanted to set the value via the API I would do something like this:

        <update>
          <vendor>
            <VENDORID>XYZ0000001</VENDORID>
            <TESTFIELD>Two potato</TESTFIELD>
          </vendor>
        </update>

That would set the value to "Two potato". Essentially, you just supply the text that you see and the API does the rest. However, on the preferred payment method, if I were setting the picklist to ACH or bank file I would pass ACH. If I wanted to choose Cheque I would have to pass Printed Check. For Credit card I need to pass Charge card, and for Record transfer, I need to pass EFT. Cash is at least as simple as passing Cash. Why are the values displayed, not the same as what is passed? How do I get the list of options that I need to pass from Intacct? For this, I ended up modifying a record and setting the value to each one and querying the record which seemed to be a really slow way of doing it. Why is this particualr field done so the text that I must pass is not (mostly) the same as I see in the picklist? Just seems odd.

Thanks

 

 

 

Edited September 16 by Lee Savidge
.

[Varian Lee]

I think it's because those values are displayed differently depending on what language your company or user preferences are using.  One way to get a list of valid selection list values is to run 'Get Vendor Object Definition' in Postman and look for the 'Preferred payment method' field in the returned list.

[Lee Savidge]

If I run the inspect object definition, it shows the field and its properties, but it doesn't give the available options. However, I ran the query specific object and it gave me the values. Thanks for that. Most helpful. Everyday is a school day!!