ERPstuff - Oracle EBS Community

I have been setup new organization , when i want inter-org receipt, it pop up error ap-po-14376, I have been check up a metalink , metalink say Period is not open but I have open all period in Inventory, Control Purchasing Period, Period In GL, I'm confused because when i use miscellineous Transacti...

set to what value, maybe u have many Inventory Organzation in one Operating unit , right

you can do it in report, just in AFTER PARAMETER FORM trigger
u can use PLSQL to restrict user to acces the report
like this:
if ( l_exist = 'N' ) then
srw.message(1,'You have no right.');
raise no_data_found;
end if;

on layout : MAIN SECTION

YOU CAN SET THE WIDTH AND LENGTH

Just check it in "AFTER PARAMETER FORM"

IF USERNAME <> "ME" THEN
srw.message(1,'You have no right.');
raise no_data_found;
end if;

SELECT I.INVOICE_DATE , I.INVOICE_NUM , I.TERMS_NAME , I.PO_NUMBER --, DECODE(I.RECEIPT_NUMBER,'UNMATCHED',NULL,I.RECEIPT_NUMBER) RECEIPT_NUMBER , ROUND(I.ACTUAL_INVOICE_AMOUNT) ACTUAL_INVOICE_AMOUNT , I.INVOICE_ID FROM AP_INVOICES_V I , AP_PAYMENT_SCHEDULES_V PS WHERE I.INVOICE_ID = PS.INVOICE_ID A...

copy the report from server, rename with your own, now you can experiment as u like

SELECT SUBSTR(FIELD_NAME,1,6) FROM TABLE;

thx, now i can get all data from AR_MISC_CASH_DISTRIBUTIONS_ALL

[:)]

CAN SOME ONE GIVE ME A EXAMPLE HOW GO GET MULTI ORG DATA FROM
ar_misc_cash_distributions_v

IF I'M MY LOGIN ORG ID IS '102', HOW CAN I GET DATA FROM '104' DATA

Some RECEIPT eaves balance on AP Acrual when invoice matched so it raise inbalance in journal which import from purchasing and payable On receipt: DB Receiving $1050 CR A/P Acrual Account Po price + Non Recoverable Tax $1050 On Invoicing: DB A/P Accrual Account PO Price $1000 DB (TAX) $50 CR AP Liab...

MAYBE THIS QUERY CAN HELP U SELECT CHK.BANK_ACCOUNT_NAME ,CHK.VENDOR_NAME ,CHK.AMOUNT ,CHK.CHECK_dATE ,INV.INVOICE_NUM FROM AP_Checks_V CHK, AP_INVOICE_PAYMENTS_V INV WHERE CHK.CHECK_ID=INV.CHECK_ID AND TO_CHAR(CHK.CHECK_DATE,'YYYY') IN ('2008','2007') ORDER BY CHK.CHECK_DATE

yes, get the data from oracle payable and oracle receivable, use UNION to join them

CAN SOMEONE GUIDE ME TO FIND A FILES IN THIS FOLDER[:)]

if we close the period, we still can open it from TOAD, I have been do it, all the time