Share This Post

GP Updates

GP Intercompany Processing Inquiries and Reports

This article explains about the Microsoft Dynamics GP Intercompany Processing Inquiries and Reports documentation and explains how to use inquiries and reports to analyze intercompany activity.

The inquiry windows and reports in Great Plains Intercompany Processing allow you to access information quickly and to display the information either on the screen or on a printed report.

The following information is discussed:

  • “Inquiries,” explains how to use the GP Intercompany Processing inquiry windows to view transaction information.
  • “Reports,” describes how to use reports to analyze intercompany activity.

Dynamics GP Intercompany Processing Inquiries

Inquiry features help you analyze intercompany financial information. Analyzing data contained in your accounting system will let you make reasoned choices about managing your company resources.

This information is divided into the following sections:

  • About reporting currency
  • Viewing transactions for a posted General Ledger journal entry
  • Viewing intercompany information for a transaction in a destination company
  • Viewing exchange rate information for an intercompany multi-currency voucher
  • Viewing exchange rate information for all destination companies on a voucher

About Reporting Currency

A reporting currency is used to convert functional or originating currency amounts to another currency on inquiries and reports.

During the reporting currency setup in Multicurrency Management, you will set up a reporting currency and enter a default exchange rate and the rate calculation method. Depending on how your system is set up, you might be able to override the default reporting currency exchange rate or rate calculation method on inquiries and reports.

Viewing Transactions for a Posted General Ledger Journal Entry

Use the Journal Entry Inquiry window to view transaction detail for General Ledger posted journal entries in an open fiscal year.

Multiple journal entries with the same number might exist if a recurring batch is posted or a reversing transaction is posted. If you enter a journal entry for which multiple entries exist, the journal entry with the oldest posting date in the open year will be displayed.

If you use the Journal Entry lookup button, all unique journal entries will be displayed, and you can select the journal entry you’d like to view. The Intercompany button is enabled only if the currently displayed journal entry originated from an intercompany generated transaction.

To view transactions for a posted General Ledger journal entry:

  • Open the Journal Entry Inquiry window. (Inquiry >> Financial >> Journal Entry Inquiry)
  • Enter or select the journal entry number to view.

Viewing Intercompany Information for a Transaction in a Destination Company

Use the Intercompany Audit Trail Code Inquiry window in destination companies to view the originating company, originating audit trail code, and journal entry for posted intercompany transactions.

To view intercompany information for a transaction in a destination company:

  • Open the Journal Entry Inquiry window. (Inquiry >> Financial >> Journal Entry Inquiry)
  • Enter or select the journal entry number to view.
  • Choose the Inter company button to open the Intercompany Audit Trail Code Inquiry window, where you can view information from the originating company. You can view the originating company ID, originating company name, originating audit trail code, and originating journal entry number.

Viewing Exchange Rate Information for an Intercompany Multi-currency Voucher

Use the Exchange Rate Entry Zoom window to view the exchange rate information for the selected intercompany voucher in Payables Management.

To view exchange rate information for an intercompany multi-currency voucher:

  • Open the Payables Inquiry – Document window. (Inquiry >> Purchasing >> Transaction by Document)
  • Select the intercompany multicurrency document to view exchange rate information for, then click the Document Number or Voucher/Payment Number link to open the Payables Transaction Entry Zoom window.
  • In the Payables Transaction Entry Zoom window, choose the Distribution button to open the Payables Distribution Zoom window.
  • In the Payables Distribution Zoom window, choose the Co. ID expansion button to open the Exchange Rate Entry Zoom window to view exchange rate information.

Viewing Exchange Rate Information for all Destination Companies on a Voucher

Use the Intercompany Destination Exchange Rate Inquiry window to view the exchange rate information for all destination companies on an intercompany voucher in Payables Management.

To view exchange rate information for all destination companies on a voucher:

  • Open the Payables Inquiry – Document window. (Inquiry >> Purchasing >> Transaction by Document)
  • Select the intercompany multicurrency document to view exchange rate information for, then click the Document Number or Voucher/Payment Number link to open the Payables Transaction Entry Zoom window.
  • In the Payables Transaction Entry Zoom window, choose the Distribution button to open the Payables Distribution Zoom window.
  • In the Payables Distribution Zoom window, choose the Rates button to open the Intercompany Destination Exchange Rate Inquiry window.

Dynamics GP Intercompany Processing Reports

You can use Intercompany Processing reports to analyze records of your intercompany transactions in the General Ledger and Payables Management modules.

This information is divided into the following sections:

  • GP Intercompany Processing report summary
  • Creating a report option

GP Intercompany Processing Report Summary

You can print several types of reports using Intercompany Processing. Some reports automatically are printed when you complete certain procedures; for example, posting journals can automatically be printed when you post transactions, depending on how your posting options are setup.

You can choose to print some reports during procedures; for example, you can print an edit list when entering transactions by choosing the Print button in the batch entry window. In order to print some reports, such as analysis or history reports, you must set up report options to specify sorting options and ranges of information to include on the report.

Creating a Report Option

Report options include specifications for sorting options and range restrictions for a particular report. In order to display several Inter company Processing reports, you must first create a report option. Each report can have several different options so that you can easily print the information you need.

For example, you can create report options for the Intercompany Distribution Breakdown Register that show either detailed or summary information.

Use the Financial, Purchasing, or System report options windows to create sorting, restriction, and printing options for the reports that have been included with Intercompany Processing.

For more information on Microsoft Dynamics GP Intercompany Processing Inquiries and Reports, please contact us.

Share This Post

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

Skip to toolbar