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
