I see instructions for copy/paste into General Journals and Account Schedules, however this doesn't work for me.
I am using Business Central.
For the General Journals, I can "edit in excel" so there is a workaround there (although copy/paste would be much preferred), but there is no such "edit in excel" option in Account Schedules when I create/edit the row formats - and copy/paste to/from excel would make building custom reports so much easier.
I am selecting all of the rows and then CTRL-V (after copying from an excel workbook) and nothing happens. If I put the cursor in the first field "row no." and choose CTRL-V, I can only paste one row at a time. If I select all the rows (as the instructions say), and then select the first row, the row selections are removed. Either way, I get the message "You cannot paste 48 rows in the selected 1 row". Same problem whether I'm creating a general journal entry or working in account schedules.
Frustrating! I'm sure there is a simple trick I'm missing, it cannot be this hard. Any ideas?