Planet Earth Solutions P. Ltd.




PES Nepal

 Host IP : 38.103.63.60
You are here: Home arrow KnowledgeBase! arrow Invalid Loan Transaction Entries
  • Decrease font size
  • Default font size
  • Increase font size
Invalid Loan Transaction Entries PDF Print E-mail
User Rating: / 0
PoorBest 
Written by Binod Nepal   
Sunday, 16 December 2007
select LEDGERNAME from ledgers
where (ledgername in
(select distinct(ledgername) from loangrant))
and groupname not in
(select groups.groupname from groups, primarygroups
where primarygroups.primarygroupname =
groups.primarygroupname
and primarygroups.primarygroupnameenglish in
('Loan Investment A/C'))
order by ledgername

This code is used to find out whether any invalid entries in LoanGrant table exists. If it belongs to ledgers other than Loan Investment Ledger Account, then probably it causes false reading on final accounts.

ENGLISH VERSION USERS

माथि दिईएको कोडले डाटावेशबाट खोज गरी कर्जा लगानी हिसाबमा गलत लेजर प्रविष्टिहरुको विवरण तयार गर्दछ ।

NEPALI VERSION USERS
Last Updated ( Sunday, 16 December 2007 )
 
< Prev   Next >
[ Back ]
 

Authentication






Lost Password?

Polls

What do you think 'Char Khata' being necessary for record keeping ?
 

Who's Online

Statistics

OS: Linux c
PHP: 5.2.5
MySQL: 5.0.51a-community
Time: 03:49
Caching: Enabled
GZIP: Disabled
Members: 19
News: 166
Web Links: 9
Visitors: 44584

Latest News

Popular

Bookmark Us

 
 

Main Menu

Home
Our Services
Our Valued Clients
About SFICS® 2.0.696
Web Hosting Plans
Web Development
Download Updates
FAQs
Technical Guidelines
Search
Contact Us
KnowledgeBase!
Careers!
HelpDesk

News Scroller

  :: Nepal Software Development   :: 404   :: About SFICS® 2.0.696   :: Nepal Cooperative Software   :: Online Error Reporting   :: New to Web Hosting ?   :: PES in Biratnagar   :: PES Nepal Software Development   :: Our Services   :: Corporate Web Hosting Plan   :: PES Nepal Web Designing   :: Our Software Development Process   :: Personal Web Hosting Plan   :: SFICS Live Update   :: Scholarship Program   :: Business Web Hosting Plan   :: Careers!!!   :: Why are some features not working properly ?   :: Annapurna Multipurpose   :: What are the things that I should be known of before calling the support team ?   :: Installing SFICS Update   :: SQL Server Behaviour   :: Samunnat Multipurpose   :: What is service?   :: What if we are unable to report online?   :: Hamro Multipurpose   :: Grace Multipurpose   :: What after the service period end?   :: What if we are not connected to the internet?   :: Karnali Saving & Credit   :: Useful Software to Download   :: What is the mode of payment?   :: Does it cost double for two computers?   :: Srijanshil Saving & Credit   :: How do you provide service then?   :: Nepal Multipurpose   :: How do we benefit from your service?   :: How do you work?   :: Full Update Links   :: Invalid Loan Transaction Entries   :: Invalid Ledger Entries   :: Gorkha Saving & Credit   :: Invalid Saving Account Entries   :: Offshore Development   :: Primary filegroup full error   :: Stop Piracy !!!   :: Why SFICS®   :: Invalid Share Transaction Entries   :: Sanjivani Saving & Credit Cooperative Society   :: Om Sainag Multipurpose

Hot Links

Personal Web Hosting Plan
Business Web Hosting Plan
Corporate Web Hosting Plan
PES Nepal Web Designing
Software Development Process
Nepal Software Development
Technical Guidelines
News-Blog
Links
Site! Map