Friday, July 12, 2019

Find the date on which a bill is fully paid via Web Services

If you are using a saved search in the UI , this date  when a vendor bill is paid in full can be retrieved by using dateclosed field.


If you are using are going to retrieve this via Web Services , you select closeDate on the columns to display the date when the bill is fully paid, you also need to select the type "_vendorBill". See sample SOAP request below:


 <platformMsgs:searchRecord xsi:type="s0:TransactionSearchAdvanced">
            <s0:criteria>
               <s0:basic>
                  <platformCommon:internalId operator="anyOf">
                     <platformCore:searchValue internalId="9903" />
                  </platformCommon:internalId>
                  <platformCommon:mainLine>
                     <platformCore:searchValue>true</platformCore:searchValue>
                  </platformCommon:mainLine>
                  <platformCommon:type operator="anyOf">
                     <platformCore:searchValue>_vendorBill</platformCore:searchValue>
                  </platformCommon:type>
               </s0:basic>
            </s0:criteria>
            <s0:columns>
               <s0:basic>
                  <platformCommon:closeDate />
               </s0:basic>
            </s0:columns>
         </platformMsgs:searchRecord>
</platformMsgs:search>

No comments:

Post a Comment