We have marked the checkbox on Unit Accounts to 'Clear Balance During Year-End Close' but the records in the AA table for BBF still have values after year end close.
We have manually updated the amount using below script.
update c set c.DEBITAMT = 0, c.CRDTAMNT = 0, c.ORDBTAMT = 0, c.ORCRDAMT = 0
from AAG30002 c inner join AAG30001 b
on b.aaGLHdrID = c.aaGLHdrID and
b.aaGLDistID = c.aaGLDistID
inner join GL00100 d on
b.ACTINDX = d.ACTINDX
where d.Clear_Balance = 1 and b.ACCTTYPE = 2 and b.SOURCDOC = 'BBF'
and (c.DEBITAMT <> 0 or c.CRDTAMNT <> 0 or c.ORDBTAMT <> 0 or c.ORCRDAMT <> 0)
Would like to check is there any solution for this except to update using script?
We are using Microsoft Dynamics GP 2018 version 18.4.1361.
