Marc Rohde | 11 Sep 18:46 2013
Picon

Infor BI Question

While this isn't directly an XA question its related to the BI tools.

We are running a SQ SQL 2008 R2 server with a linked sever to a v6 series
and seeing a number of performance issues as well as other oddities.  I have
run similar linked server configurations at prior employers and can't see
anything unusual about this configuration.

Are there any good suggested resources or documentation about how the linked
server should be configured or how it can be tuned?  We did fine that we can
see improved performance using the OPENQUERY command from the SQL server,
which was a substantial improvement  (11 min query became 10 seconds) but
again I don't recall ever needing to do this in prior environments.

Thanks in advance,

Marc

--

-- 
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
To post a message email: MAPICS-L@...
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request@...
Before posting, please take a moment to review the archives
at http://archive.midrange.com/mapics-l.

Marc Rohde | 4 Sep 19:43 2013
Picon

Shipping Accuracy

Not necessarily an XA issue but more of a metric question,

Other than using credits and disputes how are companies measuring shipping
accuracy?  When big box retailers are not always timely in reporting issues
are there any strategies to tracking issues closer to the date of occurrence
so make it easier to do root cause analyisis?

Marc 

--

-- 
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
To post a message email: MAPICS-L@...
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request@...
Before posting, please take a moment to review the archives
at http://archive.midrange.com/mapics-l.

Otto Meyn | 30 Aug 18:59 2013

Programming Question re touch screens.

Can anyone help?

               I have a green screen app that displays, in graphical form, the daily load capacity of a work center.
Currently, if I place the cursor in the bar graph area on the screen and press enter, I get a detail report of
the jobs, displayed immediately on the screen, (Spool File report)
The program knows the cursor position; Each bar is a different day and gives me the appropriate data for that day.

        Xxx  xxx
Xxx  xxx  xxx         xxx
Xxx  xxx  xxx         xxx
Xxx  xxx  xxx xxx  xxx  xxx

I have touch screen on the shop floor.

I would like this same function but just touch the bar graph on the screen, currently I touch but have to press enter.

How can I program the touch screen display to react to the touch?
I do not want to use a mouse or keyboard.

Thanks ahead of time.

DSPATR(SP) for light pen did not work or I was missing something else.
--

-- 
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
To post a message email: MAPICS-L@...
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request@...
Before posting, please take a moment to review the archives
at http://archive.midrange.com/mapics-l.
(Continue reading)

Sue Clement | 29 Aug 19:13 2013
Picon
Picon

MAPICS PO Copy

Wayne;

I don't have a current example, but I know that I have solved this by using
the PO Offline load feature.

The custom program writes and processes the PO through Offline so that all
of the proper editing and field population takes place.

Sue C. Clement

Synapse Corporation

 <mailto:synapse@...> synapse@...

513.683.0100

--

-- 
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
To post a message email: MAPICS-L@...
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request@...
Before posting, please take a moment to review the archives
at http://archive.midrange.com/mapics-l.

WayneRBaldwin | 28 Aug 20:26 2013

MAPICS PO Copy

We are attempting to move to IBM OS 7.1 and have discovered an issue with the PO Copy function in the Browser at
MAPICS R6.
Since this is really unchartered territory, I was wondering if anyone has written a "green screen" PO copy
program/routine that they may be willing to share?
Writing this from scratch opens a can of worms and a chance for missing some vital information, so we were
hoping to borrow from someone else's pain and suffering.

Thanks in advance,

Wayne Baldwin
EATON Electrical Corp.

--

-- 
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
To post a message email: MAPICS-L@...
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request@...
Before posting, please take a moment to review the archives
at http://archive.midrange.com/mapics-l.

Otto Meyn | 23 Aug 19:40 2013

Changing a PDF Documnet's Properties.

I need to print my PDFs automatically from an 8 1/2x11 to 11x17 , I would like to change the PDFs Document
Properties but have not found a solution to edit the page size.

This is my process. ALL PDFs are attached to the item rev (EPDM) file. When and MO prints we check to see if a PDF
is attached. ( ALL PDFs attached will print). Send a copy to a PC Folder which has "Acrotex PDF Printer
Monitor" active and pointed to a specific Network printer.

This work perfectly.

But now I want all PDFs to print on 11 x 17 paper.

The Printer default paper is 11x17 but the PDF prints at  8 ½ x 11.

Any ideas?  If the Document properties has a Page size of 11 x 17 it works.
--

-- 
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
To post a message email: MAPICS-L@...
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request@...
Before posting, please take a moment to review the archives
at http://archive.midrange.com/mapics-l.

Otto Meyn | 31 Jul 16:34 2013

PO Debit Memos

Is there a way to print Debit memos from a green screen command line, not from a menu.

I want to add a host job in PowerLink.

Also, Has INFOR added the VR transaction in PowerLink?
--

-- 
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
To post a message email: MAPICS-L@...
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request@...
Before posting, please take a moment to review the archives
at http://archive.midrange.com/mapics-l.

Ramos, Wilfredo | 30 Jul 01:13 2013

Labor Time Calculation

Is there a file in Mapics that will have calculated Labor time between  On and OFF transactions per Employee
similar to how MOROUT calculates Labor time once the operation is closed?

Thanks

Wil Ramos
Shur-Lok Company
SPS Fastener Division
Office - (949) 655-9221
Mobile- (949) 419-5806

This email and any attachments may contain confidential and proprietary information and must be treated
as such.  In addition, export or re-export of the information contained in or attached to this email may be
prohibited under export control laws.

--

-- 
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
To post a message email: MAPICS-L@...
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request@...
Before posting, please take a moment to review the archives
at http://archive.midrange.com/mapics-l.

Tribbe, Mike | 28 Jul 05:21 2013

Password Changes

We require password changes every 90 days.  Ideally, we want our AD passwords to match the Mapics password. 
And, we would like them both to expire at the same time.  We currently expire both every 90 days, but they soon
get out of sync.
Is there a way to change the password in AD and then pass it to the Iseries?
Or, is there a simple way to change the password in Mapics, similar to Ctrl-Alt-Dlt in AD?  Our Mapics users do
not have access to green screen, only client.

--

-- 
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
To post a message email: MAPICS-L@...
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request@...
Before posting, please take a moment to review the archives
at http://archive.midrange.com/mapics-l.

Picon

Looking for the name/file ID of the "current" inventory transaction file


Specifically the file where inventory transactions are initially captured
before they are moved to the IMHIST file.

MAPICS 7.7.

Roy Luce

Direct:  847-540-9635

            800-913-PLUS (7587)

Cell:      847-910-0884

Fax:      847-737-7635

Email:   lwl@...

--

-- 
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
To post a message email: MAPICS-L@...
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request@...
Before posting, please take a moment to review the archives
at http://archive.midrange.com/mapics-l.

Burns, Bryan | 24 Jul 16:13 2013

ITEMASA and PartSmart (or other Electronic Parts Catalogs)

As a manufacturer, we deliver some 50,000 ITEMASA descriptions for service parts to electronic parts
catalog integrators (ARI, Pathfinders, etc.) but the ITEMASA descriptions don't always fit into the
context of the parts catalog and its "Where Used" function.  Therefore our PartSmart administrator has to
tweak them and, as a result, he would like me to tailor all our 50,000 service part item descriptions
specifically for PartSmart, using the most generic descriptions possible.

For example, let's say we have an ITEMASA ITDSC of "HANDLE, 225 SERIES"  but it was also used on a discontinued
low volume 224 series unit.  A "where used" in  PARTSMART will show both usages and there'd be confusion as to
whether it's the right handle.

I get that, but on the MAPICS side of things, having just "HANDLE" show up on a report  when we could have 400
handles doesn't tell user the  much.  To exaggerate this example, we could just describe everything as
"PART" to make it easy for the PartSmart administrator.

If you faced this type of thing before and have some suggestions, I'd really like to hear them.

Thanks in advance.

Bryan Burns
--

-- 
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
To post a message email: MAPICS-L@...
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request@...
Before posting, please take a moment to review the archives
at http://archive.midrange.com/mapics-l.


Gmane