B1up calendar with navigation to beas work order

With this simple customisation you can display in B1up calendar widget opened work orders based on start date.

1. In B1 dashboard add new widget and select calendar
   
   
   
   
2. Edit the calendar resource 
   
   
   
   
3. Select "New Source"
   • here define title
     
     
     
     
   • and use this code
     

     SELECT
     
     'BEAS:WORKORDERPOS' AS 'ObjectType', 
     
     CAST(DocEntry AS NVARCHAR(254)) + '|' + CAST(LineNumber AS NVARCHAR(254)) AS 'PrimaryKey',
     
     ItemCode AS 'Subject', 
     
     StartDate AS "StartDate", 
     
     EndDate AS "EndDate" 
     
     from [BEASV_WORKORDER_POS] WHERE (StartDate BETWEEN @StartDate AND @EndDate)
     
     AND WorkOrderClosed=0

   • You can use your own code to display more field information, but important part is this one
     
     CAST(DocEntry AS NVARCHAR(254)) + '|' + CAST(LineNumber AS NVARCHAR(254)) AS 'PrimaryKey'
     
     
4. Save it and then just make double click on the record in calendar and this will open the work order position