Looks like there is already a way to batch create many receipts and payments that have multiple lines and having inventory items.
One thing that is difficult is that columns show keys for Bank.Account and Lines.Item. I have not tried a batch create yet for Receipts and Payments, but I presume you need to enter the correct bank account key instead of the text for the bank account name.
What I do know is that the batch update shows the keys for Bank.Account and Lines.Item. And that is already difficult. What I wish is that Manager would translate the keys into readable strings. And I wish I could batch create supplying the name of the bank account instead of the key for the bank account.
When I paste back into Manager, Manager would reject any name for which it does not have a key, and would let me know that I entered the name wrong.
I’m looking at what I pasted in Excel from Batch Update. Looks like multiple lines in an entry are handled with multiple lines inside the cells for Lines.Account, Lines.Qty, Lines.Item, and Lines.Amount. And you don’t use both Lines.Account and Lines.Item on the same line. One of them has to be a blank line.
In Excel, one way to get multiple lines in a cell is to hold down the Alt key while pressing Enter. So, that is fine. In my text editor, I see that you can type a double quote, then put each line data on a separate line, then end with a double quote. Then, I can copy and paste into an Excel spreadsheet cell and I have multiple line entry. So, that is all fine.
If is not this way already, I hope that (I guess Lubos does the programming?) Lubos will make Batch Create to accept the bank account name and item name, and so on for all the fields, instead of needing to enter the key for the bank account. And Batch Update will show the account names instead of the account keys, etc.
I would guess that my request is already being worked on, even before I thought to post. I just need to be patient, right?
For tonight, I think I will just use the wonderful receipts and payments forms. After all, I find them so very well designed.