Tuesday, May 22, 2012

Dynamics GP -The Account Number for ACTINDX 0 needs to be recreated

Problem:
After running check links, you get this error.
The Account Number for ACTINDX 0 needs to be recreated

Solution:
Reconcile all open years in your General Ledger: Utilities - Financial - Reconcile - Year. 


Associated Errors:
Multicurrency Account Master - The Account Number for ACTINDX 0 needs to be recreated

Cause:
The MC00200 table has extra records that assign currencies to accounts that do not exist

Solution:
Run this script to remove any unnecessary currency assignments

delete from MC00200 where actindx not in (select actindx from gl00100)

No comments:

Post a Comment