27 Using the Joint Venture Management Inquiry Programs (Release 9.2 Update)

This chapter discusses:

Note:

The inquiry programs discussed in this chapter provide extensive data that you can use to meet your reporting and inquiry needs.

27.1 Joint Venture Distributions Inquiry (P09J210)

You can use the Joint Venture Distributions Inquiry program (P09J210) to inquire and report on the joint venture distribution detail transactions. The P09J210 program uses the JV Distributions Inquiry business view (V09J210), which is based on the Joint Venture Distribution Detail table (F09J12) and also includes columns from these tables: Joint Venture Master (F09J30), Cash Call Definition (F09J40), Account Master (F0901), and Business Unit Master (F0006).

For each distribution transaction in the F09J12 table, the system displays the associated joint venture information from the F09J30 table, the cash call information (if assigned to the distributed transactions) from the F09J40 table, and the associated business unit information from the F0006 table. Additionally, the system retrieves the following information, if available:

  • Legal entity from the Joint Venture Legal Entities table (F09J10)

  • Project associated with the business unit from the Business Unit Master table (F0006)

  • Exclusive cash call from the Cash Call Definition table (F09J40)

Choose from more than 400 columns in the business view to report on your distribution detail transactions by joint venture, joint venture category codes, partner, managing business unit, business unit, account, account category codes, subledger, and so on.

27.1.1 Special Processing

The Joint Venture Distributions Inquiry program (P09J210) has the functionality to convert the values in all the amount-related grid columns into the user-specified As If Currency. The system performs this currency conversion only when the As If Currency value is entered by the user, either in the processing option or in the program.

27.1.2 Prerequisite

Before you complete the tasks in this section, set up the processing options for the Joint Venture Distributions Inquiry program (P09J210).

On the Defaults tab, enter values for the following processing option:

  • As If Currency: Specify the currency code that the system uses as the default in the P09J210 program. When the As If Currency code is set, the system will perform currency conversion for the domestic amounts by utilizing the currency code and the exchange rate that is retrieved using the date specified in the As If Date field in the program. The converted amounts are displayed in the As If amount columns in the program.

    If you leave this processing option blank, the As If Currency Code will not be set and As If processing will not occur by default.

On the Versions tab, enter values for the following processing options:

  • Joint Venture Master (P09J30) Version: Specify the version of the P09J30 program that the system launches when you access the program from the Row menu of the Joint Venture Distributions Inquiry form or when you click the joint venture name link in the grid. If you leave this processing option blank, the system uses the ZJDE0001 version.

  • Cash Call Definition (P09J40) Version: Specify the version of the P09J40 program that the system launches when you access the program from the Row menu of the Joint Venture Distributions Inquiry form or when you click the cash call ID link or exclusive cash call ID link in the grid. If you leave this processing option blank, the system uses the ZJDE0001 version.

27.1.3 Using the Joint Venture Distributions Inquiry Program (P09J210)

To use the Joint Venture Distributions Inquiry Program (P09J210):

  1. From the Joint Venture Management module (G09J), click Daily Processing, Joint Venture Inquiries, and then select Joint Venture Distributions Inquiry.

  2. Use the Joint Venture Name field in the header or create your own Saved Queries to support your inquiry needs.

  3. To view the amounts in the grid in a different currency, enter values in the following header fields:

    • As If Currency Code

      The system populates this field with the value that you have set up in the processing option, but you can override the value. The system converts the amounts to the currency populated in this field.

    • As If Exchange Rate Date

      If the As If Currency Code field has a value, the system populates this field with today's date (system date), but you can override the default date. The system uses the date in this field to retrieve the exchange rate to convert the amounts in the grid into the As If Currency.

    • Review the information in the grid.

      Note that the system has populated the As If Amount columns with the amounts in the currency that you have specified.

27.2 Joint Venture Cash Calls Inquiry (P09J220)

You can use the Joint Venture Cash Calls Inquiry program (P09J220) to inquire and report on cash calls. The P09J220 program uses the Joint Venture Cash Calls Inquiry business view (V09J220), which is based on the Cash Call Definition program (F09J40) and also includes columns from these tables: Joint Venture Master (F09J30) and Business Unit Master (F0006).

For each cash call definition record in the F09J40 table, the system displays the associated joint venture information from the F09J30 table and the associated business unit information from the F0006 table. Additionally, the system retrieves the following information, if available:

  • Legal entity information from the Joint Venture Legal Entities table (F09J10)

  • Project associated with the cash call from the Business Unit Master table (F0006)

Choose from more than 250 columns in the business view to report on your cash calls by joint venture, joint venture category codes, partner, managing business unit, business unit, cash call status, cash call effective date, account, subledger, and so on.

27.2.1 Special Processing

The Joint Venture Cash Calls Inquiry program (P09J220) has the functionality to convert the values in all the amount-related grid columns into the user-specified As If Currency. The system performs this currency conversion only when the As If Currency value is entered by the user, either in the processing option or in the program.

27.2.2 Prerequisite

Before you complete the tasks in this section, set up the processing options for the Joint Venture Cash Calls Inquiry program (P09J220).

On the Defaults tab, enter values for the following processing option:

  • As If Currency: Specify the currency code that the system uses as the default in the P09J220 program. When the As If Currency code is set, the system will perform currency conversion for the domestic amounts by utilizing the currency code and the exchange rate that is retrieved using the date specified in the As If Date field in the program. The converted amounts are displayed in the As If amount columns in the program.

    If you leave this processing option blank, the As If Currency Code will not be set and As If processing will not occur by default.

On the Versions tab, enter values for the following processing options:

  • Joint Venture Master (P09J30) Version: Specify the version of the P09J30 program that the system launches when you access the program from the Row menu of the Joint Venture Cash Calls Inquiry form or when you click the joint venture name link in the grid. If you leave this processing option blank, the system uses the ZJDE0001 version.

  • Cash Call Definition (P09J40) Version: Specify the version of the P09J40 program that the system launches when you access the program from the Row menu of the Joint Venture Cash Calls Inquiry form or when you click the cash call ID link or exclusive cash call ID link in the grid. If you leave this processing option blank, the system uses the ZJDE0001 version.

27.2.3 Using the Joint Venture Cash Calls Inquiry Program (P09J220)

To use the JV Cash Calls Inquiry Program (P09J220):

  1. From the Joint Venture Management module (G09J), click Daily Processing, Joint Venture Inquiries, and then select Joint Venture Cash Calls Inquiry.

  2. Use the Joint Venture Name field in the header or create your own Saved Queries to support your inquiry needs.

  3. To view the amounts in the grid in a different currency, enter values in the following header fields:

    • As If Currency Code

      The system populates this field with the value that you have set up in the processing option, but you can override the value. The system will convert the amounts into the currency that is specified in this field.

    • As If Exchange Rate Date

      If the As If Currency Code field has a value, the system populates this field with today's date (system date), but you can override the default date. The system uses the date in this field to retrieve the exchange rate to convert the amounts in the grid into the As If Currency.

    • Review the information in the grid.

      Note that the system has populated the As If Amount columns with the amounts in the currency that you have specified.

27.3 Joint Venture Cash Call Invoice Inquiry (P09J240)

You can use the Joint Venture Cash Call Invoice Inquiry program (P09J240) to inquire and report on cash call invoices. The P09J240 program uses the Joint Venture Cash Call Invoice Inquiry business view (V09J240A), which is based on the Cash Call Ledger table (F09J41) and also includes columns from these tables: Joint Venture Master (F09J30), Business Unit Master (F0006), Cash Call Definition (F09J40), and Customer Ledger (F03B11).

For each cash call invoice ledger record in the F09J41 table, the system displays the associated cash call definition from the F09J40 table, business unit information from the F0006 table, joint venture information from the F09J30 table, and invoice information from the F03B11 table. Each line in the grid provides information related to each cash call invoice. Additionally, the system retrieves the following information, if available:

  • Legal entity from the Joint Venture Legal Entities table (F09J10)

  • Project associated with the cash call from the Business Unit Master table (F0006)

Choose from more than 300 columns in the business view to report on your cash call invoices by joint venture, joint venture category codes, partner, managing business unit, business unit, business unit category codes, invoice document number, cash call effective date, account, subledger, and so on.

27.3.1 Special Processing

The Joint Venture Cash Call Invoice Inquiry program (P09J240) has the functionality to convert the values in all the amount-related grid columns into the user-specified As If Currency. The system performs this currency conversion only when the As If Currency value is entered by the user, either in the processing option or in the program.

27.3.2 Prerequisite

Before you complete the tasks in this section, set up the processing options for the Joint Venture Cash Call Invoice Inquiry program (P09J240).

On the Defaults tab, enter values for the following processing option:

  • As If Currency: Specify the currency code that the system uses as the default in the P09J240 program. When the As If Currency code is set, the system will perform a currency conversion for the domestic amounts by utilizing the currency code and the exchange rate that is retrieved using the date specified in the As If Date field in the program. The converted amounts are displayed in the As If amount columns in the program.

    If you leave this processing option blank, the As If Currency Code will not be set and As If processing will not occur by default.

On the Versions tab, enter values for the following processing options:

  • Joint Venture Master (P09J30) Version: Specify the version of the P09J30 program that the system launches when you access the program from the Row menu of the Joint Venture Cash Call Invoice Inquiry form or when you click the joint venture name link in the grid. If you leave this processing option blank, the system uses the ZJDE0001 version.

  • Cash Call Definition (P09J40) Version: Specify the version of the P09J40 program that the system launches when you access the program from the Row menu of the Joint Venture Cash Call Invoice Inquiry form or when you click the cash call ID link or exclusive cash call ID link in the grid. If you leave this processing option blank, the system uses the ZJDE0001 version.

  • Standard Invoice Entry (P03B11) Version: Specify the version of the P03B11 program that the system launches when you access the program from the Row menu of the Joint Venture Cash Call Invoice Inquiry form or when you click the invoice document number link in the grid. If you leave this processing option blank, the system uses the ZJDE0001 version.

27.3.3 Using the Joint Venture Cash Call Invoice Inquiry Program (P09J240)

To use the Joint Venture Cash Call Invoice Inquiry program (P09J240):

  1. From the Joint Venture Management module (G09J), click Daily Processing, Joint Venture Inquiries, and then select Joint Venture Cash Call Invoice Inquiry.

  2. Use the Joint Venture Name field in the header or create your own Saved Queries to support your inquiry needs.

  3. To view the amounts in the grid in a different currency, enter values in the following header fields:

    • As If Currency Code

      The system populates this field with the value that you have set up in the processing option, but you can override the value. The system converts the amounts into the currency that is specified in this field.

    • As If Exchange Rate Date

      If the As If Currency Code field has a value, the system populates this field with today's date (system date), but you can override the default date. The system uses the date in this field to retrieve the exchange rate to convert the amounts in the grid into the As If Currency.

  4. Review the information in the grid.

    Note that the system has populated the As If Amount columns with the amounts in the currency that you have specified.

27.4 Joint Venture Cash Call Receipts Inquiry (P09J230)

You can use the Joint Venture Cash Call Receipts Inquiry program (P09J230) to inquire and report on payment receipts for cash call invoices. The P09J230 program uses the Joint Venture Cash Call Receipts Inquiry business view (V09J230A), which is based on the Cash Call Ledger table (F09J41) and also includes columns from these tables: Joint Venture Master (F09J30), Business Unit Master (F0006), Cash Call Definition (F09J40), Customer Ledger (F03B11), and Receipts Detail (F03B14).

For each cash call invoice ledger record in the F09J41 table, the system displays the associated cash call definition from the F09J40 table, business unit information from the F0006 table, joint venture information from the F09J30 table, invoice information from the F03B11 table, and receipt details from the F03B14 table. Each line in the grid provides information related to each receipt detail. Additionally, the system retrieves the following information, if available:

  • Legal entity from the Joint Venture Legal Entities table (F09J10)

  • Project associated with the cash call from the Business Unit Master table (F0006)

Choose from more than 500 columns in the business view to report on your cash call receipts by joint venture, joint venture category codes, partner, managing business unit, business unit, business unit category codes, invoice document number, receipt batch number, cash call effective date, account, subledger, and so on.

27.4.1 Special Processing

The Joint Venture Cash Call Receipts Inquiry program (P09J230) has the functionality to convert the values in all the amount-related grid columns into the user-specified As If Currency. The system performs this currency conversion only when the As If Currency value is entered by the user, either in the processing option or in the program.

27.4.2 Prerequisite

Before you complete the tasks in this section, set up the processing options for the Joint Venture Cash Call Receipts Inquiry program (P09J230).

On the Defaults tab, enter values for the following processing option:

  • As If Currency: Specify the currency code that the system uses as the default in the P09J230 program. When the As If Currency code is set, the system will perform a currency conversion for the domestic amounts by utilizing the currency code and the exchange rate that is retrieved using the date specified in the As If Date field in the program. The converted amounts are displayed in the As If amount columns in the program.

    If you leave this processing option blank, the As If Currency Code will not be set and As If processing will not occur by default.

On the Versions tab, enter values for the following processing options:

  • Joint Venture Master (P09J30) Version: Specify the version of the P09J30 program that the system launches when you access the program from the Row menu of the Joint Venture Cash Call Receipts Inquiry form or when you click the joint venture name link in the grid. If you leave this processing option blank, the system uses the ZJDE0001 version.

  • Cash Call Definition (P09J40) Version: Specify the version of the P09J40 program that the system launches when you access the program from the Row menu of the Joint Venture Cash Call Receipts Inquiry form or when you click the cash call ID or exclusive cash call ID link in the grid. If you leave this processing option blank, the system uses the ZJDE0001 version.

  • Standard Invoice Entry (P03B11) Version: Specify the version of the P03B11 program that the system launches when you access the program from the Row menu of the Joint Venture Cash Call Receipts Inquiry form or when you click the invoice document number link in the grid. If you leave this processing option blank, the system uses the ZJDE0001 version.

  • Standard Receipt Entry (P03B102) Version: Specify the version of the P03B102 program that the system launches when you access the program from the Row menu of the Joint Venture Cash Call Receipts Inquiry form or when you click the receipt payment ID link in the grid. If you leave this processing option blank, the system uses the ZJDE0001 version.

27.4.3 Using the Joint Venture Cash Call Receipts Inquiry Program (P09J230)

To use the JV Cash Call Receipts Inquiry Program (P09J230):

  1. From the Joint Venture Management module (G09J), click Daily Processing, Joint Venture Inquiries, and then select Joint Venture Cash Call Receipts Inquiry.

  2. Use the Joint Venture Name field in the header or create your own Saved Queries to support your inquiry needs.

  3. To view the amounts in the grid in a different currency, enter values in the following header fields:

    • As If Currency Code

      The system populates this field with the value that you have set up in the processing option, but you can override the value. The system converts the amounts into the currency that is specified in this field.

    • As If Exchange Rate Date

      If the As If Currency Code field has a value, the system populates this field with today's date (system date), but you can override the default date. The system uses the date in this field to retrieve the exchange rate to convert the amounts in the grid into the As If Currency.

    • Review the information in the grid.

      Note that the system has populated the As If Amount columns with the amounts in the currency that you have specified.