Standard Crystal Report - InterCompany AP Report

Issue/Symptom/Question

Standard Crystal Report - InterCompany AP Report

Applies To

Penta for Windows

Crystal Report - InterCompany AP Report

Resolution/Fix/Answer

The InterCompany AP report provides substantiation for the intercompany payable invoices generated by PENTA. The report includes separate sections with supporting detail for the employee, equipment, vendor, and journal entry charges that produced intercompany payable entries between two companies. This report that includes all intercompany payables generated between two related companies within a date range that you specify.

This report only includes the automatic intercompany accounts payable invoices generated by PENTA when you charge resources across balance sheet OUs. This report includes all intercompany invoices generated during the date range you specified, regardless of whether you paid the invoices or they remain open.

Selection

You can limit record selection and printing of certain values for this report by:

  • Period Begin Date
  • Period End Date
  • AP Organization Unit Id – The balance sheet OU to which the intercompany payable posted.
  • InterCompany Vendor Id – The intercompany vendor to which the intercompany payable is owed.
  • Job Id – The job to which the charges were posted that resulted in the intercompany payable.
  • InterCompany Charge Type – Identifies the type of charge from which the intercompany payable was created:
  • AP
  • Labor
  • Equipment
  • AP Subcontract
  • Journal entries
  • AP Account Number

Sort

Records sort in order by:

  • AP OU Id
  • Currency Id
  • Vendor Id
  • Charge OU Id
  • InterCompany Charge Type

Page Breaks - By default, this report provides a page break for each AP OU Id.

Totals

This report has subtotals for:

  • InterCompany Charge Type
  • Charge OU Id
  • Vendor Id
  • Currency Id
  • AP OU Id

Grand totals for the report display on the last page.

Report Code: ap_interCoAP_p194_cr11.rpt

Available Parameters:

Report Example:

Fields: Labor Charge Type

Date - This is the transaction distribution date, which is also the invoice date of the InterCompany invoice.

Invoice # - This is the transaction document #, which is also the invoice number assigned to the InterCompany invoice.

Job ID - If the timecard resulting in InterCompany entries is charged to a job, this is the Job Id.

Other Distribution - If the timecard resulting in InterCompany entries is not charged to a job, this identifies the distribution:

  • WO – Work Order Id
  • ACCT – Account #
  • FA – Asset Id

Distribution Description - The description of the job, work order, asset, or account.

Employee Name - The employee’s last name, first name.

Payroll Class - The employee’s payroll class at the time of the labor charge.

Pay Period End Date - The End Date of the pay period the timecard falls in.

Description - Identifies whether the entries were generated with labor distribution, gross to net, manual check, or bonus check process.

Hours - Labor hours on the timecard.

Amount - Amount calculated by the labor distribution or gross to net process.

Fields: Equipment Charge Type

Date - The transaction distribution date, which is also the invoice date of the InterCompany invoice.

Invoice # - The transaction document #, which is also the invoice number assigned to the InterCompany invoice.

Job ID - If the equipment charge resulting in InterCompany entries is charged to a job, this is the job ID.

Other Distribution - If the equipment charge resulting in InterCompany entries is not charged to a job, this identifies the distribution:

  • WO – Work Order Id
  • ACCT – Account #
  • FA – Asset Id

Distribution Description - The description of the job, work order, asset, or account.

Equipment ID - Id of the Equipment.

Description - The description/name of the equipment.

UM - The unit of measure.

Units - The number of units charged.

Amount - Amount of the equipment charge.

Fields: AP Invoice-Subcontracts Charge Type

Date - The transaction distribution date, which is also the invoice date of the intercompany invoice.

Invoice # - The transaction document #, which is also the number assigned to the intercompany invoice.

Job ID - Id of the job to which the invoice was charged.

Distribution Description - The description of the job, work order, asset, or account.

Vendor ID - Id of the Vendor that issued the invoice.

Name - Name of the Vendor that issued the invoice.

Subcontract ID - Id of the subcontract to which the invoice was charged.

Subcontract Description - Description of the subcontract.

Amount - The amount of the invoice.

Fields: AP Invoice Charge Type

Date - The transaction distribution date, which is also the invoice date of the InterCompany invoice.

Invoice # - The transaction document #, which is also the number assigned to the InterCompany invoice.

Job ID - Id of the job to which the invoice was charged.

Other Distribution - If the invoice is not charged to a job, this identifies the distribution:

  • WO – Work Order Id
  • ACCT – Account #
  • FA – Asset Id

Distribution Description - The description of the job, work order, asset, or account.

Vendor Id - Id of the Vendor that issued the invoice.

Name - Name of the Vendor that issued the invoice.

Transaction Description - The description entered on invoice distribution resulting in the intercompany payable. System Option 104 (Default Descr to Vendor Name) determines whether this description defaults as the vendor name.

Amount - The amount of the Invoice.

Fields: Journal Entries Charge Type

Date - The transaction distribution date, which is also the invoice date of the InterCompany invoice.

Invoice # - The transaction document #, which is also the number assigned to the InterCompany invoice.

Journal Entry # - The general journal entry # or recurring journal entry #.

Amount - The amount of the Journal entry.