Job Queue run on earlier one day

Answers

• Options

  RockWithNAV Member Posts: 1,139

  2020-05-04 Answer ✓

  See for Weekends system already know that its a off day, for weekdays and it may be a leave day or a festive day you need to tell the system by someway or the other so I believe you need to go ahead with a customisation to handle this.

  Thanks
  
  Blog - rockwithnav.wordpress.com/
  Twitter - https://twitter.com/RockwithNav
  Facebook - https://facebook.com/rockwithnav/

  5
• Options

  xavierho970304 Member Posts: 12

  2020-05-05

  I know need to do new customize to handle this issue, but I am new in NAV. May I know have any sample code to handle this issue? Thanks

  0
• Options

  Tryzub Member Posts: 2

  2020-05-15

  You can use Application Setup => Base Calendar to load / update non-working days. And then the Codeunit 7600 "Calendar Management" gives the functionality to check date status.
  
  The sample of usage to get the last working date in a month:
  ===========================================

  GetLastWorkDateForCustomer(inSCNo : Code[20];VAR aDate : Date) LastWorkDate : Date
      VAR
        Customer: Record 18;
        CalendarMgt : Codeunit 7600;
        tempStr: Text[50];
  BEGIN
  
    IF aDate = 0D THEN
      aDate := WORKDATE;
  
    LastWorkDate := CALCDATE('<CM>',aDate);
  
    Customer.GET(inSCNo);
    IF Customer."Base Calendar Code" = '' THEN
      EXIT;
  
    IF CalendarMgt.CheckDateStatus(Customer."Base Calendar Code",LastWorkDate,tempStr) THEN
      REPEAT
        LastWorkDate := CALCDATE('<-1D>',LastWorkDate);
      UNTIL NOT CalendarMgt.CheckDateStatus(Customer."Base Calendar Code",LastWorkDate,tempStr);
  
  END;
  
  

  0