Excel Add-In for Zoho Inventory

Build 26.0.9770

Bills

List, Insert, Update, delete bills

Table Specific Information

Select

The add-in will use the Zoho Inventory API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client-side within the add-in.

  • Id supports the '=' comparison.

For example, the following queries are processed server side: 

SELECT * FROM Bills WHERE Id = '3350895000000089001'

Insert

Insert can be executed by specifying the VendorId, BillNumber, Date, DueDate and LineItems column. The columns that are not read-only can be inserted optionally. Following is an example of how to insert into this table. 

INSERT INTO Bills (VendorId, BillNumber, Date, DueDate, LineItems) VALUES (3249056000000160028, 33, '2022-06-30', '2022-07-30', '[{\"name\": \"Chips\",\"warehouse_id\": 3249056000000138013,\"account_id\": 3249056000000000388, \"account_name\": \"Inventory Asset\", \"rate\": 900,\"quantity\": 2,\"reverse_charge_tax_id\":3249056000000158097 }]')

Update

Update can be executed by specifying the Id in the WHERE Clause. The columns that are not read-only can be Updated. For example: 

UPDATE Bills SET VendorId = '3249056000000160028', BillNumber = '77', Date = '2022-06-30', DueDate = '2022-06-30', LineItems = '[{\"name\": \"Machines\",\"warehouse_id\": 3249056000000138013,\"account_id\": 3249056000000000388, \"account_name\": \"Inventory Asset\", \"rate\": 50000,\"quantity\": 2,\"reverse_charge_tax_id\":3249056000000158097 }]' WHERE Id = 3249056000000195059

Delete

Delete can be executed by specifying the Id in the WHERE Clause For example: 

DELETE FROM Bills WHERE Id = '3350895000000089001'

Columns

Name Type ReadOnly References Description
Id [KEY] Long True

Unique ID generated by the server.

AttachmentName String True

Name of the attached file.

Balance Integer True

Remaining balance of the Bill.

Status String True

Status of the Bill.

BillNumber String False

Bill number of Purchase Order.

CreatedTime Datetime True

Time at which the Bill details were last created..

CurrencyCode String True

Currency code.

CurrencyId Long False

Unique ID generated by the server for the currency.

CurrencySymbol String True

The symbol for the selected currency.

Documents String True

Documents attached to bill.

Date Date False

Date of the Bill.

DueByDays Integer True

Number of days by which the Bill is due.

DueDate Date False

Due date for the Bill.

DueDays String True

Number of days by which the Bill is due.

EntityType String True

Entity Type.

ExchangeRate Integer False

Exchange rate of the currency, with respect to the base currency.

HasAttachment Boolean True

Checks whether the bill has attachment or not.

IsItemLevelTaxCalc Boolean False

Checks whether item level tax is calculated or not.

LastModifiedTime Datetime True

Time at which the bill details were last Modified.

LineItems String False

The line items for a Bill.

Notes String False

Notes for the Bill.

OpenPurchaseordersCount Integer True

Number of Purchase Orders that are associated with this Bill and open.

Payments String True

Payment details for the Bill.

PricePrecision Integer True

The precision level for the price decimal point in a Bill.

PurchaseorderId Long False

Unique ID generated by the server for the Purchase Order.

ReferenceId Long True

Unique ID generated by the server for the reference.

ReferenceNumber String False

Reference number for the Bill.

SubTotal Integer True

Sub Total of the Bill.

TaxTotal Integer True

The total of the Tax.

Taxes String True

Number of taxes applied on the Purchase Order.

Terms String False

Terms and conditions..

UnusedCreditsPayableAmount Integer True

Unused credit payable amount.

VendorCredits String True

The available Vendor Credits.

VendorCreditsApplied Integer True

Vendor credits applied to the Bill.

VendorId Long False

Unique ID generated by the server for the vendor.

VendorName String True

Name of the vendor.

BillingAddressAddress String True

Name of the street of the customers billing address.

BillingAddressCity String True

Name of the city of the customers billing address.

BillingAddressCountry String True

Name of the country of the customers billing address.

BillingAddressFax String True

Fax number of the customers billing address.

BillingAddressState String True

Name of the state of the customer billing address.

Adjustment Double True

Adjustment amount.

ApproverId Long True

ID of the approver.

BillingAddressAttention String True

Billing address attention.

BranchId Long True

ID of the branch.

Discount Double True

Discount applied.

DiscountAccountId Long True

ID of the discount account.

IsInclusiveTax Boolean False

Whether tax is inclusive.

LocationId Long False

ID of the location.

PaymentTerms Integer True

Payment terms in days.

PricebookId Long True

ID of the price book.

Purchaseorders String True

Associated purchase orders.

SubStatuses String True

Sub-statuses.

Tags String True

Tags.

TaxOverridePreference String True

Tax override preference.

TemplateId Long True

ID of the template.

AdjustmentDescription String True

Adjustment description.

AllocatedLandedCosts String True

Allocated landed costs.

ApproversList String True

Approvers list.

BillOrderType String True

Bill order type.

BillingAddressPhone String True

Billing address phone.

BillingAddressStreet2 String True

Billing address street 2.

BillingAddressZip String True

Billing address zip.

BillingAddressId Long True

ID of the billing address.

BranchName String True

Name of the branch.

CanSendInMail Boolean True

Whether it can be sent in mail.

ComputationType String True

Computation type.

ContactCategory String True

Contact category.

CreatedById Long True

ID of the creator.

CurrencyNameFormatted String True

Formatted currency name.

CustomFields String True

Custom fields.

DiscountAccountName String True

Name of the discount account.

DiscountAppliedOnAmount Double True

Discount applied on amount.

DiscountPercent Double True

Discount percentage.

DiscountSetting String True

Discount setting.

DiscountTotal Double True

Discount total.

DiscountType String True

Discount type.

DueInDays Integer True

Number of days until due.

IsApprovalRequired Boolean True

Whether approval is required.

IsDiscountBeforeTax Boolean True

Whether discount is applied before tax.

IsLineItemInvoiced Boolean True

Whether line item is invoiced.

LastModifiedId Long True

ID of the last modifier.

LocationName String True

Name of the location.

NonCatalogItemsCount Integer True

Count of non-catalog items.

Orientation String True

Orientation.

PageHeight String True

Page height.

PageWidth String True

Page width.

PaymentExpectedDate Date True

Payment expected date.

PaymentMade Double True

Payment made.

PaymentTermsLabel String True

Payment terms label.

PricebookName String True

Name of the price book.

PurchaseorderIds String True

Purchase order IDs.

RecurringBillId Long True

ID of the recurring bill.

RetentionItems String True

Retention items.

ScannedPoId Long True

ID of the scanned PO.

ScannedPoNumber String True

Scanned PO number.

Source String True

Source.

SubTotalInclusiveOfTax Double True

Sub-total inclusive of tax.

SubjectContent String True

Subject content.

SubmittedBy String True

Submitted by.

SubmittedByEmail String True

Email of the submitter.

SubmittedByName String True

Name of the submitter.

SubmittedByPhotoUrl String True

Photo URL of the submitter.

SubmittedDate Date True

Submitted date.

SubmitterId Long True

ID of the submitter.

TaxRounding String True

Tax rounding.

TdsCalculationType String True

TDS calculation type.

TemplateName String True

Name of the template.

TemplateType String True

Type of the template.

TotalRetentionAmount Double True

Total retention amount.

TrackDiscountInAccount Boolean True

Track discount in account.

UnallocatedLandedCosts String True

Unallocated landed costs.

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 26.0.9770