For reference on bulk uploads see this article: Bulk Uploads

This page will give Invoice Upload specific bulk upload detail

Upload file and Select Currency of Bills

All bills will be uploaded in 'created' status, so they can be edited/deleted later

The upload template file is attached at the bottom of this article. Fields highlighted are required

Field List

*Fields headers are not case sensitive

*Only one of Description/Item.number should be set

  • number - unique id that groups line items together to form one bill
  • Vendor.id - Vendor ID for this line item
  • invoiceDate - ┬áInvoice Date
  • postedDate - Posted date of the bill
  • dueDate - Due Date of the bill
  • Location.id - Location ID value for this line item
  • ICLocation.id - Inter-Company Location ID value for this line item
  • BillAccount.number - Ledger Account used for description line items
  • CostCenter.id - Cost Center ID value for this line item
  • Job.number - Job number for this line item
  • Product.id - Product ID value for this line item
  • notes - Long form text for this bill
  • APAccount.number - Accounts Payable Ledger Account
  • Description - 255 character line item text field. If set requires BillAccount.number
  • Item.number - SoftLedger item number for this line item
  • Quantity - Number of items
  • amount - Per item price
  • reference - 255 character description for bill
Did this answer your question?