Retention % and amount on Sales Invoice

Business Central/NAV
1

Hello,

Any one has any idea ho to add retention % on a sales invoice in Business Central?

BR

2

It doesn’t exist. A way to process this would be to issue a Prepayment for the 90% (or whatever your % is) and the hold-back is the amount remaining on the invoice. It isn’t a true retainage process, but it would get the job done without an Extension or customization.

Best Regards,
Ben Baxter
Accent Software Inc

3

Thanks Ben for the reply,
what if im doing a project sales invoice where there is no Sales order in the project module to process a prepayment?

BR

4

For Projects, build it out in your Billable Project Planning Lines. If your contract is $100k, you could have two lines, one for $90k, and the retainage of $10k. Or split into more planning lines, with the final planning line being the amount retained.

What is nice about billing via Projects is the ability to set future Planning Dates so the system can remind you of what needs billed based on date.

Best Regards,
Ben Baxter
Accent Software Inc

5

Thanks @Ben_Baxter for the reply.

I have another question related to projets.
If I am doing a sales invoice from project planning lines for an assembly item.
The system is not allowing me to explode BOM after the invoice is created.

Do you have any idea how to explode BOM after I create Sales invoice?

BR

6

I haven’t played too much with Assembly Items (Explode BOM) on Projects. Microsoft may have code to prevent you from Exploding the BOM after invoicing. I would simply test what is and isn’t possible and then write your process documentation to match, or customize to suit the need.

Best Regards,
Ben Baxter
Accent Software

7

Thanks Ben for the reply.

Obviously we have to add the assembly item twice as billable line type. The first line to be invoiced to customer.
Debit: receivables
Credit: revenue

The second line we can explode bom.once bom is exploded the line typ changes to budget and we can record costs on component items.

Explode bom doesnt Work if the line type is budget.
Also it doesnt work after creating sales invoice.