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

Items Incorrectly Appearing on Order Guides

    Details

    • Type: Customer Defect
    • Status: Need More Info (View Workflow)
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: CFA 2023R1
    • Fix Version/s: None
    • Component/s: OrderGuide
    • Labels:
      None
    • VTask #:
      VTASK0510475

      Description

      106774 is appearing on the following restaurants' OGs even though there are no supporting rules setup for Martin Brower. The only Include rule that is setup for this item is for Sysco- Hawaii. Please see attached images.

      Example store # 03003

       Select * from tbVendorEntityITem with ( nolock ) where EntityID = 2056 and vendorCode = '106774'
      
       Select * from tbVendorItem with ( nolock ) where   vendorCode = '106774'
      
       Select * from tbVendorItemZoneRule A with ( nolock ) join tbZone B ON A.ZoneId = B.ZoneID where   vendorCode = '106774' and Deleted <> 1
      
       Select * from tbVendorItemEntityRule A with ( nolock ) join tbEntity B ON A.EntityId = B.EntityID where   vendorCode = '106774' and Deleted <> 1
      

       

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                wesam.el-gendy Wesam El-Gendy
                Reporter:
                wesam.el-gendy Wesam El-Gendy
              • Watchers:
                0 Start watching this issue

                Dates

                • Created:
                  Updated:

                  PagerDuty

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