-
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
-
SCRUM Team:Brotherhood of Mutants
-
Sprint:2021.R2 New Features Sprint 1
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
- blocks
-
CFAMX-12802 Update Suggested Order Export to Include A Record of Zero-ed On Hand Calculation
- Closed
-
CFAMX-13028 Testing (S1.R2) - Update Suggested Order Export to Include A Record of Zero-ed On Hand Calculation
- Closed