--- title: Read slug: netsuite/aeHE-read description: This document provides a comprehensive guide on reading Vendor Bills and using filters for the Breadwinner Global API. It covers all the necessary details about specific vendor bills, transactions, and sales orders, including transaction numbers, totals, docTags: createdAt: 2021-11-01T07:09:36.000Z --- To read Vendor Bills, please use the below parameters. ### Supported “where” Filters | **Field Name** | **Data Type** | **Description** | | ---------------- | ------------- | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | dateCreated | Long | This will filter on an exact match (equal). Use the “additionalFilter” option for a range of dates. | | internalId | String | Internal ID of the Vendor Bill. Multiple values can be passed in a comma-separated string. | | lastModifiedDate | Long | This will filter on an exact match (equal). Use the “additionalFilter” option for a range of dates. | | subsidiary | String | Internal ID of Subsidiary (Primary). Do Not Use this in additonalFilter. Multiple IDs can be passed in a comma-separated string Ex: 1,2 | | additonalFilter | String | construct the additional filter with a combination of the above fields using ‘+and+’ separator and pass it as a single string. Make sure to wrap the whole string using EncodingUtil.urlEncode | | tranDate | Long | Transaction date of the record. Use the “additionalFilter” option for a range of dates. | | entity | String | To filter the records based on the Vendor. Multiple IDs can be passed in a comma-separated string Ex: 6,7 | ### Example :::CodeblockTabs Request ```apex Map filters = new Map(); filters.put('subsidiary', '1,2'); filters.put('additionalFilter', EncodingUtil.urlEncode('lastModifiedDate>1643635961+and+lastModifiedDate<1646141561', 'UTF-8')); // Encode additionalFilter after constructing it with +and+ for multi-filters // field filters and additionalFilter for where param Map filterMap = new Map(); filterMap.put('where', new Map{'keyValueMap'=>filters}); Map requestJSONMap = new Map(); requestJSONMap.put('customParameters', filterMap); String reqJSON = JSON.serialize(requestJSONMap); Map reqObj = new Map(); reqObj.put('version', '1.0'); reqObj.put('action', 'readVendorBill); reqObj.put('requestJSON', reqJSON); // Place a request to Breadwinner Global API Map resp = breadwinner_ns.BreadwinnerNetSuiteAPI.call(reqObj); System.debug(resp); ``` Response ```json { action=readVendorBill, responseJSON={ "vendorBills": [ { "userTotal": 25000.0, "transactionNumber": "VENDBILL7", "tranId": null, "tranDate": 1553497200, "terms": null, "taxTotal": 0.0, "subsidiary": { "type": null, "name": "Parent Company", "internalId": "1", "externalId": null }, "status": "Paid In Full", "salesforceID": null, "nullFieldList": null, "memo": null, "location": null, "lastModifiedDate": 1645186351, "itemList": { "replaceAll": null, "item": [ { "unitsDisplay": null, "taxRate1": "0.0", "taxCode": { "type": null, "name": "VAT_IN:UNDEF-IN", "internalId": "5", "externalId": null }, "tax1Amt": 0.0, "shipMethod": null, "shipGroup": null, "serialNumbers": null, "revRecStartDate": null, "revRecSchedule": null, "revRecEndDate": null, "rate": "500.00", "quantityRemaining": null, "quantityReceived": null, "quantityPicked": null, "quantityPacked": null, "quantityOnHand": null, "quantityFulfilled": null, "quantityCommitted": null, "quantityBilled": null, "quantityBackOrdered": null, "quantityAvailable": null, "quantity": 50.0, "price": null, "poNum": null, "percentComplete": null, "orderLine": 1, "onHand": null, "location": null, "line": 1, "jobName": null, "itemReceive": null, "itemName": null, "itemIsFulfilled": null, "item": { "type": null, "name": "Test MEN'S VINTAGE- JEANS PANT", "internalId": "23", "externalId": null }, "isClosed": null, "grossAmt": 25000.0, "expectedReceiptDate": null, "description": "ERROR: Field 'line.custcol2' Not Found", "department": null, "customFieldList": null, "createPo": null, "costEstimateType": null, "costEstimate": null, "classification": null, "billingSchedule": null, "amount": 25000.0 } ] }, "internalId": "650", "fax": null, "externalId": null, "expenseList": null, "exchangeRate": 1.0, "entity": { "type": null, "name": "Test Anuvarthh Apparels Pvt Ltd", "internalId": "371", "externalId": null }, "email": null, "dueDate": 1553497200, "department": null, "customForm": null, "customFieldList": { "customField": [ { "valueLookup": null, "value": "false", "scriptId": "custbody34", "internalId": "558", "fieldType": null }, { "valueLookup": null, "value": "372 - Nikhil jain", "scriptId": "custbody_breadwinner_pc_internal_id", "internalId": "588", "fieldType": null }, { "valueLookup": null, "value": "false", "scriptId": "custbody_checkbox", "internalId": "272", "fieldType": null }, { "valueLookup": null, "value": "false", "scriptId": "custbody_edoc_gen_trans_pdf", "internalId": "925", "fieldType": null }, { "valueLookup": null, "value": "false", "scriptId": "custbody_ei_ds_txn_identifier", "internalId": "932", "fieldType": null } ] }, "currencyRecord": { "type": null, "name": "INR", "internalId": "1", "externalId": null }, "currencyName": "INR", "createdDate": 1553520536, "classification": null, "billingAddress": { "zip": "560011", "state": "KARNATAKA", "internalId": "223", "country": "_india", "city": "BANGALORE", "attention": null, "addrPhone": null, "addressee": "Test Anuvarthh Apparels Pvt Ltd", "addr3": null, "addr2": "Jaya Nagar East\tJayanagar", "addr1": "#, 108, 7th Main Rd, 2nd Block," }, "approvalStatus": { "type": null, "name": "Approved", "internalId": "2", "externalId": null } }, { "userTotal": 1.0727272727262E11, "transactionNumber": "VENDBILL179", "tranId": null, "tranDate": 1643702400, "terms": null, "taxTotal": 1.636363636362E10, "subsidiary": { "type": null, "name": "Parent Company", "internalId": "1", "externalId": null }, "status": "Open", "salesforceID": null, "nullFieldList": null, "memo": null, "location": { "type": null, "name": "Hyderabad : Hi-Tech City", "internalId": "10", "externalId": null }, "lastModifiedDate": 1643722367, "itemList": { "replaceAll": null, "item": [ { "unitsDisplay": null, "taxRate1": "18.0", "taxCode": { "type": null, "name": "VAT_IN:GST 18", "internalId": "36", "externalId": null }, "tax1Amt": 1.636363636362E10, "shipMethod": null, "shipGroup": null, "serialNumbers": null, "revRecStartDate": null, "revRecSchedule": null, "revRecEndDate": null, "rate": "90909090909.00", "quantityRemaining": null, "quantityReceived": null, "quantityPicked": null, "quantityPacked": null, "quantityOnHand": null, "quantityFulfilled": null, "quantityCommitted": null, "quantityBilled": null, "quantityBackOrdered": null, "quantityAvailable": null, "quantity": 1.0, "price": null, "poNum": null, "percentComplete": null, "orderLine": null, "onHand": null, "location": { "type": null, "name": "Hyderabad : Hi-Tech City", "internalId": "10", "externalId": null }, "line": 1, "jobName": null, "itemReceive": null, "itemName": null, "itemIsFulfilled": null, "item": { "type": null, "name": "Boxer", "internalId": "240", "externalId": null }, "isClosed": null, "grossAmt": 1.0727272727262E11, "expectedReceiptDate": null, "description": "test desc", "department": null, "customFieldList": { "customField": [ { "valueLookup": null, "value": "ERROR: Field 'custcol7' Not Found", "scriptId": "custcol11", "internalId": "656", "fieldType": null }, { "valueLookup": null, "value": "false", "scriptId": "custcol_checkbox", "internalId": "443", "fieldType": null } ] }, "createPo": null, "costEstimateType": null, "costEstimate": null, "classification": null, "billingSchedule": null, "amount": 9.0909090909E10 } ] }, "internalId": "95408", "fax": null, "externalId": null, "expenseList": null, "exchangeRate": 23.0, "entity": { "type": null, "name": "11 AIR 1pp", "internalId": "74489", "externalId": null }, "email": null, "dueDate": 1643702400, "department": null, "customForm": null, "customFieldList": { "customField": [ { "valueLookup": null, "value": "false", "scriptId": "custbody34", "internalId": "558", "fieldType": null }, { "valueLookup": null, "value": " - ", "scriptId": "custbody_breadwinner_pc_internal_id", "internalId": "588", "fieldType": null }, { "valueLookup": null, "value": "false", "scriptId": "custbody_checkbox", "internalId": "272", "fieldType": null }, { "valueLookup": null, "value": "false", "scriptId": "custbody_edoc_gen_trans_pdf", "internalId": "925", "fieldType": null }, { "valueLookup": null, "value": "false", "scriptId": "custbody_ei_ds_txn_identifier", "internalId": "932", "fieldType": null } ] }, "currencyRecord": { "type": null, "name": "US Dollars", "internalId": "2", "externalId": null }, "currencyName": "US Dollars", "createdDate": 1643722367, "classification": null, "billingAddress": { "zip": "505490", "state": null, "internalId": "81273", "country": "_india", "city": "1", "attention": null, "addrPhone": null, "addressee": "11 AIR 1pp", "addr3": null, "addr2": null, "addr1": "1" }, "approvalStatus": { "type": null, "name": "Approved", "internalId": "2", "externalId": null } }, { "userTotal": 51.92, "transactionNumber": "VENDBILL180", "tranId": null, "tranDate": 1644912000, "terms": null, "taxTotal": 7.92, "subsidiary": { "type": null, "name": "Parent Company", "internalId": "1", "externalId": null }, "status": "Open", "salesforceID": null, "nullFieldList": null, "memo": null, "location": { "type": null, "name": "test : Atlanta west", "internalId": "1", "externalId": null }, "lastModifiedDate": 1644922743, "itemList": { "replaceAll": null, "item": [ { "unitsDisplay": null, "taxRate1": "18.0", "taxCode": { "type": null, "name": "VAT_IN:GST 18", "internalId": "36", "externalId": null }, "tax1Amt": 1.8, "shipMethod": null, "shipGroup": null, "serialNumbers": null, "revRecStartDate": null, "revRecSchedule": null, "revRecEndDate": null, "rate": "10.00", "quantityRemaining": null, "quantityReceived": null, "quantityPicked": null, "quantityPacked": null, "quantityOnHand": null, "quantityFulfilled": null, "quantityCommitted": null, "quantityBilled": null, "quantityBackOrdered": null, "quantityAvailable": null, "quantity": 1.0, "price": null, "poNum": null, "percentComplete": null, "orderLine": null, "onHand": null, "location": { "type": null, "name": "test : Atlanta west", "internalId": "1", "externalId": null }, "line": 1, "jobName": null, "itemReceive": null, "itemName": null, "itemIsFulfilled": null, "item": { "type": null, "name": "Boxer", "internalId": "240", "externalId": null }, "isClosed": null, "grossAmt": 11.8, "expectedReceiptDate": null, "description": "test desc", "department": { "type": null, "name": "Sales", "internalId": "2", "externalId": null }, "customFieldList": { "customField": [ { "valueLookup": null, "value": "ERROR: Field 'custcol7' Not Found", "scriptId": "custcol11", "internalId": "656", "fieldType": null }, { "valueLookup": null, "value": "false", "scriptId": "custcol_checkbox", "internalId": "443", "fieldType": null }, { "valueLookup": null, "value": "1638950400", "scriptId": "custcol_date", "internalId": "445", "fieldType": null }, { "valueLookup": null, "value": "1639051620", "scriptId": "custcol_datetime", "internalId": "447", "fieldType": null }, { "valueLookup": null, "value": "45.3", "scriptId": "custcol_decimal", "internalId": "449", "fieldType": null }, { "valueLookup": null, "value": "10", "scriptId": "custcol_integer", "internalId": "452", "fieldType": null } ] }, "createPo": null, "costEstimateType": null, "costEstimate": null, "classification": { "type": null, "name": "Individual Partner Class", "internalId": "2", "externalId": null }, "billingSchedule": null, "amount": 10.0 }, { "unitsDisplay": null, "taxRate1": "18.0", "taxCode": { "type": null, "name": "VAT_IN:GST 18", "internalId": "36", "externalId": null }, "tax1Amt": 6.12, "shipMethod": null, "shipGroup": null, "serialNumbers": null, "revRecStartDate": null, "revRecSchedule": null, "revRecEndDate": null, "rate": "34.00", "quantityRemaining": null, "quantityReceived": null, "quantityPicked": null, "quantityPacked": null, "quantityOnHand": null, "quantityFulfilled": null, "quantityCommitted": null, "quantityBilled": null, "quantityBackOrdered": null, "quantityAvailable": null, "quantity": 1.0, "price": null, "poNum": null, "percentComplete": null, "orderLine": null, "onHand": null, "location": { "type": null, "name": "test : Atlanta west", "internalId": "1", "externalId": null }, "line": 2, "jobName": null, "itemReceive": null, "itemName": null, "itemIsFulfilled": null, "item": { "type": null, "name": "Bow", "internalId": "239", "externalId": null }, "isClosed": null, "grossAmt": 40.12, "expectedReceiptDate": null, "description": null, "department": { "type": null, "name": "Sales", "internalId": "2", "externalId": null }, "customFieldList": { "customField": [ { "valueLookup": null, "value": "ERROR: Field 'custcol7' Not Found", "scriptId": "custcol11", "internalId": "656", "fieldType": null }, { "valueLookup": null, "value": "false", "scriptId": "custcol_checkbox", "internalId": "443", "fieldType": null }, { "valueLookup": null, "value": "1644739200", "scriptId": "custcol_date", "internalId": "445", "fieldType": null }, { "valueLookup": null, "value": "1644833940", "scriptId": "custcol_datetime", "internalId": "447", "fieldType": null }, { "valueLookup": null, "value": "45.3", "scriptId": "custcol_decimal", "internalId": "449", "fieldType": null }, { "valueLookup": null, "value": "34", "scriptId": "custcol_integer", "internalId": "452", "fieldType": null } ] }, "createPo": null, "costEstimateType": null, "costEstimate": null, "classification": { "type": null, "name": "Individual Partner Class", "internalId": "2", "externalId": null }, "billingSchedule": null, "amount": 34.0 } ] }, "internalId": "97609", "fax": null, "externalId": null, "expenseList": null, "exchangeRate": 23.0, "entity": { "type": null, "name": "Vendor rec create test - 1", "internalId": "76690", "externalId": null }, "email": null, "dueDate": 1644912000, "department": null, "customForm": null, "customFieldList": { "customField": [ { "valueLookup": null, "value": "false", "scriptId": "custbody34", "internalId": "558", "fieldType": null }, { "valueLookup": null, "value": " - ", "scriptId": "custbody_breadwinner_pc_internal_id", "internalId": "588", "fieldType": null }, { "valueLookup": null, "value": "false", "scriptId": "custbody_checkbox", "internalId": "272", "fieldType": null }, { "valueLookup": null, "value": "1638864060", "scriptId": "custbody_datetime", "internalId": "446", "fieldType": null }, { "valueLookup": null, "value": "false", "scriptId": "custbody_edoc_gen_trans_pdf", "internalId": "925", "fieldType": null }, { "valueLookup": null, "value": "false", "scriptId": "custbody_ei_ds_txn_identifier", "internalId": "932", "fieldType": null }, { "valueLookup": null, "value": "10", "scriptId": "custbody_integer", "internalId": "454", "fieldType": null } ] }, "currencyRecord": { "type": null, "name": "US Dollars", "internalId": "2", "externalId": null }, "currencyName": "US Dollars", "createdDate": 1644922743, "classification": null, "billingAddress": { "zip": "53370", "state": "6413", "internalId": "83474", "country": "_india", "city": "1", "attention": null, "addrPhone": null, "addressee": "Vendor rec create test - 1", "addr3": null, "addr2": null, "addr1": "1" }, "approvalStatus": { "type": null, "name": "Approved", "internalId": "2", "externalId": null } } ], "customParamters": { "where": { "value": null, "keyValueMap": { "subsidiary": "1,2", "additionalFilter": "lastModifiedDate%3E1643635961%2Band%2BlastModifiedDate%3C1646141561" } } }, "currentPageRecords": 3, "totalRecords": 3, "totalPages": 1, "searchId": "WEBSERVICES_5333445_SB1_0413202320616814841383158033_85b36a5", "pageIndex": 1, "errors": [ ], "status": "200" }, timestamp=1681393897012, validRequest=true, version=1.0 } ``` :::