A client has a Ledger batch that has about 300 entries and many of them have a blank account number. The account number will be the same for all accounts that are blank. Can anyone suggest a method to set all the blank accounts to the same valid account?

It is possible but time consuming to manually edit the batch and change the blank accounts to the correct one.

I have tried exporting the batch to csv, xls or converting to another format and setting the account umber to the default but importing the batch back in results in numerous errors. The batch is in balance but some accounts are blank???

Thanks in advance for any suggestions you can offer.

Hi Terry,

If you export the batch to Excel and then use a filter in Excel to show only the blank account codes and copy paste does that not work? Or you could use Find and Replace in that Excel column to replace blank with the desired account code.

Hi Terry:

If this is a once-only problem, how about using GV-RW to fill in the GL account codes?

Hi Dan and Bruce,

Thanks for your suggestions, I'll give Excel a try.