Assigning Reference Numbers in Business Importer

реф

Overview:


1. Applying Reference Numbers from the import file

2. Generating Reference Numbers automatically

3. Keeping your QuickBooks Online Reference Numbers

4. Multilined Transactions

There are three settings options for applying reference numbers to transactions in Business Importer

1) Applying Reference Numbers from the import file

  • This option will suit you if you want to apply DocNumbers directly from the file.
  • The DocNumber column from the file should be mapped at the mapping stage of the import.
  • You can verify whether your current setting status will import DocNumbers from the file or enable it in your Business Importer settings.
10

2) Generating Reference Numbers automatically

  • Choose this option if you want the DocNumbers to be generated automatically.
  • You do not need to map the DocNumbers field at the mapping stage in this case.
  • You can verify whether your current setting status will generate DocNumbers automatically or enable it in your Business Importer settings.
  • There is also a possibility to indicate the starting number for each entity in the settings*.
*This feature is available for the following entities: Bill, Bill Payment, Cash Expense,Check, Credit Card Charge, Credit Memo, Deposit, Estimate, Invoice, Journal Entry, Payment Purchase Order, Refund Receipt, Sales Receipt, Vendor Credit.
11

In this case the numbering of the Bills will start from 25 and will be applied onwards.

3) Keeping your QuickBooks Online Reference Numbers

  • Choose this setting if you want the DocNumbers to be automatically assigned by QuickBooks Online.
  • Disable both of the following settings: “Generate automatically DocNumber” and “Apply Reference number from import file to the transaction”.
  • Make sure that your QuickBooks Custom transaction numbers is disabled in your QuickBooks Settings. Otherwise the DocNumbers field will be left blank.
12

4) Multilined Transactions

  • If you are importing a multilined transaction, all the lines containing the identical DocNumbers in the import file will be grouped to one line.
  • If you want the DocNumbers for the transaction to be taken from the import file, use the First option.
  • If you want DocNumbers for the transaction to be automatically assigned by our application, use the Second option.
  • If you want the DocNumbers for the transaction to be assigned by the QuickBooks online, use the Third option.
13
14

Option of importing DocNumbers from the file is great for importing multilined transactions

Do you have any questions? We would love to hear from you. Comment below to start a conversation or send an email to the address specified in the footer of this page.
anton.bondar

This entry has 0 replies

Comments open

Leave a reply

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>