MoneyWorks Manual
Edit
Job Sheet Item Importing
There are no options for job sheet items.
The fields that may require special consideration when importing are outlined below. For a full list of fields see Job Sheet Items.
Field | Size | Description |
---|---|---|
Job | 9 | The job code. It must already exist. |
Qty | The quantity of the resource or product used. | |
Resource | 15 | The code for the resource or product. It must already exist. |
Units | 3 | The units of the resource or product (e.g. Hr, Kg, Km). |
Date | The date of the job sheet item,. | |
CostCentre | 5 | The cost centre. If specified it must be a valid Department code. |
CostPrice | The cost of the product or resource used (ex GST). | |
Sell Price | The anticipated charged value of the product or resource used (ex GST). | |
Status | Must be "Actual" or "Budget". |
Note: As for manual entries in the job sheet, MoneyWorks will make and post a stock requisition journal for any imported job sheet entries whose resource code is that of an inventoried product.