web

You’re offline. This is a read only version of the page.

Dynamics 365 CommunityForums Microsoft Dynamics AX (Archived) Whats the best way to ...

Microsoft Dynamics AX (Archived)

Whats the best way to get total sales in terms of amount within particular range.

(0) Share

Report

Report

Posted on by Faisal Fareed

10,796 User Group Leader

Whats the best way to get total sales in terms of amount within particular range.

I am done with this by using two approaches;

1. Looping the InventTrans table

2. Looping the salesLine table

Is there any built in classes to achieve it or any other tables which are more accurate to get precise result ?

*This post is locked for comments

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

Community Member on at

Like (0)

Report

Re: Whats the best way to get total sales in terms of amount within particular range.

Depends of what sales figures you want to look at. If you want all tax, misc charges included, loop through CustInvoiceJour / CustInvoiceTrans and use TransDate.

You can actually break out MST and non MST from those tables as well.

Was this reply helpful? Yes No

Helpful resources

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1

Martin Tocauer 4

#2

#2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans