Purchase Detail Import

Modified on Fri, Mar 12, 2021 at 3:27 PM

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.


Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article