Re: salesrep zero -- MAPICS-L

Not yet...trying your suggestions first as I want to get this done...then I'll report it.

Thanks!

Charley Simpson
Director of Operations
Turbonetics Inc.
Phone:805-581-0333
Direct:805-426-3410
Fax: 805-581-2640
www.TurboneticsInc.com
www.eTurbochargers.com

________________________________

The information in this email is confidential and may be legally privileged. It is intended solely for the addressee. Access to this email by anyone else is unauthorized. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. If you are not the intended addressee please contact the sender and dispose of this e-mail.

-----Original Message-----
From: mapics-l-bounces@xxxxxxxxxxxx [mailto:mapics-l-bounces@xxxxxxxxxxxx] On Behalf Of Tom E Stieger
Sent: Wednesday, September 17, 2008 7:51 AM
To: mapics-l@xxxxxxxxxxxx
Subject: Re: [MAPICS-L] salesrep zero

I can't create a 0 sales rep in R7 CSM either. When I try I get "(E) Sales rep number required AXP0141"

Did you contact support yet?

-Tom Stieger
Engineer
California Fine Wire
805-489-5144 x235

-----Original Message-----
From: mapics-l-bounces@xxxxxxxxxxxx
[mailto:mapics-l-bounces@xxxxxxxxxxxx]On Behalf Of Charley Simpson
Sent: Wednesday, September 17, 2008 7:33 AM
To: MAPICS ERP System Discussion
Subject: Re: [MAPICS-L] salesrep zero

Adding a salesrep appears to be green screen only...or maybe ewp (but I hate that). I tried to create a salesrep with 0 and 00 and 00000 and it refuses to let me do it.

Charley Simpson
Director of Operations
Turbonetics Inc.
Phone:805-581-0333
Direct:805-426-3410
Fax: 805-581-2640
www.TurboneticsInc.com
www.eTurbochargers.com

________________________________

The information in this email is confidential and may be legally privileged. It is intended solely for the addressee. Access to this email by anyone else is unauthorized. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. If you are not the intended addressee please contact the sender and dispose of this e-mail.

-----Original Message-----
From: mapics-l-bounces@xxxxxxxxxxxx [mailto:mapics-l-bounces@xxxxxxxxxxxx] On Behalf Of Thomas, Lisa (Hayssen)
Sent: Wednesday, September 17, 2008 5:25 AM
To: MAPICS ERP System Discussion
Subject: Re: [MAPICS-L] salesrep zero

I would think you could add the sales rep 0 without any issues.

-----Original Message-----
From: mapics-l-bounces@xxxxxxxxxxxx
[mailto:mapics-l-bounces@xxxxxxxxxxxx] On Behalf Of Charley Simpson
Sent: Tuesday, September 16, 2008 6:16 PM
To: MAPICS-L@xxxxxxxxxxxx
Subject: [MAPICS-L] salesrep zero

R6 CSM Integrator

I've run into a little snag with a view in Shipped Items.

Seems when you use the Salesrep Name (afa1tx relationship to sales rep
file) and the shipped item line has a sales rep equal to zero (default from COM) it will not display the record...but oddly enough it will still include the net sales in the total (if you are totaling the column). The export only pushes the records displayed...

Anyway, since salesrep zero does not exist in the sales rep table (and I can't get it to let me create it) I am in a bit of a quandary. I need to solve the problem because I want both rep number and rep name so users can push this stuff to excel and not have to do a vlookup to cobble in the name. Without going into a long explanation, can I do one of the following:

- either force create a salesrep zero with a appropriate name (and probably blow things up)
- create a sales rep 999 and then mass replace the rep number in the shipped item table (and cause a ton more problems because of all the other tables storing the sales rep number that will no longer match)

unless, of course, someone has a much more elegant solution...

Thanks!

Charley Simpson
Turbonetics

_______________________________________________
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list To post a message email: MAPICS-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at http://archive.midrange.com/mapics-l.

_______________________________________________
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list To post a message email: MAPICS-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at http://archive.midrange.com/mapics-l.

_______________________________________________
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list To post a message email: MAPICS-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at http://archive.midrange.com/mapics-l.

_______________________________________________
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list To post a message email: MAPICS-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at http://archive.midrange.com/mapics-l.