Breaking news from around the world
Get the Bing + MSN extension
Now Available in Community - MBAS 2019 Presentation Videos
Catch the most popular sessions on demand and learn how Dynamics 365, Power BI, PowerApps, Microsoft Flow, and Excel are powering major transformations around the globe. | View Gallery
2019 release wave 2 Discover the latest updates to Dynamics 365Release overview guides and videos Release Plan | Early Access Availability
Ace your Dynamics 365 deployment with packaged services delivered by expert consultants. | Explore service offerings
Connect with the ISV success team on the latest roadmap, developer tool for AppSource certification, and ISV community engagements | ISV self-service portal
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Program | Finance TechTalks | Customer Engagement TechTalks | Talent TechTalks | Upcoming TechTalks
Need help, when I try to import customer open invoices the journal batch number is appended with '9999999' on import which then leads to an error. Please see the attached image of the staging details
and this the import file
This is my number sequence settings
Not sure if I am missing something or why the number sequence is extended with additional numbers on import.
Can you please help me solve this.
Try below steps and see if it help you identify where the problem is:
1. Create a GJ and enter a line, put in invoice number etc.
2. Export this.
3. Create import project (mapping is default, no changes to mapping)
4. change file that got exported in steps 2, only changes to the file are ..... Change invoice number to say Inv02 instead of Inv01, line number to 2 from 1, voucher number from existing number to say V1
5. import file and see if this gets imported.
Was able to successfully upload the line without any issues.
Most probably culprit is journal number mapping. My batch number is 5 digits, don't have any "." etc in it, not sure if that would cause any issue, try changing that to regular sequence as well (check that your file is not hiding any hidden 99999 after decimal places). If above works, then you can try to find differences between what you currently have and compare to what's working.
Please take time to click 'Yes' against the answers that help you guide in right direction to help other community members.
What is the specific value when click the value "2101.000001" in the formula bar of excel?
You can add the character of "'" in the front of the "2101.000001" and set it to be "'2101.000001"
Hi Satish and MATTGUO,
Thank you, your suggestions helped me identify the problem. The problem was with the format of the cell in excel, when I changed the format to 'text' the import was successful and additional numbers weren't added to the batch number.
Thanks for the help!
Business Applications communities