Views:

Cause: There could be an incorrect fiscal year (gltran.fiscyr) which would prevent the transaction from being included on the Detail GL Report.


Resolution:  Run the following query in sql server query analyzer on the Dynamics SL application database.


select fiscyr, perpost, * from gltran where fiscyr <> left(perpost,4)


If this returns anything, update the records with this update statement.


update gltran set fiscyr = left(perpost,4) where fiscyr <> left(perpost,4)


If then ending balances still do not agree, initialize the ptd balance for accounts that are incorrect.  Net the debit amount and credit amount from the detail GL report and enter that as the ptd balance for the account(s) that is incorrect.