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.

There’s no denial that cloud technology saw impressive growth in 2016. Companies like Amazon and Microsoft embraced the technology and saw increased sales. And there’s no sign of a slowdown. Below are seven predictions for cloud technology in 2017 from cloud market experts.

  1. When faced with a hardware refresh, more companies will turn to the cloud rather than new equipment.
  2. Cloud vendors with incomplete solutions will continue to form surprising alliances.
  3. CISOs will increasingly see cloud migration as a risk mitigation strategy.
  4. New Software as a Service (SaaS) will emerge to help people manage cloud-based resiliency.
  5. Machine learning will begin to enable the prediction of application downtime and duration.
  6. Cloud apps providers will build more native logging and audit features.
  7. Companies will continue to implement multi-cloud models.

Are your predictions on the list? What other predictions do you have?

 

For Full Article, Click Here

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

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.

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

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.

 

For Full Article, Click Here

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!

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!

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!

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.

 

For Full Article, Click Here