# Weekly Dynamic: Count of Fixed Assets Added

- URL: https://dynamicaccounting.net/weekly-dynamic-count-of-fixed-assets-added/
- Date: 2010-07-12
- Topics: Tips & Hidden Features, General Ledger & Financials
- Type: original article

Continuing a look at metrics to analyze GP transactions, this week’s Weekly Dynamic looks at a count of Fixed Assets added by week. As with other metrics, this can also show past data in Microsoft Dynamics GP for trends.

The code is below and it’s available for download at: [http://www.box.net/shared/vopqx25elb](https://app.box.com/shared/vopqx25elb "http://www.box.net/shared/vopqx25elb")

```
```
--Select Fixed Assets Added by week
```

```
--Could be switched to month but you'll need to use either the FA Calendar Month or the Fiscal month if you don't use a calendar year
```

```
select Case
```

```
 when datename(weekday,dateadded) = 'Friday' then dateadded
```

```
 when datename(weekday,dateadded) = 'Saturday' then dateadd(Day,6,dateadded)
```

```
 when datename(weekday,dateadded) = 'Sunday' then dateadd(Day,5,dateadded)
```

```
 when datename(weekday,dateadded) = 'Monday' then dateadd(Day,4,dateadded)
```

```
 when datename(weekday,dateadded) = 'Tuesday' then dateadd(Day,3,dateadded)
```

```
 when datename(weekday,dateadded) = 'Wednesday' then dateadd(Day,2,dateadded)
```

```
 when datename(weekday,dateadded) = 'Thursday' then dateadd(Day,1,dateadded)
```

```
 else '01/01/1900' end as WeekEndDate, count(Assetindex) as FAAddedCount
```

```
  from fa00100
```

```
Group by
```

```
Case
```

```
 when datename(weekday,dateadded) = 'Friday' then dateadded
```

```
 when datename(weekday,dateadded) = 'Saturday' then dateadd(Day,6,dateadded)
```

```
 when datename(weekday,dateadded) = 'Sunday' then dateadd(Day,5,dateadded)
```

```
 when datename(weekday,dateadded) = 'Monday' then dateadd(Day,4,dateadded)
```

```
 when datename(weekday,dateadded) = 'Tuesday' then dateadd(Day,3,dateadded)
```

```
 when datename(weekday,dateadded) = 'Wednesday' then dateadd(Day,2,dateadded)
```

```
 when datename(weekday,dateadded) = 'Thursday' then dateadd(Day,1,dateadded)
```

```
 else '01/01/1900' end
```

```
order by 1
```

 

![](/img/blogger/9b3c0fcb2a64c0ec.png)
```