2141120 - Incorrect General Ledger Account Picked From Migration Of Down Payment VAT Posting

You have completed the migration of down payments with VAT postings using the  Open Items Receivable template.

Expected posting is:

Output tax account is debited

Down payment received account is credited

Actual Posting:

Migration clearing account 456  is debited

Down Payment received 789 account is credited.

1. Go to the General Ledger work center, and choose the Journal Entries view.
2. Choose Advanced.
3. In the Journal Entry Type field select Journal Entry Type 0079 - Data Migration, and source document type 37- Payment.
4. Select your source document id 123 and view the posting.

Migration clearing account 456  is debited

Down Payment received 789 account is credited.

G/L Account under Received Down Payments - Tax Clearing tab is posted when it collects the tax amounts for down payments and any open item is cleared against a migration clearing account set for each sub-ledger. In this case it selects the  Initial Data Carryforward A/R Account. The migration process therefore updates the operative receivables and payables management in financial accounting.

The described system behavior is correct in posting the down payment vat posting clearing to a GL account maintained under Received Down Payments - Tax Clearing and clears against default GL account for set by system for Migration clearing account for sub-ledger AR only ( Initial Data Carry forward A/R Account )

Instead of Migration,If the purpose of the down payment VAT posting is to complete statistical VAT posting / clear the tax amounts against the tax authority then you can follow the below steps so that the amount of tax gets adjusted.

1. Go to the Receivables work center, and choose the Customers view.
2. Select the Customer Accounts subview.
3. Select a customer and choose View.
4. Choose New Charge/Credit
5. Select 1 Customer charge and enter the details without tax and post it
6. Repeat the above again till step 3 and in step 4 and this time choose 2 Customer Credit and enter the details with tax and post it. When you post the above with correct tax code then the tax amount will then be posted to the tax accounts.

The above two transactions will be posted as Other payable and Other receivable which you can manually clear them. Also the GL account picked is from Output tax account.

KBA , AP-ACC , Business ByDesign: Financial Accounting , How To