# How to import financial dimensions of PO through DMF **URL:** \ **Category:** Developer Forum\ **Created:** [April 7, 2022, 8:07am UTC](https://www.dynamicsuser.net/t/how-to-import-financial-dimensions-of-po-through-dmf/76115 "2022-04-07T08:07:46Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![Haribabu\_Annangi](https://avatars.discourse-cdn.com/v4/letter/h/a587f6/32.png) [@Haribabu\_Annangi](https://www.dynamicsuser.net/u/Haribabu_Annangi)\ **Post date:** [April 7, 2022, 8:07am UTC](https://www.dynamicsuser.net/t/how-to-import-financial-dimensions-of-po-through-dmf/76115/1 "2022-04-07T08:07:46Z")
I have a financial dimensions, let say XXX & YYY, and I have the excel file with same fields (XXX & YYY). I understand that PO financial dimensions comes fom vendor master but here my requirement is that financial dimensions XXX & YYY available in excel as columns and I need to import it into D365 F&O and update PO financial dimensions Please suggest ---
**Author:** ![MartinDrab](https://avatars.discourse-cdn.com/v4/letter/m/e0b2c6/32.png) [@MartinDrab](https://www.dynamicsuser.net/u/MartinDrab)\ **Post date:** [April 7, 2022, 8:36am UTC](https://www.dynamicsuser.net/t/how-to-import-financial-dimensions-of-po-through-dmf/76115/2 "2022-04-07T08:36:51Z")
Are you familiar with [Add dimensions to Excel templates](https://docs.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/financial/dimensions-overview?WT.mc_id=DX-MVP-5000414)? ---
**Author:** ![Haribabu\_Annangi](https://avatars.discourse-cdn.com/v4/letter/h/a587f6/32.png) [@Haribabu\_Annangi](https://www.dynamicsuser.net/u/Haribabu_Annangi)\ **Post date:** [April 7, 2022, 9:12am UTC](https://www.dynamicsuser.net/t/how-to-import-financial-dimensions-of-po-through-dmf/76115/3 "2022-04-07T09:12:36Z")
Hi Martin, I have gone through the link suggested. My requirement is that I have an excel file which is received from third party and it contains fields for PO header and Line. Now when to comes to the financial dimensions of PO, we have DEFAULTLEDGERDIMENSIONDISPLAYVALUE but when we export or import the value for this field is not getting updated under PO header. And in Excel I have the separate columns & values for financial dimensions(eg: financial dimension is BusinessUnit and value is 1232 &&& Costcenter and Value is abcd ) . How can I send those two columns as financial dimension for PO header any other way to import values to column DEFAULTLEDGERDIMENSIONDISPLAYVALUE of PO header? ---
**Author:** ![jacob.roder](https://sea1.discourse-cdn.com/flex023/user_avatar/www.dynamicsuser.net/jacob.roder/32/7480_2.png) [@jacob.roder](https://www.dynamicsuser.net/u/jacob.roder)\ **Post date:** [April 11, 2022, 8:15pm UTC](https://www.dynamicsuser.net/t/how-to-import-financial-dimensions-of-po-through-dmf/76115/4 "2022-04-11T20:15:51Z")
You need to make sure the “financial dimension configuration for integrating applications” form is setup properly. Add the dimensions that you want to update to a “Default dimension format”. The “Ledger dimension format” is important if you’re trying update journal lines. ---
**Author:** ![Haribabu\_Annangi](https://avatars.discourse-cdn.com/v4/letter/h/a587f6/32.png) [@Haribabu\_Annangi](https://www.dynamicsuser.net/u/Haribabu_Annangi)\ **Post date:** [April 13, 2022, 11:56am UTC](https://www.dynamicsuser.net/t/how-to-import-financial-dimensions-of-po-through-dmf/76115/5 "2022-04-13T11:56:03Z")
Hello Jacob Thanks for reply, could you assist with more info or any doc related this setup of financial dimension configuration for integrating applications? My requirement is simple I have excel with PO header and other two financial dimension columns , I could not find way to import PO header with financial dimensions. Please suggest ---
**Author:** ![jacob.roder](https://sea1.discourse-cdn.com/flex023/user_avatar/www.dynamicsuser.net/jacob.roder/32/7480_2.png) [@jacob.roder](https://www.dynamicsuser.net/u/jacob.roder)\ **Post date:** [April 13, 2022, 12:49pm UTC](https://www.dynamicsuser.net/t/how-to-import-financial-dimensions-of-po-through-dmf/76115/7 "2022-04-13T12:49:39Z")
[https://docs.microsoft.com/en-us/dynamicsax-2012/appuser-itpro/set-up-financial-dimensions-for-integrating-applications-excel-and-management-reporter#:~:text=%20To%20set%20up%20financial%20dimension%20attributes%20for,query%20is%20created%2C%20and%20a%20custom...%20More%20](https://docs.microsoft.com/en-us/dynamicsax-2012/appuser-itpro/set-up-financial-dimensions-for-integrating-applications-excel-and-management-reporter#:~:text=%20To%20set%20up%20financial%20dimension%20attributes%20for,query%20is%20created%2C%20and%20a%20custom...%20More%20) Additionally, make sure that the dimension is active - it won’t be selectable if the dimension isn’t active.