Coins ERP+ users can use Cost and Billing Splits/Transfers functionality in the Job Status module to trace original transactions and transactions that were split/transferred from the original transaction.
Cost and Billing amounts can be transferred from one Cost Type to another.
Cost and Billing amounts can be split across multiple Cost Types.
Traceability of the original transaction for which the cost/job amount has been transferred/split and all the transactions created as a result of a cost/job transfer/split.
Cost and Billing Splits/Transfers – Parameters
The JC parameters available for this functionality are listed in the table below.
Parameter | Description |
TRCEMOVE | Trace Cost and Billing Transfer/Split? Y = When Cost/Billing is transferred from one WBS/Cost Type to another WBS/Cost Type or when Cost/Billing is split across multiple WBS/Cost Types, the original transaction is untouched and new positive and negative transactions are created. N = When Cost/Billing is transferred from one WBS/Cost Type to another WBS/Cost Type or when Cost/Billing is split across multiple WBS/Cost Types, the Cost/Billing amount is transferred from the original transaction to a new transaction. Hence the original transaction disappears from the Cost Transaction browse. Related Parameters: JC/WBSMOVE, JC/CHEADMOVE |
CHEADMOVE | Allow Cost Type Transfer/Split Whether to Allow Cost and Billing transactions of posted transactions to be transferred/split between cost types. Related Parameter: JC/WBSMOVE |
TYPEMOVE | Transaction type to be used for the transactions created as a result of Cost/Billing transfer/split. The transaction type to be used for transactions resulting from a Cost/Billing transfer or Cost/Billing split. Related Parameters: JC/WBSMOVE, JC/CHEADMOVE, JC/TRCEMOVE |
Cost and Billing Splits/Transfers – Cost Splits/Transfers
This section describes functionality related to Cost Splits and Cost Transfers.
Cost Split
A Cost Split action exists on the Transactions browse in Job Status > Inquiries > Single Job Inquiry. This action is enabled under the following conditions:
The Allow Cost/Billing Transfer field is selected on the Job.
Either parameter JC/WBSMOVE or JC/CHEADMOVE is enabled.
Selection Screen
When JC/CHEADMOVE is set to N and JC/WBSMOVE is set to Y, the information shown on the Cost Split selection screen depends on the following:
If the Job uses Sections, the Section field is visible and enabled.
If the Job uses Activities, the Activity field is visible and enabled.
If the Job uses both Sections and Activities, both of those fields are visible and enabled, as shown in the screen below.
Screenshot: Cost Split - Section and Activity
When JC/CHEADMOVE is set to Y and JC/WBSMOVE is set to N, the Cost Type field is visible instead of the Section and Activity fields. This Cost Type defaults from the Cost Type of the selected transaction.
Screenshot: Cost Split - Cost Type
When JC/CHEADMOVE and JC/WBSMOVE are both set to Y, the selection screen displays a Section field (when the selected Job uses Sections), an Activity field (when the selected Job uses Activities), and Cost Type details. The Section, Activity, and Cost Type default from the Section, Activity, and Cost Type of the selected transaction.
Screenshot: Cost Split - Section, Activity, Cost Type
Processing
You can split costs across multiple Cost Codes under the following conditions:
Parameter JC/CHEADMOVE is set to Y.
The Allow Cost/Billing Transfer field is selected on the selected Job.
The resulting Cost Code has the same GL Analysis as the Cost Code of the original transaction.
When JC/TRCEMOVE is set to Y, processing occurs as follows:
The original transaction is updated with the sequence type based on the following format: “COSTTRACE. <Job Number>. <Job Phase>”.
A Cost transaction with the same Cost Code as the original transaction is created with the same amount as the original transaction amount, but it appears with a negative sign. If JC/TYPEMOVE is not blank, the transaction type on the newly created cost transaction comes from the parameter value. It is updated with the same sequence type as the original transaction.
New transactions are created with the new Cost Codes using the same amount entered on the original transaction amount. If JC/TYPEMOVE is not blank, the transaction type on the newly created cost transaction comes from the parameter value. This transaction is updated with the same sequence type as the original transaction.
Additional transactions created by splitting the already split transactions and using the same sequence type as the original transaction.
Cost Transfer
A Cost Transfer action exists on the Transactions browse in Job Status > Inquiries > Single Job Inquiry. This action is enabled under the following conditions:
The Allow Cost/Billing Transfer field is selected on the Job.
Either parameter JC/WBSMOVE or JC/CHEADMOVE is enabled.
Selection Screen
When JC/CHEADMOVE is set to N and JC/WBSMOVE is set to Y, the information shown on the Cost Transfer selection screen depends on the following:
If the Job uses Sections, the Section field is visible and enabled.
If the Job uses Activities, the Activity field is visible and enabled.
If the Job uses both Sections and Activities, both of those fields are visible and enabled, as shown in the screen below.
Screenshot: Cost Transfer - Section and Activity
When JC/CHEADMOVE is set to Y and JC/WBSMOVE is set to N, the Cost Type field is visible instead of the Section and Activity fields.
Screenshot: Cost Transfer - Cost Type
When JC/CHEADMOVE and JC/WBSMOVE are both set to Y, the selection screen displays a Section field (when the selected Job uses Sections), an Activity field (when the selected Job uses Activities), and a Cost Type field. If a single transaction is selected for Cost Transfer, the Cost Type field defaults to the Cost Type of the selected transaction.
Screenshot: Cost Transfer - Section, Activity, Cost Type
Processing
You can transfer costs from one Cost Type to another Cost Type under the following conditions:
Parameter JC/CHEADMOVE is set to Y.
The Allow Cost/Billing Transfer field is selected on the selected Job.
The resulting Cost Code has the same GL Analysis as the Cost Code of the original transaction.
When JC/TRCEMOVE is set to Y, processing occurs as follows:
The original transaction is updated with the sequence type based on the following format: “COSTTRACE. <Job Number>. <Job Phase>”.
A Cost transaction with the same Cost Code as the original transaction is created with the same amount as the original transaction amount, but it appears with a negative sign. If JC/TYPEMOVE is not blank, the transaction type on the newly created cost transaction comes from the parameter value. It is updated with the same sequence type as the original transaction.
A new transaction is created with a new Cost Code using the same amount entered on the original transaction amount. If JC/TYPEMOVE is not blank, the transaction type on the newly created cost transaction comes from the parameter value. This transaction is updated with the same sequence type as the original transaction.
Cost and Billing Splits/Transfers – Billing Splits/Transfers
This section describes functionality related to Billing Splits and Billing Transfers.
Billing Split
A Billing Split action exists on the Billing browse in Job Status > Inquiries > Single Job Inquiry. This action is enabled under the following conditions:
The Allow Cost/Billing Transfer field is selected on the Job.
Either parameter JC/WBSMOVE or JC/CHEADMOVE is enabled.
Selection Screen
When JC/CHEADMOVE is set to N and JC/WBSMOVE is set to Y, the information shown on the Billing Split selection screen depends on the following:
If the Job uses Sections, the Section field is visible and enabled.
If the Job uses Activities, the Activity field is visible and enabled.
If the Job uses both Sections and Activities, both of those fields are visible and enabled, as shown in the screen below.
Screenshot: Billing Split - Section and Activity
When JC/CHEADMOVE is set to Y and JC/WBSMOVE is set to N, the Cost Type field is visible instead of the Section and Activity fields. This Cost Type defaults from the Cost Type of the selected transaction.
Screenshot: Billing Split - Cost Type
When JC/CHEADMOVE and JC/WBSMOVE are both set to Y, the selection screen displays a Section field (when the selected Job uses Sections), an Activity field (when the selected Job uses Activities), and Cost Type details. The Section, Activity, and Cost Type default from the Section, Activity, and Cost Type of the selected transaction.
Screenshot: Billing Split - Section, Activity, Cost Type
Processing
You can split Billing across multiple Cost Codes under the following conditions:
Parameter JC/CHEADMOVE is set to Y.
The Allow Cost/Billing Transfer field is selected on the selected Job.
The resulting Cost Code has the same GL Analysis as the Cost Code of the original transaction.
When JC/TRCEMOVE is set to Y, processing occurs as follows:
The original transaction is updated with the sequence type based on the following format: “REVTRASPLIT. <Job Number>. <Job Phase>”.
A Billing transaction with the same Cost Code as the original transaction is created with the same amount as the original transaction amount, but it appears with a negative sign. If JC/TYPEMOVE is not blank, the transaction type on the newly created Billing transaction comes from the parameter value. It is updated with the same sequence type as the original transaction.
New transactions are created with the new Cost Codes using the same amount entered on the original transaction amount. If JC/TYPEMOVE is not blank, the transaction type on the newly created Billing transaction comes from the parameter value. This transaction is updated with the same sequence type as the original transaction.
Additional transactions created by splitting the already split transactions and using the same sequence type as the original transaction.
Billing Transfer
A Billing Transfer action exists on the Transactions browse in Job Status > Inquiries > Single Job Inquiry. This action is enabled under the following conditions:
The Allow Cost/Billing Transfer field is selected on the Job.
Either parameter JC/WBSMOVE or JC/CHEADMOVE is enabled.
Selection Screen
When JC/CHEADMOVE is set to N and JC/WBSMOVE is set to Y, the information shown on the Billing Transfer selection screen depends on the following:
If the Job uses Sections, the Section field is visible and enabled.
If the Job uses Activities, the Activity field is visible and enabled.
If the Job uses both Sections and Activities, both of those fields are visible and enabled, as shown in the screen below.
Screenshot: Billing Transfer - Section and Activity
When JC/CHEADMOVE is set to Y and JC/WBSMOVE is set to N, the Cost Type field is visible instead of the Section and Activity fields.
Screenshot: Billing Transfer - Cost Type
When JC/CHEADMOVE and JC/WBSMOVE are both set to Y, the selection screen displays a Section field (when the selected Job uses Sections), an Activity field (when the selected Job uses Activities), and a Cost Type field. If a single transaction is selected for Billing Transfer, the Cost Type field defaults to the Cost Type of the selected transaction.
Screenshot: Billing Transfer - Section, Activity, Cost Type
Processing
You can transfer billing from one Cost Type to another Cost Type under the following conditions:
Parameter JC/CHEADMOVE is set to Y.
The Allow Cost/Billing Transfer field is selected on the selected Job.
The resulting Cost Code has the same GL Analysis as the Cost Code of the original transaction.
When JC/TRCEMOVE is set to Y, processing occurs as follows:
The original transaction is updated with the sequence type based on the following format: “REVTRACE. <Job Number>. <Job Phase>”.
A Billing transaction with the same Cost Code as the original transaction is created with the same amount as the original transaction amount, but it appears with a negative sign. If JC/TYPEMOVE is not blank, the transaction type on the newly created Billing transaction comes from the parameter value. It is updated with the same sequence type as the original transaction.
A new transaction is created with a new Cost Code using the same amount entered on the original transaction amount. If JC/TYPEMOVE is not blank, the transaction type on the newly created Billing transaction comes from the parameter value. This transaction is updated with the same sequence type as the original transaction.