Sales invoice margin discount as per customer

406 views 4 replies

Is there a way to automatically set the sales invoice supply price as per customer?

e.g. if we supply to store 1 at 25% margin. If a product is Rs 100 MRP it should fill Rs 75 in Rate column

if we supply to store 2 at 20% margin. If a product is Rs 100 MRP it should fill Rs 80 in Rate column

without having to manually calculate and fill in each time we create an invoice

Replies (4)
Yes you can set such invoices by putting formula

Please give details where to set the formula. And will the formula automatically take effect for different Accounts. e.g. in above example if invoice is made for Store 1 it should use 25% discount. For Store 2 it should use 20% discount.

You should use ms excel and set formula according to such pattern of transactions

Please give details where to set the formula.
 


CCI Pro

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
04 June 2026
Semi Qualified CA

Goyal Puneet & Associates

New Delhi

CA Final

View Details
Company
26 May 2026
Senior Accountant cum purchase Manager

Vardhaman Group of India

Pimpri Chinchwad

CA Inter

View Details
Company
29 May 2026
Finance Head

Bhawar Sales Corporation

Chennai

Graduate (Any)

View Details
Company
ARTICLESHIP 31 May 2026
Article Assistant

KPRS And Associates

New Delhi

CA Inter

View Details
Company
29 May 2026
Accounts assistant

Shubh Consultancy

Mumbai

Graduate (Any)

View Details
Company
27 May 2026
Audit Assitant

Virender K Gupta and Co

New Delhi

B.Com

View Details
Company
ARTICLESHIP 04 June 2026
Article

Rakhecha & Co.

New Delhi

CA Inter

View Details
Company
Featured 28 May 2026
SEMI QUALIFIED/ CA DROPOUTS/ ARTICLES

T R SOOD & CO

New Delhi

CA Inter

View Details