Skip to main content
Answer

Reconciliation Statement Report - Reconciled Documents Dated After Reconciliation date

  • August 19, 2024
  • 4 replies
  • 61 views

Forum|alt.badge.img

Hi,

Do you know how transactions are picked into the “Reconciled Documents Dated After < Reconciliation Date> “ . And how can we fixes the difference?

 

Appreciate your help. 

Thank You,

Dulanjana

Best answer by Laura03

Hello @dsenevirathne54 ,

From Acumatica Report Designer, Reconciliation Statement report, here is the exact logic being used to print “Reconciled Documents dated after ...” in the colored section of your report.

If the Reconciled Date of a bank transaction is greater than the Reconciliation Date at the top of the Reconciliation Statement screen, the title on the colored section of the report changes based on the Iif statement shown.

Do your documents listed in the “Dated After” section have a late Clear Date on the Reconciliation Statement screen?

 

Laura

4 replies

Manikanta Dhulipudi
Captain II
Forum|alt.badge.img+15

Hi @dsenevirathne54 

Any transactions posted after the reconciliation will show as reconciled documents after date xyz.

You can see hat information at the end of the reports.

Example: If a payment is received in July and reconciliation is done during the July period,

 

If the user has performed any transaction in the month of August like refund to the original payment of July and the transaction if recorded in the current month,

Thanks


Forum|alt.badge.img

Hi @Manikanta Dhulipudi ,

Thank You for your feedback. 

I understand that. But this amount shows as a difference in the current month. If the case is what you have mentioned, isn't it should belong to the next period not raising a difference?

And I’m thinking this shows bank transactions that are available in July, But reconciled with transactions recorded in August. 

Thank You,

Dulanjana


Laura03
Captain II
Forum|alt.badge.img+19
  • Captain II
  • Answer
  • August 19, 2024

Hello @dsenevirathne54 ,

From Acumatica Report Designer, Reconciliation Statement report, here is the exact logic being used to print “Reconciled Documents dated after ...” in the colored section of your report.

If the Reconciled Date of a bank transaction is greater than the Reconciliation Date at the top of the Reconciliation Statement screen, the title on the colored section of the report changes based on the Iif statement shown.

Do your documents listed in the “Dated After” section have a late Clear Date on the Reconciliation Statement screen?

 

Laura


Forum|alt.badge.img

Hi @Laura02 ,

That explains the behavior. Appreciate your support. 

Thank You,

Dulanjana