NameDescriptionTypeAdditional Information
Vendor

The Vendor ID the AP Bill is for. The combination of Vendor, Invoice, and Bill Date are what uniquely identify an AP Bill.

string

Required

Max length: 10

InvoiceNumber

The number of the Invoice the AP Bill paid. One of the values returned by the GetApBill method of the API.

string

Required

Max length: 25

Description

User entered descript or short note about the AP Bill.

string

Max length: 40

EntryDate

The date the bill was entered.

string

Data type: DateTime

Format must be MM/dd/yyyy

BillDate

The date of the bill.

string

Data type: DateTime

Format must be MM/dd/yyyy

DueDate

The date the bill is due.

string

Data type: DateTime

Format must be MM/dd/yyyy

Source

the specific transaction in Agvance that created bill.

string

Max length: 10

UserName

The name of the user that entered the bill.

string

Max length: 20

PONumber

The Purchase Order Number for the bill.

string

Max length: 10

OnHoldYN

'True' or 'False' value indicating whether the bill is on hold or not.

boolean

Must be 0, 1, True, or False

PaidByDate1

The date to pay the bill by in order to receive discount1.

string

Data type: DateTime

Format must be MM/dd/yyyy

PaidByDate2

The date to pay the bill by in order to receive discount2.

string

Data type: DateTime

Format must be MM/dd/yyyy

PaidByDate3

The date to pay the bill by in order to receive discount3.

string

Data type: DateTime

Format must be MM/dd/yyyy

PaidByDate4

The date to pay the bill by in order to receive discount4.

string

Data type: DateTime

Format must be MM/dd/yyyy

PaidByDate5

The date to pay the bill by in order to receive discount5.

string

Data type: DateTime

Format must be MM/dd/yyyy

DeductionPercent1

The Discount percentage given if the bill is paid by PaidBy1 date.

decimal number

Max of 2 decimal places

Must be numeric

DeductionPercent2

The Discount percentage given if the bill is paid by PaidBy2 date.

decimal number

Max of 2 decimal places

Must be numeric

DeductionPercent3

The Discount percentage given if the bill is paid by PaidBy3 date.

decimal number

Max of 2 decimal places

Must be numeric

DeductionPercent4

The Discount percentage given if the bill is paid by PaidBy4 date.

decimal number

Max of 2 decimal places

Must be numeric

DeductionPercent5

The Discount percentage given if the bill is paid by PaidBy5 date.

decimal number

Max of 2 decimal places

Must be numeric

DiscountAmount1

The Discount amount for the bill if paid by PaidBy1.

decimal number

Max of 2 decimal places

Must be numeric

DiscountAmount2

The Discount amount for the bill if paid by PaidBy2.

decimal number

Max of 2 decimal places

Must be numeric

DiscountAmount3

The Discount amount for the bill if paid by PaidBy3.

decimal number

Max of 2 decimal places

Must be numeric

DiscountAmount4

The Discount amount for the bill if paid by PaidBy4.

decimal number

Max of 2 decimal places

Must be numeric

DiscountAmount5

The Discount amount for the bill if paid by PaidBy5.

decimal number

Max of 2 decimal places

Must be numeric

DiscountGL

The General Ledger account to post the bill discount to.

string

Max length: 10

Gross

The amount due before the discount is applied.

decimal number
Discount

The Amount of the discount.

decimal number
Net

The Amount due after the discount is applied.

decimal number
DatePaid

The date the bill was paid.

string

Data type: DateTime

Format must be MM/dd/yyyy

AmountPaid

The amount actually paid.

decimal number
PaidYN

'True' or 'False' indicating if the bill has been paid or not.

boolean

Must be 0, 1, True, or False

VoidedYN

'True' or 'False' indicating if the bill has been voided or not.

boolean

Must be 0, 1, True, or False

ReversedYN

'True' or 'False' indicating if the bill has been reversed or not.

boolean

Must be 0, 1, True, or False

Amount1099

The bill amount that needs reported on the 1099 tax form.

decimal number

Max of 2 decimal places

Must be numeric

Range: inclusive between -1000000000000.00 and 1000000000000.00

CheckNumber

The check number used to pay the bill.

string

Max length: 15

FiscalMonth

The fiscal month the bill is in.

integer
UsePrepayYN

'True' or 'False' indicating if the bill was for prepay or not.

boolean

Must be 0, 1, True, or False

Transferred

'True' or 'False' indicating if the bill was transferred or not.

boolean

Must be 0, 1, True, or False

LocationID

The ID of the location the bill was entered in.

string

Max length: 6

SpecialHandling

User entered special handling instructions for the AP Bill.

string

Max length: 60

PayByEFTYN

'True' or 'False' value indicating if bill was paid by Electronic Fund Transfer.

boolean

Must be 0, 1, True, or False

Notes

User entered notes or comments on the bill.

string

Max length: 255

POInvoice

The PO Invoice number on the bill.

string

Max length: 25

APPurchaseOrder

Whether this is an AP Bill or AP Purchase Order.

boolean

Must be 0, 1, True, or False

UserID

The user who entered the bill.

string

Max length: 3

ApBillGuid

Globally unique identifier of the AP Bill

globally unique identifier
BillDetail

A list that displays the amounts paid and discounts applied on the bill.

Collection of clsAPBillDt

List cannot be empty