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

2021.R2(S1): Suggested Order Export has wrong value for On Hand Qty used in the order

    Details

    • Type: Sprint Defect
    • Status: Done (View Workflow)
    • Priority: Major
    • Resolution: Completed
    • Affects Version/s: CFA 2021R2
    • Fix Version/s: CFA 2021R2
    • Component/s: Ordering
    • Labels:
      None

      Description

      Description
      I imported a forecast for store 00442 - College Mall. And created an MBM Corp order for Jan 11 - 18, 2021. "Everything" - the On Hand used, was a red 0 as expect from CFAMX -12803, so I placed the order and viewed the SO Export for Create Order – which actually means placed.
      When I viewed the export, I found this block for Potato, waffle fries:
      <SuggestedOrderDetail>
      <ItemCode>051835</ItemCode>
      <Description>POTATO, WAFFLE FRIES TFF</Description>
      <ForecastUsage>32.39</ForecastUsage>
      <SafetyStock>0.75</SafetyStock>
      <OnHand>-10</OnHand>
      <OnOrder>0</OnOrder>
      <SuggestedQty>34</SuggestedQty>
      <OrderedQty>34</OrderedQty>
      <ReceivedQty>0</ReceivedQty>
      <ProcessingTime>36</ProcessingTime>
      </SuggestedOrderDetail>

      If the on Hand was negative, it used 0 as the On Hand quantity in the suggested order calculation, so I'm not sure why the tbTransactionSalesOrderDetailItemQuantity.OnHandQtyOverrideValue was NULL (ps. I think we need to come up with longer table and field names ...just IMO)

      Steps
      Create an MBM order for College Mall
      View Potato Waffle Fries
      (observe that there is a red 0 for the on hand qty used in the SO calculation)
      *Added Make a small change to the Safety Stock value
      I deleted some of the items that did not have negative on hands to keep the export small
      Placed the order
      Go to the server and view the export under:
      W:\MacromatiX\SiteData\JATesting\DataExports\SuggestedOrderCreate\Ready\Archive\2021\01\11

      Results: the On Hand Quantity should have been overridden by 0 in the export
      If you view the placed order, you will see that the On Hand value is still a -10 in red on the panel details
      ex.

      Expected the export should reflect that 0 on hand was used for this item

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                soma.dixon Soma Dixon (Inactive)
                Reporter:
                soma.dixon Soma Dixon (Inactive)
              • Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - 2h
                  2h
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 1h Time Not Required
                  1h

                    PagerDuty

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