Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Answered

Import Open AR invoices to load data from previous system

(0) ShareShare
ReportReport
Posted on by 12

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.

pastedimage1627579364772v1.png

pastedimage1627579413938v2.png

  • Suggested answer
    RE: Import Open AR invoices to load data from previous system

    Thank you all the picture is clear now.

  • Suggested answer
    Gaurangkumar Jani Profile Picture
    Gaurangkumar Jani 4,511 User Group Leader on at
    RE: Import Open AR invoices to load data from previous system

    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,

  • RE: Import Open AR invoices to load data from previous system

    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.

    pastedimage1627656088896v2.png

    Opening Balance transaction

    pastedimage1627656471433v3.png

    Trial Balance of temp new main account

    pastedimage1627656013554v1.png

  • Verified answer
    saurabh bharti Profile Picture
    saurabh bharti 15,029 Super User 2025 Season 1 on at
    RE: Import Open AR invoices to load data from previous system

    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/.../

  • Verified answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,969 Super User 2025 Season 1 on at
    RE: Import Open AR invoices to load data from previous system

    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.

  • RE: Import Open AR invoices to load data from previous system

    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 

    pastedimage1627595198982v1.png

    pastedimage1627595266157v2.png

  • Suggested answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,969 Super User 2025 Season 1 on at
    RE: Import Open AR invoices to load data from previous system

    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.

  • Suggested answer
    Gaurangkumar Jani Profile Picture
    Gaurangkumar Jani 4,511 User Group Leader on at
    RE: Import Open AR invoices to load data from previous system

    Hi Hossam,

    I am unable to understand your process.

    If I have to do the process:

    • Create a general journal with
      1. Dr Customer Account (Which will reflect as "Account Receivable using Poting Profile"
      2. 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,

  • RE: Import Open AR invoices to load data from previous system

    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.

  • Suggested answer
    Ramit Paul Profile Picture
    Ramit Paul 22,297 Most Valuable Professional on at
    RE: Import Open AR invoices to load data from previous system

    Hello,

    Why dont you import the balance instead?

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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,969 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,846 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans