Bill - Acumatica Data Target Requirement
Bill - Acumatica Data Target Requirement
DataBlend supports the standard API calls to create a Bill within Acumatica leveraging the Acumatica SDK. In addition, custom fields can be added for data that is unique to your business practices. Acumatica fields are highly customizable and can be set to required or optional.
|
DataBlend Query Field Example |
Acumatica Object (API) |
Required |
|
10 |
Amount |
Yes, if no detail lines are provided |
|
TRUE |
ApprovedForPayment |
|
|
100 |
Balance |
|
|
CAPITAL |
BranchID |
If multi-branch |
|
10200 |
CashAccount |
Only for prepayments |
|
USD |
CurrencyID |
If vendor is multi-currency |
|
01/01/2026 |
Date |
Yes |
|
Miscellaneous expense |
Description |
|
|
03/01/2026 |
DueDate |
Only if Terms are not supplied and auto-calculation is disabled |
|
FALSE |
Hold |
If defaults disabled |
|
MAIN |
LocationID |
If vendor has no default location |
|
12-2026 |
PostPeriod |
Yes, unless it can be auto-derived from Date |
|
Misc |
Project |
Only if Project Accounting enforces Misc |
|
001234 |
ReferenceNbr |
Only if manual numbering is enabled |
|
Open |
Status |
|
|
8.75 |
TaxTotal |
|
|
N30 |
Terms |
Only if DueDate is not provided |
|
Bill |
Type |
Yes |
|
TAXNYSTATE |
Vendor |
Yes |
|
00BC04D48E504B6CB995 |
VendorRef |
|
|
TRUE |
IsTaxValid |
Only if tax calculation is enabled and applicable |
|
01/05/2026 10:15:36 |
LastModifiedDateTime |
|
| Description |
Note |
|
|
1 |
Detail_PoLine |
|
|
PO001234 |
Detail_PoOrderNbr |
|
|
Normal |
Detail_PoOrderType |
|
|
5 |
Detail_Qty |
|
|
50000 |
Detail_Account |
|
|
CAPITAL |
Detail_Branch |
|
|
1 |
Detail_PoReceiptLine |
|
|
PR001234 |
Detail_ReceiptNbr |
|
|
Misc |
Detail_Project |
|
|
000 |
Detail_SubAccount |
|
|
Office supplies |
Detail_TransactionDescription |
|
|
2.00 |
Detail_UnitCost |
|
More questions about API requirements? Please visit the Acumatica API site https://help.acumatica.com/Help?ScreenId=ShowWiki&pageid=74a426d9-d4f7-4005-ba45-d88817d62dff.