-
Type:
Customer Defect
-
Status: Done (View Workflow)
-
Priority:
Major
-
Resolution: Closed/Resolved by Caller
-
Affects Version/s: CFA 2021R5
-
Fix Version/s: None
-
Component/s: None
-
Labels:
-
VTask #:VTASK0473203
Description
I understand that SoldCount and PromotionalCount values determined as follows
PromotionalCount can be calculated a few different ways:
1. If there is are records in tbTransactionPromo, its the sum of the Quantity in the records found there
2. If there is are records in tbTransactionWaste that have a source of POS and an ItemCategory like "Test Products", its the sum of the WasteQty
3. If there is are records in tbTransactionWaste that have a source of anything but POS and an ItemCategory like "Test Products", its the sum of the WasteQty
SoldCount can be calculated as:
1. If there are records in tbTransactionSalesItem, its the sum of the Quantity in the records found there
2. If there is are records in tbTransactionWaste that have a source of anything but POS and an ItemCategory like "Test Products", its the sum of the WasteQty
follow up question from CFA. CFA would like to know how the records in the tables are determined to go in each table?
- is blocked by
-
CFAMX-11540 Production Defects
-
- Open
-