You need to use an importer tool to do so. You can prepare your data with the following template
| RefNumber | Account | Transaction Date | Memo | Item | New Qty | New Value | Adj Qty | Adj Value | Customer | Class |
| 1231-1 | Cost of Goods Sold | 31/12/2020 | Year End Inventory Adjustment | Hardware | 10 | | | | | |
| 1231-1 | Cost of Goods Sold | 31/12/2020 | Year End Inventory Adjustment | Door Frame | 10 | | | | | |
| 1231-1 | Cost of Goods Sold | 31/12/2020 | Year End Inventory Adjustment | Cabinets | | | -1 | | | |
| 1231-2 | Cost of Goods Sold | 31/12/2020 | Year End Inventory Adjustment | Wood Door | | 1000 | | | | |
| 1231-2 | Cost of Goods Sold | 31/12/2020 | Year End Inventory Adjustment | Interior Door Kit | | | | 500 | | |
then purchase TP Importer to proceed. It's a $199 one time license.
https://get.transactionpro.com/qbd
If your company is located in the US, you can get the license for free from a partner. Contact @Fiat Lux - ASIA via email directly for details.
