Invoice Import
This feature is available to bulk import invoices - most commonly used for accounting purposes.
Common Uses:
Invoices that are split amongst multiple stores.
Tracking Direct Operating Cost and Non-Controllable Expenses
Budget Report
Cost of Goods Sold
Accounting
Common Account Types:
Utilities
Subscriptions / Premiums
Rent / Occupation Fees
Taxes
Supplemental Compensation
How to:
To use this feature.
Download Template
Enter values in fields using the guide below
Save File as .CSV
Click Chose File and add the file you created
Click Upload
Column | Header | Field Definition & Information |
---|---|---|
1 / [Hidden] | User ID | For tracking and auditing purposes. This field is populated upon Template upload |
2 / A | StoreID | Configured per Client. Default is CUST ID from Stores Maintenance page. |
3 / B | Invoice Date | Configured per Client. Default limits entry to 2 days in the future. |
4 / C | InvoiceNumber | Max 20 characters, preferably only numerical. Must be unique for the vendor and store, however, one unique invoice number can be used across stores. |
5 / D | InvoiceTypeID | Found in Maintenance > General > PPC Maintenance > Transaction Types > ID #. |
6 / E | VendorNumber | Max 20 characters. Use value per store as assigned in Franchisor Maintenance. If no value exists in Franchisor Maintenance, use Vendor Number in PPC Maintenance > Vendors. |
7 / F | AccountNumber | Max 20 characters. Use value per store as assigned in Franchisor Maintenance. If no value exists in Franchisor Maintenance, use Account Number in PPC Maintenance > Accounts. |
9 / G | Amount | Invoice Amount ≥ 0. No dollar sign, no commas, two decimal place max. |
10 / H | PONumber | Order Number if applicable |
11 / I | Comment | Invoice comment only if necessary. |
Other Notes:
Because the file type is CSV (Comma Separated Values), the entirety of the import file cannot contain commas in fields.
If you receive an error message, the template did not upload.
“string or binary data could be truncated”
This error is most likely due to a comment that is too long or contains a comma.
“column [x] contains an unexpected value”
This error is most likely due to a comma (G or I) in a field that is pushing the next fields into the following columns
Per row, fields in columns A, D, E, and F must have confluent assignments via PPC Maintenance. Vendor (E) needs to be assigned Vendor Store (A), Vendor Type (D), and Vendor Account (F).
Multiple account numbers can be added per invoice number by adding duplicate rows and only changing the pertinent information.
© 2023 Knowledge Management Systems, LLC. Decision Logic. All Rights Reserved.
Table of Contents
For additional questions or assistance, please submit a support ticket by visiting the Decision Logic Service Center.
Related content
If you'd like to receive news on software releases and product updates, please sign up for our email list.