844-NOGALIS (844-664-2547)
Nogalis, Inc.
  • Link to Facebook
  • Link to X
  • Link to LinkedIn
  • Link to Mail
  • Company
    • News, Events and Articles
    • About Us
  • Products
    • Infor Lawson Data Archive
    • PeopleSoft Data Archive
    • Oracle Data Archive
  • Services
    • Infor Lawson Support
    • Infor Lawson / CloudSuite Consulting
  • Education & Training
  • Support
  • Contact Us
  • Click to open the search input field Click to open the search input field Search
  • Menu Menu

Archive for category: Articles

You are here: Home1 / News, Events and Articles2 / Articles

IP Designer Series – The Branch Node

Articles, News

The Branch node in IP Designer is useful for an “if-then-else” type of logical statement.

After adding a branch node to your process, make sure the node is connected (using the connection tool) to previous nodes. That way, all your variables will be available. Then, click on the branch node and add conditions. You can add many conditions, and you can use variables and/or javascript code to create the comparisons.

In this example, we have very simple conditions:

When you create a connection from a branch to another node, you will be prompted to select the condition that should lead to that node:

NOTE: If you need to connect your branch node to a different node, DO NOT DELETE the connection. That will delete your entire condition!!! Simply grab the end of the arrow and move it to the correct node, or right click on the connection to unlink it and create another connection to the correct node.

01/24/2017
https://www.nogalis.com/wp-content/uploads/2017/01/IP-Designer-Series–The-Branch-Node.jpg 665 732 Angeli Menta https://www.nogalis.com/wp-content/uploads/2013/04/logo-with-slogan-good.png Angeli Menta2017-01-24 07:54:592017-01-23 13:57:05IP Designer Series – The Branch Node

Update the Micro Focus License Manager

Articles, News

In Lawson version 10.0.8, you may encounter performance issues followed by the dreaded “error occurred outside of IOS” notification.  If you run into these issues, check your event viewer.  If you see an error like the one below, you may need to reinstall the Micro Focus license manager.  Here are the steps to do install it.

  1. Go to ftp://asqcust:AbaEsdu7Rf@amerftp.microfocus.com/supportdownload/CES/lmsetupx64.msi and download the msi
  2. Place the file on your Lawson application server
  3. On the Lawson application server, stop the Sentinel RMS License Manager service
  4. Double-click the installation file and follow the steps
  5. The Sentinel RMS License Manager service should be restarted after the installation is complete
01/09/2017
https://www.nogalis.com/wp-content/uploads/2017/01/Update-the-Micro-Focus-License-Manager-e1483656809612.jpg 544 600 Angeli Menta https://www.nogalis.com/wp-content/uploads/2013/04/logo-with-slogan-good.png Angeli Menta2017-01-09 13:14:592017-01-09 13:14:59Update the Micro Focus License Manager

Don’t forget to check your Event Viewer

Articles, News

Sometimes Lawson errors can be very cryptic and difficult to troubleshoot.  Sometimes you will have a very specific error in the ios.log or other system logs, and a search on InforXtreme produces ZERO results.  It can be quite frustrating!  Don’t forget that you have another place to check for errors.  Always remember to check your Windows Event Viewer for another “perspective” on the error.  Sometimes a Google search or even InforXtreme search on the error text in Event Viewer will actually produce results where the log search didn’t.  Some examples I have found are an error in the importdb script, which provided more information for an Infor ticket I had open, and a MicroFocus license manager error that led me to a KB and a download that solved some performance issues for us.  So, the bottom line is, don’t forget to check server logs in addition to Lawson and WebSphere logs!

01/05/2017
https://www.nogalis.com/wp-content/uploads/2017/01/Don’t-forget-to-check-your-Event-Viewer-e1483656249258.jpg 544 599 Angeli Menta https://www.nogalis.com/wp-content/uploads/2013/04/logo-with-slogan-good.png Angeli Menta2017-01-05 14:44:272017-01-05 14:44:27Don’t forget to check your Event Viewer

IP Designer Series – The Assignment Node

Articles, News

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.

01/03/2017
https://www.nogalis.com/wp-content/uploads/2017/01/IP-Designer-Series-The-Assignment-Node.jpg 665 732 Angeli Menta https://www.nogalis.com/wp-content/uploads/2013/04/logo-with-slogan-good.png Angeli Menta2017-01-03 11:30:352017-02-17 11:25:18IP Designer Series – The Assignment Node

Infor BI–Office Plus: Create a Database Alias

Articles, News

This is a simple way to create a database alias.

 

Create your Alias:

  1. Log on with Options
    infor-bi-office-plus-create-a-database-alias-1
  2. Select the Repository
    infor-bi-office-plus-create-a-database-alias-2
  3. On the Database Structure Pane – Click New Database Alias button
    infor-bi-office-plus-create-a-database-alias-3
  4. Fill in information:
    infor-bi-office-plus-create-a-database-alias-4

Your Alias is now created:

infor-bi-office-plus-create-a-database-alias-5

12/21/2016
https://www.nogalis.com/wp-content/uploads/2016/12/Infor-BI–Office-Plus-Create-a-Database-Alias.jpg 665 732 Angeli Menta https://www.nogalis.com/wp-content/uploads/2013/04/logo-with-slogan-good.png Angeli Menta2016-12-21 11:59:132016-12-21 11:59:13Infor BI–Office Plus: Create a Database Alias

Infor BI–Office Plus – Ad-hoc Report: 2 Simple Ways to Create Ad-Hoc Reports

Articles, News

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

 

Once you have your Alias create

infor-bi-office-plus-ad-hoc-report-2-simples-ways-to-create-ad-hoc-reports-1

  • Click New Ad-hoc Report on the Office Plus section of the Ribboninfor-bi-office-plus-ad-hoc-report-2-simples-ways-to-create-ad-hoc-reports-2

    or

  • Double click the cube in the left side paneinfor-bi-office-plus-ad-hoc-report-2-simples-ways-to-create-ad-hoc-reports-3

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

12/19/2016
https://www.nogalis.com/wp-content/uploads/2016/12/Infor-BI–Office-Plus-–-Ad-hoc-Report-2-simple-ways-to-create-ad-hoc-reports.jpg 665 732 Angeli Menta https://www.nogalis.com/wp-content/uploads/2013/04/logo-with-slogan-good.png Angeli Menta2016-12-19 11:09:412016-12-19 11:09:41Infor BI–Office Plus – Ad-hoc Report: 2 Simple Ways to Create Ad-Hoc Reports

Infor BI–Office Plus – Ad-hoc Report: How to Change Dimensions

Articles, News

How to Change Dimensions

 

Drag and drop your Dimension (column header) to the Dimension in the grid, the dimension will be switched.

infor-bi-office-plus-ad-hoc-report-how-to-change-dimensions

 

Right click on the data for more formatting options:

infor-bi-office-plus-ad-hoc-report-how-to-change-dimensions-2

 

Limit/filter reporting data by double clicking on column header.

infor-bi-office-plus-ad-hoc-report-how-to-change-dimensions-3_mini

 

Double click dimensions in the table , the List Designer will open in the right side of the report for selecting specifics

infor-bi-office-plus-ad-hoc-report-how-to-change-dimensions-4

 

List Designer will assist with Structure Selection, Filter, Sort, Attributes (and Advance options)

infor-bi-office-plus-ad-hoc-report-how-to-change-dimensions-5

12/13/2016
https://www.nogalis.com/wp-content/uploads/2016/12/Infor-BI–Office-Plus-Ad-hoc-Report-How-to-Change-Dimensions.jpg 665 732 Angeli Menta https://www.nogalis.com/wp-content/uploads/2013/04/logo-with-slogan-good.png Angeli Menta2016-12-13 10:54:392016-12-13 10:54:39Infor BI–Office Plus – Ad-hoc Report: How to Change Dimensions

Infor BI – Office Plus – Ad-hoc Report: Adding Charts to Ad-hoc Report

Articles, News

An easy guide on how to add charts to Ad-hoc Reports

 

Click Presentation

infor-bi-office-plus-ad-hoc-report-adding-charts-to-ad-hoc-report-1

 

Chart and Table – puts a chart above the table

infor-bi-office-plus-ad-hoc-report-adding-charts-to-ad-hoc-report-2

Table and Chart – puts chart below table
infor-bi-office-plus-ad-hoc-report-adding-charts-to-ad-hoc-report-3

 

Change Chart Type. Done!

12/01/2016
https://www.nogalis.com/wp-content/uploads/2016/11/Infor-BI-–-Office-Plus-Ad-hoc-Report-Adding-Charts-to-Ad-hoc-Report.jpg 545 597 Angeli Menta https://www.nogalis.com/wp-content/uploads/2013/04/logo-with-slogan-good.png Angeli Menta2016-12-01 06:55:002016-11-30 14:55:16Infor BI – Office Plus – Ad-hoc Report: Adding Charts to Ad-hoc Report

Infor BI – Office Plus – Ad-hoc Report: Adding Notes to Cells

Articles, News

How to add notes to cells

Make sure “Show cell notes” is enabled

infor-bi-office-plus-ad-hoc-report-adding-notes-to-cells-1

Double click the cell you want to add your note

infor-bi-office-plus-ad-hoc-report-adding-notes-to-cells-2

infor-bi-office-plus-ad-hoc-report-adding-notes-to-cells-3

 

And you’re done!

11/28/2016
https://www.nogalis.com/wp-content/uploads/2016/11/Infor-BI–Office-Plus-Ad-hoc-Report-Adding-Notes-to-Cells-e1480376056795.jpg 544 597 Angeli Menta https://www.nogalis.com/wp-content/uploads/2013/04/logo-with-slogan-good.png Angeli Menta2016-11-28 15:34:372016-11-28 15:34:37Infor BI – Office Plus – Ad-hoc Report: Adding Notes to Cells

Submitting ACA (Affordable Care Act) to IRS

Articles, News

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

submitting-aca-affordable-care-act-to-irs-1

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.xmlsubmitting-aca-affordable-care-act-to-irs-2

You also will need to make sure the AttachmentByteSizeNum is correct. This can change when you make changes to the file.

submitting-aca-affordable-care-act-to-irs-3

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
  1. Save update
    submitting-aca-affordable-care-act-to-irs-4

 

And we’re done!

11/22/2016
https://www.nogalis.com/wp-content/uploads/2016/11/Submitting-ACA-to-IRS.jpg 665 732 Angeli Menta https://www.nogalis.com/wp-content/uploads/2013/04/logo-with-slogan-good.png Angeli Menta2016-11-22 14:00:042016-11-22 14:00:04Submitting ACA (Affordable Care Act) to IRS
Page 114 of 117«‹112113114115116›»

LEGACY ERP DATA ARCHIVE SOLUTION



Discover how our clients are leveraging AWS services to archive their Legacy ERP data and provide ubiquitous access to users via a light-weight, secure, and read-only web interface. Secure, Fast, Reliable, and Cost Effective. That is the promise of APIX. Follow the link below to find out more and book a discovery call with our data archive specialist.

BOOK DEMO

© Copyright - Nogalis, Inc. 2024
  • Legal
  • Privacy
  • Contact Us
Scroll to top Scroll to top Scroll to top