Calendar week in view column
Include calendar week in a view have several advantages:
- they are selectable
- they can be compared
- a query can be created to view for which week will delivery be delayed
As an example I have created a SalesLineDeliveryView view for a sales line with 2 columns: confirmed shipping week and requested shipping week.
As columns differ only by a parameter, I have created a function that will return a week from a date:
For the first 9 weeks additional '0' will be added fir aligning.
If no datum has been entered, an empty string will be returned.
For columns I have created 2 methods
Then I have created data fields and assigned methods to them. Finally data will look like this:
You can create your own workspace and define a query to see which lines have a postponed delivery.