We’re currently updating our website to a new platform. We’re still operating as usual, but some pages may be under construction. Thank you for your patience.
Jiwa Training Centre
Breadcrumbs

Cancelling Inventory Lines from Job

In this article we look at how to cancel inventory lines from jobs in the Jiwa Job Costing module.  

Cancelling Inventory Lines from a Job

In the following example we have an installation job where Wellington Boots have been added to the job incorrectly.

https://austlinkwebresources.s3.amazonaws.com/www.jiwatraining.com.au/articles/Jiwa-JC-Cancelling-Inventory-From-Jobs/2016-06-08_14-12-54.jpg

In order to cancel the line we need to produce a finished good which will remove the item from the job and put it back into stock.

From the menu select Job Costing | Transactions | Produce Finished Goods.

https://austlinkwebresources.s3.amazonaws.com/www.jiwatraining.com.au/articles/Jiwa-JC-Cancelling-Inventory-From-Jobs/2016-06-08_14-42-00.jpg

From the menu ribbon select New to create a new batch

https://austlinkwebresources.s3.amazonaws.com/www.jiwatraining.com.au/articles/Jiwa-JC-Cancelling-Inventory-From-Jobs/2016-06-08_14-43-25.jpg

Click on the lookup icon next tot he Job Number field to select the required job

https://austlinkwebresources.s3.amazonaws.com/www.jiwatraining.com.au/articles/Jiwa-JC-Cancelling-Inventory-From-Jobs/2016-06-08_14-45-06.jpg

Add a meaningful comment in the Reference field

https://austlinkwebresources.s3.amazonaws.com/www.jiwatraining.com.au/articles/Jiwa-JC-Cancelling-Inventory-From-Jobs/2016-06-08_14-46-04.jpg

In the Details tab add the part/(s) that are to be returned to stock

In the Qty field enter in the number of units to be returned to stock, in this example all 6 units are being cancelled from the job

Use the Remark field to add a comment that is specific to the part, this is useful as this comment will also appear in the transaction tab on the job.

https://austlinkwebresources.s3.amazonaws.com/www.jiwatraining.com.au/articles/Jiwa-JC-Cancelling-Inventory-From-Jobs/2016-06-08_14-49-00.jpg

You will notice that the unit cost is zero that is because we have not selected the cost to be cancelled from the job as yet

Click on the lookup icon next to to the Unit Cost field to bring up the Job Costing - Cost Allocation window

https://austlinkwebresources.s3.amazonaws.com/www.jiwatraining.com.au/articles/Jiwa-JC-Cancelling-Inventory-From-Jobs/2016-06-08_14-51-08.jpg

The cost allocation form displays all the cost on the job and what is still sitting in WIP

Locate the line that needs to be cancelled and enter the cost value in both the This Charge and This Cost field

In this example all 6 units are being cancelled from the job however if only 3 units were to be cancelled from the job then the cost value needs to be set to reflect only 3 units

https://austlinkwebresources.s3.amazonaws.com/www.jiwatraining.com.au/articles/Jiwa-JC-Cancelling-Inventory-From-Jobs/2016-06-08_14-53-39.jpg

When you have selected the costs to be cancelled click on the OK icon to return to the batch entry form

The batch is now updated with the applicable cost

https://austlinkwebresources.s3.amazonaws.com/www.jiwatraining.com.au/articles/Jiwa-JC-Cancelling-Inventory-From-Jobs/2016-06-08_14-57-27.jpg

Save and Activate your batch  

Reviewing Job Transactions

Back at the job we can see the cancelled line in the Transaction tab

https://austlinkwebresources.s3.amazonaws.com/www.jiwatraining.com.au/articles/Jiwa-JC-Cancelling-Inventory-From-Jobs/2016-06-08_15-52-30.jpg

On the Financial Status tab the Work in Progress value is also updated

https://austlinkwebresources.s3.amazonaws.com/www.jiwatraining.com.au/articles/Jiwa-JC-Cancelling-Inventory-From-Jobs/2016-06-08_15-58-52.jpg

   

Stock Ledger

Stock is now returned to the stock ledger at the correct cost.

https://austlinkwebresources.s3.amazonaws.com/www.jiwatraining.com.au/articles/Jiwa-JC-Cancelling-Inventory-From-Jobs/2016-06-08_16-01-10.jpg