-
a GST Software that do not require you to have much GST Knowledge!
Support Center > Knowledge base> Article: Debtor Aging and Debtor Ledger not Tally

Debtor Aging and Debtor Ledger not Tally

Article ID: 52479 Email Print
Question
Debtor Aging and Debtor Ledger not Tally

Answer

1. Upgrade to the latest version, because old version may got bug. After this, scan database :

             
   GL         - Journal Entries                   
   Debtor  - Receive Payments, Debtor Credit Notes, Debtor Knock-off(All items) Past Receive Payments,  PastDebtor Credit  Notes    
   

 

 

                 
2. Check the Gain & Loss Posting Date                 
Normally the ForexPostingDate is same as ARDate or PayforDate. But sometimes the ForexPostingDate is posted to another date.       
E.g.                      
ARDATE ARTYPE ARCODE ARPOS PAYFORDATE PAYFORTYPE PAYFORCODE PAYFORPOS FOREXPOSTINGDATE      
13/08/2008 CN CN0808/002 0 30/06/2008 INV OPB97 0 04/11/2008      
11/09/2008 CN CN0809/003 0 24/09/2008 INV INV08-09-116 0 01/02/2009      
                       
2.1 Run below script and check the ForexPostingDate. The script shows all columns in ARMatched table included additional field - ArDate and PayforDate.
                       
select gl.transactiondate as ardate, ar.artype, ar.arcode, ar.arpos,            
gl2.transactiondate as payfordate, ar.payfortype, ar.payforcode, ar.payforpos,          
ar.forexpostingdate                    
from armatched ar                    
left join gltransaction gl on gl.documentno = ar.arcode              
left join gltransaction gl2 on gl2.documentno = ar.payforcode            
where not forexgltransactionid is null                

group by 1,2,3,4,5,6,7,8,9

 

                 

For Creditor

select gl.transactiondate as apdate, ap.aptype, ap.apcode, ap.appos,      
gl2.transactiondate as payfordate, ap.payfortype, ap.payforcode, ap.payforpos,     
ap.forexpostingdate          
from apmatched ap          
left join gltransaction gl on gl.documentno = ap.apcode       
left join gltransaction gl2 on gl2.documentno = ap.payforcode      
where not forexgltransactionid is null        
group by 1,2,3,4,5,6,7,8,9

                     
2.2 Once get the result, adjust the OR or CN ForexPostingDate. Try unmatch the doc and match again, check the ForexPostingDate      
         

 

 

           
3. Compare the Debtor Ledger and Aging report monthly. If it is not tally, find out which debtor is not tally.       
                       
3.1 To check this. you can get the script from CRM - Case - CAS-01603-71J7KR or \\Dfs_server\DFS_SUPPORT\Tips\Debtor Aging and Debtor Ledger not Tally and run at QnE Manangement Tools
 
after run the script, then run this                   
                       
SELECT GLACCOUNTCODEL2, BALANCE, AGINGBALANCE FROM NOTETOACCOUNT2('23-Nov-2000', '23-Nov-2009')       
                       
Remark : ('23-Nov-2000', '23-Nov-2009') --> filtering date              
                       
The result shows which debtors got problem.               
                       
                       
4. Find out which date / which document got problem, normally is the OR or CN problem. Try unmatch and match again

 


related articles

Article Details
Views: 2368 Created on: Aug 06, 2014
Date updated: Aug 06, 2014
Posted in: Delphi

Poor Outstanding