Przejdź do zawartości
Musisz się zarejestrować, aby móc wchodzić w interakcje z tą społecznością.
Wszystkie posty Osoby Odznaki
Tagi (Zobacz wszystko)
odoo accounting v14 pos v15
O tym forum
To pytanie dostało ostrzeżenie
purchasepurchase_orderbilling
4 Odpowiedzi
5062 Widoki
Awatar
Vega-Impex Kft., A S

We have created several POs (with many products) for a given vendor and we have received an long bill/invoice (which includes several POs and many products) from them. We want to match this invoice with the PO to see if everything what is billed was also ordered via PO and if anything is missing.

Manually via Odoo it is time-consuming as we would automatically need to create the bill from these POs, then manually check line-by-line the actual bill with the Odoo bill and repeat that for each POs. 


Now, is there a way to import via XLS or other formats the actual bill, which automatically references the PO line without knowing the external PO line id? We know the PO external reference and the vendor name.

Methods or paid add-ons are also welcomed if exist.

Awatar
Odrzuć
Awatar
Lars Aam
Najlepsza odpowiedź

First: Ask your Vendor to send one invoice for each purchase order.  It will reduce work on both parties.  Also the invoice must reference the purchase orders. It can be on line level on the invoice.

If so, the Odoo function with OCR, will do most of the job for you.

Create invoice from PO is not a good idea.  For the partner ledger you will only want to have one invoice register.  And that can be done:

Import/upload the vendor invoice to vendor bill in accounting

There is a field named AutoComplete where you can look up and import the lines from the PO. You can match several PO to the same invoice.  Import one PO, and check match to invoice. If you have goods receipt the received qty will be imported.  The price will be imported. Delete lines if they are not on the invoice.  

Then take the next PO. It will be a tedious work whatever way you do it.

Awatar
Odrzuć
Awatar
Thuy Ngoc
Najlepsza odpowiedź

Hi A S,

I think this video can help you: https://www.youtube.com/watch?v=etMYrOJyaiU&list=PLSKcWRTtEl5qzvRaI-VTGavfReiHS_EEb&index=2

Awatar
Odrzuć
Awatar
James
Najlepsza odpowiedź

One supplier invoice across several POs is always messy unless the supplier gives you a good reference on the invoice.

The first thing I would ask for is PO reference at line level, not only on the invoice header. If the invoice only says one vendor name and one total, Odoo has very little to match reliably against several POs.

Practically I would handle it like this:

  • upload/import the supplier invoice as one draft vendor bill
  • use the PO references to pull in PO lines one PO at a time
  • check received quantity, invoiced quantity, unit price, tax and line total
  • delete PO lines that are not actually on the supplier invoice
  • keep anything with missing PO ref, quantity mismatch or tax mismatch in manual review

If the vendor can send one invoice per PO, that is cleaner. If they cannot, then line-level PO references are the thing that saves you from doing the whole match by hand

Awatar
Odrzuć
Awatar
Tuan Bui VKS
Najlepsza odpowiedź

Can you describe it in more detail with a video?

Awatar
Odrzuć
Powiązane posty Odpowiedzi Widoki Czynność
How to Bill a Purchase Order For Services? Rozwiązane
purchase purchase_order billing
Awatar
Awatar
Awatar
Awatar
3
mar 25
7852
How can I differ the Billing address and the shipping address for a Purchase order? Rozwiązane
purchase shipping purchase_order billing
Awatar
Awatar
Awatar
Awatar
Awatar
5
kwi 24
22928
edit due date after creating partial purchase order
purchase purchase_order
Awatar
0
maj 22
4525
Purchase prototype products; What´s your solution?
purchase purchase_order
Awatar
0
lip 24
3473
How to enable Source Document (field label) Origin (field name) Rozwiązane
purchase purchase_order
Awatar
Awatar
1
lis 20
6701