SH82008 fixed this for us in case anyone is interested
-----Original Message-----
From: mapics-l-bounces@xxxxxxxxxxxx
[mailto:mapics-l-bounces@xxxxxxxxxxxx]On Behalf Of Josh Diggs
Sent: Tuesday, June 19, 2007 8:48 AM
To: MAPICS ERP System Discussion
Subject: Re: [MAPICS-L] MAPICS-L Digest, Vol 5, Issue 126
Just a quick update. This procedure still did not work so I called support and got an apar. Apar 82008 should allow you to do this for the Customer object once it is closed.
-----Original Message-----
From: mapics-l-bounces@xxxxxxxxxxxx
[mailto:mapics-l-bounces@xxxxxxxxxxxx]On Behalf Of Josh Diggs
Sent: Wednesday, June 13, 2007 11:14 AM
To: MAPICS ERP System Discussion
Subject: Re: [MAPICS-L] MAPICS-L Digest, Vol 5, Issue 126
First, I was being stupid and just solved this myself by updating the maintenance class for customer to allow system assigned keys, and then applying a number format to the system assigned key syntax. I tricked myself into thinking the controls on the maintenance tab were all disabled. Oops.
Second, I think the observation that James made is correct about intelligent next records in relation to key values. The only way I can think of to do this that I have not ruled out is by placing a query defaults button on the create template, but I'm not even sure if this can be done, or if it would work an a key value.
Third, we are not publicly held so the SARBOX auditors will have to wait until someone wants to buy us before they have a say. Although I am fascinated by the fact that they do not like system assigned numbers.
Thanks for your responses.
Josh
-----Original Message-----
From: mapics-l-bounces@xxxxxxxxxxxx
[mailto:mapics-l-bounces@xxxxxxxxxxxx]On Behalf Of
DaleGindlesperger@xxxxxxxxxxx
Sent: Wednesday, June 13, 2007 6:37 AM
To: MAPICS ERP System Discussion
Subject: Re: [MAPICS-L] MAPICS-L Digest, Vol 5, Issue 126
Unless I misunderstood, they are asking for MAPICS to assign new customer
numbers and/or vendor numbers. My SARBOX auditor strictly restricts who is
permitted to create customer and vendor numbers.
BTW - I do agree with the sequential numbering thing....
Dale Gindlesperger
IT Manager/Special Projects Leader
Fleetwood Folding Trailers, Inc.
258 Beacon Street
Somerset, PA 15501
LeLeux@xxxxxxxxxx
om
Sent by: To
mapics-l-bounces@ MAPICS ERP System Discussion
midrange.com <mapics-l@xxxxxxxxxxxx>
cc
06/13/2007 09:15 Subject
AM Re: [MAPICS-L] MAPICS-L Digest, Vol
5, Issue 126
Please respond to
MAPICS ERP System
Discussion
<mapics-l@midrang
e.com>
I think Josh pointed out a general deficiency in Integrator: auto
increment.
We've created a number of database solutions in Browser/Integrator that
replace all kinds of subsystems - and they work great for the legacy
aspect.
But then the user wants to create a new record and there is no mechanism
to support the creation of an intelligent next record. It would be nice
to
see a rules base engine that could be invoked similar to how PDM's work.
Dale, why would SOX care how the next record is generated, it's still
under the auspices of the respective control and only accessible by
the person who has the authority. Where SOX expect a paper log or
independent lookup, then a manual entry into the empty field?
Or did I miss something?
-----mapics-l-bounces+leleux=shur-lok.com@xxxxxxxxxxxx wrote: -----
To: MAPICS ERP System Discussion <mapics-l@xxxxxxxxxxxx>
From: DaleGindlesperger@xxxxxxxxxxx
Sent by: mapics-l-bounces+leleux=shur-lok.com@xxxxxxxxxxxx
Date: 06/13/2007 05:39AM
Subject: Re: [MAPICS-L] MAPICS-L Digest, Vol 5, Issue 126
My SARBOX auditor would KILL me! Question: Why do you want MAPICS
to
automatically assign Customer Numbers? Would a generic customer#
work?
Dale Gindlesperger
IT Manager/Special Projects Leader
Fleetwood Folding Trailers, Inc.
258 Beacon Street
Somerset, PA 15501
thuddleston@teled
yne.com
Sent by:
To
mapics-l-bounces@ mapics-l@xxxxxxxxxxxx
midrange.com
cc
Subject
06/12/2007 01:16 Re: [MAPICS-L] MAPICS-L Digest,
Vol
PM 5, Issue 126
Please respond to
MAPICS ERP System
Discussion
<mapics-l@midrang
e.com>
Haw about the Vendor number also?
Terry Huddleston
-----Original Message-----
From: mapics-l-bounces@xxxxxxxxxxxx
[mailto:mapics-l-bounces@xxxxxxxxxxxx]
On Behalf Of mapics-l-request@xxxxxxxxxxxx
Sent: Tuesday, June 12, 2007 12:00 PM
To: mapics-l@xxxxxxxxxxxx
Subject: MAPICS-L Digest, Vol 5, Issue 126
Send MAPICS-L mailing list submissions to
mapics-l@xxxxxxxxxxxx
To subscribe or unsubscribe via the World Wide Web, visit
http://lists.midrange.com/mailman/listinfo/mapics-l
or, via email, send a message with subject or body 'help' to
mapics-l-request@xxxxxxxxxxxx
You can reach the person managing the list at
mapics-l-owner@xxxxxxxxxxxx
When replying, please edit your Subject line so it is more specific
than "Re: Contents of MAPICS-L digest..."
Today's Topics:
1. System assigned customer number in CSM (Josh Diggs)
----------------------------------------------------------------------
message: 1
date: Tue, 12 Jun 2007 08:30:30 -0700
from: "Josh Diggs" <JDiggs@xxxxxxxxxxxx>
subject: [MAPICS-L] System assigned customer number in CSM
Hello group,
Has anyone figured out a way to convince XA to provide an
auto-generated
customer number when creating customers through CSM? I can write a
user
exit program for this if necessary, but I'm hoping to use a built-in
method if possible.
Thanks,
Josh
------------------------------
_______________________________________________
This is the MAPICS ERP System Discussion (MAPICS-L) digest 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.
End of MAPICS-L Digest, Vol 5, Issue 126
****************************************
_______________________________________________
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.
midrange.com
