Finance | Project Operations, Human Resources, ...

Journal Voucher Number Allocation

(0) Share

Report

Posted on by A.Prasanna

8,223

Hi All,

I'm just trying to figure out how and wich basis voucher numbers are allocating when importing Journals (in this case General Journal )

I found the official ms doc https://docs.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/data-entities/tips-tricks-import-general-journal-entity

and it says "When you don't use the Set-based processing setting, you do not need to provide a voucher number in the imported file. The voucher numbers are created during import, based on the setup of the journal name (One voucher only, In connection of balance, and so on). For example, if the journal name is defined as In connection of balance, the first line receives a new default voucher number. The system then evaluates the line to determine whether the debits equal the credits. If an offset account exists on the line, the next line that is imported receives a new voucher number. If no offset account exists, the system evaluates whether the debits equal the credits as each new line is imported."

But it's not mentioned what happens when importing without setting offset account in the Same line, and instead of that what happens when we importing debits and credits (multiline).

can anyone explain how it works how it's allocated vouchers when we importing journals with separate entries for Debit and Credit ?.

thanks,

AP

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

Muthusamy 4 on at

Like (0)

Report

Hi Prasanna,

As per document, when we import the data without setting offset account in the Same line means, System evaluates whether the debits equal the credits as each new line is imported. when debit & Credit matches at particular journal line means, then next voucher number will be generated for next/new imported line.

Thanks,

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi AP,

When you import transactions it is the same as when you enter transactions manually.

Once the DR and CR amount match, the next voucher number will be generated.

Importing split postings with many lines can thus be a bit tricky because you might face rounding issues that get voucher numbers mixed up.

Whenever it is possible it might thus be better importing lines with a DR and Cr account that match and complete a voucher.

Best regards,

Ludwig

Was this reply helpful? Yes No
A.Prasanna 8,223 on at

Like (0)

Report

Thanks for your valuable input,

I've noticed that there is one journal imported with 1000 + lines that have only a Single voucher, but there is another one with 20 lines that has 2 vouchers, there is no difference between debit amounts and credit amounts. Users need clarification about the basis of allocation vouchers , and I'm a bit confused.

Was this reply helpful? Yes No
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi Amith,

It is difficult to comment on the examples you mentioned.

Can you possibly attach them in a file or screenprint that would allow the community to have a look at?

Best regards,

Ludwig

Was this reply helpful? Yes No
Suggested answer

Junaid Idrees on at

Like (0)

Report

Hi Amith Prasanna,

If you are importing any journal or even create manually and if offset account is not defined on the same line then system will repeat the same voucher on 2nd line. This is how system works.

I can share with you a sample journal(Imported by using excel Add-in) with 5000 lines in it and you can see how it works.

Debit: 1411 (Offset on 2nd line)
Credit: 2905

Since offset account is on 2nd line so system is using the same voucher number because entry is not balanced yet

Was this reply helpful? Yes No