Archive for category: Articles

The Assignment node in IP Designer is pretty straightforward and simple to use, but it can also be very useful and flexible. The first step to using the assignment node is to create and initialize your variables in the start node properties.

The assignment node can be used to set simple variables. It can also be used for more complex assignments. Here is a simple assignment, created by clicking :

You can also use javascript and regular expressions in your assignment node to manipulate strings. This example uses a simple “if” statement to assign a variable (created by clicking ):

This example takes a line from a data iterator, splits it on the “,” , and removes unwanted characters using regular expressions. It assigns that string to the “impCompany” variable, which was created and initialized in the Start node.

Here are 2 simple ways to create ad-hoc reports:

 

Once you have your Alias create

• Click New Ad-hoc Report on the Office Plus section of the Ribbon

  or

• Double click the cube in the left side pane

Note: Each new ad-hoc report will open in a new window.

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!

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:

1. Browse to the location where your files and fciv.exe is located
2. Type program name + file name (ex. fciv.exe 1094C_Request_BB9LL_20160629T100009000Z.xml)
3. Press enter
4. 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

1. Locate the Forms XML File.
2. Right click on the file, select Properties
3. Locate the Manifest XML File.
4. Right click and open using Wordpad
5. Find <p4:AttachmentByteSizeNum> entry
6. 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

7. Save update
   
   

 

And we’re done!

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:

1. in emss_config.xml change “calc_hourly_rate” = “true” (location: lawdir\web\lawson\xhrnet\xml\config)
2. 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