Purchase Detail Import

NOTE:  Connected imports support tab delimited text files only. 

The Purchases Detail import supports CONNECTED’s modern import framework and allows custom field mapping and import preview. To access the Purchase Detail Import, select Import from the File menu and choose Purchases Detail.  The following screen will appear.

The import file needs to contain the following information (required fields in bold)

1. Type - purchase type; required; valid entries: INVOICE or DEBIT; related import records should have the same value
2. Vendor Code - required; must be a valid code for an active status vendor; related import records should have the same value
3. Term Code - must be a valid payable term code; if blank in the import file, the vendor's default term code is used; related import records should have the same value
4. Invoice No - required; 20 characters max; related import records should have the same value
5. Invoice Date - required; must be in an open accounting period; related import records should have the same value
6. Due Date - cannot be prior to the invoice date; if blank in the import file, a calculated date is used; related import records should have the same value
7. Scheduled Date - cannot be prior to the invoice date; if blank in the import file, a calculated date is used; related import records should have the same value
8. PO No - 15 characters max; related import records should have the same value
9. GST/HST Amount - must be a positive number; related import records should have the same value
10. Total Amount - required; must be a positive number; related import records should have the same value
11. Hold - hold purchase; valid entries: YES, NO or blank (equivalent to NO); related import records should have the same value
12. Description - purchase description; 1024 characters max; if blank in the import file, the vendor's default purchases comments are used; related import records should have the same value
13. Account No - required; must be a valid account number
14. Debit - required; must be a positive number; see note below
15. Credit - required; must be a positive number; see note below
16. Job No - must be a valid number for an open status job; see note below
17. Phase Code - must be a valid job phase code; see note below
18. Job Cost Description - 1024 characters max; if blank in the import file, the phase code name is used; see note below
19. Job Cost Hours - must be a positive number; see note below
20. Job Cost Amount - must be a positive number; see note below
    
    

NOTES:

A debit or credit amount is required for each account allocation and the total debits must balance the total credits.

Imported purchase details create a single, unposted purchase invoice.

SPECIAL CHARACTER HANDLING:

Import values containing single and double quote characters and carriage returns cannot be directly imported. Using a text editor application, these characters must be removed and substituted with the following strings prior to importing. During the import process, the substitute strings will then be replaced with the original characters. Substitute /dqt/ for double quotes, /sqt/ for single quotes and /rtn/ for carriage returns. The forward slashes must be included.