Collective billing - Line item numbering incorrect

[former_member310771]

Hi there,

I would really appreciate it if folks on SDN could help me with this issue...

We follow 1 order: 1 delivery: 1 invoice process strictly but now for a particular customer wish to implement collective billing functionality.

I was able to create a collective billing document successfully after modifying data transfer routine in 'delivery to billing copy control' however the line item numbering has gone haywire.

e.g. in SO1 if there are 2 line items 10, 20,

and in SO2, 4 line items 10, 20, 30, 40,

then in Collective billing doc

line items are coming as 10, 20, 21, 22, 30, 40 which is incorrect

While i want the numbers to come as 10, 20, 30, 40, 50, 60

It seems that when system is done with the last item (20) of first sales order, then it picks first line item (10) of the next sales order and if it is not greater than the last processed line item number (20) then adds (1) to (20) to make it (21) and so on.

Can someone pl advise how to sort this?

Many thanks,

Naminator

[former_member183879 · Accepted solution]

Hi,

Please check the item number increment in the item category of the items 21 and 22 in VOV7. It should be one instead of 10. Change it to 10 and the problem will be solved

[ivano_raimondi]

Hello,

the replay of Naminator is fine.

But I think the 'Item no.increment' field in in transaction VOFA.

Regards,

Ivano.

[former_member310771]

Thank you SNavaneetha and Ivano for your replies.

I am facing this problem only when system is combining two or more deliveries in one 'collective billing document'.

All the line items explained in my example are unique SKUs and have same item category TAN.

In VOFA item increment is set to zero as in copy control VTFL 'copy item number from reference' box is checked.

It is now established that the problem is occurring in program LV60AB06

-

---

IF SY-SUBRC = 0.

IF *TVCPF-POSVO = 'X' AND

KUMUL = SPACE AND

XPOSNR GT XVBRK-HIPOS.

XVBRK-HIPOS = XPOSNR.

ELSE.

ADD TVFK-INCPO TO XVBRK-HIPOS.

XPOSNR = XVBRK-HIPOS.

IF VBAP-UEPOS IS INITIAL.

XUEPOS = XPOSNR.

ENDIF.

ENDIF.

-

---

I do not wish to modify standard code (as far as possible) and hence checking with SDN if there is anything that could bail me out.

Thanks,

Naminator

[ivano_raimondi]

Hello,

if the field item increment is set to zero, the system by default set the increment by one.

This explains the numbering you are getting.

Please try to follow the suggestion of SNavaneetha: set it to 10, then the system should work like you need.

Best regards,

Ivano.

[former_member310771]

Hi Ivano,

In our system, item numbers are supposed to be copied from 'reference documents' and the increment in reference document may vary. e.g. for Seasonal order increment is 10, for standard order 1.

What I am getting is 10, 20, 21, 22, 30, 40 when the two reference docs - SO1 has two lines 10, 20 and SO2 has 4 - 10,20,30, 40.

Items 10 and 20 in SO2 are coming as 21, 22.

If i change config in VOFA it'll affect all F2 invoice numbering.

Thanks,

Naminator

[ivano_raimondi]

Hi Naminator,

here is the system logic:

SO1 item 10 -> billing item 10

SO1 item 20 -> billing item 20

SO2 item 10 -> item 10 already exists ! So system takes the last billing item number assigned, which is 20, and increase it by the value set in TVFK-INCPO. So billing item 21

SO2 item 20 -> same as above, so billing item 22

SO2 item 30 -> billing item 30

SO2 item 40 -> billing item 40

There is not way to avoid this.

Best regards,

Ivano.

[former_member310771]

Ivano,

Appreciate your advise on this...many thanks.

Regards,

Naminator