Accruals....

jepoysaipan

Registered User.
Local time
Tomorrow, 07:44
Joined
Nov 4, 2007
Messages
133
Hi Guys,

I have a new project in the office for our HR, everything was on time until one day I was called for a meeting and asked to add 2 things:

1. A module to import files from our existing Accounting Program (Peachtree).
2. A module to calculate Accruals (Sick & Vacation leave).

The first one I was able to pull-out some insights on how to import data from PT to Access, but haven't tried yet, Now for the second one I was totally lost, tried to talk to the guys who handles the leaves of every employee but couldn't get a clear picture.

So I decided to post this one hoping that somebody could shed a light on how this "Accruals" things work, A theory will help a lot but a sample DB is much appreciated.

Thanks a lot guys!
 
1.
either
a) probably an ODBC connection provided by peachtree to read files directly
or
b) generate spreadsheets/csvs from peachtree and import those

2. do you mean
what are accruals? or
how do you implement them?
 
Hi Gemma,

Thanks for the reply.

I think I will stick to option b .csv since I am used to try importing .csv's on my previous DB's.

Now for the accruals, same questions I asked the guy who handles employees leave, but still lost at the moment.

Is there someone who makes an HR DB that has the Accruals module on it?

Pls. help.
 
i see what you mean wrt accruals

isnt this a starightforward query for you

ie

accrued leave =
(annual leave entitilement * proportion of year passed) - (leave taken to date)

you may have special rules for determining the first 2 bits of this, but it wont be hard surely
 
Hi Gemma,

Thanks a lot!

After days of searching the net I gain some knowledge of it plus your input, now I have to convert the theory into an application.

Hope you can reply with an example of it, thanking you in advance.

Jeff
 

Users who are viewing this thread

Back
Top Bottom