Finance | Project Operations, Human Resources, ...

UPLOAD TO Dynamics 365 during the upload process it changes the voucher.

(0) Share

Report

Posted on by ASidd

205

There is a problem with Journal upload into D365. When an excel spreadsheet is being uploaded during the upload process it changes the voucher.

See below for screenshots. Looking for suggestions on what might be causing this?

[View:/cfs-file/__key/communityserver-discussions-components-files/765/Copy-of-PROD_5F00_GENJR_2D00_General-journal_2D00_MaryMount_5F00_20210401_2D00_20210430-_2800_1_2900_.xlsx]

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

A.Prasanna 8,223 on at

Like (0)

Report

this can happen If you are using a Temporary Voucher Number,

refer : kaya-consulting.com/.../

for more info.

Was this reply helpful? Yes No
ASidd 205 on at

Like (0)

Report

So whats the fix for this? what do i need change in the excel upload for this to work correctly?

Was this reply helpful? Yes No
Suggested answer

A.Prasanna 8,223 on at

Like (0)

Report

if your transactions posted with Correct Voucher Numbers then you don't need to worry, but if you really want to change the behavior you can set the "Number Allocation at Posting" option to No under Relevant Journal Name then it will use the original voucher number. but then you need to specify the Actual Voucher Number (s) on your Excel Template.

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hello ASidd,

Why is it a problem if Dynamics changes the voucher numbers?

From my perspective this is what I would expect because how can the outside data that you want to import know what voucher number is the next one?

If people are posting transactions all the time in your system while you are running an import, seeing a change in the voucher number seems to be normal to me.

You can of course make use of the voucher number assignment feature at posting that Amith mentioned but this won't ensure that the numbers that you upload will be changed.

Best regards,

Ludwig

Was this reply helpful? Yes No
Suggested answer

André Arnaud de Cal... 301,035 Super User 2025 Season 2 on at

Like (0)

Report

Hi ASidd,

I do understand that the voucher are already different directly after import, but not after posting? In that case, it is not related to the temporary voucher number. It is related to the setup of voucher series on the journal name. If this has a number sequence which is not set to manual, then during import, it will assign voucher number like you were entering the journal as manual process.

When creating the journal names, you can only assign number sequences which do have the continuous option enabled and not set to manual. After the setup, you can change the behavior of the selected number sequence.

Was this reply helpful? Yes No