Example of business partner financial details by financial company

This diagram illustrates how LN stores and retrieves the business partner data for each department in a single logistic, multifinancial company structure:

[...]

All the companies use the same database server. Therefore, the companies can share the database tables to share data. This table shows the data that can be defined in shared tables.

Shared tablesBusiness partner master data
Default role dataRole data for SA1, SA2, PA1, and PA2Role data for SB and PBRole data for SC and PC
Financial business partner dataFinancial data for FAFinancial data for FBFinancial data for FC

 

In the diagram, this setup is displayed:

  • Financial company F200 uses the business partner data that is registered for accounting office FB.
  • Financial company F300 uses the business partner data that is registered for the company's accounting office FC.
  • Financial company F100 uses company F100's accounting office FA.

    If you do not define specific business partner details for accounting office FA, then financial company F100 uses the default data defined for the entire multicompany environment. The default data is defined in the first instance of the business partner role data, for which the department field is empty.

Note

A financial company's accounting office is defined in the Company Parameters (tfgld0503m000) session. For example, for financial company F100, accounting office FA is defined as the company's accounting office in the Company Parameters (tfgld0503m000) session of financial company F100.

To define the business partner financial data at department, company, or multicompany level, you must define multiple instances of each financial business partner role. That is, multiple instances for the invoice-to role, multiple instances for the invoice-from role, multiple instances for the pay-by role, and multiple instances for the pay-to role.

In the first instance of each role, you must define the default financial data for the entire multicompany environment.

Next, you must define financial business-partner role data by financial company. That is, for each role, you must define a separate instance for each financial company.

The role data defined for a financial company applies to the sales orders and purchase orders involving the departments of the financial company. For example, financial data defined for the invoice-to role and financial company F200 applies to the departments of company F200.

Finally, for each role you must create as many instances as required to define the role data by department.

In this example, for the invoice-to, pay-by, invoice-from, and pay-to roles, you must define a separate instance to specify the financial data of each of these entities:

  • The default financial data for the entire multicompany environment. For this instance, the Department field is unavailable and blank.
  • Financial company F100. For this instance, specify accounting office FA in the Department field.
  • Financial company F200. For this instance, specify accounting office FB in the Department field.
  • Financial company F300. For this instance, specify accounting office FC in the Department field.
  • These departments:

    • SA1
    • SA2
    • PA1
    • PA2
    • SB
    • PB
    • SC
    • PC
Note

Because the database tables are shared in this example, you can work in any of the financial companies to define the financial business-partner role data. After you have defined the default financial data for the entire multicompany environment, you can also work in the logistic company to define the financial data by department. See the Infor LN User Guide for Table Sharing (lncomtableshug).

If the database tables are not shared, you must work in a financial company to define the financial role data for the company and the departments of the company.

To define the business partner financial details by financial company in the example, complete these steps:

  1. Make sure you are working in one of the financial companies.
  2. For the invoice-to, pay-by, invoice-from, and pay-to roles, define a separate instance to specify this data:

    • The default financial data that apply to the entire multicompany environment. This is the first instance. In this instance, the Department field is unavailable and blank.
    • The data that apply to the departments of a specific financial company. In this instance, specify the financial company's accounting office in the Department field.
    • The data that apply to a specific department, which you must specify in the Department field. Because the database tables are shared in this example, you can specify a department of the logistic company or any of the financial companies.