Determining the week of the year

Yahoo Archive
1
Martin,
This works perfectly. It is exactly what I was trying for. Thank you so
much.

>IIF((Date_rb - DATE("01/01/00")) Modulo 7 = 0,((Date_rb -
>DATE("01/01/00")) / 7),(TRUNCATE((Date_rb - DATE("01/01/00")) / 7,0) + 1))

>Martin Nijdam (Jr. Ing.)
>Suss Woodcraft Int'l
>(514) 363-3565


Shirley H. Graver
Systems Administrator
Rubber Associates Inc. (Certified to QS9000/ISO9002)
Cleveland/Akron, Ohio




[Non-text portions of this message have been removed]
2
Hello Everyone,

We are having a problem in payroll regarding payroll accruals from one month
to the next. Does anyone perform this using manual entries or is it just
ignored? I do not believe Vantage performs this 100%. Someone once
responded to a similar question that they mimic the payroll for the
remaining days of the month then print reports, remove payroll group and use
figures to create manual journal entries. Using this method which figures
should be used since some of Vantage's labor is posted when timecards are
entered. Could someone please advise??


Thanks

Darren Mann
Miller Products Co.
3
I am attempting to determine the WEEK of the year from a date input.
(January 4th occurs on week 1 of the year, December 28th occurs in the 52nd
week of the year). We are on 3.0. I haven't found a Progress function for
this. Has anyone come up with an algorithm that will calculate this number.

Shirley H. Graver
Systems Administrator
Rubber Associates Inc. (Certified to QS9000/ISO9002)
Cleveland/Akron, Ohio




[Non-text portions of this message have been removed]
4
I write accruals at month end. Since we pay folks on a weekly basis on
Fridays, I sometimes end up with a partial week and a full week to accrue.
I do use the actual week's payroll figures to accrue payroll and the
applicable % of the partial week. It is easy and accurate. Works for us.
Since we run the actual week's payroll while I am still working on the
month's financial statements, I do not worry about deleting groups and just
use the actual information.

I do not see Vantage as having any problems in handling this. Some
situations just demand to be made through the General Journal with manual
entries. I view a payroll accrual as one of them. IF all employees were on
a salary and IF all months were 28 days, then a recurring entry would work
great. But.......reality is as it is.

Have I addressed your concern or am I skirting the issue?

Deb
Reeder & Kline Machine Co., Inc.


-----Original Message-----
From: Darren Mann [mailto:dmann@...]
Sent: Wednesday, October 11, 2000 7:47 AM
To: Vantage User Group (E-mail)
Subject: [Vantage] Payroll Accruals - Does anyone do them monthly?


Hello Everyone,

We are having a problem in payroll regarding payroll accruals from one month
to the next. Does anyone perform this using manual entries or is it just
ignored? I do not believe Vantage performs this 100%. Someone once
responded to a similar question that they mimic the payroll for the
remaining days of the month then print reports, remove payroll group and use
figures to create manual journal entries. Using this method which figures
should be used since some of Vantage's labor is posted when timecards are
entered. Could someone please advise??


Thanks

Darren Mann
Miller Products Co.


We no longer allow attachments to files. To access/share Report Files,
please go to the following link: http://www.egroups.com/files/vantage/
(Note: If this link does not work for you the first time you try it, go to
www.egroups.com, login and be sure to save your password, choose My Groups,
choose Vantage, then choose Files. If you save the password, the link above
will work the next time you try it.)


[Non-text portions of this message have been removed]
5
Shirley,

If you are using Crystal Reports, there is an UFL add-in for v7 that
is available on their web site that does this. I believe that this is
built into Crystal v8. Be warned, however, that it calculates that
week start date on Sunday rather that ISO required Monday. v8 also
has a work around for this.

• Rob McFarlin, Controller
• Accel Group, Inc.
325 Quadral Dr.
Wadsworth, OH 44281
• (330)336-0317 x14
• FAX(330)336-1224
• RobM@...
6
Week(DATE) is a function in report Builder that returns an interger for the
week number.

Martin Nijdam (Jr. Ing.)
Suss Woodcraft Int'l
(514) 363-3565

> -----Original Message-----
> From: Shirley Graver [SMTP:shirleyg@...]
> Sent: Wednesday, October 11, 2000 9:17 AM
> To: vantage@egroups.com
> Subject: [Vantage] DETERMINING THE WEEK OF THE YEAR
>
> I am attempting to determine the WEEK of the year from a date input.
> (January 4th occurs on week 1 of the year, December 28th occurs in the
> 52nd
> week of the year). We are on 3.0. I haven't found a Progress function
> for
> this. Has anyone come up with an algorithm that will calculate this
> number.
>
> Shirley H. Graver
> Systems Administrator
> Rubber Associates Inc. (Certified to QS9000/ISO9002)
> Cleveland/Akron, Ohio
>
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> We no longer allow attachments to files. To access/share Report Files,
> please go to the following link: http://www.egroups.com/files/vantage/
> (Note: If this link does not work for you the first time you try it, go
> to www.egroups.com, login and be sure to save your password, choose My
> Groups, choose Vantage, then choose Files. If you save the password, the
> link above will work the next time you try it.)
7
Thanks Deb for the response,

> Have I addressed your concern or am I skirting the issue?
Not in the least....

BUT could you give me more details on the actual process you go through,
what reports to use, and any other 'gotchas' we should be aware of. PLEASE,
PLEASE, Please...

Take Care,

Darren Mann


> -----Original Message-----
> From: Wilmoth, Deb [mailto:Deb@...]
> Sent: Wednesday, October 11, 2000 8:37 AM
> To: 'vantage@egroups.com'
> Subject: RE: [Vantage] Payroll Accruals - Does anyone do them monthly?
>
>
> I write accruals at month end. Since we pay folks on a
> weekly basis on
> Fridays, I sometimes end up with a partial week and a full
> week to accrue.
> I do use the actual week's payroll figures to accrue payroll and the
> applicable % of the partial week. It is easy and accurate.
> Works for us.
> Since we run the actual week's payroll while I am still working on the
> month's financial statements, I do not worry about deleting
> groups and just
> use the actual information.
>
> I do not see Vantage as having any problems in handling this. Some
> situations just demand to be made through the General Journal
> with manual
> entries. I view a payroll accrual as one of them. IF all
> employees were on
> a salary and IF all months were 28 days, then a recurring
> entry would work
> great. But.......reality is as it is.
>
>
> Deb
> Reeder & Kline Machine Co., Inc.
>
8
You must be on a later version of progress than I (8.3b) mine doesnt
recognize such a function. (sigh) almost perfect.

Shirley H. Graver
Systems Administrator
Rubber Associates Inc. (Certified to QS9000/ISO9002)
Cleveland/Akron, Ohio



Week(DATE) is a function in report Builder that returns an interger for
the
week number.

Martin Nijdam (Jr. Ing.)



[Non-text portions of this message have been removed]
9
BUT could you give me more details on the actual process you go through,
what reports to use, and any other 'gotchas' we should be aware of. PLEASE,
PLEASE, Please...

Take Care,

Darren Mann

Details:
By marking the journal entry for Reversal, I save myself lots of work. To
record the entry, I gather the information as follows:

After the weekly payroll has been run and the Check Register Report has been
printed, I use the G/L Recap at the bottom of the Check Register Report to
record the accrual entry. The G/L listings for all wage categories,
overtime wages, shift premiums, are included. I know I've correctly
recorded my wage expenses (we have several depts. and hence over 30 G/L #s)
when the accrual balances to the Current Earnings Total for the under the
report total. (Payroll taxes and deductions are not part of the gross wages
that need to be accrued, vacation wages and sick pay would be.)

If I need to record a partial week, I use an Excel spreadsheet to record
these values and then use the applicable % of the week that needs to be
accrued. While we often work on Saturday and sometimes on Sunday too, I
just use 20, 40, 60, or 80% depending on whether there is one, two, three,
or four days of the month that need to be accrued.

I hope that this helps. Please feel free to call me for any clarification
needed.

Deb
Controller
Reeder & Kline Machine Co., Inc.
(317) 846-6591



> -----Original Message-----
> From: Wilmoth, Deb [mailto:Deb@...]
> Sent: Wednesday, October 11, 2000 8:37 AM
>
> I write accruals at month end. Since we pay folks on a
> weekly basis on
> Fridays, I sometimes end up with a partial week and a full
> week to accrue.
> I do use the actual week's payroll figures to accrue payroll and the
> applicable % of the partial week. It is easy and accurate.
> Works for us.
> Since we run the actual week's payroll while I am still working on the
> month's financial statements, I do not worry about deleting
> groups and just
> use the actual information.
>
>
>
> Deb
> Reeder & Kline Machine Co., Inc.
>



[Non-text portions of this message have been removed]
10
The syntax week(date) in Progress will return an integer equating to the
week of the year.

Keith E. Taylor
Vice President
LBSi
Business Systems Consultants (Progress based ERP packages)
216/476-1416 ext 26
keith@...
11
Shirley,

Sorry, you are right, that function does not exist. It comes back to me
now... This is the function I used in one of my reports to find the current
week in the year.

IIF((Date_rb - DATE("01/01/00")) Modulo 7 = 0,((Date_rb -
DATE("01/01/00")) / 7),(TRUNCATE((Date_rb - DATE("01/01/00")) / 7,0) + 1))

Martin Nijdam (Jr. Ing.)
Suss Woodcraft Int'l
(514) 363-3565

> -----Original Message-----
> From: Shirley Graver [SMTP:shirleyg@...]
> Sent: Wednesday, October 11, 2000 10:51 AM
> To: vantage@egroups.com
> Subject: RE: [Vantage] DETERMINING THE WEEK OF THE YEAR
>
> You must be on a later version of progress than I (8.3b) mine doesnt
> recognize such a function. (sigh) almost perfect.
>
> Shirley H. Graver
> Systems Administrator
> Rubber Associates Inc. (Certified to QS9000/ISO9002)
> Cleveland/Akron, Ohio
>
>
>
> Week(DATE) is a function in report Builder that returns an interger for
> the
> week number.
>
> Martin Nijdam (Jr. Ing.)
>