Introducing retention % and Advance payment in Contract.
I have a scenario like this.
Its a construction industry. The contractor submit bills on a regular basis as the work progresses.
I have to retain 1% of his amt every time of the bill. This has to be captured with reference to his contract value every time.
Also the advance money given to him (in value or %) is to be captured from the bill which shall be deducted from the gross amt paid.
Can u helpme whether the said conditions can be captured at the header level of the contract? Whether the same conditions can be introduced at the item level?
Also please guide me as to how this scenario can be mapped?