Help!! Accounting Report Problem 
Author Message
 Help!! Accounting Report Problem

FM Pro 5.0v3 - Windows 95/98/NT/2000; small network

Desperately need expert assistance!  .

Two files -   Claim File and Checking Account File

The Claim file keeps track of expenditures on a particular case. The key for
each record is identified as an Incident ID.(Unique)

The set up is a little complicated so please bear with me

The expenditure fields are as follows:
Indemnity Paid = Sum(Check ind paid::Check amount)  * see explanation
Indemnity reserved (futures) = defined as "number"
Indemnity Incurred =  (calc number)Indemnity Paid + Indemnity reserved
Medical Paid  =   Sum(Check med paid::Check amount)  * see explanation
Medical reserved = defined as "number"
Medical Incurred =  (calc number) Medical Paid  + Medical reserved
Expenses paid =  Sum(Check exp paid::Check amount) * see explanation
Expenses reserved = defined as "number"
Expenses Incurred = (calc number) Expenses paid + Expenses reserved

* Explanation
anything paid to any individual's claim account is done through the checking
account.
These fields below are native to the checking account:
med paid = Case(Payment type = "Medical", 1, "")
ind paid = Case(Payment type = "Indemnity", 2, "")
exp paid = Case (Payment type = "Expenses", 3, "")

The Payment type is set via a script that initiates the entering of a check.

In order to see this information in the Claim File I created 3 matchfields
in the Checking Account as:

matchfield med paid = (calc - text) med paid & INCIDENT ID
matchfield ind paid = (calc - text) ind paid & INCIDENT ID
matchfield exp paid = (calc - text) exp paid & INCIDENT ID

The matchfield in the Claim File are as such:
Matchfield med paid = (calc - text) 1 & INCIDENT ID
Matchfield ind paid = (calc - text) 2 & INCIDENT ID
Matchfield exp paid = (calc - text) 3 & INCIDENT ID

There is than three relationships between Claim File and Checking account
based on these matchfields.
Check med paid = Matchfield med paid= ::matchfield med paid  to checking
account
Check ind paid = Matchfield ind paid =::matchfield ind paid to checking
account
Check exp paid = Matchfield exp paid =::matchfield exp paid to checking
account

These relationships allow me to keep track of all paid amounts on any
individual claim account.  Thus on Claim account ID# 23478 -  who had 6
checks written over the past 6 months for $250; $200; $100; $150; $500; and
$300 - the Medical Paid  =   Sum(Check med paid::Check amount  will show up
as $1500.

So identifying the cumulative paid on any Claim account is easy but The
Corporations auditors want to be able to see how much was paid during a
current paid (say the Month of November) in addition to the cumulative
amount.

Since the Claim file only tracks cumulative amounts, the current periods of
payments made would be held in the Checking Account File.

Here's my problem:  .

How do I show on a report in The Claim File the current amount paid say for
the month of November 2000?

The report in the Claim File is based upon a find for the fiscal year
(anywhere from 1 - 12 months old)  The info needed from the checking account
would be based upon a different time period - usually (1-3 months long)

How do I combine two separate finds into one report?

 I think I need a portal but how the relationship should work alludes me.

Thanks for any assistance.

Pat Venditti



Wed, 30 Jul 2003 06:54:32 GMT
 Help!! Accounting Report Problem

I understand some of what's going on here: you have a Claim file and a
Checking file. Records in the Checking file are related to the Claim file- I
take it this is a one to many relationship. The Checking file keeps track of
three types of checks and this is where it gets odd; you keep track of these
by placing their identifiers in three different match fields AND with a
concatenated key. Why not just one or the other? (and if you can chose, the
concatenated key is the preferred method).
Then you loose me in some particulars about the summation... You are saying
that you want to view different summations and the problem is that each
summation is of a different found set.? Here's a crude technique: you can
use look up fields to capture the value of sum and sub sum fields by
performing one find, performing a relookup then performing the next find and
a relookup with a different lookup field, etc. Doing this in a network you
have to stop one person from performing a relookup in the middle of some one
else's report.

If this doesn't help get back to the group. I have the feeling that your
problem is simple and there is better advise for it, but it's not clear to
me what your really up to. (I don't think a portal will help because
relationships transcend found sets).

--

C. Alex Lorda


Quote:
> FM Pro 5.0v3 - Windows 95/98/NT/2000; small network

> Desperately need expert assistance!  .

> Two files -   Claim File and Checking Account File

> The Claim file keeps track of expenditures on a particular case. The key
for
> each record is identified as an Incident ID.(Unique)

> The set up is a little complicated so please bear with me

> The expenditure fields are as follows:
> Indemnity Paid = Sum(Check ind paid::Check amount)  * see explanation
> Indemnity reserved (futures) = defined as "number"
> Indemnity Incurred =  (calc number)Indemnity Paid + Indemnity reserved
> Medical Paid  =   Sum(Check med paid::Check amount)  * see explanation
> Medical reserved = defined as "number"
> Medical Incurred =  (calc number) Medical Paid  + Medical reserved
> Expenses paid =  Sum(Check exp paid::Check amount) * see explanation
> Expenses reserved = defined as "number"
> Expenses Incurred = (calc number) Expenses paid + Expenses reserved

> * Explanation
> anything paid to any individual's claim account is done through the
checking
> account.
> These fields below are native to the checking account:
> med paid = Case(Payment type = "Medical", 1, "")
> ind paid = Case(Payment type = "Indemnity", 2, "")
> exp paid = Case (Payment type = "Expenses", 3, "")

> The Payment type is set via a script that initiates the entering of a
check.

> In order to see this information in the Claim File I created 3 matchfields
> in the Checking Account as:

> matchfield med paid = (calc - text) med paid & INCIDENT ID
> matchfield ind paid = (calc - text) ind paid & INCIDENT ID
> matchfield exp paid = (calc - text) exp paid & INCIDENT ID

> The matchfield in the Claim File are as such:
> Matchfield med paid = (calc - text) 1 & INCIDENT ID
> Matchfield ind paid = (calc - text) 2 & INCIDENT ID
> Matchfield exp paid = (calc - text) 3 & INCIDENT ID

> There is than three relationships between Claim File and Checking account
> based on these matchfields.
> Check med paid = Matchfield med paid= ::matchfield med paid  to checking
> account
> Check ind paid = Matchfield ind paid =::matchfield ind paid to checking
> account
> Check exp paid = Matchfield exp paid =::matchfield exp paid to checking
> account

> These relationships allow me to keep track of all paid amounts on any
> individual claim account.  Thus on Claim account ID# 23478 -  who had 6
> checks written over the past 6 months for $250; $200; $100; $150; $500;
and
> $300 - the Medical Paid  =   Sum(Check med paid::Check amount  will show
up
> as $1500.

> So identifying the cumulative paid on any Claim account is easy but The
> Corporations auditors want to be able to see how much was paid during a
> current paid (say the Month of November) in addition to the cumulative
> amount.

> Since the Claim file only tracks cumulative amounts, the current periods
of
> payments made would be held in the Checking Account File.

> Here's my problem:  .

> How do I show on a report in The Claim File the current amount paid say
for
> the month of November 2000?

> The report in the Claim File is based upon a find for the fiscal year
> (anywhere from 1 - 12 months old)  The info needed from the checking
account
> would be based upon a different time period - usually (1-3 months long)

> How do I combine two separate finds into one report?

>  I think I need a portal but how the relationship should work alludes me.

> Thanks for any assistance.

> Pat Venditti



Wed, 30 Jul 2003 17:44:13 GMT
 Help!! Accounting Report Problem
Hi Pat -

If I understand you correctly, you aren't going to be able to create a portal
that shows whatever account and date range they want to see.  You could
establish a concatenated key to filter an account and a certain month or certain
year, or a date, but not a range.  I suggest you save yourself a lot of
head-pounding by creating a simple Find-and-summarize reporting tool in
CheckingDB, where the data resides, and generating your reports that way.  You
could script it so that a set of globals in ClaimDB accepts Find criteria, then
goes to CheckingDB, performs the Find and Sort, and shows the report in Preview
Mode.

By the way, it often happens that I say something can't be done with a calc, and
one of the real experts in the group shows us how, so this is my sneaky way of
building my own expertise.  Hi Maire, how's the weather in the Borderlands? :)

Best of Luck -
James

Quote:

> FM Pro 5.0v3 - Windows 95/98/NT/2000; small network

> Desperately need expert assistance!  .

> Two files -   Claim File and Checking Account File

> The Claim file keeps track of expenditures on a particular case. The key for
> each record is identified as an Incident ID.(Unique)

> The set up is a little complicated so please bear with me

> The expenditure fields are as follows:
> Indemnity Paid = Sum(Check ind paid::Check amount)  * see explanation
> Indemnity reserved (futures) = defined as "number"
> Indemnity Incurred =  (calc number)Indemnity Paid + Indemnity reserved
> Medical Paid  =   Sum(Check med paid::Check amount)  * see explanation
> Medical reserved = defined as "number"
> Medical Incurred =  (calc number) Medical Paid  + Medical reserved
> Expenses paid =  Sum(Check exp paid::Check amount) * see explanation
> Expenses reserved = defined as "number"
> Expenses Incurred = (calc number) Expenses paid + Expenses reserved

> * Explanation
> anything paid to any individual's claim account is done through the checking
> account.
> These fields below are native to the checking account:
> med paid = Case(Payment type = "Medical", 1, "")
> ind paid = Case(Payment type = "Indemnity", 2, "")
> exp paid = Case (Payment type = "Expenses", 3, "")

> The Payment type is set via a script that initiates the entering of a check.

> In order to see this information in the Claim File I created 3 matchfields
> in the Checking Account as:

> matchfield med paid = (calc - text) med paid & INCIDENT ID
> matchfield ind paid = (calc - text) ind paid & INCIDENT ID
> matchfield exp paid = (calc - text) exp paid & INCIDENT ID

> The matchfield in the Claim File are as such:
> Matchfield med paid = (calc - text) 1 & INCIDENT ID
> Matchfield ind paid = (calc - text) 2 & INCIDENT ID
> Matchfield exp paid = (calc - text) 3 & INCIDENT ID

> There is than three relationships between Claim File and Checking account
> based on these matchfields.
> Check med paid = Matchfield med paid= ::matchfield med paid  to checking
> account
> Check ind paid = Matchfield ind paid =::matchfield ind paid to checking
> account
> Check exp paid = Matchfield exp paid =::matchfield exp paid to checking
> account

> These relationships allow me to keep track of all paid amounts on any
> individual claim account.  Thus on Claim account ID# 23478 -  who had 6
> checks written over the past 6 months for $250; $200; $100; $150; $500; and
> $300 - the Medical Paid  =   Sum(Check med paid::Check amount  will show up
> as $1500.

> So identifying the cumulative paid on any Claim account is easy but The
> Corporations auditors want to be able to see how much was paid during a
> current paid (say the Month of November) in addition to the cumulative
> amount.

> Since the Claim file only tracks cumulative amounts, the current periods of
> payments made would be held in the Checking Account File.

> Here's my problem:  .

> How do I show on a report in The Claim File the current amount paid say for
> the month of November 2000?

> The report in the Claim File is based upon a find for the fiscal year
> (anywhere from 1 - 12 months old)  The info needed from the checking account
> would be based upon a different time period - usually (1-3 months long)

> How do I combine two separate finds into one report?

>  I think I need a portal but how the relationship should work alludes me.

> Thanks for any assistance.

> Pat Venditti

--
Don't forget to remove the obvious spam block when replying.
I advocate making an address book entry and using it!  Thanks!


Thu, 31 Jul 2003 04:32:47 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. Release of Report Accounts [RA] version 1.2 accounting engine with Inventory / Point of Sale

2. Release of Report Accounts [RA] version 1.2 accounting engine with Inventory / Point of Sale

3. Release of Report Accounts [RA] version 1.2 accounting engine with Inventory / Point of Sale

4. Release of Report Accounts [RA] version 1.2 accounting engine

5. Release of Report Accounts [RA] version 1.2 accounting engine with Inventory / Point of Sale

6. OLAP for accounting reports

7. Any recommendtions for time share accounting/reporting for SQL Server

8. simple accounting report program?

9. Accounting report systems for Delphi

10. OLAP for accounting reports

11. Abstract design of Report Accounts [RA] in Business Object Notation [BON]

12. Reports, reports, reports, reports.....REPORTS!


 
Powered by phpBB® Forum Software