RE: [development-axapta] Ageing report

Fri, 30 Apr 2004 02:16:51 -0700

James,
 when running the customer transaction report we can select a new field "Date" and then here we can enter the from and to date so see the list of transactions, for the selected period. And on which settlement screen is the "date principal" button available.  i will write down the trans date example and email back.
thanks again.
 
cheers,
Girish
 
-----Original Message-----
From: James Flavell [mailto:[EMAIL PROTECTED]
Sent: 30 April 2004 08:44
To: [EMAIL PROTECTED]
Subject: RE: [development-axapta] Ageing report

I think maybe if you give the example of the trans that not appear, i.e. what dates on the data etc and what dates you run on report
To set what date is used you should press the 'Date principal' button on settlement screen and set as you wnat (is saved as a user setting)
 
As mentioned the cust trans report has no 'as of' date so it takes the current status of the trans whereas aging has an 'as of' option, so these reports may not match even with same date range specified... without exact report setting used and examples of the trans that going missing its hard to know how the report is processing....
-----Original Message-----
From: Girish Bhatkal [mailto:[EMAIL PROTECTED]
Sent: Friday, April 30, 2004 5:15 PM
To: [EMAIL PROTECTED]
Subject: RE: [development-axapta] Ageing report

 
 Thanks , everyone, for the response.
 
            James,  I had properly taken care that i enter the correct dates . In fact for one of the client's company both the report total matches but for the rest it does not match. I also tried to run the report using all the possible criteria's and selections but it does not match . In fact in one of the company i was trying to find the solution i found that the difference is only for a particular customer.
 
        During payment/receipt the user sometimes enter the TransDate as Old date and do the posting.  When i checked the records through the table browser i observerd, as Michelle had mentioned, that the settlement date is not the date entered in the TransDate field but instead was the posting date.  where can we specify that the date of the settlement should be the date transaction date? i am not sure if this would solve the problem.
    when i ran the report with details i found a few transactions displayed in the "customer transactions" report were missing, for both the reports the date range were selected the same.
       Did anyone observe this difference earlier?
 
cheers,
Girish
 
-----Original Message-----
From: James Flavell [mailto:[EMAIL PROTECTED]
Sent: 30 April 2004 05:09
To: [EMAIL PROTECTED]
Subject: RE: [development-axapta] Ageing report

I dont think that is the problem because the report "customer balance list with credit report" should still refelect the settlement date being the invoice date right and hence the total balance of both the aging and this report should match?
 
Grish, just to double check:
Your 'As of' date for both reports is the same? 
Your 'As of' date is a past date our you set as the current date?
You select 'Only open'?
You select 'Detail'?
(maybe you can just give settings you use ..... :) )
 
I dont suggest you use customer trans report as there is no way for specifying an "As at" date (not in my Sp1 version anyway...) and so this report will just give you the current status of the transactions.
 
Thanks
James
 
 
-----Original Message-----
From: Michelle Thompson [mailto:[EMAIL PROTECTED]
Sent: Friday, April 30, 2004 3:42 AM
To: [EMAIL PROTECTED]
Subject: Re: [development-axapta] Ageing report

Because Axapta settles based on the date of the Invoice.  You have to change the date of the settlement to the date of the payment.
 
Hope that helps you.

Girish Bhatkal <[EMAIL PROTECTED]> wrote:
Hi,

    i was running the Customer ageing report (say for before 29/02/2004,
with criteria transaction date) and found that the report does not display
some of the transactions which were settled in march and april. Hence we are
finding a difference in the total balance when compared to the customer
transaction report or the "customer balance list with credit report".

    Does anyone know why is this ageing report running differently to the
customter balance list with credit report run.
   i am testing in Axapta 3 ,SP2.

thanks,

cheers,
girish


Yahoo! Groups Links

Reply via email to