can we have single invoice based on material?

[Former Member]

Hi,

My client has set of services provided to its customers.

He wants to create a single invoice at the end of the month for individual service.

for e.g Customer A / Bulk service --> Single invoice at the month end

Customer A / Pre paid service --> Single invoice at the month end.

Sales order for Customer A might look like below

Sales Order 123

Item	Description	qty	Price
10	Bulk Service	10	10,000
20	Pre paid Service	5	9000
30	Ramp Service	7	3000

Sales Order 456

Item	Description	qty	Price
10	Pre paid Service	11	11,000
20	Bulk Service	5	6000
30	Ramp Service	7	4000

There should be single invoice created for Bulk Service at month end

Bulk Service ( 10,000 + 6000) = 16,000 Rs

There should be single invoice created for Pre Paid Service at month end.

Pre paid Service ( 9000+ 11,000) = 20,000 Rs.

Is this possible using split criteria?

Regards

Trupti

[former_member182378]

Trupti,

similar requirement (not same)

TW

[former_member182378]

Trupti,

If customer wants separate bills, then during order creation, create separate sales orders.

TW

[Former Member]

Hi,

May be you can try putting a logic in the copy control (data transfer routine) at the item level (sales doc to billing doc or Del doc to billing doc which ever is your scenario). You can try as well try User exit (as suggested) which ever suits you the best.

Hope this helps...

Regards,

Mukund S

[phanikumar_v3]

I think Exit is Not required here..(Extremely sorry if it hurts)

You can play with your item category to get it extracted to Billing level..

I am taking your Sales cycle like Sales order>>Billing(order relevant billing)

Bulk service material----ZBLK(Example Item category)

Prepaid material---ZPPM(Example Item category)

Now Just maintain-different billing types like ZBLK & ZPPM(FKART)

Now in VTFA--You need to maintain only relevant item category settings only..

During VF01>>Select the relevant Billing type-Then enter Sales order number & Execute..

try & Update us..

Phanikumar

[Former Member]

This is intresting.

But I will have to consider following.

1) I want collective billing for each service at month end.

2) So I would require item category for each service. This means if I have 20 services I would require 20 item categories

3) Further 20 billing types?

4) Even if I try to do billing based on item categories, I do not have this option in VF04 ( billing as per item category). Although its possible to do billing as per billing type.

Only concern in the solution is amount of item categories and billing types we would end up creating.

Regards

Trupti

[Lakshmipathi]

Phanikumar V

With your suggestion, when billing document is generated, still there would be multiple line items with the same material code as the quantity won't be cumulated to one line item.   Business requirement is there should be only one line item and I am not sure, whether this proposal would be acceptable by Business and that is why, I suggested to go with user exit.

G. Lakshmipathi

[phanikumar_v3]

Very Good afternoon Sir -Firstly feeling very nice- mailing to you after a long time..

I think the requirement here is 2 service items in single billing (with the example mentioned by member)--So we cannot go with single line item control at billing for this requirement,

Sorry--Any thing wrong in understanding--Please correct me sir..

[Lakshmipathi]

With the standard configuration, yes you can force the system in such a way to split one line item per invoice but your requirement is little bit different.  In order to generate one billing document for a particular material from multiple sale orders, you need to go with user exit.

G. Lakshmipathi