Personalization, Customization and Productivity Tools

[Darkjedi]

I'm wanting the last 6 periods of AR_CustomerSalesHistory Dollars Sold in separate records. But I can't figure out how to get the current period, current period-1, current period-2 and so on for DollarsSold. I know this must be an easy, but my inexperience gets in the way.

Thanks

Mark

[ulrich]

What version of MAS are you using? If prior to 4.1 and you have not been doing period end processing every month I don't think you will be able to do this from standard reports.

[BigLouie]

Are you looking to get the sum of the last 6 periods. Here is a formula I used for a recent report that should give you an idea:

If Month (CurrentDate)=12 and ToNumber({IM9_ItemSalesDetailWhse.Year})=(Year(CurrentDate)) then {IM9_ItemSalesDetailWhse.QtySoldPeriod6}+{IM9_ItemSalesDetailWhse.QtySoldPeriod7}+{IM9_ItemSalesDetailWhse.QtySoldPeriod8}+{IM9_ItemSalesDetailWhse.QtySoldPeriod9}+{IM9_ItemSalesDetailWhse.QtySoldPeriod10}+{IM9_ItemSalesDetailWhse.QtySoldPeriod11} else 0

[Darkjedi]

MAS200 4.4

The only way I could think of was to use the DateUpdated record and use a date range on that record. Don't like it but it works. Do you know of a better way? The way BigLouie suggested would have worked when I was using IM9_ItemSalesDetailWhse but with update I can't use it anymore.

Thanks

[Darkjedi · Accepted solution]

Thanks BigLouie, your right I was able to use the part of your formula.