AIA retention billing

@Tcollins1968 

From a projects perspective you can get 1 AIA, it’s on the AR side where several invoices are created. 

you can do this by going to the invoices tab of the project and select release retainage. 

Check the invoices that need to have retainage released (it can be all or some) and specify the amount to release in the “percent to release” column (in this case, we will release 100%) and click process:

release the newly created AR documents (this can also be found on the invoice tab of the project). this 

Once released, run project billing for a zero dollar amount and click “Print AIA Report” for review:

the retainage amount is reduced and the current amount due is updated with the payment amount:

as you can see, although we had 2 retainage invoice documents, the AIA combined the amounts (this would apply to however many lines you released). release the pro forma once it’s been reviewed (a zero dollar amount AR invoice will be created that you will need to release as well)

there are a ton of other retainage solutions I've worked on so if you have any others, I am happy to help!

@Tcollins1968 were the credit memos added as change orders or done through a AR/AP?

@iqraharrison48 We ran into this same issue during our implementation and were told by our Acumatica support team that there was absolutely no way we could get AIA retention billings.

This fix worked perfectly. The only thing I would add is that the dates are very important for this. @Tcollins1968 had the issue with credit/debit adjustments, and I would guess it is because of the dates of the adjustments vs. the dates on the ProFormas. I noticed the same thing with the AIA retention. If the ProForma invoice date was on or before the date of the AR retention invoices, I could generate a retention AIA that showed a current payment due equal to the consolidated retention amount. But if the ProForma invoice date was AFTER the AR retention invoice date, then the AIA would show $0.00 in the current payment due. 

Another thing I noticed was that if you ran the AIA ProForma on an invoice date that already had a ProForma, then it would also show $0.00 for the current payment due. So for example, if I ran a normal project billing with pending values for March 2023 dated 3/31/23, then released the AR retention on 3/31/23, then ran the $0.00 project billing to get the retention AIA dated 3/31/23, I would get a ProForma AIA that showed a $0.00 current payment due. Alternatively, if I did the same thing as above, but released the retention on 4/1/23, and ran the $0.00 project billing dated 4/1/23, I would get an accurate AIA retention billing from that ProForma. 

This also partially solves the problem of not being able to consolidate retention billings, since the AIA kind of does it automatically (even though Acumatica technically still generates individual AR documents for each ProForma, which is an awful feature). I saw some other threads where people were mentioning that there customers were very frustrated receiving separate invoices for each retention billing. But almost all of our customers require the retention to be billed out on an AIA. They wouldn't even accept the official Acumatica AR retention invoice. 

Anyways, if you are affiliated with Acumatica, you should publish this solution ASAP because I do not think this is common knowledge within the Acumatica support team and it is an absolute necessity for the construction industry. God bless the current Acumatica construction users who are trying to make due without this. You guys are the real heroes haha. 

@Tcollins1968 i learned that the hard way too.  i made my own rule of thumb and say if it’s done in projects, do it in projects (specifically for billing)