Symptom
You are migrating General Ledger Account Balances and received the below error message:
Accnt Initial Data Carryforward - XYZ in ABC Chart of Accounts not permitted for posting using journal entry voucher
Environment
Business ByDesign
Reproducing the Issue
- Go to the Business Configuration work center.
- Select the Implementation Projects view.
- Select your implementation project and click Open Activity List.
- Search and open the activity Migration of Accounting Transaction Data.
- Click Migrate accounting transaction data using the migration tool.
- Process the file and during simulate import you get the error.
Accnt Initial Data Carryforward - XYZ in ABC Chart of Accounts not permitted for posting using journal entry voucher
Cause
When you migrate G/L account balances, the amounts are posted on the G/L accounts of the corresponding sub ledgers.
The G/L account balances will also be forwarded automatically to Migration Clearing Accounts.
Here the system will not post to the corresponding sub-ledgers due to a G/L account posting-block stating Only automatic postings allowed.
Below are some Examples of sub ledgers of G/L accounts:
Initial Data Carryforward - Accounts Payables
Initial Data Carryforward - Accounts Receivables
Initial Data Carryforward - Asset Account
Initial Data Carryforward - Cash Account
Initial Data Carryforward - Open Items Payable
Initial Data Carryforward - Inventory
Resolution
- Go to Business Configuration work center.
- Go to Implementation Projects view.
- Select the project and open activity list.
- Open activity Charts of Accounts, Financial Reporting Structures, Account Determination.
- Click link Edit chart of accounts.
- Select a G/L in question and go to the view G/L Account Posting Block and select All Postings Allowed from the dropdown.
- Also change the corrresponding sub-ledgers G/L Account Posting Block to All Postings Allowed.
- Save.
Now you are able to migrate the G/L account balances.
Keywords
KBA , migration of accounting transaction data , migrating general ledger account balance , accnt initial data carryforward - xyz in , SRD-FIN-GL , General Ledger , How To