Example of Loading Organization Payment Methods

In this example, you create an Organization Payment Method and define payment sources and payment rules.

You do these steps:

  1. Create an Organization Payment Method HDL_OPM_TRU for the Vision Corporation US LDG LDG.

  2. Load the two payment sources to associate bank accounts and other sources of funds with it.

  3. Define the payment rules to determine the appropriate payment source based on tax reporting unit.

As this image shows, for your organization payment method, you create the payment sources and rules.

In this image, the payment rule HDL_OPM_TRU_DFLT sets the HDL_OPM_TRU_PS_DFLT as the default source. The payment rule HDL_OPM_TRU_VISION associates the payment source HDL_OPM_TRU_PS_VISION with the vision corporation TRU.

Create an Organization Payment Method

These payment method lines create an organization payment method HDL_OPM_TRU:

METADATA|OrganizationPaymentMethod|SourceSystemOwner|SourceSystemId|LegislativeDataGroupName|EffectiveStartDate|OrganizationPaymentMethodName|OrganizationPaymentMethodCode|CurrencyCode|PaymentTypeCode
MERGE|OrganizationPaymentMethod|VISION|HDL_OPM_TRU|Vision Corporation US LDG|2018/01/01|HDL Organization Payment Method with TRU rule|HDL_ORG_PAYMENT_METHOD_TRU|USD|EFT

Create Payment Sources

These DAT files to load the two payment sources:

Payment Source

Use To

HDL_OPM_TRU_PS_VISION

Pay workers or third-party people based in the Vision Corporation tax reporting unit.

HDL_OPM_TRU_PS_DFLT

Pay workers in all other tax reporting units. Set this payment source as the default payment source.

METADATA|PaymentSource|SourceSystemOwner|SourceSystemId|LegislativeDataGroupName|EffectiveStartDate|OrganizationPaymentMethodId(SourceSystemId)|PaymentSourceCode|PaymentSourceName|BankAccountName|BankReferenceEFT|CompanyReferenceEFT
MERGE|PaymentSource|VISION|HDL_OPM_TRU_PS_DFLT|Vision Corporation US LDG|2018/01/01|HDL_OPM_TRU|HDL_DEFLT|HDL Payment Source|Corporate Payroll Account-202|808123663|456102113
MERGE|PaymentSource|VISION|HDL_OPM_TRU_PS_VISION|Vision Corporation US LDG|2018/01/01|HDL_OPM_TRU|HDL_VISION|HDL Payment Source Vision|Vision Nacha Account-202|234506332|567890123

Create Payment Rules

Finally, use the DAT file to load these two payment rules.

Payment Rule

What It Does

HDL_OPM_TRU_DFLT

Sets the payment source HDL_OPM_TRU_PS_DFLT as the default source.

HDL_OPM_TRU_VISION

Associates the payment source HDL_OPM_TRU_PS_VISION with the Vision Corporation TRU.

METADATA|PaymentMethodRule|SourceSystemOwner|SourceSystemId|LegislativeDataGroupName|EffectiveStartDate|PaymentSourceId(SourceSystemId)|DefaultFlag|TaxReportingUnitName 
MERGE|PaymentMethodRule|VISION|HDL_OPM_TRU_DFLT|Vision Corporation US LDG|2018/01/01|HDL_OPM_TRU_PS_DFLT|Y|
MERGE|PaymentMethodRule|VISION|HDL_OPM_TRU_VISION|Vision Corporation US LDG|2018/01/01|HDL_OPM_TRU_PS_VISION|N|Vision Corporation
Note:

When updating these existing components, you can't change either the first effective start date or last effective end date:

  • Organization payment method

  • Payment source

  • Payment method rule