Yo yo yo (meant to not sound like Santa saying ho ho ho)!
By now in your career of D365, you’ve experienced the dreaded “Import Failed” message more times than you’d care to admit. It’s like the Universe’s way of reminding us that tech isn’t infallible and neither are we.
But there’s one particular case that I’m here to save you from: importing vouchers using the General Journal entity in Dynamics 365, where auto-generated voucher numbers are the mischievous culprit behind your import failure.
Step into My General Journal Entity Office
So, you’re importing vouchers using the General Journal entity. You’ve got your Excel template all polished and ready. You hit import with the confidence of a dad nailing the perfect grilled steak. But then… BOOM – your import crashes faster than a toddler hyped up on candy.
“Why, Dynamics 365? Why must you torment me?”
Here’s the thing: if your voucher number is set to auto-generate, your shiny voucher import won’t even get off the runway. Dynamics 365, in its well-intentioned wisdom, doesn’t know what to do when it has to import vouchers but doesn’t have clear, explicit numbers from you.
BLUMF (Bottom Line Up Mostly Front): if you expect the system to magically assign voucher numbers during import, NOPE. Not happening, my friend.
The Voucher Number Sneak Peek – What You Need to Know
When using the General Journal entity to import vouchers, there’s a specific rule to remember: If the voucher number is auto-generated by your number sequence, your import will fail. Why? Because Dynamics 365 can’t predict the future. It doesn’t generate voucher numbers on the fly when importing data.
Let’s break it down:
Voucher Number Field: This is a required field. If you’re using auto-generated vouchers (set up under your number sequence), you’ll run into trouble because the system expects you to provide a valid voucher number upfront.
How to Avoid Failure: Either manually add voucher numbers to your import file OR use a numbering strategy where the voucher number is specified during the import process.
Remember, when it comes to data entities, Dynamics 365 is like a kid with strict rules—it needs clear instructions or else it throws a tantrum (or an error message). In this case, no voucher number, no game.
How to Import Vouchers (Without Losing Your Mind)
Okay, now that you know what not to do, let’s get into how to successfully import vouchers using the General Journal entity without driving yourself nuts.
Manual Voucher Numbers: When you’re preparing your Excel file for import, ensure the voucher number is provided for each line. You’ll need to disable the automatic generation of voucher numbers for that particular transaction.
Check Your Number Sequence Setup: Head over to your number sequence setup and take a look at your voucher number settings. If your system is configured to auto-generate voucher numbers, you’re going to have to decide whether to disable that or make sure you provide the numbers manually during import.
Use Templates Smartly: If you’ve got multiple vouchers to import, set up a template where the voucher numbers are already defined. You can use Excel to fill out the voucher numbers sequentially to avoid any hiccups.
Use the Learn Link: Check out this helpful resource for more tips and tricks to make your import smoother than my dad jokes at a family barbecue.
Avoid the Pitfalls Real-Life Dynamics Dad Example
Picture this: You’re trying to import 10,000 journal entries for your finance department. You click import, watch the progress bar with hopeful eyes, and then… ERROR. You’ve fallen into the same trap I did, auto-generated voucher numbers.
The fix? Manually entering those pesky voucher numbers before you hit import. Yes, it’s tedious, but hey, if it gets the job done, it’s better than slamming your keyboard in frustration.
Why Auto-Generated Voucher Numbers Trip You Up
So why does Dynamics 365 make it so tricky with auto-generated voucher numbers? It’s because during an import, the system doesn’t stop to think, “I wonder what voucher number should go here.” Instead, it expects that you’ve already thought of that. Consider it like telling your teenager to do their homework without telling them what subject—it’s chaos waiting to happen.
Don’t Let Auto-Generated Numbers Fool You
Next time you’re importing vouchers with the General Journal entity, double-check your voucher number settings.
"If they’re auto-generated, you’ve got to change your game plan, or change your plans for the rest of the night because you midas whale manually import all of these by hand."
Dad Joke of the Day
Why don't accountants play hide and seek?Because good luck hiding—they always find balance!
Happy importing,
DynamicsDad
Comments