It's dirty, but it can be done. Here's the concept, it is a variation of
the autonumbering in R6 (triggers are handy things):
- create the business object, have the key auto assigned and numbered
- include in the file a field RENUM="renumbered" or any similar trick
- create a trigger which:
- does your logic and changes the key,
- only on those records which are not yet renumbered,
- and in the end updates the flag to 'Y'
- add your trigger "after insert" with ALWRPTCHG=*YES
Done
The dirty part is when you press enter, you see the record in the view
listed with its "temporarily" assigned number. You need to press F5 to get
the 'final' one. Being a trigger it is full proof. If other triggers are
present, then mind the sequence.
Good luck with the new function
Kris
-----Original Message-----
From: mapics-l-bounces@xxxxxxxxxxxx [
mailto:mapics-l-bounces@xxxxxxxxxxxx]
On Behalf Of Josh Diggs
Sent: donderdag 14 juni 2007 16:26
To: MAPICS ERP System Discussion
Subject: Re: [MAPICS-L] MAPICS-L Digest, Vol 5, Issue 126
I think what James and I are saying is that you can auto-increment
numerically, alphabetically, or in some combination thereof, but you can not
make the next number "intelligent". The distinction involves running custom
logic on a key field.
-----Original Message-----
From: mapics-l-bounces@xxxxxxxxxxxx
[
mailto:mapics-l-bounces@xxxxxxxxxxxx]On Behalf Of Kris De Vlieger
Sent: Thursday, June 14, 2007 7:12 AM
To: 'MAPICS ERP System Discussion'
Subject: Re: [MAPICS-L] MAPICS-L Digest, Vol 5, Issue 126
If you say auto increment is a lacking function in integrator, think again.
It is standard in Integrator R7 (now you have one more reason to upgrade to
R7). I have constructed a workaround in R6 if you are interested, but I
prefer the neat standard way. Both are of course for the user defined
business objects.
Kind regards,
Kris
-----Original Message-----
From: mapics-l-bounces@xxxxxxxxxxxx [
mailto:mapics-l-bounces@xxxxxxxxxxxx]
On Behalf Of LeLeux@xxxxxxxxxxxx
Sent: woensdag 13 juni 2007 15:15
To: MAPICS ERP System Discussion
Subject: Re: [MAPICS-L] MAPICS-L Digest, Vol 5, Issue 126
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
