ERP 相关
puserzhou
这个作者很懒,什么都没留下…
展开
-
How To Setup PDF Format For PO Printing
1) /Setup/Organizations/Purchasing Option...click Control... PO Output Format = PDFpo_output_format in po_system_parameters2) /Setup/Purchasing/Document Typechoose Standard PODocument Type Layout = PO原创 2006-02-08 10:58:00 · 1061 阅读 · 0 评论 -
oracle内发送email
create or replace procedure ProcSendEmail(txt varchar2)IS --senders email addressSendorAddress Varchar2(30) := xxx@xxx.com; --receiver s email addressReceiverAddress varchar2(30) := xxx@xxx.com;原创 2006-02-14 10:38:00 · 1220 阅读 · 1 评论 -
ReceiptNum不見了
Subject: Lockbox Errors ORA-06503 REP-1401 MSG-01001 Doc ID: Note:141052.1 Type: PROBLEM Last Revision Date: 29-MAY-2002 Status: PUBLISHED fact: Oracle Receivablesfact: ARLPLB - Process Lockboxessympt原创 2006-02-14 08:37:00 · 1045 阅读 · 0 评论 -
在po_headers_all 中closed_code 狀態'closed','closed for invoice','closed for receiving' 的區別
在oracle中,PO的状态除了“Final Close”外,都是没有实际控制作用的当接收完成后,shipment状态就会自动变为“close for receiving”,当发票匹配完成后,状态就会自动变为“close for invoice”。这两个都完成后,shipment的状态变为“close”。当所有的shipment都close后,PO的状态为close。这些状态仅仅是一个标志,没原创 2006-02-14 08:59:00 · 2945 阅读 · 0 评论