Sage 50 Payroll Employee Payments XML
The Importing Employee Payments Into Sage 50 Payroll task allows you to insert or update Payments associated with Employees in Sage 50 Payroll.
For an Employee Payment to be imported, the Employee and the Payment must already exist in Sage 50 Payroll.
Employee Matching
The Employee is matched based on the provided EmployeeReference
in the XML.
<?xml version="1.0"?>
<Company>
<EmployeePayments>
<EmployeePayment>
<EmployeeReference>1</EmployeeReference>
</EmployeePayment>
</EmployeePayments>
</Company>
EmployeeReference
Required
Employee Reference
The numeric identifier of the Employee that you would like to associate the Payment with.
Payment Matching
The Payment is matched based on the provided PaymentReference
or PaymentName
in the XML.
<?xml version="1.0"?>
<Company>
<EmployeePayments>
<EmployeePayment>
<PaymentReference>1</PaymentReference>
<PaymentName>Expense</PaymentName>
</EmployeePayment>
</EmployeePayments>
</Company>
PaymentReference
Optional
Ref
The numeric identifier of the Payment that you would like to associate with the Employee.
PaymentName
Optional
Payment Name
The name of the Payment that you would like to associate with the Employee.
Employee Payment Fields
The following Employee Payment fields can be set using Zynk.
<?xml version="1.0"?>
<<<<<<< HEAD:documentation/sage-50-payroll/Sage-50-Payroll-Employee-Payments-XML.md
<Company
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<EmployeePayments>
<EmployeePayment>
<Hours>7.5</Hours>
<Rate>10</Rate>
</EmployeePayment>
</EmployeePayments>
=======
<Company>
<EmployeePayments>
<EmployeePayment>
<Hours>7.5</Hours>
<Rate>10</Rate>
</EmployeePayment>
</EmployeePayments>
>>>>>>> 201fb269a522c32a2ed43abfd3c2b9ace29f1999:developers/sage-50-payroll/employee-payments-xml.md
</Company>
Hours
Optional
Hours/No.
The number of hours to set on the Employee Payment.
Rate
Optional
Rate
The hourly rate to set on the Employee Payment.
Samples
Sample import file for sage-50-payroll-xml Employee Payment
If the Payment is already associated with the Employee then the import of the record will fail
<?xml version="1.0"?>
<<<<<<< HEAD:documentation/sage-50-payroll/Sage-50-Payroll-Employee-Payments-XML.md
<Company
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<EmployeePayments>
<EmployeePayment RecordOperation="Insert">
<EmployeeReference>1</EmployeeReference>
<PaymentName>Expense</PaymentName>
<Hours>7.5</Hours>
<Rate>15</Rate>
</EmployeePayment>
</EmployeePayments>
=======
<Company>
<EmployeePayments>
<EmployeePayment RecordOperation="Insert">
<EmployeeReference>1</EmployeeReference>
<PaymentName>Expense</PaymentName>
<Hours>7.5</Hours>
<Rate>15</Rate>
</EmployeePayment>
</EmployeePayments>
>>>>>>> 201fb269a522c32a2ed43abfd3c2b9ace29f1999:developers/sage-50-payroll/employee-payments-xml.md
</Company>
Sample import file for updating an existing Employee Payment
If the Payment isn't already associated with the Employee then the import of the record will fail
<?xml version="1.0"?>
<<<<<<< HEAD:documentation/sage-50-payroll/Sage-50-Payroll-Employee-Payments-XML.md
<Company
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<EmployeePayments>
<EmployeePayment RecordOperation="Update">
<EmployeeReference>1</EmployeeReference>
<PaymentName>Expense</PaymentName>
<Hours>7.5</Hours>
<Rate>15</Rate>
</EmployeePayment>
</EmployeePayments>
=======
<Company>
<EmployeePayments>
<EmployeePayment RecordOperation="Update">
<EmployeeReference>1</EmployeeReference>
<PaymentName>Expense</PaymentName>
<Hours>7.5</Hours>
<Rate>15</Rate>
</EmployeePayment>
</EmployeePayments>
>>>>>>> 201fb269a522c32a2ed43abfd3c2b9ace29f1999:developers/sage-50-payroll/employee-payments-xml.md
</Company>
Sample import file for upserting a Employee Payment
If the Payment isn't already associated with the Employee then one will be created, otherwise the existing Employee Payment will be updated
<?xml version="1.0"?>
<<<<<<< HEAD:documentation/sage-50-payroll/Sage-50-Payroll-Employee-Payments-XML.md
<Company
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<EmployeePayments>
<EmployeePayment RecordOperation="Upsert">
<EmployeeReference>1</EmployeeReference>
<PaymentName>Expense</PaymentName>
<Hours>7.5</Hours>
<Rate>10</Rate>
</EmployeePayment>
</EmployeePayments>
=======
<Company>
<EmployeePayments>
<EmployeePayment RecordOperation="Upsert">
<EmployeeReference>1</EmployeeReference>
<PaymentName>Expense</PaymentName>
<Hours>7.5</Hours>
<Rate>10</Rate>
</EmployeePayment>
</EmployeePayments>
>>>>>>> 201fb269a522c32a2ed43abfd3c2b9ace29f1999:developers/sage-50-payroll/employee-payments-xml.md
</Company>