Uploaded image for project: 'CFA MX '
  1. CFA MX
  2. CFAMX-8076

ASN without PO # was Auto Received without checking Delay Hours

    Details

      Description

      Store -01919, Env. - Testing

      Scenario- Created an ASN without a PO for Store 01919 
      Auto Receive Delay Hours set to 6 hours for 01919

      ASN is processed successfully and the Order displays in the UI as AUTO RECEIVED (order #797158) 

      However when running this query in the DB for Store 01919 - Entity 1041, we see the status is -1. This means the Auto Receive task is queued and has not been fired.

      select * from tbTaskQueueMessage with(nolock)
      where entityid = 1041
      and LongKey = 797158

      Note: the order is now auto-received and the message has been updated

      DEFECT:

      • When an order is auto received, there is a setting Auto Receive Delay Hours, that should be respected
      • It appears that when an order is created from an ASN, AND the delivery time is in the past, the system is not correctly applying the Delay Hours as a part of the Auto Receive Process
      • For example:
      • Auto Receive Delay Hours = 2
        1. Order processed @ 1030, Delivery Time = 1100 - Order should be auto received at 1300 (1100 + 2 hours)
        2. Order processed @ 1100, Delivery Time = 0800 - Order should be auto received immediately (0800 + 2 hours = 1000, which is before 1100, so auto receive the order)
        3. Order processed @ 1130, Delivery Time = 1030 - Order should be auto received at 1230 (1030 + 2 hours), even though the delivery time is in the past, the delay hours should be taken into account (this is the scenario that appears NOT to be working)

      When investigating this issue with Charles Wheeler, this particular order was processed at about 1430, with delivery time of 1330. The order was marked as auto received, however, the message on tbTaskQueueMessage had not fired, as it was correctly scheduled to fire at 2030.

      • Why 2030?
        • The server is EST, and the store is in CST. 1330 + 6 hours = 1930 CST (orders are auto received at the store local time), which is actually 2030 EST

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                Gareth.Leibbrandt Gareth Leibbrandt (Inactive)
                Reporter:
                charles.wheeler Charles Wheeler
              • Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - 8h Original Estimate - 8h
                  8h
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 27.5h
                  27.5h

                    PagerDuty

                    Error rendering 'com.pagerduty.jira-server-plugin:PagerDuty'. Please contact your Jira administrators.