RE: [development-axapta] Ageing report

[Girish Bhatkal]

 
 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:09To: [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 AMTo: [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 displaysome of the transactions which were settled in march 
      and april. Hence we arefinding a difference in the total balance when 
      compared to the customertransaction report or the "customer balance 
      list with credit report".    Does anyone know why 
      is this ageing report running differently to thecustomter balance list 
      with credit report run.   i am testing in Axapta 3 
      ,SP2.thanks,cheers,girish







Yahoo! Groups Links

To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ 
To unsubscribe from this group, send an email to:[EMAIL PROTECTED] 
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.