Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Unanswered

Vendor payment journal import using excel - Vendor value stores in LedgerDimension field

(1) ShareShare
ReportReport
Posted on by 42
.Hi experts,
 
I am working on create vendor payment journal using excel import. 
I am able to import the data using excel import but when my account type "Vendor" and Account have some value,
I am unable to store Vendor number field value to "LedgerJournalTrans.LedgerDimension" because "LedgerDimension" is
the segment type field and that's contain ledgerDimension value of Vendor field.
 
My question here - How I store Journal line "Vendor" field value to "LedgerJournalTrans.LedgerDimension".
 
Thanks
  • Vinay S Profile Picture
    42 on at
    Vendor payment journal import using excel - Vendor value stores in LedgerDimension field
    Hi experts,
     
    Kindly suggest a way to fix this issue.
  • udaY-ch Profile Picture
    4,915 on at
    Vendor payment journal import using excel - Vendor value stores in LedgerDimension field
    Hi 
     
    Are you trying to import using data management and using the entity VendorPaymentJournalLine ? If yes, Did you try setting the value in the field Account Display value ?
     
    Or Are you trying to import using x++ ?
     
    Thanks
    Uday

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

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard >

Product updates

Dynamics 365 release plans