MYOXIMPORT Timesheets - Revision history

Nic at 05:34, 17 November 2016

2016-11-17T05:34:48Z

← Older revision		Revision as of 00:34, 17 November 2016
Line 5:		Line 5:
	== Fields ==		== Fields ==

	Fields that are mandatory are in '''bold'''.		The following fields allow you to import data. Fields that are mandatory are in '''bold'''. Fields that are optional are in ''italics''.

	Fields that are optional are in ''italics''.

	* '''TimesheetDate'''		* '''TimesheetDate'''

Nic at 05:33, 17 November 2016

2016-11-17T05:33:48Z

← Older revision		Revision as of 00:33, 17 November 2016
Line 9:		Line 9:
	Fields that are optional are in ''italics''.		Fields that are optional are in ''italics''.

	* '''TimesheetDate''' ~~allows you to specify the date.~~		* '''TimesheetDate'''
	* '''Hours''' ~~allows you to specify the hours.~~		* '''Hours'''
	* ''Notes'' ~~allows you to specify the notes.~~		* ''Notes''
	* ''ActivityUID'' ~~allows you to specify the UID of the time billing activity.~~		* ''ActivityUID''
	* ''CustomerUID'' ~~allows you to specify the UID of the customer.~~		* ''CustomerUID''
	* '''EmployeeUID''' ~~allows you to specify the UID of the employee.~~		* '''EmployeeUID'''
	* ''JobUID'' ~~allows you to specify the UID of the job.~~		* ''JobUID''
	* '''PayrollCategoryUID''' ~~allows you to specify the UID of the payroll category (usually a wage).~~		* '''PayrollCategoryUID'''

	== Notes ==		== Notes ==

Nic at 05:32, 17 November 2016

2016-11-17T05:32:58Z

← Older revision		Revision as of 00:32, 17 November 2016
Line 5:		Line 5:
	== Fields ==		== Fields ==

	* '''~~TimesheetDate~~''' ~~is a~~ '''~~mandatory~~''' ~~field which~~ allows you to specify the date.		Fields that are mandatory are in '''bold'''.
	* '''Hours''' ~~is a '''mandatory''' field which~~ allows you to specify the hours.
	* '''Notes''~~' is an '''optional''' field which~~ allows you to specify the notes.		Fields that are optional are in ''italics''.
	* '''ActivityUID''~~' is an '''optional''' field which~~ allows you to specify the UID of the time billing activity.
	* '''CustomerUID''~~' is an '''optional''' field which~~ allows you to specify the UID of the customer.		* '''TimesheetDate''' allows you to specify the date.
	* '''EmployeeUID''' ~~is a '''mandatory''' field which~~ allows you to specify the UID of the employee.		* '''Hours''' allows you to specify the hours.
	* '''JobUID''~~' is an '''optional''' field which~~ allows you to specify the UID of the job.		* ''Notes'' allows you to specify the notes.
	* '''PayrollCategoryUID''' ~~is a '''mandatory''' field which~~ allows you to specify the UID of the payroll category (usually a wage).		* ''ActivityUID'' allows you to specify the UID of the time billing activity.
			* ''CustomerUID'' allows you to specify the UID of the customer.
			* '''EmployeeUID''' allows you to specify the UID of the employee.
			* ''JobUID'' allows you to specify the UID of the job.
			* '''PayrollCategoryUID''' allows you to specify the UID of the payroll category (usually a wage).

	== Notes ==		== Notes ==

Nic at 05:31, 17 November 2016

2016-11-17T05:31:24Z

← Older revision		Revision as of 00:31, 17 November 2016
Line 5:		Line 5:
	== Fields ==		== Fields ==

	* '''~~Date~~''' is a '''mandatory''' field which allows you to specify the date.		* '''TimesheetDate''' is a '''mandatory''' field which allows you to specify the date.
	* '''Hours''' is a '''mandatory''' field which allows you to specify the hours.		* '''Hours''' is a '''mandatory''' field which allows you to specify the hours.
	* '''Notes''' is an '''optional''' field which allows you to specify the notes.		* '''Notes''' is an '''optional''' field which allows you to specify the notes.

Nic at 02:32, 15 November 2016

2016-11-15T02:32:29Z

← Older revision		Revision as of 21:32, 14 November 2016
Line 25:		Line 25:

	* [[Import Tables]]		* [[Import Tables]]
			* [[Writing Data]]

Nic at 00:49, 15 November 2016

2016-11-15T00:49:20Z

← Older revision		Revision as of 19:49, 14 November 2016
Line 5:		Line 5:
	== Fields ==		== Fields ==

	* '''Date''' is a '''mandatory''' field which allows you to ~~specific~~ the date.		* '''Date''' is a '''mandatory''' field which allows you to specify the date.
	* '''Hours''' is a '''mandatory''' field which allows you to specify the hours.		* '''Hours''' is a '''mandatory''' field which allows you to specify the hours.
	* '''Notes''' is an '''optional''' field which allows you to specify the notes.		* '''Notes''' is an '''optional''' field which allows you to specify the notes.

Nic at 00:47, 15 November 2016

2016-11-15T00:47:56Z

← Older revision		Revision as of 19:47, 14 November 2016
Line 16:		Line 16:
	== Notes ==		== Notes ==

	* Timesheets are treated as a complete timesheet for a given employee and day. As such, part-timesheets cannot be imported into MYOB AccountRight Live. Recording a timesheet for an employee/date pair which already exists in MYOB will delete all timesheet entries for that pair and replace with the new entries.		* Timesheets are treated as a complete timesheet for a given employee and day. As such, part-timesheets cannot be imported into MYOB AccountRight Live. Recording a timesheet for an employee/date pair which already exists in MYOB will delete all timesheet entries for that pair and replace with the new entries. In other words, you are telling MYOB the complete story of that employee's timesheet on that date.

	*		* Because timesheets are not actual transactions, the RecordedUID and RecordedRowVersion will either have the values of '''Imported''' or '''Not Imported''' once the write data process takes place.

			* Because timesheets are not actual transactions, the InternalLineIndex does not really control how the lines will appear on the timesheet. Although we do use that field to order the data, MYOB may decide to display the lines in any order.

			== Related Topics ==

			* [[Import Tables]]

Nic: Created page with "== Overview == MYOXIMPORT_Timesheets allows you to import timesheets into MYOB. == Fields == * '''Date''' is a '''mandatory''' field which allows you to specific the date. ..."

2016-11-15T00:32:00Z

Created page with "== Overview == MYOXIMPORT_Timesheets allows you to import timesheets into MYOB. == Fields == * '''Date''' is a '''mandatory''' field which allows you to specific the date. ..."

New page

== Overview ==

MYOXIMPORT_Timesheets allows you to import timesheets into MYOB.

== Fields ==

* '''Date''' is a '''mandatory''' field which allows you to specific the date.
* '''Hours''' is a '''mandatory''' field which allows you to specify the hours.
* '''Notes''' is an '''optional''' field which allows you to specify the notes.
* '''ActivityUID''' is an '''optional''' field which allows you to specify the UID of the time billing activity.
* '''CustomerUID''' is an '''optional''' field which allows you to specify the UID of the customer.
* '''EmployeeUID''' is a '''mandatory''' field which allows you to specify the UID of the employee.
* '''JobUID''' is an '''optional''' field which allows you to specify the UID of the job.
* '''PayrollCategoryUID''' is a '''mandatory''' field which allows you to specify the UID of the payroll category (usually a wage).

== Notes ==

* Timesheets are treated as a complete timesheet for a given employee and day. As such, part-timesheets cannot be imported into MYOB AccountRight Live. Recording a timesheet for an employee/date pair which already exists in MYOB will delete all timesheet entries for that pair and replace with the new entries.

*