You’re offline. This is a read only version of the page.
20
Hi all,
I am trying to use data management to import AP journal and would like to bring over default dimension from vendor account without having default dimension display column in the source excel file. Please advise if there is any way to achieve it.
Thank you!
Best regards
Hi SallyXue,
You need to understand one point here.
Importing data through data management is simply a data push activity in system. Means, system will validate the data you provided in the loading template with the setup you have done in below forms/sections.
- Main accounts: Which is linked with the subledger vendor.
- Default financial dimension in Legal entity override section in Main accounts form: If you set any fixed/not fixed dimension as default for that main account in the Main accounts form. It will override the setup you have done in account structure for that specific main account.
- Configure account structure: The main account + dimension combinations you have set for that vendor summary account (and no default dimension is available in the main accounts form for that vendor summary account).
Now as per the standard behaviour in system; if you maintain default financial dimension in the vendor master and manually creating an AP journal, system will then automatically defaulted the dimensions for vendor in the journal.
But when you are pushing data through data management, the nature of such action is typed as inserting data by force which you provided in default dimension display column in the source excel file. This time system cannot update default vendor dimensions in AP journal automatically.
Additional checkpoint: If you have defaulted dimensions in vendor master and then pushed vendor record with some other dimensions in AP journal, then system will throw error during validation and posting due to such contradiction of dimension selection. Also, this is generally recommended not to maintain any default dimension in customer and vendor subledger as same subledger account could be used with different dimension combinations as per the combination set for respective summary accounts in account structure form.
Let us know if you have any further concern on this.
Regards,
Sourav
To my knowledge, this would require custom development.
When you load data through the data management framework, the system writes the values you supply and does not retrieve defaults based on your vendor account.
#1
André Arnaud de Cal...
291,971
Super User 2025 Season 1
#2
Martin Dráb
230,846
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
