Job Liquidity Integration
The integration of the standard Microsoft Dynamics 365 Business Central Liquidity module (Cash Flow) into COSMO Project Manufacturing allows for an in-depth analysis of cash flow for job-related sales and purchases. This topic describes functionality that is specific to COSMO Project Manufacturing.
For detailed information about setting up or using the standard Job Liquidity module, refer to the Microsoft Dynamics 365 Business Central Help relating to Cash Flow.
Setup
Settings to use Cash Flow in COSMO Project Manufacturing are defined in the Cash Flow Setup and Projects Setup pages. Each is described in this section.
Cash Flow Setup
The Cash Flow Setup page – accessed using Tell Me – contains two fields in the Accounts FastTab to identify the cash flow accounts for Job Cost and Job Sales.
| Field | Description |
|---|---|
| Job Cost CF Account No. | Specifies the number of the cash flow account in which the values for job costs should be recorded. Open job procurement entries and/or scheduled job liquidity entries are used to calculate job costs. |
| Job Sales CF Account No. | Specifies the number of the cash flow account in which the values for job sales should be recorded. Scheduled job liquidity entries are used to calculate job sales. |
Projects Setup / Project Card
On the Planning FastTab of the Projects Setup page, the Cash Flow Pmt. Code field indicates the payment terms for the cash flow date calculations. This value defaults to the Cash Flow Pmt. Code field in the Project Card but can be changed as needed.
Payment Terms are always considered when calculating the Cash Flow Date. For example, if you plan costs in a liquidity entry on January 1st, 2022, then the Cash Flow Date is January 15th, 2022 if the Payments Terms Calculation is 14 days.
- If the Consider CF Payment Terms toggle is turned on in the Cash Flow Forecast Card page, then the value from the Cash Flow Pmt. Code field on the Project Card is used. If this field is empty, then the value in the Payment Terms Code field on the Project Card is used.
- If the Consider CF Payment Terms toggle is not turned on in the Cash Flow Forecast Card page, then the value in the Payment Terms Code field on the Project Card is used.
Job Planning
This section describes the usage of the Job Liquidity integration in the Job Planning process.
Job Planning and Processing with Cash Flow
Multiple fields in the Job Planning and Processing page display information about the cash flow for the job.
The fields relating to Job Liquidity in the Job Planning and Processing page are described in the following table.
| Field | Description |
|---|---|
| TDC Liquidity Schedule (LCY) | Indicates the total direct cost that has been scheduled, in local currency; used for the Cash Flow calculation. |
| TDC Liquidity Request (LCY) | Indicates the total direct cost that has been requested, in local currency. |
| TDC Liquidity Payment (LCY) | Indicates the total direct cost that has been paid, in local currency. |
| TP Liquidity Schedule (LCY) | Indicates the total price that has been scheduled, in local currency; used for the Cash Flow calculation. |
| TP Liquidity Request (LCY) | Indicates the total price that has been requested, in local currency. |
| TP Liquidity Payment (LCY) | Indicates the total price that has been paid, in local currency. |
The values in the fields are determined by the setting in the Liquidity Type field in the Job Liquidity Entries page, accessed by choosing Line > Liquidity Entries on the Related menu.
The values scheduled for total direct cost and sales are visible in the TDC Liquidity Schedule (LCY) and TP Liquidity Schedule (LCY) fields in the Job Planning and Processing page.
The fields in the Job Liquidity Entries page are described in the following table.
| Field | Description |
|---|---|
| Liquidity Type | Indicates the type of liquidity entry. The options are: - Schedule: used for the Cash Flow calculation. - Request: currently has no functionality. - Payment: currently has no functionality. |
| Date | Indicates the date on which this liquidity entry is valid. |
| Description | Short description of the liquidity entry. |
| Special Position | Currently has no functionality. |
| Total Direct Cost (LCY) | Specifies the total direct cost for the liquidity entry, in local currency; used for the Cash Flow calculation. |
| Total Cost (LCY) | Specifies the total cost for the liquidity entry, in local currency. |
| Sales Line Amount (LCY) | Specifies the sales line amount for the liquidity entry, in local currency; used for the Cash Flow calculation. |
| Person Responsible | Specifies a resource that is responsible for the liquidity entry. |
| Job No. / WBS | Transfers from the Job Planning and Processing line. |
| Job Procurement No. | Transfers from the Job Procurement line. |
Procurement with Cash Flow
Once Cash Flow has been set up in the Job Planning and Processing page, any procurement will result in an update of the Liquidity Entries. This periodic update must be done manually if needed.
Cash Flow Worksheet
Once all job processing has been completed, the entries can be managed in the Cash Flow Worksheet. The Options FastTab on the Suggest Worksheet Lines request page includes settings for COSMO Project Manufacturing.
The options relating to COSMO Project Manufacturing are described in the following table.
| Option | Description |
|---|---|
| Procurement Material | Determines if procurement materials are included in the cash flow forecast. |
| Procurement Service | Determines if procurement services are included in the cash flow forecast. |
| Liquidity Entries Purchase | Determines if purchase liquidity entries are included in the cash flow forecast. |
| Liquidity Entries Sales | Determines if sales liquidity entries are included in the cash flow forecast. |
The Cash Flow Worksheet is populated with all relevant entries when the Suggest Worksheet Lines function is run.
Once the lines are registered, all entries can be viewed from the Cash Flow Forecast Card. Additionally, an overview of all entries, including Job Procurement, Job Liquidity Purch., and Job Liquidity Sales, is available from the Cash Flow Forecast Statistics page.
Job-related information is also available in the CF Availability by Periods page, accessed from the Related menu on the Cash Flow Forecast Card.
See Also
Job Planning and Processing Page
Feedback
Submit feedback for this page .