Negative header discount on Invoice created by DGW

[Former Member]

Hi Experts,

I'm hoping you can help me with a question I have.

On the BP Master Data for a Customer the discount amount is set at '9'. Therefore when I raise a marketing document for this BP the discount on the header level of that document is automatically 9%.

I raise a Delivery Note for this BP for 1 x Item A @ £10.80 with 100% discount in the row. Total amount of Delivery Note = £0.00.

I raise a second Delivery Note for this BP for 1 x Item B Unit Price = £24.00 with no discount the row.

Total amount of Delivery Note = £21.84

£24.00 - £2.16(9%) in the header row = £21.84

I run the DGW and create one Invoice for this BP consisting of the two Delivery Notes for Items A and B.

1st row of the Invoice for Item A: 0.00 (which is fine)

2nd row of the Invoice for Item B: Unit Price = £24.00 Discount on the Row = 17.21% Total LC = £19.87

Invoice Total Before Discount = £19.87

Header Discount = -9.89% = £-1.97

Total Invoice = £21.84

Can anyone tell me why the discount appeared on the 2nd Row of the Invoice for Item B when there wasn't any discount in the row for this Item on it's Delivery Note?

And also why thre is negative discount -9.89% -£1.97 on the header of the Invoice too please?

I understand the total amount of the Invoice is correct, I just don't understand the logic or why SAP has put a discount on the row of Item B in the Invoice, and why it put the negative discount on the header of the invoice too.

Thanks so much for any help,

Caroline

[Former Member]

3rd Party add-on inteferring with the DGW causing the behaviour explained by Gordon's explaination is the reason for this.

[Former Member]

Hi Caroline,

The system may not be able to calculation easily in your special case. Everytime if 0 amount or negative amount involved in the same document. System cannot ignore the 0 row. It applied 9% discount in both rows that make the 2nd line took 9% twice. Then use negative discount in the header to make up the right total.

The calculation is reversed from the fixed total. If I were you, I will do manual invoice for this kind of special case.

Thanks,

Gordon

[Former Member]

Hi Gordon,

Thanks very much for this. It would seem a 3rd party add-on interferring with the DGW... coupled with your explaination is the reason for this strange behaviour.

Thanks again.

Caroline

[Former Member]

Hi Experts,

I forgot to say this is 2007A PL12.

Thanks

Caroline

[Former Member]

DGW is an add-on right? i think this DGW automatically modified the grand total for this two consolidated transaction. This a normal design of SAP, if Grand total is Less/Greater than the Line total it will re-calculate the discount on the header portion(either the result is negative or positive). why dont you try to remove first the discount on the first and second line before consolidating the transaction.

Regards,

Darius

[Former Member]

Hi Daris,

Thanks for your reply.

DGW is Document Generation Wizard and is a standard feature in SAP.

I can't take the discount off of the row for Item B ( it wasn't on the Delivery Note and you can't modify an Invoice once it's posted).

SAP seems to have added the discount in the DGW process, I dont know why this is hence logging the question on the forum.

thanks,

Caroline