Demand Planner Question regarding Reorder Cycle

gadzilla1

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!

Thanks - gad1

gadzilla1

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

Hey all - I was able to revise the DP SQL to accomplish this item.

Have a great day - gad1