Is there any way I can create a client wise report of my deliveries stating delivery date, number and quantity?
No. You are applying too many filters at once (customer, delivery date, number, quantity). Maybe when custom reports are further developed.
By the way, what do you intend as the difference between number and quantity? Are you referring to delivery note number? Invoice number?
I am forced to bump this topic again as I am facing serious trouble to reconcile deliveries of multiple items to different customers. My customers are demanding statement of deliveries of all items for a period of time which isn’t achievable easily as the current delivery reporting is still insufficient and custom report isn’t versatile yet. Current method to achieve such report is by going to
Inventory Items qty owned, qty on hand module. But it is impossible to memorize which customer bought which items as I have 217 items and 36K
I think the delivery reports must be improved urgently. I have few ideas which @lubos could consider to implement.
- Qty to be shown as column in
- New reports just like
Sales Invoicecurrently offers e.g. Deliveries by item, delivery to customer, etc.
- Custom report improvement basis date, customer, item and quantity
@lubos I need your attention here. I have more than 311 client whose deliveries as per their respective sales has to be reconciled. Manager currently has no way to reconcile under which particular invoice deliveries are pending or delivered more than sold qty. It’s very urgent. I am facing tremendous pressure from customers as I have no other way as of now.
If I understand correctly what you want to do, @raJ, you can do it through the Inventory Items tab, assuming you are using delivery notes. Click on the
Qty to deliver figure. Then click on a particular customer’s
Qty to deliver number. You will see a list of invoices including that inventory item.
I know how to trace qty to deliver to respective customers. But I don’t know which deliveries in the list is corresponding to which invoices. That is what I need to know.
If you follow the drill-down all the way as I described, you get exactly that. It sounds like you are stopping one step short of the answer you want.
There are 964 deliveries against 10 invoices in different dates. Sales invoices has different prices for the same product. But deliveries were made in different dates against their respective sales invoices. Can you now tell me under which sales invoice -34.660 is over delivered?
In this case, I have to increase that particular invoice quantity to adjust the over delivery.
In other cases if the quantity was less delivered than the original invoice - then I would have to decrease that respective invoice quantity to adjust.
None. That number is a total for all sales invoices and their corresponding delivery notes for the particular customer and is not useful for your purpose, because in the situation you described it is likely that no single invoice was over-delivered by 34.660 units.
If you are going to follow this workflow of adjusting sales invoices after delivery, you need to implement a procedure for adjusting quantities on a timely basis, rather than after 964 deliveries. I admit that seems like a daunting task.
Unfortunately, you cannot copy a delivery note to a sales invoice. That would be ideal for your situation.