#COE#SW01 Supplier ID in all line intems (supplier invoice)

[former_member762273]

Hi team,

We want to see he supplier ID in all line items from a supplier invoice. When we go to 'Display line items in General Ledger' app, if we filter for example from one journal entry that is a supplier invoice, we would like to see the supplier in all line items (P&L accounts too). Is there any possibility to achieve this?

Thanks,

Sebastián

[OwenLiu]

We helped you to accept the answer, since there were no updates after 7 days.

You can unaccept it anytime if you have further questions.

[OwenLiu]

Hi Sebastián,

I think you mean the supplier only shows in some line items but not for all.

This is not relevant with the function of the report, but it's due to the original posting.

The report just shows what's saved in database.

Best Regards,
Owen

[israelpsalas]

Hello Owen,

We want the field "Supplier" to appear in all the line items that refers to the same journal entry.

Is that possible?

Thank you.

KR

[OwenLiu]

Hello israelpsalas ,

I just would like to share my understanding, but I'm not 100% sure.

First from business point of view, for example for one supplier invoice, it will debit GR/IR and credit payables.

The payable should record the supplier field, but the offsetting GR/IR should not record this field.

I think this is not a reasonable requirement and it may lead to further issues when clearing the GR/IR.

Best Regards,
Owen

[israelpsalas]

Hello owen.liu ,

My apologizes, but this is a requirement that I was asked in all the customers that I worked for. And in products as S4Hana on premise and R3, was possible through coding. The problem comes with S4Hana Cloud, were we can not add it or at least find it.

They want to have the field "supplier" in all the line items that refers to an invoice for reporting purposes. It is obviously, much more easy to work in queries if they have this information in each line item that doing extra formulas.

And here it is my question again, it is any way to could do it?

Thank you again!

KR

[OwenLiu]

How did you achieve it in OP system?

Did you try Custom Logic for maybe Coding Block?

[israelpsalas]

Hello,

If I dont remember wrong, we used "User exits" for it.

Thank you!

KR