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

All responses (4)

Answers (1)

Sort by

Dynamics 365 6 on at

Like (1)

Report
Copy link

Link copied!

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
Suggested answer

IB-29041624-0 1,191 Moderator on at

Like (1)

Report
Copy link

Link copied!

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
Thoeff 35 on at

Like (1)

Report
Copy link

Link copied!

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
Verified answer

Dynamics 365 6 on at

Like (0)

Report
Copy link

Link copied!

Thanks for your feedback Thomas.

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