Project Ledger CU69

This section contains enhancements in Infor CloudSuite Financials for 11.0.69.0.

Added fields for third party document management and invoice print integration with Project Invoicing

These are the enhancements that were made:

  • New field on the FEG to designate if using third party for invoice print must be enabled
  • New field on the Project Contract Invoice for third party invoice print status
  • New print status parameter field on Generate/Journalize Invoice actions
  • New Set Print Status to Printed action for third party
  • New Update Invoice Link (invoice URL) action for third party
  • New field/link on the Project Contract Invoice for URL to view invoice

Program/Business class/Process affected:

ProjectContractInvoice

JT-1415567

Added override billing method for Pass Through

Pass Through is added as an override billing method on posting Projects and Project Billing Override records. A Pass Through Finance Structure field is added to the Project Funding Source and applies to any pass through transactions. Pass Through billing has no mark up, and retainer, retention, fees, and allowances do not apply to pass through transactions. Pass Through transactions are posted to the pass through accrual/clearing account. They are not posted to billed/unearned or earned/unbilled accounts. Pass through transactions do not apply to maximums and are totaled separate from project contract/funding amounts used for maximums. Added new fields: Pass Through Finance Structure, Total Billed Pass Through and Total Recognized Pass Through.

Program/Business class/Process affected:

ProjectFundingSource business class

To test this enhancement, add pass through finance structure to the project funding source. Add pass through as override billing method on project or project override. Post cost transactions to the project or override account/account category. Run generate invoices action and validate pass through transactions are included on the invoice. Journalize invoice and ensure pass through journal is created. Run the same process for revenue recognition.

Pass Through billing method is only valid for billing override at the posting project and billing override levels.

JT-1410531

Added ability to transfer multiple transactions to a new project

Action transfer cost transaction to another project only allowed selection and transfer of a single expense. This enhancement allows the user to select multiple cost transactions to transfer. Added an action to automate the journal entries that are required to transfer multiple posted project expenditures from one project to another project.

Program/Business class/Process affected:

New Transfer Multiple Transactions action added to the GLTransactionDetail business class. Use Unbilled transactions list to execute the action.

Use these steps to test the enhancement:

Test the action: Select unbilled transactions and transfer to any piece of the finance code block including Accounting Entity, Accounting Unit, Account, Sub Account, Project and FD1-10 user dimensions. Verify that the entries are journalized and the journal control is created in a released status. The journal must be posted in so that the transfer transactions are appended to the invoice.

Dependencies: The action is only valid for unprocessed transactions where Billed = unprocessed, Capitalized = unprocessed, Labor Distribution = unprocessed, and Indirect Burden = unprocessed.

Project Ledger-generated transactions with System Code = PS cannot be transferred.

Project Ledger-generated labor distribution transactions with System Code = PR and Event Codes = PL, BD, or PJ cannot be transferred.

JT-1402142

Add transaction date through date to Generate Invoices and Recognize Revenue action

Added a new parameter field to specify a transaction through date. This field is used in addition to the posting date range selection.

Program/Business class/Process affected:

Generate Invoice action and Recognize Revenue action.

Use these steps to test the enhancement:

  1. Run the Generate Invoice action and the Recognize Revenue action.
  2. Select a Transaction Through Date.
  3. Verify that only transactions with transaction date up to and including the through date are processed.

Dependencies: Posting date range is required. Transaction through date is optional.

JT-1402097

Added the ability to support tax table with unique tax accounts

If unique tax accounts are defined on the Output Finance Code Block for each Tax Code that is attached to the tax table, only one tax journal entry line is created. The tax journal entry line that is created is the first value of Output Finance Code Block. Enhanced tax journal entry to create a single line for each tax code account. This enhancement is required for HSN/SAC Code enhancement to support tax requirements for India.

Program/Business class/Process affected:

Generate Invoices action. Added business class ProjectContractInvoiceTaxLine.

Use these steps to test the enhancement:

Add a taxable project funding source to a project contract. If using the Infor Tax system, assign a tax table tax code that contains multiple tax codes. If using the Vertex Tax system, you must use tax code accounts and tax distributions. Run the generate invoices action. Drill Around from the invoice transactions to tax lines to validate tax distributions.

Dependencies: If using Infor Tax system, tax entity setup must use tax code accounts. There must be unique accounts for each tax code. If using the Vertex Tax system, and you require multiple distributions, you must use tax code accounts and tax distribution codes.

JT-1350377

Added advance billing functionality to Project invoicing

Added an action to the ProjectContractInvoiceLine so that you can create a bill in advance invoice transaction. Bill in advance results in a single line added to the invoice for the advance billing. Advance billing amounts can be taxed and can be placed on hold for application.

Program/Business class/Process affected:

Added ProjectContractAdvance business class and modified ProjectFundingSource and ProjectContractLine business classes.

Use these steps to test the enhancement:

  1. Run Generate Invoices.
  2. From the project contract invoice line, select the Create Advance Billing action.
  3. Specify the amount to bill in advance and description. Select a posting project under the project contract. Override the advance billing finance structure. Designate whether the Advance Billing is taxable.
  4. Optionally, select hold to place the bill in advance application on hold. The Advance Billing will result as a new project contract invoice line. Validate journal entries to Advance Billing account.

Dependencies: The Advance Billing action is only available on project contract invoices where the funding source is defined as an external funding source.

JT-1328574