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

Invoicing Jobs

In this article we look at how to create invoices against jobs in Jiwa 7.

Jobs are invoiced at the cost centre level this means that during the invoicing stage costs and charges are assigned to the invoice.

The allocation process enables users to assigned costs and charges to an invoice either manually or automatically.    

Creating Job Invoice

Job invoices are created through the Sales Order Entry form either by selecting Sales | Order Entry and then New | New Job Invoice from the menu ribbon.

https://austlinkwebresources.s3.amazonaws.com/www.jiwatraining.com.au/articles/Jiwa-JC-Invoicing-Jobs/2016-08-23_9-39-48.jpg

The sales order entry form can also be opened from the Transaction tab on a job by using the transaction type of Sales invoices and then clicking on Create Transaction

https://austlinkwebresources.s3.amazonaws.com/www.jiwatraining.com.au/articles/Jiwa-JC-Invoicing-Jobs/2016-08-23_9-41-09.jpg

When the sales order is created the Job Costing - Cost Allocation popup is displayed

The form is divided into three(3) sections;

  • The top section displays costs and charges that have yet to be allocated to an invoice by cost centre, and the Auto Allocation options

  • The middle section provides a job summary

  • The bottom section displays all job transactions and values that are still in WIP

 

https://austlinkwebresources.s3.amazonaws.com/www.jiwatraining.com.au/articles/Jiwa-JC-Invoicing-Jobs/2016-08-23_10-37-04.jpg

The List Transactions date can be used to filter transactions upto and including a set date.  This is useful if you need to invoice to a specific date.

https://austlinkwebresources.s3.amazonaws.com/www.jiwatraining.com.au/articles/Jiwa-JC-Invoicing-Jobs/2016-08-26_9-09-40.jpg

 

https://austlinkwebresources.s3.amazonaws.com/www.jiwatraining.com.au/articles/Jiwa-JC-Invoicing-Jobs/2016-08-26_9-13-06.jpg

   

Manual Allocation

Manual allocation of costs and charges to an invoice can be completed at the cost centre / stage level or at the transaction level.

NOTE: All values entered in the Cost Allocation form are GST exclusive, GST if applicable to the job will be applied to the sales order.  Check the Settings tab on the job to confirm if GST is to be applied to or not.  

Allocation by Cost Centre

This method of invoicing sets the charge and cost values at the cost centre / stage level.

Enter in the amount to be invoiced (excl GST) for the cost centre / stage in the This Charge field

https://austlinkwebresources.s3.amazonaws.com/www.jiwatraining.com.au/articles/Jiwa-JC-Invoicing-Jobs/2016-08-23_11-33-41.jpg

When this field is updated you will notice that in the Transactions grid the amount is then apportioned across all transactions still in WIP linked to the cost centre on a prorata basis.

https://austlinkwebresources.s3.amazonaws.com/www.jiwatraining.com.au/articles/Jiwa-JC-Invoicing-Jobs/2016-08-23_11-36-22.jpg

Now in the This Cost field add in the cost value you want to allocate to the invoice.

https://austlinkwebresources.s3.amazonaws.com/www.jiwatraining.com.au/articles/Jiwa-JC-Invoicing-Jobs/2016-08-23_11-40-16.jpg

Alternatively if you want to allocate the full cost centre cost and charge amounts to the invoice you can right mouse click over the cost centre WIP Charges or WIP Costs value and select one of the Allocate All options

https://austlinkwebresources.s3.amazonaws.com/www.jiwatraining.com.au/articles/Jiwa-JC-Invoicing-Jobs/2016-08-23_11-45-43.jpg

In the example below the Allocate All Charge and Cost option was selected which updated the This Charge and This Cost fields to what is sitting in WIP

https://austlinkwebresources.s3.amazonaws.com/www.jiwatraining.com.au/articles/Jiwa-JC-Invoicing-Jobs/2016-08-23_12-36-10.jpg

You will notice that the job summary and transactions are updated accordingly

https://austlinkwebresources.s3.amazonaws.com/www.jiwatraining.com.au/articles/Jiwa-JC-Invoicing-Jobs/2016-08-23_12-38-09.jpg

 

Prorata Costs

Costs can also be allocated on a prorata basis based on the This Charge amount

Enter the value to be invoiced (excl GST) in the This Charge amount field

Then right click over the WIP amount and select Prorata Costs 

https://austlinkwebresources.s3.amazonaws.com/www.jiwatraining.com.au/articles/Jiwa-JC-Invoicing-Jobs/2016-08-23_12-41-38.jpg

The cost field is automatically updated on a prorata basis

https://austlinkwebresources.s3.amazonaws.com/www.jiwatraining.com.au/articles/Jiwa-JC-Invoicing-Jobs/2016-08-23_12-45-40.jpg

 

Allocation by Transaction

Costs and charges can be allocated to an invoice by individual transaction using the Transactions grid.

Work through each transaction and set the This Charge and This Cost amount

Notice that the top and middle sections of the form are updated as you work through the transactions

https://austlinkwebresources.s3.amazonaws.com/www.jiwatraining.com.au/articles/Jiwa-JC-Invoicing-Jobs/2016-08-23_12-55-08.jpg

Alternatively, you can set the charge and cost amounts to match the WIP values by right mouse clicking on either of the WIP values on the transaction

https://austlinkwebresources.s3.amazonaws.com/www.jiwatraining.com.au/articles/Jiwa-JC-Invoicing-Jobs/2016-08-23_13-00-26.jpg

   

Auto Allocation

Move the the Auto Allocation tab and then select your Allocation Amount method

NOTE: All values entered in the Cost Allocation form are GST exclusive, GST if applicable to the job will be applied to the sales order.  Check the Settings tab on the job to confirm if GST is to be applied to or not.  

https://austlinkwebresources.s3.amazonaws.com/www.jiwatraining.com.au/articles/Jiwa-JC-Invoicing-Jobs/2016-08-23_13-12-29.jpg

 

Section

Description

Work in Progress

This section provides an overview of;

  • Current value in WIP,

  • WIP balance as at List Transaction date

https://austlinkwebresources.s3.amazonaws.com/www.jiwatraining.com.au/articles/Jiwa-JC-Invoicing-Jobs/2016-08-23_13-15-41.jpg

Allocation Amount

This section is used to set the basis of the automatic allocation, options are Charge or Cost. Fields are enabled or disabled depending on the method selected. Users can also select if the allocation is applicable to all cost centres or a single cost centre

https://austlinkwebresources.s3.amazonaws.com/www.jiwatraining.com.au/articles/Jiwa-JC-Invoicing-Jobs/2016-08-23_13-24-46.jpg

Allocation Method

This section is used to control how costs and charges are taken up in the allocation process and if any balances are to be written off. Fields are enabled or disabled based on the method of allocation selected.

https://austlinkwebresources.s3.amazonaws.com/www.jiwatraining.com.au/articles/Jiwa-JC-Invoicing-Jobs/2016-08-23_13-26-55.jpg

Enter either the charge or cost amount excluding GST in the Charge / Cost Amount field

Confirm if the allocation is applicable to a specific cost centre or all cost centres, the default is All Cost Centres

https://austlinkwebresources.s3.amazonaws.com/www.jiwatraining.com.au/articles/Jiwa-JC-Invoicing-Jobs/2016-08-23_13-29-43.jpg

Confirm how your costs/charges are to be taken up

https://austlinkwebresources.s3.amazonaws.com/www.jiwatraining.com.au/articles/Jiwa-JC-Invoicing-Jobs/2016-08-23_13-32-03.jpg

Select the Auto Allocate button

Then select OK to start the process

https://austlinkwebresources.s3.amazonaws.com/www.jiwatraining.com.au/articles/Jiwa-JC-Invoicing-Jobs/2016-08-23_13-34-37.jpg

Select OK at the completion prompt

https://austlinkwebresources.s3.amazonaws.com/www.jiwatraining.com.au/articles/Jiwa-JC-Invoicing-Jobs/2016-08-23_13-35-23.jpg

Each transaction is updated with a charge and cost value

https://austlinkwebresources.s3.amazonaws.com/www.jiwatraining.com.au/articles/Jiwa-JC-Invoicing-Jobs/2016-08-23_13-47-05.jpg

   

Processing Invoice

When you have confirmed the costs and charges to be allocated to the invoice click on the OK button at the bottom of the form.

https://austlinkwebresources.s3.amazonaws.com/www.jiwatraining.com.au/articles/Jiwa-JC-Invoicing-Jobs/2016-08-23_13-50-19.jpg

Add comments to your order as required and then Save and Process your sales order as usual.

https://austlinkwebresources.s3.amazonaws.com/www.jiwatraining.com.au/articles/Jiwa-JC-Invoicing-Jobs/2016-08-23_14-46-16.jpg

   

This video is best seen on the full screen. Just click on the icon at the bottom right of the video (see image below).

To exit full screen just press escape 

 

VideoFullScreen.jpg