Food Donation > Import Fair Market Value

As a Store manager I want the Fair Market Value of finished products to be imported as a part of the Menu Item Cost Import so that when I generate reports for those items that I waste the Fair Market Value is represented

Notes

• Enhance the Menu Item Cost Import to include a new column, Fair Market Value
  • This field should support 4 decimal places, as per other costs
  • This value should be stored at the entity level, in addition to the Sales Cost
    Menu Item Cost import

    Note: Below is a sample of Menu Item Cost import, which runs last 5 days of each month, it may be possible to leverage this import to support a Fair Market value

    StoreNumber,ItemCode,CostType,SalesCost,CostDate
    00001,100004,food,0.1446,2018-10-01
    00001,100005,food,0.0317,2018-10-01
    00001,100006,food,0.3615,2018-10-01

    These cost values are currently stored in tbentitysalesitemcost

• There are two files that are sent for Item Cost, these are:
  • MIFC (Food cost)
  • MIPC (Paper cost)
• These files are sent to InFORM for the last 5 days of the month

Acceptance Criteria

1. Confirm that the Menu Item Cost Import is updated to include a new Optional field for the Fair Market Value
2. Confirm that the Fair Market Value can be sent as a value up to four (4) decimal places
3. Confirm that Confluence documentation is provided around the changes to the file
4. If any validation rule fails, the record will be skipped. Processing will continue with the next record.
5. Confirm that if the Fair Market Value is not included in the header record, and subsequent detail records, the file processes as expected
6. Confirm that if the Fair Market Value is not included for an item, there is a mechanism to successfully process the record, such as the inclusion of a Null instead of a value
   • This is to cater for the scenario whereby not all Menu Items have a Fair Market value assigned to them