SMWorkCompletedInventory
This is a direct import (that is, data is uploaded directly to the data table) that allows for inserting new records and updating existing ones.
Imported work completed inventory lines are set with a status of Provisional in SM Work Orders. This means that unlike manually entered work completed lines, posting will not occur automatically; they must be batched and processed using SM Work Order Cost Posting.
- Cost Tax Type
-
When importing records from the text file, if the Cost Tax Type identifier (in Template Detail) is set to Use Viewpoint Default, the system defaults the Cost Tax Type based on the work completed line's taxability status. The taxability of a Work Completed Inventory line is determined by the SM Cost Type assigned to the line and the associated scope's Material Tax Override and Tax Option Override selected options. For detailed information about the tax type default behavior, see Cost Tax Type.
- Bill Tax Type
-
The system uses the same default process for the Bill Tax Type identifier except that if the work completed line is taxable, the system uses the Tax Type defined for the work order scope rather than the tax type specified in the Material Tax Override field. For more information about the tax type default behavior, see Bill Tax Type.
For both the Cost Tax Type and Bill Tax Type fields, if you do not select the Use Viewpoint Default option and the Tax Type for the import record does not match what the system would default, the system allows the entry as long as it is a valid tax type.
For example, the system will not allow an imported Cost Tax Type of 1-Sales for Inventory lines with a Location specified. Likewise, it will not allow an imported Bill Tax Type of 2-Use, as Use tax is not valid as a bill tax type for Inventory lines.
