콘텐츠로 건너뛰기
메뉴
커뮤니티에 참여하려면 회원 가입을 하시기 바랍니다.
신고된 질문입니다
3 답글
3355 화면

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.

아바타
취소
베스트 답변

Hi A S,

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

아바타
취소
베스트 답변

Can you describe it in more detail with a video?

아바타
취소
베스트 답변

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.

아바타
취소
관련 게시물 답글 화면 활동
3
3월 25
5653
5
4월 24
20355
0
5월 22
3000
0
7월 24
2199
1
11월 20
4739