Thanks so much James,
I checked the CustTrans table, it including all customer transactions (Sales, credit note and payments) but I want to know how to segregate Receipts, Cash discounts, Sales, Credit noted and any other kind of transations. is there any way to know the type of tranaction in custTrans.
regards
Ahmed
James Flavell <[EMAIL PROTECTED]> wrote:
Hi Ahmed,Its CustTrans and not CustInvoiceTrans you need if you want balances (I take it meaning unsettled amount on a transaction)James-----Original Message-----
From: Ahmed Ibrahim [mailto:[EMAIL PROTECTED]
Sent: 24 November 2004 13:56
To: [EMAIL PROTECTED]
Subject: RE: [Axapta-Knowledge-Village] Customer inquiryThanks James,I will try to go through custinvoicetrans and will look at standard reports.Ahmed.
James Flavell <[EMAIL PROTECTED]> wrote:I think since you mention balance here then you have to focus on the custtrans. If you wanted just list of sales and credit notes then custinvoicetrans would be okay but since you seem to be wanting something with balance then you need to use custtrans I would expect. This can be a bit tricky and I suggest oyu look at the standard reports such as external or internal customer account statement (I tend to just reuse the query logic of this and add my own required format)James-----Original Message-----
From: allie [mailto:[EMAIL PROTECTED]
Sent: 24 November 2004 04:00
To: [EMAIL PROTECTED]
Subject: Re: [Axapta-Knowledge-Village] Customer inquiryThe typical tables to use are the Inventjournaltrans,Inventtrans Custinvoicetrans.
mbsdeveloper <[EMAIL PROTECTED]> wrote:
Hi ,
I want to create a report for the customer movement to show sales,
receipts, credit notes, debit notes and balance so I want to know
what are the tables&Queries required to get these information
Regards
Ahmed El-sayed
Sharing the knowledge on Axapta.
ALL-NEW Yahoo! Messenger - all new features - even more fun!
Sharing the knowledge on Axapta.
Sharing the knowledge on Axapta.
Do you Yahoo!?
The all-new My Yahoo! - Get yours free!
Sharing the knowledge on Axapta.
Sharing the knowledge on Axapta.
Do you Yahoo!?
Take Yahoo! Mail with you! Get it on your mobile phone.
Sharing the knowledge on Axapta.
| Yahoo! Groups Sponsor | |
|
|
Yahoo! Groups Links
- To visit your group on the web, go to:
http://groups.yahoo.com/group/Axapta-Knowledge-Village/
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
