I want to create Purchase order line via PURCHASE_ORDER_LINE_API.New__.when I pefrom “PURCHASE_ORDER_LINE_API.New__(info_,objid_,objversion_,attr_,'CHECK');” no error message. but I change to “PURCHASE_ORDER_LINE_API.New__(info_,objid_,objversion_,attr_,'DO');” it dispaly “4246591008” is not a valid integer value.my script as beolowDECLARE info_ VARCHAR2(32000); objid_ VARCHAR2(2000); objversion_ varchar2(300); attr_ VARCHAR2(32000); BEGIN -- TBOOLENSTRING:=TRUE; Client_SYS.Clear_Attr(attr_); --Client_SYS.Add_To_Attr('BUYER_CODE','3HB03', attr_);- Client_SYS.Add_To_Attr('ORDER_NO','10112', attr_); Client_SYS.Add_To_Attr('BUY_QTY_DUE','100', attr_); Client_SYS.Add_To_Attr('DATE_ENTERED',sysdate, attr_); Client_SYS.Add_To_Attr('LAST_ACTIVITY_DATE',sysdate, attr_); Client_SYS.Add_To_Attr('PLANNED_DELIVERY_DATE',sysdate, attr_); Client_SYS.Add_To_Attr('PLANNED_ARRIVAL_DATE',sysdate, attr_);
as attachment, does any body know why shop order cost estimated material less than shop order material? in shop order material tab, there are 9 materials. but in shop order cost,estimate detail only have 5 materials. where can setup to make all of the material in estimate detail?
we want to modify purchase order received data via API. it can aslo modify TRANSACTION_HISTORY DATE_APPLIED field. does anybody give me a favior for inform me API function name. thanks
hello,I have question about shop order Receipt. currently we setup part Inventory valuation method: Weighted Average. After Receipt of Shop Order sometime it generate both Negative Difference of Calculation and Positive Difference of Calculation. sometime it only generate Negative Difference of Calculation or Positive Difference of Calculation. I want to know what’s situation it will generate Difference of Calculation? as I checked if WIP still have value on WIP or between WIP and Inventory have variance it will generate Difference of Calculation. does any one can give me a favor for explain the fully work principle about this?
I want to make report as shop order cost-> cost variance tab. which table or view i can query the data? current I query view SHOP_ORDER_VARIANCE2 which only have few records. it need me query in the shop order cost windows first, then the SHOP_ORDER_VARIANCE2 have records.
for the PODIRSH records, I only can saw Receipt with Purchase Order with Credit amount and Cost of Goods Sold, Sales with Debit amount.for Receipt with Purchase Order finace account, it have to have another finance account to transfer. it can not increase by itselfI thought most probably there were inventory cost with credit amount and Receipt with Purchase Order with Debit amount. does any one can inform me where I can see it?
Already have an account? Login
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.
