Hi Superfly,

Are you referring to the IC Sales History information? If so, there is no easy way to relate the information to a specific date range. This is because the sales periods are defined by how often Period End processing is run in IC. If it's not done consistantly (ie last day of every month), there will be no way to even know what a Sales period means. Dates are not stored in the Sales History file.

If you do Period ends regularly (ie end of month), then you'll know what Sales Period refers to what month. In Quik Reports DOS, you could use some formula to the effect of "Sales Amount[Month(Today)-x]" where Amount is the Sales History field, Month(Today) is the numeric value for the month, and x is the number of months difference between January and your first Sales Period. Quik Reports for Windows deals with Array field differently, and you would need a long if/then/else: "If Month(Today)=1 then Sales Amount[1] else if Month(Today)=2 then..."

A better method for Sales reports would be to base the report off of the IC Transaction history file. Detailed information is stored for each transaction, including a date field.

An even better method for Sales reports is by basing the report on a database whose purpose is to accumulate sales data, such as Sales Analysis or Invoice Sales History.

Regards,

Apparently that was just a tease...

If the data you want is from the IC Sales History, there is no easy way to definitively relate any date to this data.

About the closest you can get is by inserting the Period End date fields from the IC Company Profile table. However, this file cannot be 'linked'; it can only be used for comparison purposes...

"If Date >= Period end date[1] and Date < Period end date[2] then....."

Not an easy proposition; this will certainly test your mettle with formulas...

We don't have any sample reports with functionality like this already defined.

Regards,

Hi Superfly,

Just a FYI that you can do this sales report from Softrak's Sales Analysis database with Crystal Reports for Adagio, or from Order Entry if you are not purging your invoices over the period in question.

(Unless I'm missing something here...)