Skip to Content

How can we group the GL codes for all items on a Sales Invoice and post only the aggregate totals?

Hi, everybody,

Please see the attached picture which explains what I want to do.

I am at the planning stage, and not programming yet.

I am trying to find the best idea to implement.

So, any ideas will be most welcome.




capture.jpg (217.4 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Aug 14, 2017 at 12:36 PM

    Hi Leon,

    The functionality that is being performed by the original A/R Invoice Form cannot be changed. Probably, you need to customize it by your own.

    Kind regard,


    SAP SME Support

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Ankit,

      Thanks for your reply.

      I agree with your comments.

      And I want to customise, without having to rewrite the whole system form.

      Maybe I can modify the system form and exploit the form and item events to achieve what I want.

      But I am short of ideas ...

      What can you suggest?

      Best Regards,


  • Aug 17, 2017 at 05:58 AM

    Hi Leon,

    In order to achieve this, you need to set your Item in the Item Master Data as Non Inventory Item.
    On the AR Invoice form, create a Formatted Search based on changes of Item No, set the GL Account field depending on whether it is Goods or Service.
    If you are below 9.2PL7, and there is no project/cost centre involved, the JE posted would have been aggregated by GL.

    No programming required.

    If your Item is an Inventory Item, you can not change the GL Account posted by SAP.
    You will need to post another JE by debitting the Inventory Account and Credit you required account.
    You will need an addon to post this additional JE.


    Add comment
    10|10000 characters needed characters exceeded

    • Hi, Edy

      Thanks for your response.

      Your suggestion contains many ideas which are not very familiar to me.

      I will have to study them and test your suggestions.

      This will take some time, and I will let you know how it goes.

      Best Regards,