ERPstuff - Oracle EBS Community

Hi, Basically the main tables involved will be RA_CUSTOMER_TRX_ALL, RA_CUSTOMER_TRX_LINES_ALL and AR_PAYMENT_SCHEDULED_ALL. However the report itself is taking also receipts on account etc..... Please see also my private message on how to get the detailed query ran by the report (Debug Flag of the r...

I had this problem also and it was a hard to correct.... Don't ask me why but with one client of us the issue was caused by a internet security setting. Go to: Control Panel -> Internet Options -> tab Security -> Click on Custom Level -> Check for the scripting options.. Good luck, Cyriel

Use Invoice Type prepeyment and enter the invoice as normal. Don't use VAT on the prepayment invoice but enter it with VAT on the Distribution Line and enter Tax Code (no VAT or something like that). You can pay this prepayment through manual payment or with a payment batch. When the actual invoice ...

Hi, It can be that that user has customized his form by using the folder technology for rearranging columns in his form. Also when you search in a form by for example using F11 -> CTRL F11 the form will save the corresponsing Query in the form. When the use has created a folder after that (or is res...

Hi, Complete means that the user hitted the Complete button. The invoice will receive it's transaction number (based on a document sequence linked to the transction type) and the invoice (receivables journal) can be posted to GL. The field STATUS_TRX which will held CL or OP will stand for Closed an...