We need retainage to show up as a separate column on all of the AP & AR agings.

Hello @khowe86 ,

Did you try the AR Aged Period Sensitive report with Retainage?  Remember to select the Report Format as shown below.  This report has unreleased retainage in a separate column.

Laura

Hi @khowe86 , @Laura02 

With the AP Aging by Project (2023 R2) and AR Aging by Project Reports (2023 R1), we have a format including retainage for selection, similar to the screen shot above;

We’re happy to collect feedback on those options and reports in general.  Thank You.

The new AP Aging by Project (2023 R2) and AR Aging by Project Reports (2023 R1) are compatible with our 2022 R2 environment so we went ahead and added them to it.

This is all great news! Thank you Ron, Joel and Laura!  AR seems to be covered! 

As for AP,  I’m interested in tying out the balances of AP & AP retainage to the General Ledger.  I see AP Aging (Detailed with Retainage) but not on the AP Period sensitive report.  We need the AP Period Sensitive to tie to each specific accounting month.  Is there a way to add retainage to the AP Aged Period Sensitive (Detailed) report?  

Hi @khowe86 were you able to find a solution? Thank you!

Joel - there still isn’t an AR Aging report with Retainage that is Period-Sensitive that I can see?
 

Hi @khowe86,

Take a look at the AP Retained Balance report.  It allows you to select the financial period as follows:

It should provide the retainage subledger detail needed to support each GL accounting month.

HI Terry,

Thanks - we are using this report, but….is there a report by financial period with the AP trade and the retainage all on one report?  That’s what I’m really after.  We used to have this in Sage 300 and miss it in Acumatica.

Thanks in advance!

Best,

Kay