I understand that data can be brought into a system for past years from other systems. With this premise, I am hoping that I can create some data to be brought in for the 2006 year to provide Unit Comparatives for the year previous to LY.

The accounts are already set up and in use as they already have LY and current data recorded.

I am hoping that someone can assist me with the required layout of a working file and the importing process of such file.

The data I am hoping to import includes:
Account Number
Description
Period
Date (last day of mth)
# Units

... and that's all.

What do you think?

I look forward to hearing from you.