DatabaseRobert
Level 4

This has been an issue of long standing due to the way in which Lacerte adds forms.  Each form has a variable associated with it for internal use in the program; these are stored in a list and sorted in one order (either numerically/by the variable, or alphabetically/by the form name).

However, the data table that records, "this client # has This Form" in it is sorted in the OTHER order (alphabetically, versus numerically).

This means that if you have a form #1234 and a form #1237 at the start of the season, they will appear next to each other in the "forms prepared report" at that time...  but if Lacerte later adds a #1235, its variable number may well put it five columns away INSTEAD OF in between those existing two.
  Which means that any report based on "something further to the right" of that new form, is now offset to be shown as "some other form" in the report.

As I say, this has been the case for MANY years.

.

You can largely fix this by highlighting all of your clients (F3/"all"), and going to the Alt+menu | L(cLient) | U(pdate client database)...
  ...however, any clients that you have previously Locked with NOT be updated.

Again, you can largely fix *that* issue by copying your entire data path to a separate directory, then UNlocking all of your clients, doing the update as just described, and then generating the "forms used this year" report while in THAT directory.
  Just make certain to change *back* to your "live" data when you're done...



Robert Kirk
LTUGtools