cancel
Showing results for 
Search instead for 
Did you mean: 

group billing quantity for batch split items

peng_tang
Participant
0 Kudos

Hi  guys

We have batch split items in our delivery notes. When we process billing, we dont want have several splitted lines for the same material no. Instead, we want only one line shows up for each material(which sums up the quantity and price and cost for those splitted lines.).  Could any one go through with me about how to manage this issue? thanks in advance.

Best Regards

T.P

Accepted Solutions (1)

Accepted Solutions (1)

ivano_raimondi
Active Contributor
0 Kudos

Hello Peng Tang,
in the delivery you have main-item and one or more batch-items.
What you can get in the billing document is documented in the WIKI page Batch items in billing document - ERP SD - SCN Wiki

There are not other possibilities in the standard.

Best regards,

Ivano.

peng_tang
Participant
0 Kudos

Thanks Ivano, this link helps me out greatly!

Answers (2)

Answers (2)

mahendra_jani3
Contributor
0 Kudos

Dear Peng Tang,

You can take below 2 actions for this:

1) In VTFL (Delivery to Billing Copy control) at Item category level and update Billing Quantity fields as G (Cumulative batch quantity minus invoiced quantity)

2) For not bringing batch split items in Invoice, you should have 2 different item category. Main item category for example (ZTAN) and Batch split Item category (ZTA2).

Now, Mark this ZTA2 as not relevant for Billing in VOV7 (field: Billing relevance as Blank.)

This should suffice your purpose.

Regards,

MJ.

Former Member
0 Kudos

Hello Peng Tang,

It is possible.

Create a new Item category for batch Line Item (ZTAN) coping you existing Item category (TAN).

Make TAN not relevant for billing and ZTAN relevant for billing.

By this way only batch Items will appear in the VF01 screen main item will not.

Hope this will help.

Regards

Amrit.

peng_tang
Participant
0 Kudos

Hi Amrit.

I think you get my question in the way side. Make the batch splited lines shows in vf01 is not what i concerned. My issue is that I want to group those splited lines into one based on the material no in vf01.  for examples, If i have three batch splited item for one material in DN. When I process billing in vf01, I hope there is only one lines which sum the splited lines base on different material NO.

I am not sure whether this help u get clear picture. any thought?

Thanks

T.P