Skip to Content
0

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

Aug 14, 2017 at 11:33 AM

38

avatar image

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.

Thanks

Leon

capture.jpg

capture.jpg (217.4 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

ANKIT CHAUHAN
Aug 14, 2017 at 12:36 PM
1

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,

ANKIT CHAUHAN

SAP SME Support

Show 1 Share
10 |10000 characters needed characters left 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,

Leon

0
Edy Simon Aug 17, 2017 at 05:58 AM
1

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.



Regards
Edy

Show 1 Share
10 |10000 characters needed characters left 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,

Leon

0