PROJECTCOSTTOCOMPLETE function
Created by Harry Lewis, Modified on Tue, 16 Jul at 9:34 AM by Gabriel Michaud
Applies to
- Velixo NX
- Velixo Classic
- Acumatica, MYOB Acumatica, Cegid
Description
The PROJECTCOSTTOCOMPLETE function calculates the Cost to Complete for one or more projects and tasks.
Syntax
PROJECTCOSTTOCOMPLETE(Connection, Project, Task, AccountGroup, CostCode, InventoryItem, UseProjectCurrency)
Parameters
The PROJECTCOSTTOCOMPLETE function uses the following parameters (see our article on Filtering Velixo functions):
Parameter | Required/ Optional | Description |
Connection | Required | The name of the connection as configured in the Connection Manager |
Project | Required | The Project(s) to include |
Task | Optional | The Task(s) to include |
AccountGroup | Optional | The Account Group(s) to include |
CostCode | Optional | The Cost Code(s) to include |
InventoryItem | Optional | The Inventory Item(s) to include |
UseProjectCurrency | Optional | TRUE/FALSE value indicating if the amount should be returned in the project's defined currency (default = FALSE) |
Example
Assuming the following project information within the ERP:
=PROJECTCOSTTOCOMPLETE("ACE","1002HOTEL","01", "LABOR", "01313",, FALSE)Description
Calculates the cost to complete for:
Project: 1002HOTEL
Task: 01
Account Group: LABOR
Cost Code: 01313
Inventory Items: all
and returns the value in the default currency.
Result
1,000,000.00
(note: cell references have been used for the parameter values)
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article