Invoice-related requirement

[Former Member]

Dear All,

There is one requirement:

Suppose, there is a Sales Order with Various line-items i.e.

Item --- Material -

---

Qty --- Rate -

---

UoM

10 -

---

Professional Fees -

---

5 -

---

7750 -

---

each (Rs. 7750 is per participant/ batch; & 1 batch = 3 days)

20 -

---

Edu. Course Mat. -

---

5 -

---

700 -

---

each (=> Rs. 700* 5 participant = Rs. 3,500)

30 -

---

Tea/ snacks----

---

5 -

---

100 -

---

day (=> Rs. 100* 5 participant * 3 days = Rs. 1500)

i.e. Total Order value = Rs. 7750*5 (line 10) + Rs. 3, 500 (line 20) + Rs. 1500 (line 30)

=> Rs.(38750 + 3,500 + 1500) => Rs. 43, 750

We do delivery (no matter, whether single delivery for all items or seperate deliveries/ item-wise).

Then, we generate single invoice at the completion of order.

Now, instead of capturing all 3 items in the invoice, my client's requirement is to have a single line with consolidated value for all 3 items i.e. Rs. 43,750.

Best Regards,

Amit.

[former_member1042017 · Accepted solution]

Sir,

I also faced the same requirement, tried a lot but was unable to find somthing like that. BOM was the only solution we got and we applied the same.

Regards

Gaurav

[Former Member · Accepted solution]

Dear Gaurav,

Thanks for the confirmation.

Just one more query:

When we use BOM in Sales Order, all the components appear in S.Order (i.e. BOM: "Mat A" with 4 components. Then when we enter "Mat A" in Sales Order, all 4 components along with "Mat A" appears in Sales Order line-item level)

Similarly, When we Invoice the "Mat A" either from S.Order or Delivery; "Mat A" gets listed in Invoice, along with all 4-components.

But, the value is getting captured against "Mat A" and all 4-components are w/o any Value.

That means, Customer would come to know about full amount value against "Mat A" and will not be able to know respective components' values?

Am I right?

Best Regards,

Amit

[former_member1042017 · Accepted solution]

Hi Sir,

You are absolutely right.

The amt reflected in the invoice will be in front of Mat A.

But I think this will fulfill your requirement as you only needed the same (1 complete item) in you respective invoice.

Regards

Gaurav

[Former Member]

Thanks.

[former_member204513]

Dear Amith,

Try with the copying routine.

Develop new copying routine as per your logic with the help of abaper then assign that in VTFL transaction at item level settings.

I hope this will help you,

Regards.

Murali.

[Former Member]

Dear Murali,

Thanks for the suggestion.

But, I am working-around on another thought.

This is some thing like "digging and cabling for 5 Kms" and say, the total time required for completion of work is 5 days; but we have to bill everyday.

Now, to complete "digging and cabling" requires various components:

1. Labour-charges

2. cable-cost

3. Other charges

So, on day one, say work as completed for 1 km. only.

Therefore, in Invoice, it should be:

Digging and Cabling -

---

1--

---

Day--

---

Rs. 50000

(whereas, this price of Rs. 50,000 comes from "Labour Charge for 1 day+ cable cost, used in 1 Km.+Other chares occured in 1 day")

Best Reagrds,

Amit.

Note: Will "BOM" ful-fill this requirement?