Import / Uplaod General ledger entries with dimensions

(0) Share

Report

Posted on by Thoeff

Dear Community,

I need to uploud general ledger entries. Beside the account I have to add up to 5 Dimensions.

1. Challange: Posting manual: I want to add the dimensions to the line without staring the menu "Dimensions"

2. Challange: Import a general ledger entry: What is the way "edit in excel" from the general ledger or work with the configuratin package or ...

Kind regards

Thomas

I have the same question (0)

All responses (4)

Answers (1)

Dynamics 365 6 on at

Like (1)

Report

Hi Thomas,

Can you please tell me, Have you already Posted the Documents and system have created the general Ledger Entries.

As If it's already posted against specific Document number then you have to update through Configuration Package, first you have to export all G/L Entries with Dimension Field Column then after updating the Excel you need to import that data but while doing this need to take care.

But if in case that document is not posted yet, export the document via Config Package update the Dimension Value and import it and create one Job queue to post it in a single shot.

Hopei it will help you.

Many Thanks

Aman Kumar

Was this reply helpful? Yes No
Suggested answer

Inge M. Bruvik 1,111 Moderator on at

Like (1)

Report

The best way for you would be to add a customization to your system so you can add more than 2 shortcut dimensions to your General Journal lines.

Once that is done it is pretty easy to add a function that also will let you import transactions from Excel into your general journals for posting.

I recommend you discuss these requirements with your partner.

You can also have a look at this app:

appsource.microsoft.com/.../PUBID.chasesoftware1583153119945|AID.excel-journal-import|PAPPID.ee3871f6-b8ab-4a26-9e80-04945a36b42e

Was this reply helpful? Yes No
Thoeff 35 on at

Like (1)

Report

Dear Aman,

Dear Inge,

thanks for your advices, also for the link to the xls tool.

As you recommended we discussed with our partner and found a solution via the configuration package.

My "errors" were

- I did not mark to show the dimensions as column

- I did not setup which fields to show

- also for account coloumn it was needed to activate the reference option

Now it works

Thanks for your input

Thomas

Was this reply helpful? Yes No
Verified answer

Dynamics 365 6 on at

Like (0)

Report

Thanks for your feedback Thomas.

Please Verify if you found the answer helpful so that it will help others.

Was this reply helpful? Yes No