Finance | Project Operations, Human Resources, ...

GL Vendor Opening balance error-Import

(3) Share

Report

Posted on by aqeel2020uae

257

Dear Big Experts.

We are getting error while import data for vendors /Customers in Data Management.

Issue exist in generate staging data
Issue exists in auto generation of number sequence
Number sequence is not set

JOURNALBATCHNUMBER

LINENUMBER

ACCOUNTDISPLAYVALUE

ACCOUNTTYPE

CASHDISCOUNT

CASHDISCOUNTAMOUNT

CASHDISCOUNTDATE

CREDITAMOUNT

CURRENCYCODE

DEBITAMOUNT

DEFAULTDIMENSIONDISPLAYVALUE

DESCRIPTION

DOCUMENT

DOCUMENTDATE

DUEDATE

EXCHANGERATE

EXCHANGERATESECONDARY

INVOICE

ISPOSTED

ISWITHHOLDINGCALCULATIONENABLED

ITEMSALESTAXGROUP

ITEMWITHHOLDINGTAXGROUPCODE

JOURNALNAME

OFFSETACCOUNTDISPLAYVALUE

OFFSETACCOUNTTYPE

OFFSETDEFAULTDIMENSIONDISPLAYVALUE

OFFSETTEXT

OVERRIDESALESTAX

PAYMENTID

PAYMENTMETHOD

PAYMENTREFERENCE

POSTINGLAYER

POSTINGPROFILE

PREPAYMENT

QUANTITY

REPORTINGCURRENCYEXCHRATE

REPORTINGCURRENCYEXCHRATESECONDARY

REVERSEDATE

REVERSEENTRY

SALESTAXCODE

SALESTAXGROUP

TAXEXEMPTNUMBER

TEXT

TRANSDATE

VOUCHER

RFJB000174

FV\-TR\-IC000001

Vendor

3,333.00

USD

\-ICWE12

ddd2

########

958.6500

JRG

999942

GEN

31/03/2025 0:00

Categories:

Dynamics 365 Finance

I have the same question (0)

All responses (4)

Answers (0)

Adis 5,694 Super User 2025 Season 2 on at

Like (0)

Report

GL Vendor Opening balance error-Import

Hi,

Is the number seq. set to Manual?

Kind regards, Adis

If this helped, please mark it as "Verified" for others facing the same issue

Keep in mind that it is possible to mark more than one answer as verified

Was this reply helpful? Yes No
aqeel2020uae 257 on at

Like (0)

Report

GL Vendor Opening balance error-Import

No its Auto i can create JVS

Was this reply helpful? Yes No
Suggested answer

André Arnaud de Cal... 299,386 Super User 2025 Season 2 on at

Like (0)

Report

GL Vendor Opening balance error-Import

Hi Aqeel,

You mention that you import customers and vendors, but your error is about a journal. SO probably you are importing journal lines for customer and vendor transactions. Correct?

Can you show us how you did set up the field mapping for the voucher number? What is the abbreviation JVS meaning?

Anyway, you can read my blog about using a temporary voucher number while importing data. What is the temporary voucher functionality in Dynamics 365?

Was this reply helpful? Yes No
aqeel2020uae 257 on at

Like (0)

Report

GL Vendor Opening balance error-Import

Dear @Andre.

I am trying to uploading Opening balance for Vendor .Attached is excel sheet for import.

1-I am using import project (data management) My Entity =General Journal

2-

3-In mapping only Vendor Dimension is (Auto and default) nothing changed as you can see attached excel file.

4-Stageing Error ?

Thanks

Aqeel.

Import Vendors 32...

Was this reply helpful? Yes No