Hi Marc
The next transaction number is in data area
RTVDTAARA DTAARA(*LIBL/ZNXTRN) RTNVAR(&TRNO)
CHGVAR VAR(&TRNO) VALUE(&TRNO + 1)
CHGDTAARA DTAARA(*LIBL/ZNXTRN) VALUE(&TRNO)
Can't remember where I found this code for the queue
C EXSR SNDDQ
C Return
C SNDDQ BEGSR
*
C CALL 'QSNDDTAQ' PDQJUC
C MOVE '1' *INLR
*
C ENDSR
C PDQJUC PLIST
C PARM 'DQJUC' QNAME# 10
C PARM '*LIBL' QLIBR# 10
C PARM 1 QFLDL# 5 0
C PARM '1' QFIEL# 1
Regards
Iain
-----Original Message-----
From: mapics-l-bounces@xxxxxxxxxxxx [mailto:mapics-l-bounces@xxxxxxxxxxxx]
On Behalf Of mapics-l-request@xxxxxxxxxxxx
Sent: 30 June 2011 16:54
To: mapics-l@xxxxxxxxxxxx
Subject: MAPICS-L Digest, Vol 9, Issue 86
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. Re: Posting Inventory Transactions via ODBC (gogo400@xxxxxxxxx)
2. Re: Offline Orders Process (Thompson, Ricky)
3. Re: Offline Orders Process (Wyatt, Chris (FGWA-IL))
4. Re: Offline Orders ProcessABAWXFR (DGowen@xxxxxxxxxxxxxxxxx)
5. Transaction times periodically increase (Mike Tribbe)
6. Re: Transaction times periodically increase
(Wyatt, Chris (FGWA-IL))
7. Re: Transaction times periodically increase
(Nick_Radich@xxxxxxxxxxxxxx)
----------------------------------------------------------------------
message: 1
date: Wed, 29 Jun 2011 09:26:00 -0700
from: gogo400@xxxxxxxxx
subject: Re: [MAPICS-L] Posting Inventory Transactions via ODBC
TRDATA is the place. The the PM&C UJOB will pick it up automatically,
validate and process (or not).
We are planning to perform inventory transactions from an offline process
and would like to do so near real time with ODBC. If I recall you can do
this posting to TRDATA but wanted to confirm that this is the proper place
and if not get some direction regarding were we should post the data to be
processed.
Marc Rohde
_______________________________________________
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.
------------------------------
message: 2
date: Wed, 29 Jun 2011 16:15:42 -0400
from: "Thompson, Ricky" <rthompson@xxxxxxxxxxxxxxx>
subject: Re: [MAPICS-L] Offline Orders Process
Is there a list of what breaks down the second parameter? Thanks.
message: 1
date: Wed, 29 Jun 2011 15:44:28 +0200
from: "Michael J. Raber" <mail@xxxxxxxxxx>
subject: Re: [MAPICS-L] Offline Orders Process
Hi,
you can use order origin MBC6REP.C6AD0W. Populate this field with a char
(e.g. X)
and then process with:
CALL PGM(AMBE8XFR) PARM(' ' '00X000000000000')
The third char in the second parameter controls which records are
processed.
We are using this in Release 6 and Release 7 and it works since many years.
Best regards from Germany
Michael Raber
-------------------------------------------------------
Dipl.-Ing. Michael J. Raber
Consulting - Projectmanagement - Software-Engineering
Villar-Perosa-Stra?e 10
75038 Oberderdingen
Tel: +49 7045 2006880
Fax: +49 7045 2006881
Mobil: +49 1520 8523330
eMail: mail@xxxxxxxxxx
Web: www.mjraber.de
Skype: mjraber
This e-mail transmission may contain confidential or legally privileged
information that is intended only for the individual(s) or entity(ies) named
in the e-mail address. If you are not the intended recipient or an agent
responsible for delivering it to the intended recipient, you are hereby
notified that any disclosure, copying, distribution, or reliance upon the
contents of this e-mail is strictly prohibited. If you have received this
e-mail transmission in error, please notify the sender immediately, so that
Endo can arrange for proper delivery, and then please delete the message
from your system. Thank you.
<Virus Scanned by Microsoft ForeFront Online Security>
------------------------------
message: 3
date: Wed, 29 Jun 2011 14:14:28 -0700
from: "Wyatt, Chris (FGWA-IL)" <Chris.Wyatt@xxxxxxxx>
subject: Re: [MAPICS-L] Offline Orders Process
Here's the breakdown of the 2nd parm (Release 6)
Position 1-1 = Error listing only 1=yes 0=no
Position 2-2 = Purge error records? 1=yes 0=no
Position 3-3 = Order origin
Position 4-14 = Transaction group (the token number)
Positino 15-15 = Print pick list 1=yes 0=no
Make sure you test this, in case I'm wrong. :)
-----Original Message-----
From: mapics-l-bounces@xxxxxxxxxxxx [mailto:mapics-l-bounces@xxxxxxxxxxxx]
On Behalf Of Thompson, Ricky
Sent: Wednesday, June 29, 2011 3:16 PM
To: mapics-l@xxxxxxxxxxxx
Subject: Re: [MAPICS-L] Offline Orders Process
Is there a list of what breaks down the second parameter? Thanks.
message: 1
date: Wed, 29 Jun 2011 15:44:28 +0200
from: "Michael J. Raber" <mail@xxxxxxxxxx>
subject: Re: [MAPICS-L] Offline Orders Process
Hi,
you can use order origin MBC6REP.C6AD0W. Populate this field with a char
(e.g. X)
and then process with:
CALL PGM(AMBE8XFR) PARM(' ' '00X000000000000')
The third char in the second parameter controls which records are processed.
We are using this in Release 6 and Release 7 and it works since many years.
Best regards from Germany
Michael Raber
-------------------------------------------------------
Dipl.-Ing. Michael J. Raber
Consulting - Projectmanagement - Software-Engineering
Villar-Perosa-Stra?e 10
75038 Oberderdingen
Tel: +49 7045 2006880
Fax: +49 7045 2006881
Mobil: +49 1520 8523330
eMail: mail@xxxxxxxxxx
Web: www.mjraber.de
Skype: mjraber
This e-mail transmission may contain confidential or legally privileged
information that is intended only for the individual(s) or entity(ies) named
in the e-mail address. If you are not the intended recipient or an agent
responsible for delivering it to the intended recipient, you are hereby
notified that any disclosure, copying, distribution, or reliance upon the
contents of this e-mail is strictly prohibited. If you have received this
e-mail transmission in error, please notify the sender immediately, so that
Endo can arrange for proper delivery, and then please delete the message
from your system. Thank you.
<Virus Scanned by Microsoft ForeFront Online Security>
_______________________________________________
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.
------------------------------
message: 4
date: Wed, 29 Jun 2011 19:30:45 -0500
from: DGowen@xxxxxxxxxxxxxxxxx
subject: Re: [MAPICS-L] Offline Orders ProcessABAWXFR
Ricky,
Below is an example of calling the program with one group# (order#).
Hopefully this will help.
fOSAARES0 uf a e k Disk
// off line header file
fOSABCPS0 uf a e k disk
// off line detail file
fOSACCPS0 uf a e k disk
// off line location
// ------------------------------------- ship program
D MapShip PR ExtPgm('ABAWXFR')
D Var1 7
D Var2 1
D Var3 10
//--------------------------------------------------------
D GrpNo S 10
D ShipNo S 7 inz('1')
D ShipSeq S 7 0 inz(0)
d Seven S 7 inz(' ')
We keep track of the group number in a file.
//-------------- get group# ---------------------------
Chain 'A' groupf;
GrpNo = '0000000000';
If %found(groupf);
gnumb += 1;
%subst(GrpNo:11- %len(%trim(%char(gnumb)))) = %char(gnumb)
update groupr;
endif;
//-------------- create header ------------------------
Clear FMXREAT;
MXNWCD = GrpNo; // Off-Ship Group ID
MXAJSS = '03'; // Off-Ship Type
MXNTCD = c6b9cd; // Off-Ship Number
MXAENB = CDAENB; // Company number
MXA3CD = CDA3CD; // Warehouse
MXDCCD = CDDCCD; // Internal header type
MXCVNB = CDCVNB; // Quote/order number
MXIVNB = %Dec(%Char(%Date(*Date):*CYMD0):7:0); //ship date
etc....................
fill in all other files per Mapics user guide. Then call.......
MapShip(Seven:UpdFlg:GrpNo:packit);
The group number you pass will be the one that is processed.
Regards,
From: "Thompson, Ricky" <rthompson@xxxxxxxxxxxxxxx>
To: "mapics-l@xxxxxxxxxxxx" <mapics-l@xxxxxxxxxxxx>
Date: 06/29/2011 08:18 AM
Subject: [MAPICS-L] Offline Orders Process
Sent by: mapics-l-bounces@xxxxxxxxxxxx
We are currently on release 6. But is there a way to only process one
offline order at a time? Can you pass it the token number that you want
to upload and only upload that one token?
Thanks
This e-mail transmission may contain confidential or legally privileged
information that is intended only for the individual(s) or entity(ies)
named in the e-mail address. If you are not the intended recipient or an
agent responsible for delivering it to the intended recipient, you are
hereby notified that any disclosure, copying, distribution, or reliance
upon the contents of this e-mail is strictly prohibited. If you have
received this e-mail transmission in error, please notify the sender
immediately, so that Endo can arrange for proper delivery, and then please
delete the message from your system. Thank you.
<Virus Scanned by Microsoft ForeFront Online Security>
_______________________________________________
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 message and any files transmitted with it contain privileged and
confidential information. This message is intended only for the use of the
individual or entity to whom it is addressed. If you are not the intended
recipient, or an employee or agent responsible for delivering this message
to the intended recipient, you are hereby notified that any disclosure,
dissemination, distribution, copying, or exploitation of, or taking any
action in reliance on the contents of this message is strictly prohibited.
If you have received this message in error, please notify the sender by
email reply and delete this message from your system. Thank you.
------------------------------
message: 5
date: Thu, 30 Jun 2011 10:13:17 -0400
from: "Mike Tribbe" <mtribbe@xxxxxxxxxxxxxxxxxx>
subject: [MAPICS-L] Transaction times periodically increase
We have users that periodically experience long delays in processing certain
transactions. For example, someone will change a date on a Purchase Order
and the screen will freeze for 3-4 minutes. The problem is intermittent
throughout the day and is not specific to any single transaction (even
though Purchasing complains the most). CPU usage during the delay never
appears high.
How do we troubleshoot to determine the cause (such as other programs that
may be conflicting)?
Mike Tribbe
Hydrosystems
------------------------------
message: 6
date: Thu, 30 Jun 2011 08:25:56 -0700
from: "Wyatt, Chris (FGWA-IL)" <Chris.Wyatt@xxxxxxxx>
subject: Re: [MAPICS-L] Transaction times periodically increase
I'm not completely sure I'll have an answer, but which interface are you
using? Green screen or Browser/PowerLink?
And what Release are you on?
Information on your network infrastructure might be helpful also.
cw
-----Original Message-----
From: mapics-l-bounces@xxxxxxxxxxxx [mailto:mapics-l-bounces@xxxxxxxxxxxx]
On Behalf Of Mike Tribbe
Sent: Thursday, June 30, 2011 9:13 AM
To: MAPICS-L@xxxxxxxxxxxx
Subject: [MAPICS-L] Transaction times periodically increase
We have users that periodically experience long delays in processing certain
transactions. For example, someone will change a date on a Purchase Order
and the screen will freeze for 3-4 minutes. The problem is intermittent
throughout the day and is not specific to any single transaction (even
though Purchasing complains the most). CPU usage during the delay never
appears high.
How do we troubleshoot to determine the cause (such as other programs that
may be conflicting)?
Mike Tribbe
Hydrosystems
_______________________________________________
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.
------------------------------
message: 7
date: Thu, 30 Jun 2011 10:37:54 -0500
from: Nick_Radich@xxxxxxxxxxxxxx
subject: Re: [MAPICS-L] Transaction times periodically increase
Hi Mike,
We see this periodically also. I have found that it is usually a lock on
a record from someone else. They get onto a screen and then walk away.
Check the QSYSOPR messages, there may be a message in there showing the
lock. Otherwise, I look at the Job Log of the job that is slow.
Thanx,
Nick
Nick Radich
Sr. Programmer/Analyst
EPC Molding, Inc.
Direct (320) 679-6683
Toll free (800) 388-2155 ext. 6683
Fax (320) 679-4516
nick_radich@xxxxxxxxxxxxxx
From: "Mike Tribbe" <mtribbe@xxxxxxxxxxxxxxxxxx>
To: <MAPICS-L@xxxxxxxxxxxx>
Date: 06/30/2011 10:15 AM
Subject: [MAPICS-L] Transaction times periodically increase
Sent by: mapics-l-bounces@xxxxxxxxxxxx
We have users that periodically experience long delays in processing
certain
transactions. For example, someone will change a date on a Purchase Order
and the screen will freeze for 3-4 minutes. The problem is intermittent
throughout the day and is not specific to any single transaction (even
though Purchasing complains the most). CPU usage during the delay never
appears high.
How do we troubleshoot to determine the cause (such as other programs that
may be conflicting)?
Mike Tribbe
Hydrosystems
_______________________________________________
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) 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 9, Issue 86
***************************************
This e-mail and any attachments contain material that is confidential for
the sole use of the intended recipient. Any review, reliance or distribution
by others or forwarding without express permission is strictly prohibited.
If you are not the intended recipient, please contact the sender and delete
all copies.
Tokheim UK LTD. Registered in Scotland No. 58090
Registered Office: Exchange Tower, 19 Canning Street, Edinburgh EH3 8EH
This e-mail and any attachments contain material that is confidential for the sole use of the intended recipient. Any review, reliance or distribution by others or forwarding without express permission is strictly prohibited. If you are not the intended recipient, please contact the sender and delete all copies.
Tokheim UK LTD. Registered in Scotland No. 58090
Registered Office: Exchange Tower, 19 Canning Street, Edinburgh EH3 8EH
midrange.com
