Skip to Content

Data not displaying in IBP Excel add in

Hi all,

Can anyone help please? I have loaded 'actualsqty' data into IBP 1611 at day prod loc cust level via the provided template. When querying this data in the Excel add in, I get a message 'no data'. However, I find that the IO Sales KF is displaying the sum of 'actuals qty' loaded for that product at a 'no location' level.

Also - in the same template 'AdjustedSensedDemandQty' is loaded. Again, this is not showing in Excel. However 'Copy of Combined Final Demand for Copy Operator KF' is populated with this value. Looking at the calculation for this KF - it is ultimately derived from 'AdjustedSensedDemandQty'

Can anyone help explain why the KF data as loaded is not displayed, but KF's calculated from the loaded data is showing?

many thanks

Alison

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Jan 06, 2017 at 03:31 PM

    Hi Alison,

    Usually this issue is caused by unit of measure data maintenance. Did you load the UoM conversion?

    Pay attention, if base uom is EA and display your planning view in EA, you need to have a UoM conversion of 1 from EA to EA.

    Best

    Alecsandra

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 09, 2017 at 09:24 AM

    Thank you Alecsandra - this was exactly the problem! All working now!

    Many thanks

    Alison

    Add comment
    10|10000 characters needed characters exceeded