Work in Progress > Job Postings > Part Billings

Part Billings

You use this program to invoice a customer based on work completed for a non-stocked job or to raise an asset in suspense for a capex requisition line linked to the job (see Asset Capex Items and Assets in Suspense).

At the same time the work in progress value is reduced and can be distributed to General Ledger codes of your choice.

Although you can also use this program to clear out residual work in progress values without invoicing a customer, this should rather be performed using the WIP Job Closure program.

If a General Ledger account used in this program requires General Ledger analysis (General Ledger Codes or GL Structure Definition), then the GL Analysis program is displayed when you post the transaction, enabling you to enter the analysis details or to select to enter them later (see General Ledger Integration). General Ledger analysis entries are always distributed in the local currency, irrespective of the currency in which the original transaction is processed.

Toolbar and menu

Field Description
Edit  
Change Posting Period Select this to change the General Ledger period to which you want to post the transaction entries (see Change posting Period).
Set Transaction Date Select this to change the date that must be used for the transaction.
[Note]

This facility should be used with caution - see Transaction Date.

Options  
Preferences Select this to customize processing by indicating default selections to apply for this program.
Job

You use this field to indicate the job for which you want to part-bill the customer.

If you selected the Preference: Automatic kit issue of job required, then you are prompted to process kit issues for the job.

You cannot access this field when the Part Billings program is run from the Billing Schedule Review program.

The job description is displayed alongside the Job field.

In addition, the wording "Hierarchical job" is displayed for hierarchical non-stocked jobs.

You can part bill a sub job, however part billing a sub job does not update the master job. If you want to update the master job, then you must issue the sub job to the master job using the Transfer Work in Progress program.

Play Select this to use the Multimedia program to view any multimedia objects assigned to the job.
O/s WIP Value Select this to indicate the posting period for which you want to clear outstanding work in progress amounts. You can select the current month or the previous two months.
Post

Select this to post entries to General Ledger. All outstanding amounts must be fully distributed before you can use this function. See Distribute COS and Billings.

This function is only enabled if you specified at least one quantity to release.

The Track Component Lots and Serials to Parent program is called from the Part Billings program if you selected the setup option: Require component to parent lot tracking and the non-stocked parent part is defined as lot traceable. This enables you to link the lot numbers of component parts to the parent part.

If the part billing is for a job for a capex requisition line (see Asset Capex Items), then an asset in suspense is created for the requisition line (see Assets in Suspense).

If you selected the option: Create new sales order, then the sales order which is created is numbered according to the Sales order numbering method defined (Sales Order Setup - Numbering tab).

If you selected the option: Create new sales order and against the Order Details you specified that the order must be created in a status of 8, then you are prompted to supply an invoice number if the option: Billing type is set to Post-billing with invoice (Sales Order Setup - General 1 tab) and the option: Order release - automatic invoice numbering is set to No (Sales Order Setup - Numbering tab).

If you did not select the option: Allow same number for different customers (Sales Order Setup - Numbering tab) then no duplicate invoice numbers are allowed within the current SYSPRO company. This applies irrespective of both the order and the invoice numbering methods selected.

If you selected the setup option: Print online delivery note when releasing quantity from back order (WIP Setup - Projects and Contracts tab), and you have an hierarchical job linked to an hierarchical sales order, then you can generate a delivery note online. You are also given the option to reprint the delivery note if required. The quantity on the delivery note is the current ship quantity (as per the sales order). The amount on the sales order is only reset when you print an invoice. Therefore if you release a quantity of one, but you previously released a quantity of two, then the delivery note is generated for a quantity of three until you issue an invoice for the quantity of two previously released.

Close Select this to exit the program.

Change posting Period

This screen is displayed when you select the Change Posting Period option from the Edit menu.

Field Description
Change Posting Period Select this to use the Change Posting Period program to indicate the General Ledger period to which you want to post the transaction entries.
Close Select this to return to the previous screen.
Change Posting Period  
Current period  
Month This indicates the period the General Ledger is currently in.
Year This indicates the year the General Ledger is currently in.

Transaction Date

You use the Set Transaction Date option from the Edit menu to indicate the date that must be used for the transaction.

Transaction Date

The transaction date defaults to the current system date, if you selected the option: Set accounting date to system date (Operator Maintenance). The transaction date is used as the journal start date and the inventory movement date.

For example, if the transaction extends over two days (e.g. the processing of the transaction begins before midnight and ends after midnight) then the actual date of posting is used instead of the date on which the program was loaded. In this example, the date after midnight is used as the transaction date.

[Note]

We recommend that you exercise caution when setting the transaction date.

A number of programs provide the facility to change the date that must be used for the transaction.

If you change the transaction date manually, then the entered date is used regardless of the actual date on which the transaction is posted.

Regardless of the date you enter, however, the transaction is posted to the General Ledger period that matches the period of the module at the time the transaction is posted (i.e. posting to the General Ledger is period-driven, not date-driven).

Because reports are date-driven, changes to the transaction date can affect the information that is included in the report.

Transaction Date

Field Description
OK Select this to accept the date you entered.
Cancel Select this to ignore the date entered and to return to the previous field.
Transaction date Enter the default transaction date to use for the transaction.

Example:

If you post a Part Billing transaction on 14 January 2004, but you set the transaction date to 31 December 2003, then the transaction is posted to the General Ledger period in January. However, if you print the Job Transaction Report for January (01/01/04 to 31/01/04), the transaction is not included on the report.

If you use this option to post additional costs to a job that is already marked as complete, and the date you enter differs from the original completion date for the job, then the system displays the following prompt:

Field Description
Change the job completion date to the transaction date?  
Yes Select this to change the job completion date to the date you entered using the Set Transaction Date function.
No Select this to leave the job completion date as the original job completion date.
Cancel Select this to abort the posting and ignore the transaction.

Part Billings

Field Description
General  
Job This indicates the job number for which you are processing the part billing.
Job description This indicates the description assigned to the job number.
Journal  
Hierarchical job This indicates whether the job is hierarchical.
Customer This indicates the customer assigned to the job.
Customer description This indicates the customer's name.
Sales order This indicates the number of the sales order linked to the job.
Sales order status This indicates the status of the sales order linked to the job. See Status Codes.
WIP value This indicates the work in progress value of the job.
Quantity outstanding This indicates the quantity still outstanding for the job.
Quantity

You use this field to indicate the quantity of the non-stocked item that has been manufactured.

For hierarchical jobs linked to a sales order, you use this field to indicate the quantity by which you want to increase the quantity manufactured for the job. It is the quantity which must be moved from back order to ship on a pre-existing sales order line(s). If an order does not exist, it becomes the quantity ordered and shipped on a new sales order.

You cannot access this field when the Part Billings program is run from the Billing Schedule Review program.

If the job is linked to a sales order and the quantity you enter in this field is greater than the quantity on backorder against the sales order, a warning is displayed. You are given the opportunity to increase the sales order quantity or to leave it as it is. If you select to increase the order quantity, then the order quantity is increased to match the quantity received plus the quantity already shipped. If you select to leave the quantity as is, then the quantity still on back order is added to the quantity to ship.

You cannot enter a quantity which is greater than the Quantity outstanding or which is greater than the Quantity outstanding less the Quantity in inspection if the activity: WIP Allow over-receipts for jobs is set to Denied against your operator code (Operator Maintenance - Security tab).

Quantity to bill

This field is displayed only for hierarchical jobs and if a zero quantity was entered at the Quantity field.

It is used to release non-merchandise lines on a sales order (e.g. escalation charges, refunds, etc) which have no bearing on the quantity of the product still to be produced.

WIP value based on Indicate the source to use for the outstanding WIP value.
FieldDescription
Outstanding WIPSelect this to indicate that the outstanding work in progress must be used as the source of the work in progress value.
Original expected costsSelect this to indicate that the original expected costs must be used as the source of the work in progress value.
Actual costSelect this to indicate that the actual cost must be used as the source of the work in progress value.
Manual entrySelect this to manually enter the WIP material and WIP labor values required.
WIP material value Indicate the value by which the material portion of work in progress must be reduced.
[Note]

Although values are separated into material and labor amounts when reducing the work in progress value, at the time of posting them to General Ledger they are combined and posted as one figure.

This field is only enabled if the WIP value is based on Manual entry.

WIP labor value You use this field to indicate the value by which the labor portion of work in progress must be reduced.

This field is only enabled if the WIP value is based on Manual entry.

Value basis This enables you to indicate the basis for the material/labor values entered.

If the WIP value based on is set to Original expected costs or Actual cost, then the Value basis is set to Unit.

If the WIP value based on is set to Outstanding WIP, then the Value basis is set to Total.

FieldDescription
UnitSelect this if the material/labor values entered are based on the unit quantity that has been manufactured.
TotalSelect this if the material/labor values entered are based on the total quantity that has been manufactured.
Action

This option is only available if you entered a customer in the Customer field when you created the job Job Entry. The customer assigned to the job is only validated when a part billing is made.

For hierarchical jobs, the sales order number linked to the job is indicated at the Linked to s/o field. In addition, all the sales order options (i.e. No sales order link, Create new sales order, Update sales order and Append to sales order) are disabled as you can only update the sales order(s) to which the hierarchical job is linked.

You cannot part bill a job linked to a sales order for which a delivery note has already been printed if the activity: S/O Maintain s/order after d/note print is denied against your operator code (Operator Maintenance - Security tab) and/or maintenance of sales orders after the delivery note is printed is denied (Sales Order Setup - Printing tab).

Field Description
No sales order link Select this if the job is not linked to a sales order.
Create new sales order

Select this to create a new sales from the job.

Each new sales order contains one or more sales order detail lines, depending on the invoice method selected.

You use the Order Details function to enter the order details.

After creating a new order, you can immediately maintain that sales order and add lines or comments. In addition, all the facilities of Sales Order maintenance are available.

[Note]

You cannot create a new sales order if a negative value was entered at the Quantity field.

You cannot create a sales order if the customer assigned to the job is not held on file. In addition, if the customer fails a credit check then the order is optionally placed into suspense.

Update sales order

Select this to ship the part-billed quantity of a previously back-ordered sales order line, so you can deliver the goods and/or invoice the customer.

You can only select this option if a back-ordered sales order line exists for the job.

A job created from a back-ordered sales order normally contains one non-stocked line, with the order quantity being placed into the back order quantity field.

Once you have manufactured a quantity of the finished part and you part-bill the quantity, then the entered part-billing quantity is moved from the back-order quantity to the ship quantity field. You are now able to deliver and/or invoice the goods to the customer. You can also change the order status and unit cost of the non-stocked line.

Append to sales order

Select this to add detail lines to an existing sales order. You will not be required to enter any sales order header details.

When appending details lines to an existing order, the program defaults to using the last sales order created for the job.

You cannot append lines to a sales order which is in a status of In process, Cancelled or Complete.

You can append the non-stocked job to the same order it is currently linked to providing there is nothing on backorder or ship for the non-stocked code.

Create a credit note

Select this to process a credit note for a non-stocked item or a hierarchical job. You can also process a negative billing from within the Part Billings program, but processing a credit note is preferable as this creates an audit trail linking the credit note to the original invoice.

You use the Order Details function to enter the credit note details.

This option is normally only enabled when you enter a negative value in the Quantity field. However, you can process a credit note for a zero quantity, provided that there is a link to a sales order with a miscellaneous line, which you can then credit. Note that you process the credit note with a positive value which will be credited.

For both a credit note and a negative billing, the selling price is derived from the sales order price of the sales order created for the job. If the sales order does not exist (e.g. it may have been purged), then the selling price against the job is used.

Any deposits or retentions which require adjusting must be manually adjusted.

When you process a credit note using the Sales Order Entry program for an existing invoice for a non-stocked item linked to a job, then the credit note is linked to the job according to your selection at the preference:Update non stocked jobs when creating a credit note (see Preferences). When you process a credit note from the Part Billings program, the credit note is automatically linked to the job.

Billing method
[Note]

If you set the job to Complete when the option: Calculate and check gross profit in part billings is selected (WIP Setup), then the billing method defaults to Selling price and cannot be changed. This is so that the program can calculate the gross profit.

Field Description
Progress payment

Select this to generate an order value based on the value of work in progress not yet billed to the customer. This value may be incremented by markup percentages and/or profit percentage as defined against the job.

This method usually creates a non-stocked sales order detail line, where the unit cost is calculated as the value by which work in progress is reduced, divided by the quantity being part billed.

The stock code is defined as the stock code of the job, and the stock description may be entered at the time of entering the sales order details.

It is assumed that the quantity part-billed is the sales order quantity and the quantity to ship.

However, if the quantity being part-billed is zero then a miscellaneous charge line is created instead, where the value of the line is the order value, and the cost of sales is the value by which work in progress is reduced.

Selling price

Select this for the order value to be determined by multiplying the quantity part-billed by an entered selling price. This defaults to the selling price defined against the job.

This method usually creates a non-stocked sales order detail line where the unit cost is calculated as the value by which work in progress is reduced, divided by the quantity being part billed.

The stock code is defined as the stock code of the job, and the stock description may be entered at the time of entering the sales order details.

The assumption is that the quantity part-billed will be the sales order quantity and the quantity to ship.

However, if the quantity being part billed is zero, then a miscellaneous charge line is created instead, where the value of the line is the order value, and the cost of sales is the value by which work in progress is reduced.

Line details

Select this to generate multiple sales order lines. The first line of the order is a comment line describing the job from which was generated the line details.

A detail sales order line is created for each material allocation (attached to the job) still to be billed. The line is treated as a non-stocked, regardless of whether the allocation is for a stocked entry. The prevents the Sales Order Entry program from reducing inventory levels again for the stocked items.

Against the sales order details, you will need to enter a valid product class, commission code and tax details which will be used for each non-stocked item found.

You can only select this method when the option: Calculate and check gross profit margin is deselected (WIP Setup - General 2 tab).

Order details Select this to append detail lines to an existing sales order (see Sales Order Number) or to assign sales order header information for the part billing if a link to sales order is required (see Order Details).
Additional reference

Enter an additional reference or notation.

The text you enter here is printed on the WIP Part Billings Distribution report and is displayed when you select the WIP Booked tab of the WIP Query.

Job complete

Select this to indicate that the job is complete.

The program checks that there are no outstanding purchase orders, operations, or material allocations for the job.

When you set a job to complete:

  • outstanding operations are also set to complete, unless the option: Work in Progress load levelling required (WIP Setup - General 1 tab) is enabled.

  • all allocations are set to complete and any reserved stock for them is released. This applies when the Reserve stock for allocations option is enabled (WIP Setup) and stock was reserved for the allocation.

[Note]

Completed jobs are only purged by the WIP Period End program if there are no outstanding values held against the job.

Lot number

Enter a lot number for the non-stocked item you are part billing.

This field is only enabled if:

  • you have not selected the option: Automatic lot numbering (Lot Traceability Setup). If you indicated that automatic lot numbering is required, then the lot number is generated automatically and you can only access the Concession and Certificate fields.
  • if a non-zero entry was made at the Quantity field
  • you indicated that the finished stock item of the job is a traceable item (Browse on Jobs).

The lot number must not already exist, unless you are crediting an existing sales order (i.e. the quantity being part billed is negative), in which case the lot number must exist.

For a positive quantity being part billed, this creates a lot number for a non-stocked item. The warehouse code against this lot number is designated as **. In addition, the sales order line created for the non-stocked item is assigned to the lot number entered, so that a subsequent invoice reduces stock on hand of that lot number to zero.

Concession Enter a concession number if applicable.

This applies only if a non-zero entry was made at the Quantity field, and the finished stock code of the job is a traceable item (Browse on Jobs).

Certificate Enter the certificate number. The certificate number serves to identify the certification of your product to your customer. This number can be printed on your delivery note or invoice to the customer.

This applies only if a non-zero entry was made at the Quantity field, and the finished stock code of the job is a traceable item (Browse on Jobs).

Session details  
Transaction date This indicates the transaction date to be used for the transaction (see Transaction Date)
Posting period This indicates the period into which the transaction will be posted.

Sales Order Number

This screen is displayed when you select the Edit option at the Order details field and you selected the Action: Append to sales order. This enables you to indicate the sales order number to which you want to add detail lines.

Field Description
Continue Select this to accept the sales order number you entered and to return to the previous screen.
Close Select this to ignore any entry you made and to return to the previous screen.
Append to sales order  
Order number to append Indicate the order number to which you want to append lines.

Margin Checking

This screen is displayed when you select the Edit option at the Order details field if all of the following are true:

  • the option: Calculate and check gross profit in part billings (WIP Setup - General 2 tab) is selected
  • the job is set to complete
  • you selected to create a new sales order

The screen enables you to perform a margin check and does not update any data (i.e. it is used for information purposes only).

Field Description
Continue Select this to perform the margin check.
Close Select this to return to the previous screen.
Costs to date  
Material This indicates the current material costs of the job.
Labor This indicates the current labor costs of the job.
Markup percentage Indicate the markup percentages you want to add to the cost.

A warning is displayed if the percentages you enter are not within the percentages defined at the option: Calculate and check gross profit in part billings (WIP Setup - General 2 tab).

[Note]

The percentages you enter are merely used to recalculate what the selling price and gross profit with those percentages.

If these are the percentages you want to use, then you need to enter them in the Sales Order Billing Details pane (i.e. the percentages you enter here are not automatically used).

Material Indicate the markup percentage you want to add to the material cost.
Labor Indicate the markup percentage you want to add to the labor cost.
Details  
Selling price This indicates the calculated selling price of the job according to the Markup percentages you entered in the previous fields.
Gross profit

This indicates the calculated gross profit using the Markup percentages entered.

The gross profit is the difference in value between the accumulated costs to date and the selling price of the job.

Order Details

The pane is enabled when you select theEdit option at the Order details field and you selected the Action: Create new sales order.

[Note]

The options and field in this pane are enabled when you select the Edit option at the Order details field in the Part Billings pane.

Field Description
Order Header

Select this to use the Sales Order Header Maintenance program to maintain the sales order header information.

If you selected the option: Create new sales order and against the Order status you specified that the order must be created in a status of 8, then you can enter an invoice number against the Order Header if:

  • the option: Request when order released from status 4 is set to Invoice (Sales Order Setup - General 3 tab)
  • the option: Order release - automatic invoice numbering is set to No or Use delivery note (Sales Order Setup - Numbering tab)
  • the option: Order number moved to invoice number is not selected (Sales Order Setup - General 3 tab)
Maintain This order This option is displayed when you select the Action: Update sales order.

Select this to use the Sales Order Entry program to maintain the sales order.

The following warning message is displayed by the Sales Order Entry program when you select this option: "There are one or more jobs attached to this order. Certain maintenance may invalidate these links. Do you wish to continue?"

This field is not enabled if you selected the preference: Apply recommended cost automatically.

Apply Recommended This option is displayed when you select the Action: Update sales order.

Select this to apply the value in the Unit cost - Recommended field to the Unit cost - New field.

This field is not enabled if you selected the preference: Apply recommended cost automatically, because the recommended cost will already have been calculated.

Sales Order Details

This pane is displayed if the Billing method is set to Progress payment or Selling price and you selected a sales order link.

Field Description
General  
Customer purchase order Enter the customer's purchase order reference details if required.
Order status Select the status to which you want to set the order. See Status Codes.
Salesperson The salesperson assigned to the customer is displayed here as the default.
[Note]

You must specify a valid salesperson before you will be allowed to post the transaction.

Order value Indicate the amount you want to bill the customer.
Selling price This indicates the selling price of the finished item as defined against the job (Job Entry).
Customer currency This indicates the currency of the customer and is displayed for foreign currency customers.
Line details  
Stock code This indicates the code of the item you are billing.
Stock code description This indicates the description for the code.

If the item is non-stocked, then this defaults to

the description entered when the job was created, but can be changed here.
Product class Indicate the product class to use for the billing.
[Note]

A valid product class must be entered before you will be allowed to post the transaction.

Commission

Assign a commission code to the non-stocked line.

You can only access this field if you indicated that commission must be calculated, and that the calculation must use the code held against the price (Sales Order Setup).

Taxable Select this to apply tax to the billing.
Tax code

Indicate the tax code to apply.

If you are using the EC VAT system, you will have to enter EC information when performing part billings for EC customers.

GST taxable Select this to apply GST.
GST code Indicate the GST code to apply.
Credit These fields are only enabled for credit notes.

If you selected option: Ask reason code when entering new credit notes (Sales Order Setup) then you must enter a reason code.

Credit reason Indicate the reason code for the credit.
Credit reason description This is the description of the Credit reason code selected.
Adjust qty on backorder for linked SO

You can process a credit note for an invoice you have not yet printed, by entering a negative Quantity and selecting the Update sales order action.

If you select this option, then a new line is created on the original sales order with a credit in the back order quantity field to adjust the quantity on back order. This enables you to correct mistakes made on an hierarchical sales order, by adjusting the original order back to its original state.

If you do not select this option, then the original sales order quantity is not reversed and the contract will not be fully billed. For example, if you invoiced a quantity of 1 out of a total contract quantity of 5 and then reversed the invoice, Part Billings will not put back the 1 unless this option is selected. This means that the sales order is 20% short and you will only part bill 80% of the original contract.

to reverse the original sales order quantity. Put another way, if you invoice 0.2 of 1.00, then later discover you need to reverse 0.2, part billings does not put back the 0.2. The consequence is that the sales order is 20% short, or you are only part billing 80% of the original contract.

This option is only available when processing a credit for an hierarchical order with a job is linked to a valid and incomplete sales order. If the sales order is complete and a credit note is required, then you first need to set the order to incomplete in Sales orders.

This option is not available if you accessed the Part Billings program by processing a credit note for an hierarchical sales order using the Sales Order Entry program. The back order quantity for the linked sales order would have been adjusted using the SO Order Lines for Credit Note program.

Sales Order Billing Details

This pane is displayed if the Billing method is set to Line details and you selected a sales order link.

Field Description
General  
Customer purchase order Enter the customer's purchase order reference details if required.
Order status Select the status to which you want to set the order. See Status Codes.
Salesperson The salesperson assigned to the customer is displayed here as the default.
[Note]

You must specify a valid salesperson before you will be allowed to post the transaction.

Stocked lines to be valued at For any selection made here the quantity issued is the quantity not yet billed to the customer and the cost of sales is based on the actual cost of the material issued to the job.
FieldDescription
List priceSelect this to value material lines at the list price of the item. The value of each material line created is calculated as follows:
  • Stocked items: The quantity issued multiplied by the list price of the item.
  • Non-stocked items: The quantity issued multiplied by the unit cost (as defined against the allocation) marked up by the Material markup % figure.
Markup percentageSelect this to value both stocked and non-stocked lines at the quantity issued multiplied by the unit cost marked up by the entry made at the Markup % field.
Customer priceSelect this to value material lines at the price held against the customer. The value of each material line created is calculated as follows:
  • Stocked items: The quantity issued multiplied by the price as determined by normal pricing mechanisms applicable to Sales Order Entry, including line discounts and any pricing contracts in force.
  • Non-stocked items: The quantity issued multiplied by the unit cost (as defined against the allocation) marked up by the Material markup % figure.
Markup percentage  
Material Indicate the material markup percentage to be applied to the line. This defaults to the percentage entered at the time the job was created.
Labor Indicate the labor markup percentage to be applied to the line. This defaults to the percentage entered at the time the job was created.
Details applied for non-stocked lines  
Product class Indicate the product class to be assigned to the non-stocked line.
[Note]

You must specify a valid product class before you will be allowed to post the transaction.

Apply product class to stocked lines

Select this to apply the product class specified for non-stocked lines to stocked lines as well.

Otherwise the product class held against the stock item is used.

Commission

Assign a commission code to the non-stocked line.

You can only access this field if you indicated that commission must be calculated, and that the calculation must use the code held against the price (Sales Order Setup).

Details applied for operations  
Default product class Indicate the default product class to be assigned to the operation line.
Create details for each operation

Select this to create a miscellaneous charge line for each unbilled operation.

Otherwise a single miscellaneous charge line is created for all unbilled operations.

The lines are created with a default product class of _OTH and the description defaults to your entry made at the preference: Comment text for operations.

Summarize by product class

Select this to summarize all unbilled operations by product class.

The product class defined against each work center used in each operation is used. If this is blank then the default product class is used.

The program creates miscellaneous charge lines for the summarized operations. The description assigned to each charge line will be the product class description. If this is blank or the product class is not found, then this defaults to your entry made at the preference: Comment text for operations.

You can only access this option if you selected the option: Create details for each operation.

Use labor service charges

Select this to apply a labor service charge to the current sales order line.

The service charge code against the work center (Browse on Work Centers) is used to determine the charge. If no service charge code is defined against the work center, then the default code defined at the Default labor service charge code field (WIP Setup - General 2 tab), is used to determine the charge.

This field is only enabled if labor service charges are set to Prompt operator (WIP Setup - General 2 tab). If labor service charges are set to Required, then this field is automatically selected and cannot be deselected.

Refer to Labor Service Charges in Part Billings for additional information.

Additional  
Copy narrations attached to labor allocations

Select this to copy labor allocation narrations to a sales order when creating the sales order with the billing method of Line details.

This option is only enabled when you select the options: Create details for each operation or Use labor service charges.

Copy narrations attached to mat allocs Select this to copy material allocation narrations to a sales order when creating the sales order with a billing method of Line details.
Seq mats with associated labor allocs

This option is only enabled when you select the options:Create details for each operation or Use labor service charges.

If you select this option, then when creating a sales order with the billing method: Line details, the material allocations linked to labor allocations are attached to the sales order after the labor allocations to which they are linked. If materials use offset days, then these materials are inserted before the labor allocation lines.

For example, a job has the following:

Operation 1

Operation 2

Component A uses offset days

Component B is required for Operation 1

Component C is required for Operation 1

Component D is required for Operation 2

Component E is required for Operation 2

If you select to sequence materials with labor allocations, then the sales order lines are created as follows:

1 Component A

2 Miscellaneous operation line 1

3 Component B

4 Component C

5 Miscellaneous operation line 2

6 Component D

7 Component E

Tax details for non-stocked/operations The tax details entered for non-stocked items applies equally to all operation charge lines created.
Taxable Select this to apply tax to the billing amount.
Tax code

Indicate the tax code to apply to the billing.

If you are using the EC VAT system, you will have to enter EC information when performing part billings for EC customers.

GST taxable Select this to apply GST to the billing amount.
GST code Indicate the GST code to apply to the billing.
Labor Service Charges in Part Billings

Labor service charges are only applied when you create a sales order with the Billing method of Line details.

Before you can process labor service charges from the Part Billings program, you must have done the following:

  • Defined at least one service charge code for labor using the Service Charge Maintenance program.
  • Selected Required or Prompt operator against the setup option: Labor service charge (WIP Setup - General 2 tab).
  • Defined a default service charge code for labor at the Default labor service charge field (WIP Setup - General 2 tab).
  • Used the Browse on Work Centers program to optionally define a service charge code for labor against one of more work centers
  • Used the Job Entry program to create a job with at least one operation.

Labor allocations are processed is as follows:

  • When processing labor allocations to add to a sales order and the option: Use labor service charges is selected then:

    For normal allocations, a miscellaneous charge line is created for each labor allocation. This follows the normal rules for processing that type of service charge.

    • The charge code is taken from the work centre file/table. If this is not defined, or the work center is not on file, the system default is used.
    • The quantity is taken as the labor time units.

      The labor time units are calculated as:

      Total time issued to date (sum of run time issued, setup time issued, startup time issued and teardown time issued) LESS Total time billed to date.

    • The price per unit is taken from the service charge.
    • The cost is calculated from the Total labor cost (value issued to date less value billed to date).

      Note that usually when quantity is involved, the cost is a unit cost, but in this case it is always the outstanding amount from the allocation.

  • When processing subcontract allocations and the option: Use labor service charges is selected then a check is made for a charge code on the associated work centre. If there is no charge code, then a charge line is created by applying the markup to cost.

    If there is a charge code, then a miscellaneous charge line is created which follows the normal rules for processing that type of service charge.

    • The charge code is taken from the work centre file/table.
    • The quantity is the quantity completed for the subcontract operation.

      This is calculated as:

      Total quantity completed less total quantity billed to date. The result is multiplied by the subcontract quantity per if the quantity per is non-zero.

    • The price per unit is taken from the service charge.
    • The cost is calculated from the Total labor cost (value issued to date less value billed to date).

      Note that usually when quantity is involved, the cost is a unit cost, but in this case it is always the outstanding amount from the allocation.

Update Sales order

This pane is displayed when you select the Action - Update sales order.

Field Description
General  
Sales order This indicates the sales order number you are updating.
Current status This indicates the current status of the sales order. See Status Codes.
New order status This enables you to indicate the status to which you want to set the sales order.
Unit cost  
Recommended This indicates the recommended unit cost amount. This is based on your selection at the WIP value based on field in the Part Billings pane.
New You use this field to indicate the new unit cost to use for the billing.

By default, the new unit cost is assumed to be the current unit cost plus the unit value of the work in progress to be distributed.

GL Distribution

This editable listview enables you to assign any outstanding WIP value for the job to specific General Ledger codes.

You can also use the listview to change any details for transaction lines that have been entered, or delete the entry.

If you selected the option: Tracking cost only, then the outstanding amount for each head/section is automatically distributed to the ledger code you defined in the Cost ledger code field for that head/section (Hierarchies for Job).

When part billing a completed job where additional material or labour has been posted after the job was completed, you need to select the Post function to enable the GL Distribution pane.

Field Description
Delete

Select this to remove the listview entry currently highlighted.

Apply Undistributed Select this function to assign the total outstanding amount (displayed in the Undistributed field) to the specified ledger code.
G/L Distribution  
Ledger code

Indicate the ledger code against which the amount must be posted.

This defaults to the account indicated at the preference: Default G/L distribution account.

Your entry here is validated only if the Work in Progress module is integrated to General Ledger in detail or summary (General Ledger Integration).

If you are part billing a hierarchical order and a Cost ledger code is defined against the head/section of a hierarchy (Hierarchies for Job), then that ledger code is displayed in this field.

If the job is for a Capex item, then the General Ledger distribution account defaults to the Asset Clearing account if General Ledger integration is enabled. The account indicated at the preference: Default G/L distribution account is ignored.

If the Ledger account you enter requires General Ledger analysis (General Ledger Codes or GL Structure Definition), then the GL Analysis program is displayed when you post the transaction, enabling you to enter the analysis details.

Description This indicates the description of the ledger code selected.
WIP ledger code This indicates the Work in Progress
Amount You use this field to indicate the amount you want to distribute.
Undistributed amount This indicates the value that must still be distributed to ledger codes. It is updated for each listview entry added, deleted or changed.

Preferences

You use the Preferences option from the Options menu to customize processing by indicating default selections to apply for this run of the program.

Field Description
Save Select this to save your selections against your operator code. Your selections will remain in force until changed.
Close Select this to save the preferences for the current run of the program only.

Preferences

Field Description
General  
Default WIP value based on This enables you to indicate the default setting for the option: WIP value based on in the Part Billings pane.
FieldDescription
Outstanding WIPSelect this to indicate that the outstanding work in progress must be used as the source of the work in progress value.
Original expected costsSelect this to indicate that the original expected costs must be used as the source of the work in progress value.
Actual costSelect this to indicate that the actual cost must be used as the source of the work in progress value.
Sales order creation  
Default order status

Indicate the order status to use when creating a new sales order.

The following statuses are available:

  • 8 - To invoice
  • 3 - Released back order
  • 4 - In warehouse
  • S - Suspense
Default billing method Indicate the preferred billing method to use when creating a new sales order, or appending lines to an existing sales order.
Line detail defaults for SO creation  
Default product class for operations Indicate the product class to use when creating miscellaneous charge lines for operations.
Comment text for operations You use this field to indicate the text you associated with operation miscellaneous charge lines.
Create details for each operation Select this to create a miscellaneous charge line for each operation allocated to the job.
Summarize by product class Set the default setting you require for the option: Summarize by product class in the Sales Order Billing Details screen.
Use labor service charges

Set the default setting you require for the option: Use labor service charges in the Sales Order Billing Details pane.

This preference is only enabled if labor service charges are set to Prompt operator (WIP Setup - General 2 tab).

Copy narrations attached to labor allocs Set the default setting you require for the option:Copy narrations attached to labor allocations in the Sales Order Billing Details pane.
Copy narrations attached to mat allocs Set the default setting you require for the option: Copy narrations attached to material allocations in the Sales Order Billing Details pane.
Sequence mats with assoc labor allocs Set the default setting you require for the option: Sequence materials with associated labor allocations in the Sales Order Billing Details pane.
Sales order update  
Default order status

Indicate the default status to which an existing sales order must be set when the order is updated.

This preference is applied when you update the sales order but do not use the Order Details pane.

[Note]

If an order is in Suspense, then the status cannot be updated using the Part Billings program, irrespective of your selection at this option.

The following options are available:

  • No default

    Select this to leave the sales order in its current status.

  • 8 - To invoice
  • 3 - Released back order
  • 4 - In warehouse
  • S - Suspense
Apply recommended cost automatically

Select this to apply the recommended cost when updating a sales order as long as the recommended cost is valid.

This preference enables you to apply the recommended cost to the sales order without having to use the Order Details screen. If you select this preference, then the Apply Recommended function and the Unit cost - New field on the Update Sales Order screen are disabled, because the recommended cost will already have been calculated and you cannot change the new cost.

G/L distribution  
Default G/L distribution account

Indicate the default ledger account to be used when distributing entries to General Ledger.

This does not apply when processing a job for a Capex item. In that case, your entry here is ignored and the General Ledger distribution account defaults to the Asset Clearing account if General Ledger integration is enabled.

Kit issue  
Automatic kit issue of job required Select this to be able to apply kit issues for outstanding materials and labour to a job for a non-stocked item during the part billing process.

Notes and warnings

eSignature considerations

Electronic Signatures provide security access, transaction logging and event triggering. This enables you to increase control over your system changes.

Access to the following eSignature transactions within this program can be restricted at Operator, Group, Role or Company level. You configure this using the Electronic Signatures program.

eSignature Transaction Description
WIP Part billings

Controls access to the Post function in the Part Billings program.

Inserting Application Help

You would typically follow this procedure to display help for the current program in a customized pane that can be pinned to the program window.

Information includes step-by-step instructions for the various functions available within the program, including a brief overview of what the program does, what setup options are required and how to personalize the program.

  1. Open the program for which you want to insert application help into a customized pane.

    This functionality is only available for a program that has panes.

  2. Right-click any form field.

    You can also click the triangle menu icon that appears in the title area of a pane.

  3. Select Insert Application Help from the context-sensitive menu.

    The application help appears in a pane within your program. You can reposition the pane using the docking stickers or pin it to the program window.

Removing the Application Help pane

If you no longer want to display application help in a pane for your current program, you can simply remove it.

  1. Select the Close icon in the right-hand corner of the application help pane.

  2. Confirm that you want to delete the pane.