|
Thanks to Greg for completing this string of the discussion. The export/import we have been discussing of a Jacana created IWP report is utilized to "move" a report from one system to another. The subset on which the subject report is built contains customized files created with additional Jacana created IWP reports. Because of this, moving the report to another system would not be meaningful due to the company specific nature of the customized files. As Greg mentioned, if you have a need for this type of report building, I would be glad to talk to you offline at davidakemp@xxxxxxxxxxxxxx -----Original Message----- From: Greg Novak, Momentum [mailto:gnovak@xxxxxxxxxx] Sent: Wednesday, November 19, 2003 9:51 AM To: 'MAPICS ERP System Discussion' Subject: RE: Shortage / Due Reporting An FYI to the list. Since I am on digest mode, David contacted me directly. After he reviewed one of our tutorials, he was able to determine that the EXPORT folder needed to be created in QDLS/INFOWP. David also mentioned (hope you don't mind) that his solution is typically customer specific and the subsets are unique to their business. I am pretty sure that if you contact David off-list he would be willing to discuss his methods and how he approaches the process of building a customized subset from files output by Jacana reports. For self-paced training, please visit the JuMPZone on Momentum's web site at www.jacana.com/jumpzone. These are a series of multi-media presentations that cover a wide range of topics on our products provided free to our customers. Regards, -Greg Gregory Novak Manager North American Technical Services Momentum Utilities Pty Ltd (630) 985-1736 gnovak@xxxxxxxxxx www.jacana.com Making Information Work for your Business www.intuator.com -----Original Message----- From: David Kemp [mailto:dkemp@xxxxxxxxxx] Sent: Tuesday, November 18, 2003 1:07 PM To: MAPICS ERP System Discussion Subject: RE: Shortage / Due Reporting Greg, System registry enrollment is already set-up. The same user already downloads output from IWP to the QDLS/INFOWP folder. User also has all object authority and all special authority needed to write to all AS/400 folders. Any other ideas? David -----Original Message----- From: Greg Novak, Momentum [mailto:gnovak@xxxxxxxxxx] Sent: Tuesday, November 18, 2003 12:54 PM To: 'MAPICS ERP System Discussion' Subject: RE: Shortage / Due Reporting David, Sounds like you need to add either your profile or AMAPICS to the system directory. The easiest way is to enroll the user as a PC user. From the AS/400 Main Menu, select option 11. Client Access/400 tasks, then options 21. Enroll Client Access/400 users. Note that you can also specify saving to previous release on the Options menu when prompted for method. Hope this helps, -Greg Gregory Novak Manager North American Technical Services Momentum Utilities Pty Ltd (630) 985-1736 gnovak@xxxxxxxxxx www.jacana.com Making Information Work for your Business www.intuator.com -----Original Message----- From: David Kemp [mailto:dkemp@xxxxxxxxxx] Sent: Tuesday, November 18, 2003 9:38 AM To: MAPICS ERP System Discussion Subject: RE: Shortage / Due Reporting Greg, I have never exported an IWP report to a PC file. When attempting to do so as you wrote, the following error message was received after PCDOWN was entered: 8 objects saved from library IWPEXPT. Member PCDISKETT2 not copied to PC document. Function check. IWS1612 unmonitored by O#XG8135 at statement *N, instruction Text not available for message ODX0838 file O#XM0001. As a result, there is nothing in the QDLS/INFOWP/EXPORT folder. In fact, the folder does not exist. QDLS/INFOWP does exist as this is where our Excel exports typically go. Do you know why the export did not complete? David -----Original Message----- From: Greg Novak, Momentum [mailto:gnovak@xxxxxxxxxx] Sent: Tuesday, November 18, 2003 8:21 AM To: 'MAPICS ERP System Discussion' Subject: RE: Shortage / Due Reporting David, This sounds like a great solution to Chuck's problem. Would you be willing to share your work with him (and others in this forum)? The reports and subsets can easily be exported from IWP to a PC file and emailed to anyone that wants it. >From IWP "green screen", select Export from the Housekeep menu. After specifying the reports and subsets to export, use the method PCDOWN. It will create a file in /qdls/infowp/export that can be copied or emailed. Regards, -Greg -----Original Message----- From: David Kemp [mailto:dkemp@xxxxxxxxxx] Sent: Monday, November 17, 2003 2:10 PM To: MAPICS ERP System Discussion Subject: RE: Shortage / Due Reporting Chuck, We have done exactly what you are looking for with Jacana. We took the approach of creating some database files of our own and then building a customized subset. The database files can be built using Jacana and the subset can be created using IWP. The reason we built our own database files and subset was to make the linking in the subset much less complicated. We linked a CL to a task that runs all of the reports to build the database files and then runs the report to produce the printed output. This makes running the report very easy for the user. We also use Jacana to download this same information to Excel. The report gives all the items that are short with all manufacturing orders that require the item, all purchase orders for the item with appropriate due dates, and all inventory currently on hand. This is all pulled live from the MAPICS files so the report is literally up to the minute. David Kemp -----Original Message----- From: Chuck Kearney [mailto:ckearney@xxxxxxxxxxxxxxxxxx] Sent: Monday, November 17, 2003 7:57 AM To: mapics-l@xxxxxxxxxxxx Subject: Shortage / Due Reporting To all, I'm looking to create a single report that will combine manufacturing order shortage information with purchasing information. We currently accomplish this manually using Microsoft Word. It's a good report but with many issues such as time, accuracy, and timeliness. All information used to create this report comes from Mapics. So why not let the system do all of the work, right? The "Manufacture Order Shortage Report --- Follow-Up Analysis ---" is used to show what each manufacturing order is short. We use the purchase orders to know when items are due. Any ideas on how to accomplish this? We use Jacana/Valet for report writing. Thank you, Chuck Kearney Production Planner Hydro Systems Company Phone (513) 271-8800 Direct line (513) 842-2511 _______________________________________________ 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. _______________________________________________ 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.
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
