Transaction record count in practice

(0) Share

Report

Posted on by Pete Alberts

3,542

Hi folks

I am working on some custom cash flow analysis. One of the ever present hurdles is performance.

I have written a program that generates random transactions (standard demo data functionality proved not sufficient). I now want to use my program to populate the cash flow source tables. But I do not know how many records to create.

If it needs mentioning - my random trans generator will enable me to analyse the performance of my cash flow forecasting. And then take appropriate steps.

I was hoping someone could assist me with some figures - what are the maximum record count values in a given month for the following tables:

SalesTable
PurchTable
ForecastSales
ForecastPurch
CustInvoiceTable
CustInvoiceOpen
VendTransOpen
BudgetTransactionLine (not supported in my random trans generator, but I'm still interested)
GeneralJournalAccountEntry (not supported, but still interested)

I know this will vary drastically between customers / AX-implementations and also between companies within an AX instance. I can obviously make some guesses. But your (the reader's) estimation will still be much more valuable than my own - I am an ISV dev spending my entire lifetime in Visual Studio. And then when I am not using VS, my employer puts me back in my box in the store room - I haven't been out to clients much.

Thank you for your attention

I have the same question (0)

All responses (7)

Answers (3)

Verified answer

Satish Panwar 14,671 Moderator on at

Like (1)

Report

Hi Pete,

Infact, I have to agree that's it varies too much.

Sales is higher side in most of the companies if sales is being implemented. PO is much lower as suppliers are often consolidated.

Typical Sales 5K lines. Purchase - 1K lines. Very rough estimate. CustTransOpen is much higher than VendTransOpen.

Suggest that since you are building the ISV solution, you should try for minimum of 5K-10K records for above tables just so that you don't get to Customer and start to have basic issues. The question you have asked can have wide range of answers. I just got another customer that just sell to 2-3 customers and major implementation is purchase side.

Was this reply helpful? Yes No
Pete Alberts 3,542 on at

Like (0)

Report
Thanks Satish

I realise now I only need approximate maximum values. Averages are not relevant - if my functionality copes with the max it will cope with anything else. On the info you supplied and context of max values, I estimate the following:

Sales < 10K

Purch < 10K

ForecastSales ≈ Sales

ForecastPurch ≈ Purch

CustInvoiceTable ?

CustTransOpen < 3K

VendTransOpen < 2K

Could you be so kind to comment again please.

I was actually hoping to hear that we are dealing with millions of records... lol... Would've made me feel really high-tech!

Was this reply helpful? Yes No
Verified answer

Satish Panwar 14,671 Moderator on at

Like (1)

Report

Million transaction per month may be there for top tiers of the customer base. I don't think even MS test all tables with million records :). If that was the case, you should never hear performance related issues (leave aside high-profile hardware). Its like build a solution for high-end customer but you may never use them.

CustInvoiceTable - 2K is good.

Cust/Vend-TransOpen...try to keep close to sales/purch as typical they don't get settled right away.

You can only plan for so much of transaction level, these are just approximations.

Was this reply helpful? Yes No
Verified answer

Sukrut Parab 71,710 Moderator on at

Like (1)

Report

HI Pete ,

As you are aware of and said above , number of transactions on these tables depend on the customers business.

For some of the customers I worked on , I have seen more than 5k sales order a day and for some 1k orders a day , from these number you can imagine/ guess how many transactions get generated In tables like custinvoicejour , trans etc..

Was this reply helpful? Yes No
Rahul Mohta 21,032 on at

Like (0)

Report

you should involve a fasttrack architect to help in coming numbers for your customer.

Comparing any customers max volume is like comapring apples with oranges, all varies

I had seen a customer who had to get vendor prices for 1 million rows a day and some with 3000 lines ~ 300 Sales orders

Was this reply helpful? Yes No
Pete Alberts 3,542 on at

Like (0)

Report

Thanks Sukrut

I assume those figures are cross company. I forgot to bring in that factor...

Thanks Rahul

On your first two comments - please read my post properly. On the figures you supplied - I do not understand. You are mentioning vendor price rows with lines and then conclude with sales orders.

Was this reply helpful? Yes No
Sukrut Parab 71,710 Moderator on at

Like (1)

Report

Those numbers are for a single company, numbers vary for different companies within same instance .

Was this reply helpful? Yes No