Import Open AR invoices to load data from previous system

(0) Share

Report

Posted on by Hossam Z. EL Hassan

Hi,

I need to import Import Open AR invoices to load data from previous system. I am using the General journal data entity through a data management import. We would like to user the control account Trade Accounts Receivable as the offset account but since it is flagged for no manual entry, I am not able to use this account. Which account I should use instead?

Also in UAT, I have removed the flag for the no manual entry, and I imported that data using the Trade Accounts Receivable control account. But when I run the customer ledger reconciliation report the invoice amount is not showing under the Ledger balance, hence the balances are not matching. Also if I run the trial balance for the Trade Accounts Receivable the invoice amount is not reflecting. I am not sure what I am missing.

Kindly find below screen shots which could be helpfull.

I have the same question (0)

All responses (10)

Answers (2)

Suggested answer

Ramit Paul 22,797 Most Valuable Professional on at

Like (0)

Report

Hello,

Why dont you import the balance instead?

Or else, why dont you import the original invoices with Sales Cr and Debtors DR?

Was this reply helpful? Yes No
Hossam Z. EL Hassan 12 on at

Like (0)

Report

Hi,

We are importing invoices to help us on aging and to be more detailed. Can you elaborate more on your proposed solutions. How the journal entry will look like.

Thanks.

Was this reply helpful? Yes No
Suggested answer

Gaurangkumar Jani 4,534 User Group Leader on at

Like (1)

Report
Hi Hossam,

I am unable to understand your process.

If I have to do the process:

Create a general journal with

Dr Customer Account (Which will reflect as "Account Receivable using Poting Profile"

Cr Control Account (Which should be other than Account Receivable)

In your case, I assume both accounts are the same, because of which impact of the Invoice nullifies.

Let us know if this helps.

Thanks,

Was this reply helpful? Yes No
Suggested answer

André Arnaud de Cal... 301,194 Super User 2025 Season 2 on at

Like (1)

Report

Hi Hossam,

You can use a new balance account, specific for the conversion as offset. When you enter the opening balance, you can use this same account instead of the AR control account. If should then zero out that balance on the suspension account.

Was this reply helpful? Yes No
Hossam Z. EL Hassan 12 on at

Like (0)

Report

Hi André,

I really would like to use your approach but I need some clarifications. I need to create a new account example 999900 to be used as offset to the customer debit amount. Does this main account 999900 need to be of Main account type "Asset".

Do I need to create a new suspense account, and what would be the transaction debit and credit to zero the main account 999900. Or is there a property to be enabled on main account 999900 to make it zero automatically once I enter the transaction as debit customer and offset

Was this reply helpful? Yes No
Verified answer

André Arnaud de Cal... 301,194 Super User 2025 Season 2 on at

Like (0)

Report

Hi Hossam,

The main account type can be 'Balance'. You might use the same account for open vendor entries. You can also create separate suspense accounts.

The balance will not be cleared automatically. You have to do this yourself; part of the opening balance entry.

Was this reply helpful? Yes No
Verified answer

saurabh bharti 15,039 Moderator on at

Like (0)

Report

Hi,

you can use separate "opening balance Account" which you can use against all balance migration.

You can look at this blog for approach:

exploredynamics365.home.blog/.../

Was this reply helpful? Yes No
Hossam Z. EL Hassan 12 on at

Like (0)

Report

Thanks everybody for the support. I am almost there, and I need your help in the last step.

I have created a new main account "980000" with main account type balance sheet. Posted the entry as below. Now the customer and ledger reconciliation report is matching which is perfect.

What is pending is to zero this new main account "980000". Or should I leave it as is?

Comparing the steps you have shared with me, since I am only importing opening balances for AR, the new main temp account "980000" will not zero by it self, since I am not importing bank, sales, vendor, and the other subledgers.

Opening Balance transaction

Trial Balance of temp new main account

Was this reply helpful? Yes No
Suggested answer

Gaurangkumar Jani 4,534 User Group Leader on at

Like (1)

Report

Hi Hossam,

How did you match the Balance sheet if you are not Importing other main Accounts?

Let's see the scenario:

Total Assets: $ 100,000.00 (Excluding AR)

Account Receivable: $ 25,000.00

Total Equity & Liability: $ 125,000.00

You import Account Receivable as you mentioned:

Accounts Receivable Dr $25,000.00

Control Account Cr $25,000.00

Net : $ 0.00

Now you Post:

Assets Dr $ 100,000.00

Equity & Liability Cr $ 125,000.00

Control Account Dr $ 25,000.00

Net : $ 0.00

As the system follows the double-entry system, you'll have the same difference (Control Account) while posting other balances.

So please follow the basics of the Account and you will be able to solve the entire balancesheet.

Thanks,

Was this reply helpful? Yes No
Suggested answer

Hossam Z. EL Hassan 12 on at

Like (1)

Report

Thank you all the picture is clear now.

Was this reply helpful? Yes No