Demand Planner Question regarding Reorder Cycle

gadzilla1
gadzilla1 Member Posts: 316
edited 2008-06-03 in NAV/Navision Classic Client
Hello all!

I'm working with Demand Planner and have succesfully created Measures in DP from NAV.

I've been tasked with accessing the Reorder Cycle from the NAV Item table (it is a Date value) and another custom field (which is a text field).

Here's my issue - DP seems to only allow numeric fields as Measures, not the Date and Text that I need...is there a way to get around this with other views? Does anyone have any sample SQL script?

Any help is greatly appreciated! :lol:

Thanks - gad1

Answers

  • gadzilla1
    gadzilla1 Member Posts: 316
    ok...let me post this a tad differently.

    has anyone imported non-numeric values into DP? if so, could you give me a tip on how to accomplish this?

    thanks! have a great day - gad1
  • gadzilla1
    gadzilla1 Member Posts: 316
    Hey all - I was able to revise the DP SQL to accomplish this item.

    Have a great day - gad1

Categories