Re: MAPICS-L Digest, Vol 9, Issue 86
"Iain Wilson" <[email protected]>
| Newsgroups | gmane.comp.systems.as400.mapics |
|---|---|
| Message-ID | <[email protected]> |
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-Zwy7GipZuJhWk0Htik3J/[email protected] [mailto:mapics-l-bounces-Zwy7GipZuJhWk0Htik3J/[email protected]] On Behalf Of mapics-l-request-Zwy7GipZuJhWk0Htik3J/[email protected] Sent: 30 June 2011 16:54 To: mapics-l-Zwy7GipZuJhWk0Htik3J/[email protected] Subject: MAPICS-L Digest, Vol 9, Issue 86 Send MAPICS-L mailing list submissions to mapics-l-Zwy7GipZuJhWk0Htik3J/[email protected] 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-Zwy7GipZuJhWk0Htik3J/[email protected] You can reach the person managing the list at mapics-l-owner-Zwy7GipZuJhWk0Htik3J/[email protected] 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 ([email protected]) 2. Re: Offline Orders Process (Thompson, Ricky) 3. Re: Offline Orders Process (Wyatt, Chris (FGWA-IL)) 4. Re: Offline Orders ProcessABAWXFR (DGowen-KH87JHHfSKradGDVLbOUCQC/[email protected]) 5. Transaction times periodically increase (Mike Tribbe) 6. Re: Transaction times periodically increase (Wyatt, Chris (FGWA-IL)) 7. Re: Transaction times periodically increase ([email protected]) ---------------------------------------------------------------------- message: 1 date: Wed, 29 Jun 2011 09:26:00 -0700 from: [email protected] 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-Zwy7GipZuJhWk0Htik3J/[email protected] > To subscribe, unsubscribe, or change list options, > visit: http://lists.midrange.com/mailman/listinfo/mapics-l > or email: MAPICS-L-request-Zwy7GipZuJhWk0Htik3J/[email protected] > 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" <[email protected]> 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" <[email protected]> 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: [email protected] 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)" <[email protected]> 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-Zwy7GipZuJhWk0Htik3J/[email protected] [mailto:mapics-l-bounces-Zwy7GipZuJhWk0Htik3J/[email protected]] On Behalf Of Thompson, Ricky Sent: Wednesday, June 29, 2011 3:16 PM To: mapics-l-Zwy7GipZuJhWk0Htik3J/[email protected] 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" <[email protected]> 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: [email protected] 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-Zwy7GipZuJhWk0Htik3J/[email protected] To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/mapics-l or email: MAPICS-L-request-Zwy7GipZuJhWk0Htik3J/[email protected] 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-KH87JHHfSKradGDVLbOUCQC/[email protected] 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" <[email protected]> To: "mapics-l-Zwy7GipZuJhWk0Htik3J/[email protected]" <mapics-l-Zwy7GipZuJhWk0Htik3J/[email protected]> Date: 06/29/2011 08:18 AM Subject: [MAPICS-L] Offline Orders Process Sent by: mapics-l-bounces-Zwy7GipZuJhWk0Htik3J/[email protected] 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-Zwy7GipZuJhWk0Htik3J/[email protected] To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/mapics-l or email: MAPICS-L-request-Zwy7GipZuJhWk0Htik3J/[email protected] 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" <[email protected]> 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)" <[email protected]> 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-Zwy7GipZuJhWk0Htik3J/[email protected] [mailto:mapics-l-bounces-Zwy7GipZuJhWk0Htik3J/[email protected]] On Behalf Of Mike Tribbe Sent: Thursday, June 30, 2011 9:13 AM To: MAPICS-L-Zwy7GipZuJhWk0Htik3J/[email protected] 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-Zwy7GipZuJhWk0Htik3J/[email protected] To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/mapics-l or email: MAPICS-L-request-Zwy7GipZuJhWk0Htik3J/[email protected] 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: [email protected] 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 [email protected] From: "Mike Tribbe" <[email protected]> To: <MAPICS-L-Zwy7GipZuJhWk0Htik3J/[email protected]> Date: 06/30/2011 10:15 AM Subject: [MAPICS-L] Transaction times periodically increase Sent by: mapics-l-bounces-Zwy7GipZuJhWk0Htik3J/[email protected] 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-Zwy7GipZuJhWk0Htik3J/[email protected] To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/mapics-l or email: MAPICS-L-request-Zwy7GipZuJhWk0Htik3J/[email protected] 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-Zwy7GipZuJhWk0Htik3J/[email protected] To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/mapics-l or email: MAPICS-L-request-Zwy7GipZuJhWk0Htik3J/[email protected] 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 _______________________________________________ This is the MAPICS ERP System Discussion (MAPICS-L) mailing list To post a message email: MAPICS-L-Zwy7GipZuJhWk0Htik3J/[email protected] To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/mapics-l or email: MAPICS-L-request-Zwy7GipZuJhWk0Htik3J/[email protected] Before posting, please take a moment to review the archives at http://archive.midrange.com/mapics-l.