Odoo Help

Welcome!

This community is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.

0

Return shipment PO doesn't update the received Qty

By
Ignacio Fernandez Divar
on 3/1/16, 2:55 PM 818 views

Hello to all,

I assume that I'm doing something wrong because I can not believe this is not working in Odoo v9. I detected it in a dropshopping process but it happens in a regular flow as well.


1.  I create a PO for 13 units

2.  Received the 13 units

3.  Reverse the shipment created with another shipment for 5 units. I was hoping that the two shipments were linked to the PO and the received quantity updated to 8 units but it is not happening.


I'm using the control purchase bill on received quantities in the product.


Thanks in advace for your help,

Nacho

0

Ray, I agree with Nacho's point of view in the sense that it would make the flow more intuitive.

So, as long as you have not entered the supplier invoice, you should be able to return with reference to that PO for the PO lines and quantities not yet invoiced, and the system should reduce the quantity to invoice. Quantity received - quantity returned = quantity to invoice. Because you, as a customer, do not acknowledge these quantities to be included in the supplier invoice.

In this same sense, if the supplier uses Odoo, he should be able to return the quantities delivered, provided that they have not been invoiced yet, reducing the quantity to invoice.

If the customer invoice have been posted and sent at the supplier side, then I agree that it is the obligation of the customer to accept the invoice. The initiating supplier invoice should then be posted with the original quantity received. Then the return should be part of a separate process, with separate refund invoice.

So, that is, adjustments in the quantity to invoice resulting from disputes between the supplier and customer, before invoices have been generated, should become part of the same transaction. But once the invoice has been sent, a new transaction flow must be initiated.
 

I agree also. I have never seen this in a single Customer. Either the Invoice arrives BEFORE the goods, or arrives WITH the goods, or arrives a few days later. ALWAYS for the complete quantity. NEVER adjusted, always credited with a SECOND invoice. Just because the user receiving the goods hasn't entered the Invoice, doesn't mean it hasn't already been created in another system. I've never come across the case where the Vendor/Supplier would cancel the Invoice and re-issue one with a smaller quantity. Perhaps it is just a factor of how business is done where I am versus where others (and you) are.

Bista Solutions US, Ray Carnes
on 10/19/16, 11:47 AM

Usually, the vendor will replace the defective product. We don't want a refund, we want the PO completed. How do we keep track of those 5 units the supplier still owes us? The PO is fully received. The supplier invoice is for the full quantity. The accounting department is going to pay the bill. There is no evidence anywhere in the system that the supplier owes us more product. There should be a mechanism for "return for replacement" versus "return for refund." In the "return for replacement" work flow, the PO receipt quantity should be updated.

Matt Taylor
on 10/19/16, 3:58 PM
0

Maybe I didn’t explain myself, I don’t expect the receipt to change but I would like the “received quantity” on the purchase to update.

The business case I try to explain is this:

  • I ordered 13 units of product A using a Purchase order.
  • I received the 13 units
    • PO quantity: 13 units
    • "Shipment one" quantity: 13 units
    • PO received quantity: 13 units  
  •  After the inbound process I realize the 5 units were broken and I return them to the vendor reversing "shipment one":

    • PO quantity: 13 units
    • "Shipment one" quantity: 13 units  
    • Return shipment quantity: 5 units  
    • PO received quantity: 13 units --> I expected that after the reverse/return this quantity were 8.  

·        The vendor tells me that he´s not got stock so we agree to invoice only 8 units and close the purchase order. I create the invoice and the system proposes 13 units. On the purchase order we cannot see any trace of what happened (the received quantity hasn´t changed) and the return shipment is no accessible or visible from the purchase order. All these factors will trigger  an incorrect invoice.  

Is there anything we can do to solve this issue? Maybe there is another way to do it and I don’t know how this process works in Odoo.

I understand your business case. What does the Vendor invoice you for? Normally they will send an Invoice for 13 as soon as they ship, not knowing that 5 were broken. Odoo is assuming you will get an Invoice for 13, and your Vendor will credit you for 5 units. So you will validate the Invoice for 13, and create an Credit Invoice from the reverse operation for 5. You will then only need to pay for 8 in the end.

Bista Solutions US, Ray Carnes
on 3/2/16, 8:43 PM
0

Ray Carnes

--Ray Carnes--
15717
| 9 7 9
Greater Los Angeles, United States
--Ray Carnes--

Senior Odoo Analyst

OpenERP 6.1, 7.0 and Odoo 8.0, 9.0 (Since 2012)

Completed Functional and Technical Training.

Major Skills:

  • Needs Discovery and Requirements Analysis;

  • Function and Technical Specifications;

  • Project Planning;

  • Prototyping and Proof of concepts;

  • Data migration;

  • Configuration & Customization (UI and modules);

  • Integration - data, business logic and service levels;

  • Training and Knowledge transfer;

  • Go Live support;

  • Help desk;

  • Version Migration.

I have over 20 years of experience empowering and enabling users with enterprise information systems that make a real and measurable difference in their ability to proactively manage their businesses and organizations. 

Ray Carnes
On 3/1/16, 6:49 PM

It won't work this way in Odoo without customization - Odoo is working exactly the way it is designed to work out of the box.

Since 13 units came in, there will be a record that 13 came in.

When you reverse the shipment and select 5, there will be another record that 5 went back.  

The fact that 13 came in hasn't changed, which is why it won't update the Receipt - Odoo will just record the reverse as a second record that reduces the net quantity in stock to 8 units.

What was the reason for 13 units being received?  If this was a mistake, you may want a record of the mistake so you can keep track of users who need additional training.  If you don't, you can customize Odoo to allow you to 'reset' the Receipt as if nothing happened (but then you lose any record of the mistake) and proceed to receive 8.


Can you clarify your statement in the above comment: "create an Credit Invoice from the reverse operation"? No options visible on the delivery order. Maybe you mean ASK REFUND, on the vendor bill?

Matt Taylor
on 10/18/16, 5:58 PM

Yes. It depends on the version of Odoo you are using. Sorry - I wasn't specific.

Bista Solutions US, Ray Carnes
on 10/19/16, 11:49 AM

The invoice probably hasn't been created yet, at the time of inspection. In that case, the inspector can't ASK REFUND (it really should be done by an accountant anyway). What's to prevent the returned product being paid for, and forgotten?

Matt Taylor
on 10/19/16, 3:53 PM

Usually it's the same way that Accounting is prevented from paying for product that they never receive in first place - they check with the Warehouse. How this happens is different from company to company. The most common way - the Warehouse stamps 'received' on the paperwork and signs/dates. The next most common way - the Warehouse scans and attaches to the Receipt document in Odoo the same paperwork. Other ways include Notes or Chatter beneath the Receiving document, copying Accounting. So Accounting is either given the paperwork, looks at the attachment or receives and email. Again - this is just how it works at the sites I have visited and/or implemented Odoo. At some places, the Vendor must put the Customer PO# in the shipment or it will be refused.

Bista Solutions US, Ray Carnes
on 10/20/16, 3:54 PM

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

2 follower(s)

Stats

Asked: 3/1/16, 2:55 PM
Seen: 818 times
Last updated: 10/11/16, 12:16 AM