AP 立帐的时候不能match之:app-sqlap-10655

app-sqlap-10655:you cannnot match to this document .[@more@]

1.先查找该页面的视图:得PO_LINE_LOCATIONS_INQ_V

2.查找到视图的栏位是哪个table 得到:
po_line_locations_all --pll
DECODE (pll.match_option, 'P', 'PO', 'R', 'Receipt', 'PO'),

3.所以是那里为'P',值为PO 不能match.

select poh.segment1 --20601404

from

po_headers_all poh,

po_lines_all pol,

po_line_locations_all poll,

rcv_shipment_lines rsl,

rcv_shipment_headers rsh

where

poh.po_header_id=pol.po_header_id

and

pol.po_line_id=poll.po_line_id

and poll.line_location_id= rsl.po_line_location_id

and rsh.shipment_header_id=rsl.shipment_header_id

and rsh.receipt_num=60002831

4.查一下结果果然是,查询语句:
select pll.match_option , pll.po_line_id /*查询结果是 P 和 156363*/
from po_line_locations_all pll,
po_headers_all poh,
po_lines_all pol
where
poh.po_header_id=pol.po_header_id
and pol.po_line_id=pll.po_line_id
and poh.segment1='20600620'

5.修改pll.match_option 为'R'就可以了:
update po_line_locations_all
set match_option='R'
where po_line_id='156363'

commit;

最后,需要让user 去修改一下supplier 的设置, control- invoice match option , 选择 receipt .

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/226700/viewspace-846053/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/226700/viewspace-846053/