Microsoft Dynamics AX Support

This blog contains posts by the Microsoft Dynamics AX Support teams Worldwide

AX For Retail: Transaction volume per store per day

AX For Retail: Transaction volume per store per day

Rate This
  • Comments 1

Description:

We sometimes get the question how to find the transaction
volume. The data gathered are useful for

- Sizing of the System infrastructure

- Evaluate sales trends

 

 

Example script:

Can be executed on the AXRETAILPOS or HQ database

The example illustrates only the large transaction tables

select store,transdate, COUNT(*) as reccount from (
select  CONVERT(varchar(8), TRANSDATE, 112) as transdate, STORE
 from RBOTRANSACTIONPAYMENTTRANS ) as t
group by store, transdate
order by store, transdate

 

select STORE,transdate, COUNT(*) as reccount from (
select  CONVERT(varchar(8), TRANSDATE, 112) as transdate,STORE
 from  dbo.RBOTRANSACTIONSALESTRANS) as t
group by store,transdate
order by store,transdate

 

select store, transdate, COUNT(*) as reccount from (
select  CONVERT(varchar(8), TRANSDATE, 112) as transdate, STORE
 from RBOTRANSACTIONTABLE ) as t
group by store, transdate
order by store, transdate

 

OUTPUT example:

STORE transdate reccount
R_309 20111013 5
R_309 20111014 1
R_309 20111017 3
R_309 20111018 4
R_309 20111019 3
R_309 20111020 3
R_309 20111025 1
R_309 20111026 1
R_309 20111027 236
R_309 20111102 33
R_309 20111104 36
R_309 20111105 91
R_309 20111108 38
R_309 20111209 8
R_309 20111215 36
R_309 20111216 154
R_315 20110826 11
R_315 20110829 4
R_315 20110830 3
R_315 20110831 10
R_315 20110905 3
R_315 20111004 3
R_315 20111006 16
R_317 20110801 174
R_317 20110802 160
R_317 20110803 228
R_317 20110804 220
R_317 20110805 240
R_317 20110806 200
R_317 20110807 75
R_317 20110808 131
R_317 20110809 191
R_317 20110810 317
R_317 20110811 149
R_317 20110812 513
R_317 20110813 311
R_317 20110814 43
R_317 20110816 261
R_317 20110817 130
R_317 20110818 258
R_317 20110819 91
R_317 20110820 333
R_317 20110821 83
R_317 20110822 118
R_317 20110823 162
R_317 20110824 122
R_317 20110826 2
R_320 20111012 19
S0001 20111228 3
S0001 20111229 186
S0001 20120102 21
S0001 20120106 7
S0001 20120125 1
S0001 20120128 2
S0001 20120130 15
S0001 20120131 12

 

Author: Kim Truelsen

Blog date: 12-2-2012

Leave a Comment
  • Please add 7 and 2 and type the answer here:
  • Post
  • Hi,

    This statistics can be computed only when there is data.

    Required is prior to going to production, what should be the volumetrics.

    For Example in Fashion, we can compute  basis

    20 Stores

    200 Tranactions a Day, 5 SKU per Transaction and 2 PAyment Line

    Basis above, general requirement is how much space we need to keep for retail data.

    Regards

    Ashish Jain

Page 1 of 1 (1 items)