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:
- Browse to the location where your files and fciv.exe is located
- Type program name + file name (ex. fciv.exe 1094C_Request_BB9LL_20160629T100009000Z.xml)
- Press enter
- The unique value should be placed in the ChecksumAugmentationNum tag in the Manifest.xml
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
- Locate the Forms XML File.
- Right click on the file, select Properties
- Locate the Manifest XML File.
- Right click and open using Wordpad
- Find <p4:AttachmentByteSizeNum> entry
- Replace the existing byte size entry with the byte size found in the Forms XML File properties.
- In this example: Change Manifest Size: 4522 to match Forms XML File size: 4598
- Save update
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:
- in emss_config.xml change “calc_hourly_rate” = “true” (location: lawdir\web\lawson\xhrnet\xml\config)
- The user requires access to their data. Through Lawson Security Administrator grant access to EMPLOYEE table fields: EXEMPT-EMP, SALARY-CLASS, TAX-STATE, WORK-STATE (see screen print #3 for “Printable Pay Stub” displaying correctly).
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!
If you upload the ACH file generated by PR160 to your bank, chances are you will need to fix the formatting after your upgrade to version 10. Some banks require the 94-character fixed width format, rather than the sequential format that is the Lawson default. Here are the steps to update your ACH file format.
- In LID, type in the command workdef
- Search for your product line and the File name TAPE
- File Media should be “Tape”
- The default “Value” for file name is PR160-ACHTAPE. If you need to drop the file under a custom name, you will enter it in the “Value”. If you want to keep the default, leave that field blank.
- Click enter twice to save your changes
- The PR160-ACHTAPE file is defaulted to save in the user’s print directory. If you want it saved somewhere else, you can supply the filename on the PR160 job. If you supply a file path on PR160, make sure the file name matches the “Value” field in workdef.
- In Lawson Security, make sure that your Batch role has access to the cnvexp development token
Infor announced the availability of Infor Learning Optimization, a new addition to the Infor Talent Management suite. This tool is designed to match organizations and employees with personalized learning and coaching at the individual level, to help resolve behavioral opportunities. This individualized learning is meant to help employees feel more connected to their jobs and reduce attrition and flight risk. Charles Cagle, senior vice president, HCM Development, Strategy, & Operations at Infor states,”by providing managers with insights and tools to capitalize on employees’ behavioral strengths and characteristics, Infor Learning Optimization can help them directly impact success and influence business goals.”
Every time an employee makes a benefits change, a new record is stored in the benefits table. Additionally, a new record is stored in the employee’s deduction master table for each deduction related to that benefit. If these records are allowed to accumulate unchecked, this can slow down payroll processing and even cause errors. The larger the benefits and deductions table become, the slower payroll batch jobs will run. These batch jobs, such as PR140, loop through each record in these benefits and deductions tables so that the correct deductions are applied. Some of these batch jobs have a limit of the number of records allowed, so if an employee has deductions that exceed that limit, the job will error out. Also, traversing through these records can greatly slow down processing.
To help alleviate these issues, we recommend running the BN430 benefits purge program periodically. When you are processing payroll, if you see an error similar to “26 20591 PRDED-DED-TABLE must be increased; Cur size 0500”, chances are you have an employee with too many benefits changes, and need to run the BN430. But, before you receive this error, you should make the benefits purge part of a normal maintenance process. Ideally, payroll users would make this part of the payroll process each pay period, and choose a “Purge Through Date” corresponding to your company’s record retention period.
Restaurant executives are turning to technology to improve overall efficiency. After being surveyed in hospitality technology, they have adopted many customer-facing technologies. Many have adopted loyalty programs, comprehensive mobile experiences , personalized offerings, and tableside ordering – all of which can help restaurants better reach customers and make their overall experience more satisfying. Restaurant execs are also turning to predicative analytics and Internet of Things (IoT). Though these technologies are still new, some have begun harnessing the power of them. Few also said they were focusing on other new types of technologies, such as augmented reality (AR) and wearables. Technology can help increase sales, and the use of it in a restaurant provides a competitive advantage.