Labor Entries Blank Title 68618

We are on 6.1 and occasionally have the same problem. We have never
determined what combination of circumstance generates these entries.
I was unaware of the existence of the conversion program(s), so thanks for
the pointer.

It's probably of no comfort to Frances but previously the only way I could
find around the problem was to
1.Use ODBC to extract the faulty LaborHed and LaborDtl records
2.Reset the ActiveTrans field in both files
3.Use the Conversion Tool to update.

A bit messy but it works.....but obviously is dependant upon having the
Conversion Tool available!




[Non-text portions of this message have been removed]
We have an issue with labor entry. We are on Vantage 6.10.507 and do
not subscribe to the maintenance with Epicor. We have labor entries
that are blank, but we cannot edit or delete or end the activity. So
consequently, the employees cannot clock out. Any help would be greatly
appreciated.



Frances Skidmore

Entek Corporation

Norman, OK

Frances@...

Phone: 405-364-5588

Fax: 405-364-4727







[Non-text portions of this message have been removed]
Sorry, I forgot to mention that the labor entries are in production but
have not job numbers or sequence numbers, but we cannot edit, delete or
end the activity.



Frances Skidmore
Entek Corporation
Norman, OK
Frances@... <mailto:Frances%40entek.net>
Phone: 405-364-5588
Fax: 405-364-4727

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Frances Skidmore
Sent: Monday, September 08, 2008 2:27 PM
To: Vantage User Group
Subject: [Vantage] Labor Entries



We have an issue with labor entry. We are on Vantage 6.10.507 and do
not subscribe to the maintenance with Epicor. We have labor entries
that are blank, but we cannot edit or delete or end the activity. So
consequently, the employees cannot clock out. Any help would be greatly
appreciated.

Frances Skidmore

Entek Corporation

Norman, OK

Frances@... <mailto:Frances%40entek.net>

Phone: 405-364-5588

Fax: 405-364-4727

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





[Non-text portions of this message have been removed]
You need to use the endact.r function on the conversion program list under
system management.



Edward F. Fox, Jr., CPA

Controller

Maxson Automatic Machinery Company

Phone 401-596-0162 a Fax 401-596-1050

www.maxsonautomatic.com

_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Frances Skidmore
Sent: Monday, September 08, 2008 3:34 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Labor Entries



Sorry, I forgot to mention that the labor entries are in production but
have not job numbers or sequence numbers, but we cannot edit, delete or
end the activity.

Frances Skidmore
Entek Corporation
Norman, OK
Frances@entek. <mailto:Frances%40entek.net> net <mailto:Frances%40entek.net>

Phone: 405-364-5588
Fax: 405-364-4727

________________________________

From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf
Of Frances Skidmore
Sent: Monday, September 08, 2008 2:27 PM
To: Vantage User Group
Subject: [Vantage] Labor Entries

We have an issue with labor entry. We are on Vantage 6.10.507 and do
not subscribe to the maintenance with Epicor. We have labor entries
that are blank, but we cannot edit or delete or end the activity. So
consequently, the employees cannot clock out. Any help would be greatly
appreciated.

Frances Skidmore

Entek Corporation

Norman, OK

Frances@entek. <mailto:Frances%40entek.net> net <mailto:Frances%40entek.net>


Phone: 405-364-5588

Fax: 405-364-4727

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

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





[Non-text portions of this message have been removed]
THANKS MR. FOX, BUT WE DO NOT HAVE THAT CONVERSION PROGRAM. SO I AM
APPEALING TO THE GROUP AGAIN..... We are on Vantage 6.10.507. We have
labor entries that are blank, but we cannot edit or delete or end the
activity. So consequently, the employees cannot clock out. Any help
would be greatly appreciated. The labor entries are in production but
have no job numbers or sequence numbers, we cannot edit, delete or end
the activity.
MY GUYS CANNOT CLOCK OUT.



Frances

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Edward F. Fox, Jr.
Sent: Monday, September 08, 2008 2:38 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Labor Entries



You need to use the endact.r function on the conversion program list
under
system management.

Edward F. Fox, Jr., CPA

Controller

Maxson Automatic Machinery Company

Phone 401-596-0162 Fax 401-596-1050

www.maxsonautomatic.com






[Non-text portions of this message have been removed]
How are you viewing these 'blank' records? (ODBC SQL query? BAQ? A v6.1 program?)

Are they truly blank (no employee ID, no record creation date)?

Have you tried (on a COPY of your live db) simply deleting the blank records via odbc?

Rob Brown



--- On Mon, 9/8/08, Frances Skidmore <Frances@...> wrote:
From: Frances Skidmore <Frances@...>
Subject: RE: [Vantage] Labor Entries
To: vantage@yahoogroups.com
Date: Monday, September 8, 2008, 5:04 PM











THANKS MR. FOX, BUT WE DO NOT HAVE THAT CONVERSION PROGRAM. SO I AM

APPEALING TO THE GROUP AGAIN..... We are on Vantage 6.10.507. We have

labor entries that are blank, but we cannot edit or delete or end the

activity. So consequently, the employees cannot clock out. Any help

would be greatly appreciated. The labor entries are in production but

have no job numbers or sequence numbers, we cannot edit, delete or end

the activity.

MY GUYS CANNOT CLOCK OUT.



Frances



____________ _________ _________ __



From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On Behalf

Of Edward F. Fox, Jr.

Sent: Monday, September 08, 2008 2:38 PM

To: vantage@yahoogroups .com

Subject: RE: [Vantage] Labor Entries



You need to use the endact.r function on the conversion program list

under

system management.



Edward F. Fox, Jr., CPA



Controller



Maxson Automatic Machinery Company



Phone 401-596-0162 Fax 401-596-1050



www.maxsonautomatic .com



[Non-text portions of this message have been removed]
I fired 6.1 up last night and found that the end activity program was
included in 6.10.535.



I'm not sure what to tell you. I think support has you over a barrel on
this one.



Edward F. Fox, Jr., CPA

Controller

Maxson Automatic Machinery Company

Phone 401-596-0162 a Fax 401-596-1050

www.maxsonautomatic.com

_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Frances Skidmore
Sent: Monday, September 08, 2008 5:05 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Labor Entries



THANKS MR. FOX, BUT WE DO NOT HAVE THAT CONVERSION PROGRAM. SO I AM
APPEALING TO THE GROUP AGAIN..... We are on Vantage 6.10.507. We have
labor entries that are blank, but we cannot edit or delete or end the
activity. So consequently, the employees cannot clock out. Any help
would be greatly appreciated. The labor entries are in production but
have no job numbers or sequence numbers, we cannot edit, delete or end
the activity.
MY GUYS CANNOT CLOCK OUT.

Frances

________________________________

From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf
Of Edward F. Fox, Jr.
Sent: Monday, September 08, 2008 2:38 PM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Subject: RE: [Vantage] Labor Entries

You need to use the endact.r function on the conversion program list
under
system management.

Edward F. Fox, Jr., CPA

Controller

Maxson Automatic Machinery Company

Phone 401-596-0162 Fax 401-596-1050

www.maxsonautomatic.com

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





[Non-text portions of this message have been removed]
I believe I also have that conversion and we are on 6.10.540. In the
conversion list they are numbers 7428 and 7429. It does not say endact.r on
my listing.



Kathy Schaich
Operations Support Manager
Ultra Tool & Manufacturing, Inc.
W169 N5954 Ridgewood Drive
Menomonee Falls, WI 53051

Phone: 262-703-0455
Fax: 262-703-0468
Toll Free: 800-779-3566
kathy.schaich@...
www.ultratoolmfg.com

The information contained in this electronic message (email) and any
attachment(s) to it is/are intended for the exclusive use of the intended
addressee(s) and may contain information that is confidential and/or
privileged and exempt from disclosure under applicable law. If you are not
the intended recipient(s) and have received this communication in error,
please do not distribute it. Instead, please notify Ultra Tool &
Manufacturing, Inc. at 1-800-779-3566 or by email at
general@... and destroy all copies of this message and any
attachments. Thank you.


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Edward F. Fox, Jr.
Sent: September 09, 2008 7:08 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Labor Entries



I fired 6.1 up last night and found that the end activity program was
included in 6.10.535.

I'm not sure what to tell you. I think support has you over a barrel on
this one.

Edward F. Fox, Jr., CPA

Controller

Maxson Automatic Machinery Company

Phone 401-596-0162 a Fax 401-596-1050

www.maxsonautomatic.com

_____

From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf Of
Frances Skidmore
Sent: Monday, September 08, 2008 5:05 PM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Subject: RE: [Vantage] Labor Entries

THANKS MR. FOX, BUT WE DO NOT HAVE THAT CONVERSION PROGRAM. SO I AM
APPEALING TO THE GROUP AGAIN..... We are on Vantage 6.10.507. We have
labor entries that are blank, but we cannot edit or delete or end the
activity. So consequently, the employees cannot clock out. Any help
would be greatly appreciated. The labor entries are in production but
have no job numbers or sequence numbers, we cannot edit, delete or end
the activity.
MY GUYS CANNOT CLOCK OUT.

Frances

________________________________

From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf
Of Edward F. Fox, Jr.
Sent: Monday, September 08, 2008 2:38 PM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Subject: RE: [Vantage] Labor Entries

You need to use the endact.r function on the conversion program list
under
system management.

Edward F. Fox, Jr., CPA

Controller

Maxson Automatic Machinery Company

Phone 401-596-0162 Fax 401-596-1050

www.maxsonautomatic.com

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

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







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