SPEC 6034 - Upload to Future & Sale Cost File (FIL 29) via CSV file

Date Released: November 2019

Modules: Future & Sale Cost File, Special System Maintenance Functions Menu (SYS)

Description:Provides the ability to mass upload cost changes via a CSV upload process.

Special System Maintenance Functions Menu

The option Work with Future Cost File (SYS 928) was added.

• Option 1 = Generate Report from Future Cost IFS file with no updates/writes- this option produces an Audit Report that lets you see what the effects of the upload are before you actually perform the upload.
• Option 2 = Write new Future Cost records from an IFS file without updating old data - Adds any new records. Note: If the record already exists in the Future and Sale Cost File it will not be uploaded; even if there is a price change.
• Option 3 = Write new Future Cost records from an IFS file and update old data - Replaces any existing data in the Future and Sale Cost File with the information in the spreadsheet. Lines that have cost formulas are never overwritten.