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)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.