we used the comment column on the ver 6 accounts payable g/l distribution screen to indicate the future year account code for all pre-paid expenses. At the beginning of the new year we ran a query and were able to easily import a g/l entry to recode all the pre-paids to current. Has anyone else found way to do this besides the old fashioned excel spreadsheet?

To avoid prepaids we either split invoices or have them posted in the correct year. The biggest problem this can create is if you then actually pay it before the post date then your AP detail wont balance to the GL. for us this is usually immaterial in total. i put in an attribute for each of these invoices and then query all the invoices after year end to see if any were actually prepaid (and thus affecting the AP reconciliation). this procedure keeps the voucher posting clean and no need for a GL entry.