Trying to do some Purchasing forecasting need to Convert Date to Week ending??

Business Central/NAV User Forum
1

Were using Nav. 5.1 here.

I am trying to do some forecasting of upcoming Purchase lines due and sum them on week ending.

I need a way to convert a Planned Receipt Date of 12-24-10 to i.e. Week 51. Then total on each week how many P/O items are due that week. This would give Receiving a heads up how busy each week is and I’d run it weekly to update the counts.

Any suggestions?

Thanks in advance,

Greg

2

Hi Greg,

The normal way is to use the virtual table DATE and use Period Type “Week”. i.e. filter the DATE table on Period Type “Week” and the find last Period Start Date where the Period Start Date is less than or equal to the Planned Receipt Date. You can of course develop your on week number routine but if you want to show a number of week then you can use the DATE table as a dataitem.

3

Thanks Dave. Are there any reports that use this I could use as an example??