Baanboard.com

Go Back   Baanboard.com > Forum > Baan SIGs > ION

User login

Frontpage Sponsor

Main

Poll
How big is your Baan-DB (just Data AND Indexes)
0 - 200 GB
18%
200 - 500 GB
29%
500 - 800 GB
3%
800 - 1200 GB
8%
1200 - 1500 GB
8%
1500 - 2000 GB
11%
> 2000 GB
24%
Total votes: 79

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
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) 11.0.0.365
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, 14 views)
Reply With Quote
  #2  
Old 22nd December 2018, 12:33
kpramod.v kpramod.v is offline
Newbie
 
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.

Regards
Rajini.P

Last edited by kpramod.v : 22nd December 2018 at 12:34. Reason: information edited
Reply With Quote
Sponsored Links
  #3  
Old 27th December 2018, 11:42
ARijke ARijke is offline
Guru
 
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.
Adriaan
Reply With Quote
Reply


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:29.


©2001-2018 - Baanboard.com - Baanforums.com