SMWorkCompletedMisc
This is an "insert" only import. You cannot use this import to update existing work completed miscellaneous lines.
Additionally, imported miscellaneous work completed 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 Misc 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 3-VAT for Miscellaneous lines not generated from an AP transaction. Likewise, it will not allow an imported Bill Tax Type of 2-Use, as Use tax is not valid as a bill tax type.
