KCastellanos
Occasional Member - Level 1

Using Import Distribution to create different line items with different line descriptions

Hello,

 

I was wondering if with the import distribution option, I am able to upload an excel with different line items from an invoice that contain different GL accounts, amounts and line-item descriptions. 

 

I tried to import it myself but kept getting an error that said distribution must be a numerical value which it has.

 

Maybe there is a video that someone can lead me to that shows me more in depth how to use that feature.

 

Thanks!

1 Solution
Solution
PoojaKumatkar
Super User
Super User

Hi @KCastellanos ,

 

With reference to import document, seems its not possible to create different line items with different line description using distribution import template. Because distribution import template does not have required line item import related columns. It will only show columns which are available in your distribution form and used for distribution purposes only.

 

Regarding error, note that, in import template you need to always pass exact code which you are maintaining in list management (if it is connected/simple list) based on field data type. if any custom field is having text data type then you may enter any alphanumeric value etc.

 

Attaching distribution import template specifications for your further reference:

https://help.sap.com/docs/CONCUR_INVOICE/4b7ddd72185c41b997afef66de878da2/8b4bb62070891014bbdd65f944...

PoojaKumatkar_0-1756723057543.png

 

 

If this answers your query, then please mark solution as accepted.

 

Thanks!
Regards,
Pooja

View solution in original post

1 REPLY 1
Solution
PoojaKumatkar
Super User
Super User

Hi @KCastellanos ,

 

With reference to import document, seems its not possible to create different line items with different line description using distribution import template. Because distribution import template does not have required line item import related columns. It will only show columns which are available in your distribution form and used for distribution purposes only.

 

Regarding error, note that, in import template you need to always pass exact code which you are maintaining in list management (if it is connected/simple list) based on field data type. if any custom field is having text data type then you may enter any alphanumeric value etc.

 

Attaching distribution import template specifications for your further reference:

https://help.sap.com/docs/CONCUR_INVOICE/4b7ddd72185c41b997afef66de878da2/8b4bb62070891014bbdd65f944...

PoojaKumatkar_0-1756723057543.png

 

 

If this answers your query, then please mark solution as accepted.

 

Thanks!
Regards,
Pooja