Accruals....

[jepoysaipan]

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!

 

[gemma-the-husky]

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?

 

[jepoysaipan]

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.

 

[gemma-the-husky]

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

 

[jepoysaipan]

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