The latest version (24.1.7) improves batch operations so you can use codes or reference numbers instead of internal UUID keys when using
Batch Update or
Batch Create functions.
Customers, suppliers, employees, accounts in your
Chart of Accounts, currencies, items have
Transactions such as journal entries, invoices, orders, quotes, receipts, payments etc. have
Batch operations will now take advantage of codes and reference numbers (if entered) and substitute them for internal UUID keys.
Here is an example how it works. Let’s say we want to batch create exchange rates for US dollar.
Code for the currency is
USD, now when batch creating exchange rates, we can use the code
USD instead of UUID key. Your batch create spreadsheet can look like this:
And when using this spreadsheet in
Currency column will be properly recognized without using any UUID keys.