Skip to main content

Vendor Bill API

Create, read, update, and delete vendor bills.


Endpoints

MethodEndpointDescription
GET/record/v1/vendorBillList vendor bills
GET/record/v1/vendorBill/{id}Get specific bill
POST/record/v1/vendorBillCreate bill
PATCH/record/v1/vendorBill/{id}Update bill
DELETE/record/v1/vendorBill/{id}Delete bill

Key Fields

FieldTypeDescriptionRequired
entityobjectVendorYes
tranDatestringBill dateYes
dueDatestringPayment due dateAuto-calculated
subsidiaryobjectSubsidiaryYes (OneWorld)
currencyobjectCurrencyYes
totalnumberTotal amount (read-only)-
amountPaidnumberAmount paid (read-only)-
amountRemainingnumberBalance due (read-only)-
termsobjectPayment termsNo
tranIdstringVendor invoice numberNo
createdFromobjectSource PONo
itemcollectionLine itemsConditional
expensecollectionExpense linesConditional

Example: Create Bill from PO

POST /record/v1/vendorBill
Content-Type: application/json
{
"entity": {
"id": "789"
},
"tranDate": "2025-12-25",
"subsidiary": {
"id": "1"
},
"currency": {
"id": "1"
},
"createdFrom": {
"id": "2001"
},
"tranId": "VEND-INV-12345",
"item": {
"items": [
{
"item": { "id": "789" },
"quantity": 100,
"rate": 25.00
}
]
}
}

Example: Create Expense Bill

POST /record/v1/vendorBill
Content-Type: application/json
{
"entity": {
"id": "789"
},
"tranDate": "2025-12-25",
"subsidiary": {
"id": "1"
},
"currency": {
"id": "1"
},
"memo": "Office rent - December 2025",
"expense": {
"items": [
{
"account": { "id": "150" },
"amount": 5000.00,
"memo": "Monthly rent"
}
]
}
}

Query Filters

Find Unpaid Bills

GET /record/v1/vendorBill?q=amountRemaining > 0

Find by Vendor

GET /record/v1/vendorBill?q=entity='789'

Find Overdue Bills

GET /record/v1/vendorBill?q=dueDate < SYSDATE AND amountRemaining > 0

See Also