mibuso.com

Microsoft Business Solutions online community
It is currently Sun May 19, 2013 6:52 am

All times are UTC + 1 hour [ DST ]




Post new topic Reply to topic  [ 2 posts ] 
Author Message
 Post subject: KPI using accounting scheduls
PostPosted: Fri Apr 27, 2012 5:14 pm 
Offline

Joined: Wed May 09, 2007 5:05 pm
Posts: 710
Location: Zejtun
Country: Malta (mt)
Dear all,

We are using the accounting schedules to extract the KPI. In a specific case we require to get the balance of the debtors, and the net change for the Sales Account. How should I go through this as they are found within the same column?


Top
 Profile  
 
 Post subject: Re: KPI using accounting scheduls
PostPosted: Fri Apr 27, 2012 11:05 pm 
Offline

Joined: Sat May 12, 2007 9:19 am
Posts: 270
Location: Falkensee
Country: Germany (de)
Hi sabzam,

sabzam wrote:
How should I go through this as they are found within the same column?


It won't work. But you can use two colums to calculate balance at date and net change. And make a type field (or so) in the Account Schedule Line defining the "valid" column, and deriving a customized report or matrix window to respect this type field (and show it as one column).

with best regards

Jens


Top
 Profile E-mail  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 2 posts ] 

All times are UTC + 1 hour [ DST ]


Who is online

Users browsing this forum: No registered users and 11 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum


Search for:
Jump to: