Go Back > Forum > Baan SIGs > ION

User login

Frontpage Sponsor


As a Customer What would do to keep your ERP Implementation intact
Proactively define Business Process-- Take the Project Ownership
Handover everything to System Integrator from drawing BP till implementation of ERP
Hire more inhouse skilled & capable IT Resource to work directly with SI
Rely on SI Architects/Consultants
Total votes: 8

Baanboard at LinkedIn

Reference Content

Thread Tools Display Modes
Old 22nd October 2018, 12:35
vip1982 vip1982 is offline
Junior Member
Join Date: Oct 2018
Posts: 3
vip1982 is on a distinguished road
Baan: 10.4 - DB: SQL - OS: Windows 2016
INFOR BI Dashboard Issue

Hello Everyone,

I would appreciate your support into the issue below, INFOR till now didnt solve it for us.

We have installed the following:

1) Infor Business Vault Enterprise Edition 11.3.2
2) Infor BI OLAP Server (64 bit)
3) Infor LN Analytics Foundation 10.5.2

We are using Infor LN FP9.

We have 2 companies: 222 and 333.

Company 222 has common Master data in it which is shared with company 333.

We have published all the data referring the document "Infor_LN_Integration_Guide_for_Infor_LN_Analytics_Foundation".

But when we see the Sales Overview screen from LN Analytics Foundation, we see "Customer reference missing", "Customer reference invalid" etc in report "Top 10 Customers".

We see "Item reference missing" in report "Top 10 Items",
"Employee reference missing" in report "Top 10 Sales Representative"

Please refer the attached screenshot.

Please tell me if someone can have an idea about this?

Thank You,
Attached Images
File Type: jpg InkedSales_Overview_LI2.jpg (82.1 KB, 16 views)
Reply With Quote
Old 22nd December 2018, 11:33
kpramod.v kpramod.v is offline
Join Date: Nov 2016
Posts: 2
kpramod.v is on a distinguished road
Baan: 10.2 - DB: SQL server - OS: windows
INFOR BI Dashboard Issue

Hi vip1982,

Reference missing is nothing but if you don't mention any customer,employee and item in the sales order then those orders will come under respective customer reference missing, item reference missing and employee reference missing.


Last edited by kpramod.v : 22nd December 2018 at 11:34. Reason: information edited
Reply With Quote
Sponsored Links
Old 27th December 2018, 10:42
ARijke ARijke is offline
Join Date: Sep 2005
Posts: 506
ARijke is on a distinguished road
Baan: Baan IV upto LN - DB: -- - OS: --
The invalid reference means that the underlying order/invoice has a customer code but the master data is not known at the BI side. (re)Publishing the missing one or just all customers should resolve this issue.
The reference missing means that the underlying order/invoice does not have a customer or item code attached to it. This is not wrong it is just a fact. Sometimes this is just how LN works in certain cases. Sometimes you could resolve this in LN by maintaining more data, like give each sales order a sales representative.
Reply With Quote

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Issue materials to production order with old date vp1980 Distribution, Transportation & Warehousing 0 9th September 2015 01:05
Pemeco's Planning Dashboard Enhancements patvdv Pages and Stories 1 4th May 2011 22:22
Item Issue by Day Jason Patte Distribution, Transportation & Warehousing 0 24th August 2009 18:17
Subcontracting Material Issue DineshSharma Manufacturing & Supply Chain 2 14th June 2007 17:02
Issue stock in service orders gokove Project & Services 4 14th April 2004 15:53

All times are GMT +2. The time now is 12:27.

©2001-2020 - -