Sounds like a bug. I found the same problem exists in R7 at client 40.87.
It looks like it is excluding the record from the view if the sales rep name is null.
One suggestion (if you don't want to wait for support) is to recreate the relationship to sales rep from shipped items and see if the sales rep name shows <null> with this new relatioship. Furthermore, you could create a new business object over the sales rep file and relate to that.
Again, this looks like a bug that Infor should fix!
-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: Tuesday, September 16, 2008 3: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.
midrange.com
