[CFAMX-8486] Update Forecast Import to support Net Sales flag - HotSchedules JIRA

Details

Type: Story
Status: Closed (View Workflow)
Resolution: Done
Affects Version/s: None
Fix Version/s: None
Component/s: None
Labels:
- Forecast
- aws
- imports

Sprint:
CFAMX 2020R2 SA Sprint 5
SCRUM Team:
Globogym Purple Cobras
Story Points:
5
Work Type Classification:
Sustaining

Description

As a system processing the Forecast Import sent from CFA AWS I want to be able to support an optional flag in the header to indicate whether a forecast is generated using Net Sales or Gross Actuals

{
"GenerationDate": "2020-01-15T17:29:56.010Z",
"Forecast": {
"StoreNumber": "01501",
"BusinessDay": "2020-02-07T00:00:00",
"ReadOnly": "true",
"ForecastBasis": "Net Sales",  
"Sales": "25516.09",
"TransactionCount": "2083.97",
"LastYearSales": "17831.90",
"LastYearTransactionCount": "1682.00",
"MetricDetail": [
{
...

Where ForecastBasis can be either "Net Sales" or "Gross Actual".

Notes

This ForecastBasis field should be optional, if it is not provided, the value should assumed to be Gross Actual
Update the AWS Confluence page: https://cfacorp.atlassian.net/wiki/spaces/IN/pages/53344021/AWS+-+InFORM+-+Forecast+Import

Acceptance Criteria

Confirm when a forecast is imported and the new field is set to "Net Sales", the file is processed and the saved in the database as a Net Sales generated forecast
Confirm when a forecast is imported and the new field is set to "Gross Actual", the file is processed and the saved in the database as a Gross Actual generated forecast
Confirm when a forecast is imported and the new field is not present (it's an optional field), the file is processed and the saved in the database as a Gross Actual generated forecast