@BGMDI
Prepare the Purchase Order data with the following template
| Vendor | Transaction Date | PO Number | Class | ShipTo Entity | BillTo Line1 | BillTo Line2 | BillTo Line3 | BillTo Line4 | BillTo City | BillTo State | BillTo PostalCode | BillTo Country | ShipTo Line1 | ShipTo Line2 | ShipTo Line3 | ShipTo Line4 | ShipTo City | ShipTo State | ShipTo PostalCode | ShipTo Country | Terms | Due Date | Expected | Ship Method | FOB | Vendor Message | Memo | Vendor Acct No | Item | Quantity | Description | Rate | Customer | Service Date | To Be Printed | Template Name | Vendor Email | To Be E-Mailed | Items Class | Other1_Header | Other2_Header | Other1 | Other2 | Unit of Measure | Manuf Part Number | Currency | Exchange Rate |
| John's Lumber | 01/09/2020 | 8 | | | John's Lumber | 1 Main Street | | | Newton | NY | 12345 | USA | John's Lumber | 1 Main Street | | | Newton | NY | 12345 | USA | | | | | | | | | Cabinets | 10 | Cabinets | 200 | | | | | | | | | | | | | | | |
| John's Lumber | 01/09/2020 | 8 | | | John's Lumber | 1 Main Street | | | Newton | NY | 12345 | USA | John's Lumber | 1 Main Street | | | Newton | NY | 12345 | USA | | | | | | | | | Hardware | 20 | Hardware | 10 | | | | | | | | | | | | | | | |
| Jane's Landscape Design | 02/09/2020 | 9 | | | Jane's Landscape Design | 200 Smith Street | | | Anytown | NY | 11111 | USA | Jane's Landscape Designe | 200 Smith Street | | | Anytown | NY | 11111 | USA | | | | | | | | | Door Frame | 1 | Door Frame | 1000 | Baker, Chris | | Y | | | | | | | | | | | | |
| ABC Roofing Company | 03/09/2020 | 10 | | | ABC Roofing Company | 1 North Street | | | Newton | NY | 12345 | USA | ABC Roofing Company | 1 North Street | | | Newton | NY | 12345 | USA | | | | | | | | | Black Tiles | 100 | Black Premium Tiles | 25 | | | | | | | | | | | | | | | |
| ABC Roofing Company | 03/09/2020 | 10 | | | ABC Roofing Company | 1 North Street | | | Newton | NY | 12345 | USA | ABC Roofing Company | 1 North Street | | | Newton | NY | 12345 | USA | | | | | | | | | Red Tiles | 100 | Red Premium Tiles | 25 | | | | | | | | | | | | | | | |
then utilize one of these importer tools
https://transactionpro.grsm.io/qbd
https://partners.saasant.com/affiliate/idevaffiliate.php?id=5051_2
