Import purchase order invoices from Excel

Dynamics 365 for Finance and Operations/AX Developer Forum
#1

Hi all,

We have purchase order invoice excel details and we want import that excel data to ax 2009 then post.

How we can post it?

Thanks for support.

MODULE EXPENSES DATE G/L Account Details Currency Amount Amount2 Cost Center Cost Center 2
Satış vergisi EXP001141 25.09.2015 191.011.003 Satış vergisi TL 15,39 15,39
Maliyet muhasebesi EXP001141 25.09.2015 760.021.002 5301479472 TLF TURKCELL FATURA TL 0,00 233,87 Tür
Maliyet muhasebesi EXP001141 25.09.2015 760.021.002 5301479472 TLF TURKCELL FATURA TL 0,00 233,87 Maliyet merkezi TK11202
Maliyet muhasebesi EXP001141 25.09.2015 760.021.002 5301479472 TLF TURKCELL FATURA TL 0,00 233,87 Çalışan
Maliyet muhasebesi EXP001141 25.09.2015 760.021.002 5307734053 TLF TURKCELL FATURA TL 0,00 231,80 Tür
Maliyet muhasebesi EXP001141 25.09.2015 760.021.002 5307734053 TLF TURKCELL FATURA TL 0,00 231,80 Maliyet merkezi TK11202
Maliyet muhasebesi EXP001141 25.09.2015 760.021.002 5307734053 TLF TURKCELL FATURA TL 0,00 231,80 Çalışan
Maliyet muhasebesi EXP001141 25.09.2015 760.021.002 5326625084 TLF TURKCELL FATURA TL 0,00 233,40 Tür
Maliyet muhasebesi EXP001141 25.09.2015 760.021.002 5326625084 TLF TURKCELL FATURA TL 0,00 233,40 Maliyet merkezi TK11202
Maliyet muhasebesi EXP001141 25.09.2015 760.021.002 5326625084 TLF TURKCELL FATURA TL 0,00 233,40 Çalışan
#2

Hello Sadulla,

I hope you have PO’s created in the system before importing the invoices data from excel, if so i suggest you to invoice these orders through standard functionality(but as a bulk by writing a x++ job) which will reduce a lot work/complexity when compared to excel importing. Excel importing for Invoices is not encouraged because it involves a lot of tables(PurchInvoicejour, Vendor transactions etc.,) where data need to be consistent across all of these tables.

Hope this wil help you…

Thank you

Anil Kumar