web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Microsoft Dynamics AX (Archived)

Customer Account Statement on basis of Order Account

(0) ShareShare
ReportReport
Posted on by 2,055

Hi, 

I have a chain to whom I am selling my products. As its chain so it have some branches. To maintain this I have open one Customer Account for its head office, and one customer account for each branch. I have open branch account so I can get the total sale to each branch. 

In branch customer account I have mentioned the head office account for invoice account. So all invoice goes to head office, and delivery will go to its branch. 

All its working fine. But now when I tried to get the report Customer Account Statement for any branch. I am unable to get this, as its invoice account is the head office account. So its display all of the sale. But I need the list of my sale to particular branch. 

I have notice that branch code going to save with invoice account in CustInvoiceJour as OrderAccount field. Now the question is how I can get the report depending on Order Account not the Invoice Account. I have try to select Order Account where I select the Invoice Account, but failed. 

Please help me how I can slove my this problem.

*This post is locked for comments

I have the same question (0)
  • André Arnaud de Calavon Profile Picture
    299,149 Super User 2025 Season 2 on at
    RE: Customer Account Statement on basis of Order Account

    Hi Nadeem,

    The account statement is based on the customer transactions which does not have the information of the sales order. You can try to use a financial dimension based on customer account to get details on the order account. Or you can go for a custom report.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Community Member Profile Picture

Community Member 4

#2
Guy Terry Profile Picture

Guy Terry 2 Moderator

#2
Nayyar Siddiqi Profile Picture

Nayyar Siddiqi 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans