Invoices - Revision history

Anw: Added ORS Profit and Loss

2025-06-04T07:33:19Z

Added ORS Profit and Loss

← Older revision		Revision as of 09:33, 4 June 2025
Line 47:		Line 47:

	* Highlight the invoice to be sent		* Highlight the invoice to be sent
	* Once reviewed, set the relevant invoice status from Draft to Approved - this is achieved by right clicking on the line, select '''Set Status''' and select "Approved".		* Once reviewed, set the relevant invoice status from Draft to Approved - this is achieved by right clicking on the line, select '''Set Status''' and select '''Approved'''.
	* Select "Exports"		* Select '''Exports.'''

	<center>[[Image:finance_guide_12.png\|600px]]</center>		<center>[[Image:finance_guide_12.png\|600px]]</center>
Line 92:		Line 92:
	The support documents will run for a single customer, where the customer has at least one invoice included in the export. If the customer selected does not have an invoice in the export, the supporting doc will be blank.		The support documents will run for a single customer, where the customer has at least one invoice included in the export. If the customer selected does not have an invoice in the export, the supporting doc will be blank.

			== Profit & Loss ==
			The oracle report suite ('''Reporting''' & '''Extract Suite''') allows data to be extracted into CSV. A '''Profit and Loss''' report can be created. Once created, this can be run daily, weekly or monthly and will show all inbound and outbound payments within a specific time frame.


			By amending the Credit account, you can extract costs and then revenue separately.

			The criteria below shows all revenue payments allowing the data to be totalled in CSV format.<center>
			[[File:ORS PROFIT AND LOSS.png\|800x800px]]
			</center>

	== View invoice details ==		== View invoice details ==

Anw: Added searchable tables

2024-07-24T09:00:57Z

Added searchable tables

← Older revision		Revision as of 11:00, 24 July 2024
Line 142:		Line 142:
	== Further Configuration ==		== Further Configuration ==
	The following system parameters affect this functionality:		The following system parameters affect this functionality:
	{\| class="wikitable" border="1"		{\| class="wikitable apt-searchable" border="1" id="inv_params"
	\|- bgcolor="silver"		\|- bgcolor="silver"
	!Parameter !! Description !! Level		!Parameter !! Description !! Level

Anw: Added system parameters affecting the screen

2024-06-10T11:27:15Z

Added system parameters affecting the screen

← Older revision		Revision as of 13:27, 10 June 2024
Line 138:		Line 138:
	== Carrier Billing ==		== Carrier Billing ==
	C-TMS also allows a Carrier to be invoiced using a "Self Bill" mechanism - this process involves sending a list of trips and payments to the carrier to validate. The carrier reports any discrepancies and once all issue are resolved a Carrier invoice is sent to the carrier. The purpose of this is to speed up the process of paying the carrier and reducing the amount of time spent resolving issues with and de-briefing carrier invoices.		C-TMS also allows a Carrier to be invoiced using a "Self Bill" mechanism - this process involves sending a list of trips and payments to the carrier to validate. The carrier reports any discrepancies and once all issue are resolved a Carrier invoice is sent to the carrier. The purpose of this is to speed up the process of paying the carrier and reducing the amount of time spent resolving issues with and de-briefing carrier invoices.


			== Further Configuration ==
			The following system parameters affect this functionality:
			{\| class="wikitable" border="1"
			\|- bgcolor="silver"
			!Parameter !! Description !! Level
			\|-
			\| OF_CURRENCY_CODE \|\| Oracle Financial Currency Code \|\| SYSTEM
			\|-
			\| OF_FILE_ARCHIVE \|\| Oracle financials archive file path. \|\| SYSTEM
			\|-
			\| OF_FILE_NAME_SECTION2 \|\| Stores the name of section 2 on the OF filename \|\| SYSTEM
			\|-
			\| OF_FILE_PATH \|\| Oracle financials file path. \|\| SYSTEM
			\|-
			\| OF_FTP_DESTINATION_DIRECTORY \|\| Oracle Financials FTP Dir \|\| COST_CENTRE
			\|-
			\| OF_FTP_DESTINATION_DIRECTORY \|\| Oracle Financials FTP Dir \|\| SYSTEM
			\|-
			\| OF_FTP_DESTINATION_IP_ADDRESS \|\| Oracle Financials FTP IP \|\| SYSTEM
			\|-
			\| OF_FTP_DESTINATION_IP_ADDRESS \|\| Oracle Financials FTP IP \|\| COST_CENTRE
			\|-
			\| OF_FTP_DESTINATION_PASSWORD \|\| Oracle Financials FTP Password \|\| COST_CENTRE
			\|-
			\| OF_FTP_DESTINATION_PASSWORD \|\| Oracle Financials FTP Password \|\| SYSTEM
			\|-
			\| OF_FTP_DESTINATION_PORT \|\| Oracle Financials FTP Port \|\| SYSTEM
			\|-
			\| OF_FTP_DESTINATION_PORT \|\| Oracle Financials FTP Port \|\| COST_CENTRE
			\|-
			\| OF_FTP_DESTINATION_USERNAME \|\| Oracle Financials FTP User \|\| SYSTEM
			\|-
			\| OF_FTP_DESTINATION_USERNAME \|\| Oracle Financials FTP User \|\| COST_CENTRE
			\|-
			\| OF_FTP_DEST_DTL_DIRECTORY \|\| Cargowise Details directory \|\| COST_CENTRE
			\|-
			\| OF_FTP_DEST_DTL_PASSWORD \|\| Cargowise Details password \|\| COST_CENTRE
			\|-
			\| OF_FTP_DEST_DTL_USERNAME \|\| Cargowise Details username \|\| COST_CENTRE
			\|-
			\| OF_IF_DTL \|\| Oracle Financial IF DTL \|\| SYSTEM
			\|-
			\| OF_IF_FTR \|\| Oracle Financial IF FTR \|\| SYSTEM
			\|-
			\| OF_IF_HDR \|\| Oracle Financial IF HDR \|\| SYSTEM
			\|-
			\| OF_JRNL_ENTRY_SOURCE_NAME \|\| Oracle Financial Journal Entry Source Name \|\| SYSTEM
			\|-
			\| OF_ORIGID \|\| Stores the name of ORIGID \|\| SYSTEM
			\|-
			\| OF_SECTION2 \|\| Stores the name of section 2 on the OF filename \|\| SYSTEM
			\|-
			\| OF_SETTINGS \|\| Controls if Oracle Financial settings are required for 11i and R12 \|\| SYSTEM
			\|-
			\| OF_SOURCE_SYSTEM_CODE \|\| Oracle Financial System Code \|\| SYSTEM
			\|}

Anw: Merged from training document

2024-06-10T11:22:26Z

Merged from training document

← Older revision		Revision as of 13:22, 10 June 2024
Line 71:		Line 71:

	{{Note}} There is specific setup required beforehand to ensure that the relevant customer will receive the invoice in the required format.		{{Note}} There is specific setup required beforehand to ensure that the relevant customer will receive the invoice in the required format.

			If the push of the file fails, users may view the FTP Errors to find out why the extract failed.

			<center>[[Image:inv_ftp_errors.png\|600px]]</center>


Line 76:		Line 80:

	C-TMS provides the ability to see the savings generated for a particular date range for a particular customer. This can then be exported into a CSV file.		C-TMS provides the ability to see the savings generated for a particular date range for a particular customer. This can then be exported into a CSV file.


			== View Export and Supporting Docs ==
			Once an invoice has been generated, it will be displayed first in the top data block. You may then select '''View Export''' to see the payments that will be posted when the export is sent. Selecting view will automatically display the header for the selected.

			You are also able to view the details of the export, this includes details of the items for which payments have been generated. When selecting the '''View Supporting Doc''' button, the following screen is displayed, You enter the export id and select a customer, to view the payment details.

			<center>[[Image:inv_supporting_doc.png]]</center>


			The support documents will run for a single customer, where the customer has at least one invoice included in the export. If the customer selected does not have an invoice in the export, the supporting doc will be blank.


	== View invoice details ==		== View invoice details ==
	It is possible to view the itemised breakdown of the invoice by double clicking into it and selecting "~~both~~"		It is possible to view the itemised breakdown of the invoice by double clicking into it and selecting "Both"

	<center>[[Image:finance_guide_23.png\|600px]]</center>		<center>[[Image:finance_guide_23.png\|600px]]</center>

Anw: Minor formatting change

2024-05-24T14:42:38Z

Minor formatting change

← Older revision		Revision as of 16:42, 24 May 2024
Line 24:		Line 24:
	It is possible to view the itemised breakdown of the invoice by double clicking into it and selecting "both".		It is possible to view the itemised breakdown of the invoice by double clicking into it and selecting "both".

	[[Image:finance_guide_9.png\|600px]]		<center>[[Image:finance_guide_9.png\|600px]]</center>


Line 36:		Line 36:
	This is a configurable setting within TMS and can be amended in the Accounts maintenance screen - located in C-TMS Modules, Maintenance, Accounts Maintenance.		This is a configurable setting within TMS and can be amended in the Accounts maintenance screen - located in C-TMS Modules, Maintenance, Accounts Maintenance.

	[[Image:finance_guide_10.png\|600px]]		<center>[[Image:finance_guide_10.png\|600px]]</center>

	To amend the date range, select the '''Edit''' option. You can then amend the Invoice Period and the Day in the Period the invoices are created:		To amend the date range, select the '''Edit''' option. You can then amend the Invoice Period and the Day in the Period the invoices are created:

	[[Image:finance_guide_11.png\|600px]]		<center>[[Image:finance_guide_11.png\|600px]]</center>


Line 50:		Line 50:
	* Select "Exports"		* Select "Exports"

	[[Image:finance_guide_12.png\|600px]]		<center>[[Image:finance_guide_12.png\|600px]]</center>

	* Select '''Generate Export'''		* Select '''Generate Export'''
	Image:finance_guide_13.png\|600px
			<center>[[Image:finance_guide_13.png\|600px]]</center>

	* Select '''OK'''. You will see the screen below:		* Select '''OK'''. You will see the screen below:

	[[Image:finance_guide_14.png\|600px]]		<center>[[Image:finance_guide_14.png\|600px]]</center>

	* Select '''OK'''.		* Select '''OK'''.

	[[Image:finance_guide_15.png\|600px]]		<center>[[Image:finance_guide_15.png\|600px]]</center>

	* You will then see the "successfully created file" message as above.		* You will then see the "successfully created file" message as above.
Line 67:		Line 68:
	* This is the trigger point that will send the invoice across. The invoice will display as "Processed" - as below.		* This is the trigger point that will send the invoice across. The invoice will display as "Processed" - as below.

	[[Image:finance_guide_16.png\|600px]]		<center>[[Image:finance_guide_16.png\|600px]]</center>

	{{Note}} There is specific setup required beforehand to ensure that the relevant customer will receive the invoice in the required format.		{{Note}} There is specific setup required beforehand to ensure that the relevant customer will receive the invoice in the required format.
Line 79:		Line 80:
	== View invoice details ==		== View invoice details ==
	It is possible to view the itemised breakdown of the invoice by double clicking into it and selecting "both"		It is possible to view the itemised breakdown of the invoice by double clicking into it and selecting "both"
	[[Image:finance_guide_23.png\|600px]]
			<center>[[Image:finance_guide_23.png\|600px]]</center>


Line 89:		Line 91:
	New Invoice Creation:		New Invoice Creation:

	[[Image:finance_guide_24.png\|600px]]		<center>[[Image:finance_guide_24.png\|600px]]</center>

	Set the debit and credit accounts appropriately:		Set the debit and credit accounts appropriately:

	[[Image:finance_guide_25.png~~\|600px~~]]		<center>[[Image:finance_guide_25.png]]</center>

	This invoice will then appear in the invoices screen with a status of "Draft". All relevant payment lines in a status of "A" (Actualised) will automatically be added to the invoice.		This invoice will then appear in the invoices screen with a status of "Draft". All relevant payment lines in a status of "A" (Actualised) will automatically be added to the invoice.
Line 104:		Line 106:
	* {{Note}} You can send the Invoice to a CSV Spreadsheet format by right-clicking and selecting ''Export Invoice''.		* {{Note}} You can send the Invoice to a CSV Spreadsheet format by right-clicking and selecting ''Export Invoice''.

	[[Image:finance_guide_26.png\|600px]]		<center>[[Image:finance_guide_26.png\|600px]]</center>

	* Select '''Print'''		* Select '''Print'''

	[[Image:finance_guide_27.png\|600px]]		<center>[[Image:finance_guide_27.png\|600px]]</center>

	An example output is illustrated below:		An example output is illustrated below:

	[[Image:finance_guide_28.png\|600px]]		<center>[[Image:finance_guide_28.png\|600px]]</center>

	An itemised breakdown of the associated invoice is also displayed:		An itemised breakdown of the associated invoice is also displayed:
	[[Image:finance_guide_29.png\|600px]]
			<center>[[Image:finance_guide_29.png\|600px]]</center>

Anw: Categorisation

2024-05-24T14:38:24Z

Categorisation

← Older revision		Revision as of 16:38, 24 May 2024
Line 122:		Line 122:


			<noinclude>
	[[Category:Accounts\|130]]		[[Category:Accounts\|130]]
	[[Category:C-TMS Modules\|C-130]]		[[Category:C-TMS Modules\|C-130]]
	[[Category:C-TMS User Guide\|BC-130]]		[[Category:C-TMS User Guide\|BC-130]]
	[[Category:TEST\|C-130]]		[[Category:TEST\|C-130]]
			<noinclude>

Anw: Merged from training document

2024-05-24T10:53:18Z

Merged from training document

← Older revision		Revision as of 12:53, 24 May 2024
Line 77:		Line 77:


	== ~~Invoice Generation~~ ==		== View invoice details ==
	~~Invoices can be generated weekly or monthly. There~~ is ~~an invoice form which will display all invoices which have been created and also~~ the ~~payments which make up~~ the invoice.		It is possible to view the itemised breakdown of the invoice by double clicking into it and selecting "both"
			[[Image:finance_guide_23.png\|600px]]

	~~<center>[[Image:inv_2.jpg]]</center>~~

			== Invoice Generation and Printing ==
			* To generate a new invoice for a new date range, click '''Generate'''.
			* Payment Lines can only be assigned to invoices in a status of "Draft"
			* Once a previous invoice has been reviewed and all relevant payment lines are included, the status should be changed to "approved" as part of the exporting to customer process.

			New Invoice Creation:

			[[Image:finance_guide_24.png\|600px]]

			Set the debit and credit accounts appropriately:

			[[Image:finance_guide_25.png\|600px]]

			This invoice will then appear in the invoices screen with a status of "Draft". All relevant payment lines in a status of "A" (Actualised) will automatically be added to the invoice.


			== Printing of an Invoice==
			To print of an Invoice to review or to keep a manual copy:
			* Highlight the associated invoice
			* Right click and select ''Print -> Invoice''
			* {{Note}} You can send the Invoice to a CSV Spreadsheet format by right-clicking and selecting ''Export Invoice''.

			[[Image:finance_guide_26.png\|600px]]

			* Select '''Print'''

			[[Image:finance_guide_27.png\|600px]]

			An example output is illustrated below:

			[[Image:finance_guide_28.png\|600px]]

			An itemised breakdown of the associated invoice is also displayed:
			[[Image:finance_guide_29.png\|600px]]

Anw: Merged from training document

2024-05-24T10:25:48Z

Merged from training document

@@ Line 1: / Line 1: @@
-C-TMS can be configured, so that a customer invoice can be generated, once ‘[[Trip Debrief]]’ has taken place.
+C-TMS can be configured, so that a customer invoice can be generated, once [[Trip Debrief]] has taken place.
 == Customer Setup ==
 Customers can be set up so that they can use BCI (Base Cost Invoicing) or ACI (Actual Cost Invoicing).
@@ Line 8: / Line 8: @@
 Customers can also be configured to use Provisional Invoicing, this method generates a provisional invoice consisting of trips which have been ‘ACCEPTED’, another invoice, called adjustments will be generated, several weeks later, which again is configurable.
 == Configuration Form ==
-Invoicing is configured within the Invoice Requirements form
+From this form, the invoices can be printed or exported to a CSV file.
-<center>[[Image:inv_1.jpg]]</center>
+C-TMS provides the ability to see the savings generated for a particular date range for a particular customer.  This can then be exported into a CSV file.
 == Invoice Generation ==
 Invoices can be generated weekly or monthly.  There is an invoice form which will display all invoices which have been created and also the payments which make up the invoice.
 <center>[[Image:inv_2.jpg]]</center>
 == Carrier Billing ==
 [[Category:Accounts|130]]

Anw: test

2024-05-17T06:43:32Z

test

← Older revision		Revision as of 08:43, 17 May 2024
Line 33:		Line 33:
	[[Category:C-TMS Modules\|C-130]]		[[Category:C-TMS Modules\|C-130]]
	[[Category:C-TMS User Guide\|BC-130]]		[[Category:C-TMS User Guide\|BC-130]]
			[[Category:TEST\|C-130]]

Anw at 11:45, 11 May 2011

2011-05-11T11:45:36Z

← Older revision		Revision as of 13:45, 11 May 2011
Line 29:		Line 29:

	C-TMS also allows a Carrier to be invoiced using a ‘Self Bill’ mechanism, this process involves sending a list of trips and payments to the carrier to validate, the carrier reports any discrepancies and once all issue are resolved a Carrier invoice is sent to the carrier. The purpose of this is to speed up the process of paying the carrier and reducing the amount of time spent resolving issues with and de-briefing carrier invoices.		C-TMS also allows a Carrier to be invoiced using a ‘Self Bill’ mechanism, this process involves sending a list of trips and payments to the carrier to validate, the carrier reports any discrepancies and once all issue are resolved a Carrier invoice is sent to the carrier. The purpose of this is to speed up the process of paying the carrier and reducing the amount of time spent resolving issues with and de-briefing carrier invoices.

			[[Category:Accounts\|130]]
			[[Category:C-TMS Modules\|C-130]]
			[[Category:C-TMS User Guide\|BC-130]]

← Older revision		Revision as of 08:43, 17 May 2024
Line 33:		Line 33:
	[[Category:C-TMS Modules\|C-130]]		[[Category:C-TMS Modules\|C-130]]
	[[Category:C-TMS User Guide\|BC-130]]		[[Category:C-TMS User Guide\|BC-130]]
			[[Category:TEST\|C-130]]