Business Importer Desktop: Linking Bill to Purchase Order

Woman calling while calculating bills in kitchen

Linking Bill Payment to Purchase Order

 

There are two ways to link Bill to Purchase Order (PO):
●     Full – if you have a Bill that operates on all of the PO lines;
●     Partial – if you have a Bill that operates on selected PO lines.

Full Bill to Purchase Order link

 ●     It should have the same Bill Ref/Doc numbers for each line of Bill you would like to be joined during the import;
●     It should have “Linked PO Number” columns filled in with PO numbers from your QuickBooks.
im1

Step 1:

Select your import file and sheet in case you have several, and set Bill transaction type for import.
im2

Step 2:

Map (connect) QuickBooks fields with the headings of the columns from your import file.
Note: Red fields are required. You can also save the mapping for all subsequent imports, if needed, clicking Save Import Mapping button.
Note: make sure you have mapped “Linked PO Number” field, and “Item Line: Linked PO Number” is not mapped.
im3

Step 3:

Preview your file clicking Next to make sure you mapped all you wanted and then click Start Import to initiate the import.
im4
Import Results
im5
Possible variants of results in the app
7
Results of the import in your QuickBooks
im6
im7
Bill
im8

Partial Bill to Purchase Order link

Make sure you set up the import file correctly:
●     It should have “Item Line: Linked PO Number” column filled in with PO numbers from your QuickBooks;
●     Make sure you have mapped fields Item Line: Item name and Item Line: Quantity
 im9

Step 1:

Select your import file and sheet in case you have several, and set Bill transaction type for import.
im2

Step 2:

Map (connect) QuickBooks fields with the headings of the columns from your import file.
Note: Red fields are required. You can also save the mapping for all subsequent imports, if needed, clicking Save Import Mapping button.
Note: make sure you have mapped “Item Line: Linked PO Number” field, and “Linked PO Number” is not mapped.
im10

Step 3:

Preview your file clicking Next to make sure you mapped all you wanted and then click Start Import to initiate the import.
im11
Import Results
im12
Possible variants of results in the app
7
Results of the import in your QuickBooks
im13
im14
Do you have any questions? We would love to hear from you. Contact us via our in-app chat to start a conversation or send an email to the address specified in the footer of this page.
michael

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>