cancel
Showing results for 
Search instead for 
Did you mean: 

Arrangement of items in Invoice to be the same as Service contract

Sheila_Regine_N
Explorer
0 Kudos
356

Hi Gurus,

I have created a Service contract with the following entries
100 ABC

200 DEF

2 billing documents are generated for this one wherein both BDRS item number are '1'

reference per item are in each BDRs are:

<Service contract #> <800013> <CSCT>

<Service contract #> <800025> <CSCT>

Upon creation of the invoice, what happens is that the items appear reversed.

1 DEF

2 ABC

We should have something like

1 ABC

2 DEF

or even
100 ABC
200 DEF

Any advice how to make them appear in the same arrangement as the Invoice?

Accepted Solutions (1)

Accepted Solutions (1)

Tom_Wei
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi Sheila

We ask billing team. Here is the answer.

Based on my knowledge of job scheduling, the billing due list items are sorted in ascending order according to the content of the primary key of the billing due list table (= VKDFS)

And the billing date is part of the table’s primary key.

Best Regards
Tom

Sheila_Regine_N
Explorer
0 Kudos

Hi Tom,

Aside from the billing date, what else is the primary key?

regards,

Sheila

Answers (4)

Answers (4)

Tom_Wei
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi Sheila

if you take look at blew screenshot, you will see i highlight fields are key fields.

Best Regards

Tom

Silvia_Ventura
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi Sheila

thanks a lot for sharing this solution. I didn't think about it.

In Service, we don't have the possibility to configure the copy control between documents but BSC, SVTB and F2 are sales documents.

THANKS again

BR, Silvia

Sheila_Regine_N
Explorer
0 Kudos

Hi Silvia,

For now this worked.

I'll try checking what if that config is removed and check because according to Tom (reply below) in background job it is sorted in ascending order instead....

regards,

Sheila Ng

Silvia_Ventura
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hello Sheila

I've understood your point of view. Let us know the answer of the incident. I'm quite sure that my explanation is the root cause of this behavior so the question is if it could be improved.

Let's see the answer from S4HC Support.

BR, Silvia

Sheila_Regine_N
Explorer

Hi Silvia,

I was able to solve this.

If Invoice creation is to be created manually - that sorting of Billing due list will work

If Invoice creation is to be scheduled via background, we need to enable "Copy Item number" From the copying control

Sales Doc (BSC) > Billing Document (SVTB)

Billing doc (SVTB) > Billing Doc (F2)

regards

Sheila

Silvia_Ventura
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi Sheila

I saw that you're already created a support incident in SD-BIL. I didn't answer before because I knew that system worked as you explained (at least in previous versions)

Some customer raised your same question, The explanation is : "The default displaying order of the Billing Due List items is by descending order of billing date. And if the BDRs have the same billing date, they will be sorted in the descending order of creation" and the workaround "Please set the displaying order of the SD documents in the billing due list items as Ascending".

Best regards

Silvia

.

Sheila_Regine_N
Explorer

Hi Silvia,

Thanks for this info.

But if the billing creation is scheduled via background job, I don't think this will work, or will it?

- Sheila