Go Back > Forum > Baan SIGs > ION

User login

Frontpage Sponsor


How big is your Baan-DB (just Data AND Indexes)
0 - 200 GB
200 - 500 GB
500 - 800 GB
800 - 1200 GB
1200 - 1500 GB
1500 - 2000 GB
> 2000 GB
Total votes: 83

Baanboard at LinkedIn

Reference Content

Thread Tools Display Modes
Old 22nd October 2018, 13: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, 15 views)
Reply With Quote
Old 22nd December 2018, 12: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 12:34. Reason: information edited
Reply With Quote
Old 27th December 2018, 11:42
ARijke ARijke is offline
Join Date: Sep 2005
Posts: 498
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
Sponsored Links

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 02:05
Pemeco's Planning Dashboard Enhancements patvdv Pages and Stories 1 4th May 2011 23:22
Item Issue by Day Jason Patte Distribution, Transportation & Warehousing 0 24th August 2009 19:17
Subcontracting Material Issue DineshSharma Manufacturing & Supply Chain 2 14th June 2007 18:02
Issue stock in service orders gokove Project & Services 4 14th April 2004 16:53

All times are GMT +2. The time now is 10:35.

©2001-2018 - -