Discount % In Sales Invoice @ document level

Dear All

I have two little query and I hope , I will get answer.
.
*   I need Discount % at document/Invoice  level on Sales Invoice. waiting for any correct reply.
Sales Register Report in Account Modules didn’t fetch data, because one inner join is missing, but how i will change the query of report

 tabAccount left join   tabCustomer  on tabCustomer.name = tabAccount.master_name



Best Regards,
M.H.I



You received this message because you are subscribed to the Google Groups "ERPNext Developer Forum" group.

To post to this group, send email to er...@googlegroups.com.

To unsubscribe from this group, send email to erpnext-developer-forum+un...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msg/erpnext-developer-forum/-/tp_F1brIXiEJ.

For more options, visit https://groups.google.com/groups/opt_out.

 

 

Dear Mahr,

1. You can enter negative charges in tax table for discount at document level.

2. For editing the query of Sales Register, go to Advance Settings and set "Standard" as "Yes". Copy and Paste "Client Script", "Server Script" and "Overload Query" from repository file. And then change the "Overload Query" as your requirement.

You can directly change into file as well, in that case you have to fix conflict yourself while pulling updates from github.



Regards,
Nabin Hait



On Mon, Oct 29, 2012 at 4:23 PM, Stk Intl Trading IT Manager Mahr Haider <st…@gmail.com> wrote:

Dear All

I have two little query and I hope , I will get answer.
.
* I need Discount % at document/Invoice level on Sales Invoice. waiting for any correct reply.
  • Sales Register Report in Account Modules didn't fetch data, because one inner join is missing, but how i will change the query of report


tabAccount left join tabCustomer on tabCustomer.name = tabAccount.master_name



Best Regards,
M.H.I



You received this message because you are subscribed to the Google Groups "ERPNext Developer Forum" group.

To post to this group, send email to er…@googlegroups.com.

To unsubscribe from this group, send email to erpnext-developer-forum+un…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msg/erpnext-developer-forum/-/tp_F1brIXiEJ.

For more options, visit https://groups.google.com/groups/opt_out.










You received this message because you are subscribed to the Google Groups "ERPNext Developer Forum" group.

To post to this group, send email to er...@googlegroups.com.

To unsubscribe from this group, send email to erpnext-developer-forum+un...@googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.

 

 

Dear

1- For discount purpose, i need a separate field for discount. If I will use tax as discount then how we will separate tax and discount amount for reporting.
2- In Stock Report i want to hide for only warehouse users not for all


Thanks

On 30 October 2012 10:36, Nabin Hait <na...@gmail.com> wrote:
Dear Mahr,

1. You can enter negative charges in tax table for discount at document level.

2. For editing the query of Sales Register, go to Advance Settings and set "Standard" as "Yes". Copy and Paste "Client Script", "Server Script" and "Overload Query" from repository file. And then change the "Overload Query" as your requirement.

You can directly change into file as well, in that case you have to fix conflict yourself while pulling updates from github.



Regards,
Nabin Hait





On Mon, Oct 29, 2012 at 4:23 PM, Stk Intl Trading IT Manager Mahr Haider <st…@gmail.com> wrote:

Dear All

I have two little query and I hope , I will get answer.
.
* I need Discount % at document/Invoice level on Sales Invoice. waiting for any correct reply.
  • Sales Register Report in Account Modules didn't fetch data, because one inner join is missing, but how i will change the query of report


tabAccount left join tabCustomer on tabCustomer.name = tabAccount.master_name



Best Regards,
M.H.I



You received this message because you are subscribed to the Google Groups "ERPNext Developer Forum" group.

To post to this group, send email to er…@googlegroups.com.

To unsubscribe from this group, send email to erpnext-developer-forum+un…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msg/erpnext-developer-forum/-/tp_F1brIXiEJ.

For more options, visit https://groups.google.com/groups/opt_out.










You received this message because you are subscribed to the Google Groups "ERPNext Developer Forum" group.

To post to this group, send email to er…@googlegroups.com.

To unsubscribe from this group, send email to erpnext-developer-forum+un…@googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.







You received this message because you are subscribed to the Google Groups "ERPNext Developer Forum" group.

To post to this group, send email to er...@googlegroups.com.

To unsubscribe from this group, send email to erpnext-developer-forum+un...@googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.

 

 

Dear Mahr,

1. For "Discount" as a separate field, you need to make big changes in client and server side code. If you just want to separate out discount from taxes , you can simply add a custom filed in tax table.


2. "Stock Report" is based on "Stock Ledger Entry" doctype, so you need to change permission of "Stock Ledger entry" doctype, to manage access restriction of "Stock Report".



Regards,
Nabin Hait

On Tue, Oct 30, 2012 at 12:27 PM, stkitmanager <st…@gmail.com> wrote:

Dear

1- For discount purpose, i need a separate field for discount. If I will use tax as discount then how we will separate tax and discount amount for reporting.
2- In Stock Report i want to hide for only warehouse users not for all


Thanks

On 30 October 2012 10:36, Nabin Hait <na...@gmail.com> wrote:
Dear Mahr,

1. You can enter negative charges in tax table for discount at document level.

2. For editing the query of Sales Register, go to Advance Settings and set "Standard" as "Yes". Copy and Paste "Client Script", "Server Script" and "Overload Query" from repository file. And then change the "Overload Query" as your requirement.

You can directly change into file as well, in that case you have to fix conflict yourself while pulling updates from github.



Regards,
Nabin Hait





On Mon, Oct 29, 2012 at 4:23 PM, Stk Intl Trading IT Manager Mahr Haider <st…@gmail.com> wrote:

Dear All

I have two little query and I hope , I will get answer.
.
* I need Discount % at document/Invoice level on Sales Invoice. waiting for any correct reply.
  • Sales Register Report in Account Modules didn't fetch data, because one inner join is missing, but how i will change the query of report


tabAccount left join tabCustomer on tabCustomer.name = tabAccount.master_name



Best Regards,
M.H.I



You received this message because you are subscribed to the Google Groups "ERPNext Developer Forum" group.

To post to this group, send email to er…@googlegroups.com.

To unsubscribe from this group, send email to erpnext-developer-forum+un…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msg/erpnext-developer-forum/-/tp_F1brIXiEJ.

For more options, visit https://groups.google.com/groups/opt_out.










You received this message because you are subscribed to the Google Groups "ERPNext Developer Forum" group.

To post to this group, send email to er…@googlegroups.com.

To unsubscribe from this group, send email to erpnext-developer-forum+un…@googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.







You received this message because you are subscribed to the Google Groups "ERPNext Developer Forum" group.

To post to this group, send email to er…@googlegroups.com.

To unsubscribe from this group, send email to erpnext-developer-forum+un…@googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.










You received this message because you are subscribed to the Google Groups "ERPNext Developer Forum" group.

To post to this group, send email to er...@googlegroups.com.

To unsubscribe from this group, send email to erpnext-developer-forum+un...@googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.