Consignment sales

Hi!
Again need you assistance. We often give goods on consignment basis, it means that we supply goods along with Delivery Note, and we give invoice monthly against customer sales statement. It's important for us to know, how many of our items are laying with each customer. I tried using for this purpose Delivered Items To Be Billed report, but there're 2 problems: 1. it doesn't show quantity, only amounts (there's no such parameter as Billed quantity. is it?) 2. it doesn't take into consideration sales returns (through Stock Entry).
Can you please suggest some solution?

Slava



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

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+un...@googlegroups.com.

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

 

 

Hi Slava,

You can customize the report "Delivered Items To Be Billed" report and add the "Pending qty" column. It can be done by dividing "Pending Amount" by "Rate".

And for Sales Return, you can make a new report based on "Stock Entry" and there you can filter based on customer.

Regards,
Nabin Hait

On 08-Apr-2013, at 12:11 PM, Slava wrote:

Hi!
Again need you assistance. We often give goods on consignment basis, it means that we supply goods along with Delivery Note, and we give invoice monthly against customer sales statement. It's important for us to know, how many of our items are laying with each customer. I tried using for this purpose Delivered Items To Be Billed report, but there're 2 problems: 1. it doesn't show quantity, only amounts (there's no such parameter as Billed quantity. is it?) 2. it doesn't take into consideration sales returns (through Stock Entry).
Can you please suggest some solution?

Slava



You received this message because you are subscribed to the Google Groups “ERPNext User’s Forum” group.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-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 User's Forum" group.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+un...@googlegroups.com.

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

 

 

It helped, thanks!

On Monday, April 8, 2013 3:47:10 PM UTC+5:30, Nabin Hait wrote:

Hi Slava,

You can customize the report “Delivered Items To Be Billed” report and add the “Pending qty” column. It can be done by dividing “Pending Amount” by “Rate”.

And for Sales Return, you can make a new report based on “Stock Entry” and there you can filter based on customer.


Regards,
Nabin Hait


On 08-Apr-2013, at 12:11 PM, Slava wrote:

Hi!
Again need you assistance. We often give goods on consignment basis, it means that we supply goods along with Delivery Note, and we give invoice monthly against customer sales statement. It's important for us to know, how many of our items are laying with each customer. I tried using for this purpose Delivered Items To Be Billed report, but there're 2 problems: 1. it doesn't show quantity, only amounts (there's no such parameter as Billed quantity. is it?) 2. it doesn't take into consideration sales returns (through Stock Entry).
Can you please suggest some solution?

Slava



You received this message because you are subscribed to the Google Groups “ERPNext User’s Forum” group.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-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 User's Forum" group.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+un...@googlegroups.com.

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