DISCOUNT IN SALES INVOICE

[Former Member]

Hi All,

I have one querry. What is the requirement of discount in row lavel as well as in Header lavel in sales invoice.How I will get the report of this discount.Because it is not generating any jurnal entry.only the net amount is posted in the JE.

Thanks

santosh

[Former Member · Accepted solution]

Hi Santosh

You will notice that I had 2 lines against the sales account. The first is the nett amount of 90-00 and the second is writing the discount back to sales for 10-00 and to discount for 10-00. The other legs of the document will still be Customer and TAX and I was only focusing on the sales side and freight charge side of the document.

Kind regards

Peter Juby

[Former Member]

Hi Santosh

You will notice that I had 2 lines against the sales account. The first is the nett amount of 90-00 and the second is writing the discount back to sales for 10-00 and to discount for 10-00. The other legs of the document will still be Customer and TAX and I was only focusing on the sales side and freight charge side of the document.

Kind regards

Peter Juby

[Former Member]

Hi Santosh

SAP Business One always posts the net value after discount. If you would like the gross amount posted to sales and the discount to a separate account, you can use Freight charges to achieve this. In the first Freight charge post a - (negative value) of the discount to a discount account and in the second a + (positve value) to the sales account. The effect is as follows:

Price ........... Discount ................ Nett Price ............... Freight 1 ................. Freight 2 ........Doc Total

100 ............. 10 ......................... 90 .......................... -10 .......................... 10 .................= 90

CR Sales .... 90

CR Sales .... 10

DR Discount 10

These freight charges can be linked with Formatted Searches so it will be automatically posted.

Let me know if you would like to configure the above and I can send you some sample queries to use.

Kind regards

Peter Juby

[Former Member]

Hi peter ,

I dont get u wht u replied.My entry is as follows.

price is 100 dis count is 10 doc total is 90.

customer Dr 90

sales revenue Cr 90.

but i want like Customer Dr 90

discount Dr 10

Sales Revenue Cr 100

How I will do this.

Thanks

Santosh

[Former Member]

Hi

As an alternate, you can book the discount % in the 'Incoming Payment' screen when the customer gives the payment.

[Former Member]

You must define a freight (used like a discount) with the right account for discount and use it in line of document.

Edited by: Simona Bossi on Jul 28, 2008 1:57 PM

Edited by: Simona Bossi on Jul 28, 2008 2:01 PM

[Former Member]

Hi Peter,

I would be interested in seeing your queries to accomplish the use of freight to record discount on sales in conjunction with formatted search.

Thank you,

Lang