web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Vendor and Customer Op...
Microsoft Dynamics AX (Archived)

Vendor and Customer Opening Balance Upload in AX 2009

(0) ShareShare
ReportReport
Posted on by Prayaga Pramod KumAR 69

Can anyone help me out in explaining procedure for uploading all customers and vendors opening balance in AX 2009? Which entity we need to select for template and What are the rules we need to follow with regard to this ? what are the fields we need to use normally in uploading the balances?

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 304,508 Super User 2026 Season 1 on at

    Hi Prayaga,

    Usually, the opening balances for customers and vendors are registered/imported in a general journal. Then it can be validated and posted. At minimum you would need to have the customer account, invoice date, invoice number, due date, open amount (or full amount and also convert related payments). Possibly, you also want to put in a transaction text or financial dimensions.

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Good morning Prayaga,

    I noticed that you also asked for the item upload before.

    In general follow what Andre recommended in regards to the vendor /customer open balance upload.

    With the customer, vendor and item balances uploaded you are almost complete.

    What is still missing is the upload of the ledger balances. Uploading those balances requires that you exclude the uploaded customer, vendor and item amounts. Otherwise you have a double counting effect. I would recommend that you just give it a try in a demo or test environment if you haven't done this before. There you can check the uploads and try to reconcile them with your old system data before doing this is your live environment.

    Best regards

    Ludwig

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
CP04-islander Profile Picture

CP04-islander 39

#2
Michel ROY Profile Picture

Michel ROY 14

#3
imran ul haq Profile Picture

imran ul haq 8

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans