AccountEntity and AccountPartner

The AccountEntity_x and AccountPartner_x keywords specify the accounts for matching. For each account pair to match, you specify AccountEntity_x and AccountPartner_x starting with zero. To create a One-to-Many or Many-to-Many matching report, specify additional accounts using the correct keyword. You cannot use duplicate keywords within one report. For example, AccountEntity_0 cannot exist more than once within one report.

Syntax

AccountEntity_0=A#Sales.C1#GolfBalls.C2#Customer2

AccountPartner_0=A#Purchases.C1#GolfBalls.C2#Customer2

This example uses these keywords to show all accounts in one matching report:

AccountEntity_0=A#1004780

AccountEntity_1=A#1004790

AccountEntity_2=A#1005850

AccountEntity_3=A#1005850

AccountPartner_0=A#2000100

AccountPartner_1=A#2000140

AccountPartner_2=A#2000210

AccountPartner_3=A#2000250

AccountPartner_4=A#2000320

AccountPartner_5=A#2000430

AccountPartner_6=A#2000560

AccountPartner_7=A#2000630

AccountPartner_8=A#2000680

This example uses the Entity and Partner keywords to create different reports with different account pairs. This is an example of one report with one account matching two accounts (one to many):

Report 1

AccountEntity_0=A#1004780

AccountPartner_0=A#2000100

AccountPartner_1=A#2000140

This example shows one report with two accounts matching one account (many to one):

Report 2

AccountEntity_0=A#1004790

AccountEntity_1=A#2000210

AccountPartner_1=A#2000250

Report 3 is an example of one report with one account matching with one account (one to one).

Report 3

AccountEntity_0=A#1005850

AccountPartner_0=A#2000320

Report 4 is an example of one report with two accounts matching with four accounts (many to many).

Report 4

AccountEntity_0=A#1005850

AccountEntity_1=A#1005860

AccountPartner_0=A#2000430

AccountPartner_1=A#2000560

AccountPartner_2=A#2000630

AccountPartner_3=A#2000680