Hi Community,
Hoping someone can help shed some light on this issue.
We would like the system to calculate customer retention amounts on Milestone invoices on Fixed Price projects and we are trying to determine how to do so. In the process of testing, we are unable to get this to work.
We are on version 10.0.4, platform version: Update 28 (7.0.5314.35441)
Questions:
- Are you not able to do this by design?
- Have we missed some configuration?
- Is this a bug?
Issues we see:
- Even though customer retention terms are entered on the Project Contract, they do not default to the retention % field on the Milestone.
Project contract
Project Milestone
- When generating the Invoice proposal for the milestone billing, the retention % does not default.
- Even though there is a manually entered retention % on the Invoice proposal and the totals reflect the retained amount, the retention is not deducted when posted. The invoice posts at $ 100,000 value as opposed to the $ 90,000 value.
Invoice totals
Posted Invoice transaction
Posted Journal Voucher
Our configuration is as follows:
- Setup Ledger account for Customer retention
- Setup Account for automatic transactions for Customer retention
- Setup number sequence for customer retention terms
- Setup Customer retention terms
- Setup Shared Category, Project Category and Category Groups
------------------------------
Christopher Ho Yee
Altius Consulting
Richmond BC
------------------------------