Here are 2 simple ways to create ad-hoc reports:
Once you have your Alias create
or
Note: Each new ad-hoc report will open in a new window.
How to Change Dimensions
Drag and drop your Dimension (column header) to the Dimension in the grid, the dimension will be switched.
Right click on the data for more formatting options:
Limit/filter reporting data by double clicking on column header.
Double click dimensions in the table , the List Designer will open in the right side of the report for selecting specifics
List Designer will assist with Structure Selection, Filter, Sort, Attributes (and Advance options)
Infor Mobility for Field Service (MFS, a comprehensive mobility solution designed to streamline activities for technicians operating in the field. released version 15.6.2 to deliver a purpose-built mobile field service application to manage work orders for users of Infor M3, an enterprise resource planning (ERP) system. Infor MFS provide companies with real-time transaction data from their technicians, enabling faster invoicing which help improve cash flow. MFS off-line allow technicians to complete their work efficiently and synchronize transactions when going back on-line. “Infor MFS was designed to help ensure that service technicians can be assigned to an order in the shortest possible time to fix the issue quickly and efficiently,” said Brian Dunks, product director, M3 Product Management, Infor. Infor MFS provides the stability and performance that is necessary to carry out the most advanced field operations.
An easy guide on how to add charts to Ad-hoc Reports
Click Presentation
Chart and Table – puts a chart above the table
Table and Chart – puts chart below table
Change Chart Type. Done!
How to add notes to cells
Make sure “Show cell notes” is enabled
Double click the cell you want to add your note
And you’re done!
Once you have done all your Infor work to create your files for submitting to IRS, the steps below will help you get your file submitted successfully. The final files are generated when you run the BN299.
Download the schema package from the IRS website: Schema Package – IRS
Follow instructions on validating the files generated from Infor. See attached KB from Infor View Attachment
Example of file names:
1094C_Request_XXXXX_YYYYMMDDXXXXXXXXXXZ.xml
1094C_Request_XXXXX_YYYYMMDDXXXXXXXXXXZ-Manifest.xml
An XML Reader Application is needed to validate the files. Altova XMLSpy application is a good program to use for this. Follow the steps in the above KB article to validate the files.
Once you make the changes that are noted in the XML Validator you will need to update the Checksum value in the Manifest.xml
Checksum verifies the integrity of the file. Download the utility FCIV. FCIV (File ChecksumIntegrity Verifier) is utility from Microsoft that computes (MD5 and SHA1) and verify Integrity of the File.
From the command prompt:
You also will need to make sure the AttachmentByteSizeNum is correct. This can change when you make changes to the file.
See attached KB from Infor for details. View Attachment
And we’re done!
Infor announced the availability of Infor Sales Intelligence for Customer Relationship Management (CRM). This tool is designed to help organizations prioritize customers from their purchase likelihood and justified recommendations and provide better assistance for individual customer needs. Organizations are able to better support the sales team to help build the business, boost sales and build stronger customer relationships. Infor Sales Intelligence for CRM’s easy-to-implement solution doesn’t need heavy integration, and delivers immediate results. “By analyzing customer preferences, companies are able to allocate resources where they’re most cost effective and ultimately grow the business,” said Jason Rushforth, GM and Vice President, Infor Customer Experience Suite.
You may be used to deleting users jobs through jobdef.
This works, though you must select each job individually and press delete. So it’s not very efficient.
A better way do to this is jobinq
In lid >> jobinq <DOMAIN\UserName>
This will open up a window listing all the jobs of the user:
Now you can select multiple jobs with the HOME key:
If you want to select ALL jobs and delete them, select first job with HOME key.
Scroll all the way to the bottom of the job list and press END key on the very last Job and press F9 to delete:
Done. Good luck!
After upgrading to Infor 10 with Employee Self Service, when users view their Printable Pay Stub the Overtime Rate was displaying Regular Rate (see screen print #2).
Screen Print #2
To resolve this issue:
Screen Print #3
Login and get to the main menu of websphere
Then go to Resources >> JDBC >> Data sources:
Select New to create a new DataSource:
Type in the name of your DataSource and your database name as so (place the jndi\ in jndi name field):
Select existing JDBC provider >> Microsoft SQL Server JDBC Driver (Most common)
Enter in your database name and the server your database sits on:
Select your Admin user for Component-managed authentication alias.
Review your setup and click Finish:
Go test your newly created DataSource in from a SmartNotification or LBI Report that uses that DataSource.
Enjoy!