RE: [SYSTEM21] Account Code Inquiry tallys

[Richard_Caldicott@xxxxxxxxxxxxxxx]

FLP056 is the header file.  You probably need to look at FLP055.

Richard




"Kincer, Alan" <akincer@xxxxxxxxx>
Sent by: system21-bounces@xxxxxxxxxxxx
02/04/2004 01:03 PM
Please respond to System 21 Users

 
        To:     System 21 Users <system21@xxxxxxxxxxxx>
        cc: 
        Subject:        RE: [SYSTEM21]   Account Code Inquiry tallys


This is great Richard. What file do the budget numbers come from? I 
thought
they may have been from FLP056 but I was barking up the wrong tree.

-----Original Message-----
From: Richard_Caldicott@xxxxxxxxxxxxxxx
[mailto:Richard_Caldicott@xxxxxxxxxxxxxxx] 
Sent: Wednesday, February 04, 2004 1:12 PM
To: System 21 Users
Subject: Re: [SYSTEM21] Account Code Inquiry tallys

You will need to add a couple of figures from FLP004 for the period you 
are interested. 

NPDR04 + NPCR04 = Period Postings
FYDR04 + FYCR04 = Fiscal Year to date (Balance for B/S accounts)

One note - for future periods ie if your G/L is still in 0401 and you are 
looking at 0402, the FY values only counting the same as the NP fields and 

you have to add the 0401 FY figures to get the correct figure.  This is 
done automatically be the standard inquires and reports.  At month end the 

FY figures from the old month are added to the new month.

Richard




"Kincer, Alan" <akincer@xxxxxxxxx>
Sent by: system21-bounces@xxxxxxxxxxxx
02/04/2004 12:02 PM
Please respond to System 21 Users

 
        To:     System 21 Users <system21@xxxxxxxxxxxx>
        cc: 
        Subject:        [SYSTEM21]   Account Code Inquiry tallys


Hi folks!

In 1/GLE (Account Code Inquiry) there is some calculated information that 
I
am interested in pulling into a report. The numbers are the two figures
below net movement and Balance YTD (examples given below with >>)

I would like to know what files/fields are used to produce these totals. I
am assuming that the search criteria is a combination of the account and 
the
period number so if there's anything else please advise.

Thank you!

Alan

================================================================
GL134

Account Code Inquiry

 Account : 501014XXXXX  Ledger P&L  Acct typ Fisc Rpt ctl  012

 Desc  . : SALES, WIDGETS MADE WITH RED PAINT 
 Annual budget:  40415770-

 Period 0309             Net movement                 Balance YTD


Budget . . . :         >> 3831200.00-             >> 40415770.00-
Actual . . . :         >> 3831685.16-             >> 41930483.41-

Variance . . :                485.16                  1514713.41




=== [ KI (USA) Corporation - http://www.kiusa.com ]
====================================== 
Tel. 859.986.1420  --  Fax. 859.986.1485 
This e-mail, including any attachments, contains information from KI (USA)
Corporation that may be confidential or privileged. Mail is intended only
for those to whom it is addressed. If you are not the intended recipient 
do
not copy, distribute, or take any action in reliance on the contents of 
this
message. 
If you have received this e-mail in error notify the sender immediately 
then
delete or destroy all electronic and hard copies of this communication,
including attachments. 
KI (USA) Corporation's anti-virus system checks for known viruses. However
you are advised to run your own virus check before opening any attachments
received. KI (USA) Corporation will not accept any liability once an 
e-mail
and/or any attachment is received. 
Views expressed in the e-mail are those of the author and not necessarily
those of KI (USA) Corporation. 
============================================================================


_______________________________________________
This is the System 21 Users (SYSTEM21) mailing list
To post a message email: SYSTEM21@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/system21
or email: SYSTEM21-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/system21.