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

Notifications

Announcements

Sign Up for Ask a Community Pro Today!
Introducing our New Video Series: Community Spotlight
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Export / Import free t...
Finance | Project Operations, Human Resources, ...
Suggested Answer

Export / Import free text invoices with data Management

(0) ShareShare
ReportReport
Posted on by Azize Reghioui 115

Hello,

I exported the entity Customer free text invoices with data management.

pastedimage1648206409418v1.png

I was able to import the customer free text invoices without any error.

Is there a way to have the Sales Tax Group - Financial dimensions - Terms of payment  (Which are on the Customer card) directly populated in D365.

Example:

In the Excel to import, I will enter the Customer account, GL account, Qty and Amount.

The Sales Tax Group should be populated directly based on the Customer account. 

pastedimage1648206919871v2.png

Thanks in advance for your help.

I have the same question (0)
  • Suggested answer
    Alireza Eshaghzadeh Profile Picture
    Alireza Eshaghzadeh 14,839 Super User 2025 Season 2 on at

    Hi Azize,

    Please delete field for SALESTAXGROUP and SALESTAXITEMGROUP from your source Excel file while you import free text in invoices via data management.

    Then this two field will be populated via vales on customer card/master.

  • Azize Reghioui Profile Picture
    Azize Reghioui 115 on at

    Hello Alireza,

    I have deleted the columns:  SALESTAXGROUP and ITEMSALESTAXGROUP from my Excel File.

    I got the following error:

    pastedimage1648456939232v1.png

    Should I modify "Map staging to Target"?

    pastedimage1648457010563v2.png

    Thank for your help.

    Regards,

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

News and Announcements

Sign Up for Ask a Community Pro Today!
Introducing our New Video Series: Community Spotlight

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the December Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 612 Super User 2025 Season 2

#2
Abhilash Warrier Profile Picture

Abhilash Warrier 437 Super User 2025 Season 2

#3
Martin Dráb Profile Picture

Martin Dráb 305 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans