Payables - Supplier Opening Credit - Debit - Net Amount Formula

/*******Supplier Opening Balance*******/

/*---------Net Opening Credit Balance----------*/
/*--------------NET_CR_OB----------------------*/

select nvl(sum(inv.invoice_amount *  nvl(inv.exchange_rate,1)) ,0)
from ap_invoices_all inv
where inv.vendor_id = :VENDOR_ID
and inv.gl_date < :P_FROM_DATE ;
   

/*---------Net Opening Debit Balance-----------*/
/*--------------NET_DR_OB----------------------*/    
   
select nvl(sum (chk.amount * nvl (chk.exchange_rate,1)) ,0)
from ap_checks_all chk
where chk.vendor_id = :VENDOR_ID
and chk.check_date < :P_FROM_DATE;

/*---------Net Opening Debit Balance-----------*/
/*-----NET_OB_BAL = NET_CR_OB - NET_DR_OB------*/

(select nvl(sum(inv.invoice_amount *  nvl(inv.exchange_rate,1)) ,0)
from ap_invoices_all inv
where inv.vendor_id = :VENDOR_ID
and inv.gl_date < :P_FROM_DATE )
    -
    (select nvl(sum (chk.amount * nvl (chk.exchange_rate,1)) ,0)
from ap_checks_all chk
where chk.vendor_id = :VENDOR_ID
and chk.check_date < :P_FROM_DATE )

Oracle Standard Workflow Required Edit Access

Step 1: Open Oracle Worflow Builder form Desktop


Step 2: Open Seeded Workflow Which is required to modify.

Step 3: 

Navigation: Workflow Builder > Help > About Workflow builder

1        i) Set Access Level : 0 
          ii) Select Checkbox ‘Allow modification of customization objects’

Oracle Workflow Compilation Steps

Step 1: Login into the FTP server using Putty.

Step 2: Load Environment Variable

example: execute below load environment script.

. /u02/DEV/apps/apps_st/appl/APPSDEV_skverpapptest3.env

Step 3: move workflow .wft file on $APPL-TOP

example: move .wft file mentioned path

/u02/DEV/apps/apps_st/appl/

Step 4: Workflow Compilation Command

WFLOAD apps/apps 0 Y FORCE Suppplier User Registration Workflow Version 2.wft