35
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
Thanks for your feedback Thomas.
Please Verify if you found the answer helpful so that it will help others.
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
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:
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
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
290,564
Super User 2024 Season 2
#2
Martin Dráb
228,651
Most Valuable Professional
#3
nmaenpaa
101,148
Share
Report
All responses (
Answers (