Start Time : 11/10/2023 08:27:01 AM
Executing Action
ASB XE3/32/64 DLL running
[Compiled on 08/12/2022 01:29:00 AM] [File Version : 11.1.0.0]] [Product Version : 11.1][64Bit(0712)]
DB Manager created
Current ASB DLL folder : C:\Program Files (x86)\AgileLabs\AgileERPUAT_11\AxpertWebScripts
Connecting to project : bafcotesting
Connecting to project found : -1
Session key validation
Session key validation completed
Db Manager Connection starts
Db Manager Connection XML receied : dbOracledbxagileclouddbbafcotesting
creating connection starts...
creating connection end...
creating date xds...
creating date xds end...
OracleConnect starts...
Dbx name = bafcotesting
ConnectionName = oracle
DriverName = oracle
GetDriverFunc = getSQLDriverORACLE
LibraryName = C:\Program Files (x86)\AgileLabs\AgileERPUAT_11\AxpertWebScripts\dbxora.dll
VendorLib = C:\Program Files (x86)\AgileLabs\AgileERPUAT_11\AxpertWebScripts\OCI.dll
Database = agileclouddb
User_Name = bafcotesting
db user : bafcotesting
Select sysdate as sdt from dual
Time elapsed = 16
select ConnectNoSeq.NextVal from Dual
Time elapsed = 15
Time elapsed = 0
select props from axprops where lower(name)='app' order by blobno
Time elapsed = 16
axprops xml = images\Bafco (Test)INRTF2000020500firesql({m3},{select axusersid from axusers b where b.username = :username})m_axuserid := sqlget({m3},{axusersid})firesql({m4},{select to_date(sysdate) as sdate from dual})m_systemdate := sqlget({m4},{sdate})firesql({m5},{select b.currency from company a, currency b where a.basecurrency = b.currencyid and a.companyid = 1}) m_basecurrency := sqlget({m5},{currency})firesql({m9},{select min(startdate) fstartdate from financial_year b where active = 'T'})m_fstartdate := sqlget({m9},{fstartdate})firesql({m10},{select max(enddate) fenddate from financial_year b where active = 'T'})m_fenddate := sqlget({m10},{fenddate})firesql({m11},{select tstartdate from vw_transcontroldates})m_tstartdate := sqlget({m11},{tstartdate})firesql({m12},{select tenddate from vw_transcontroldates})m_tenddate := sqlget({m12},{tenddate})firesql({m13},{select employee_id as employeeid from axusers where upper(username) = upper( :username)})m_employeeid := sqlget({m13},{employeeid})firesql({m14},{select e.employee_name as employeename from axusers a, empmaster e where a.employee_id=e.empmasterid and upper(a.username) = upper( :username)})m_employeename := sqlget({m14},{employeename})firesql({m15},{select cstartdate from vw_transcontroldates})m_cstartdate := sqlget({m15},{cstartdate})firesql({d1},{select initcap(d.dim1code) as dim1 from dimmaster d where rownum = 1})m_dim1 := sqlget({d1},{dim1})firesql({d2},{select initcap(d.dim2code) as dim2 from dimmaster d where rownum = 1})m_dim2 := sqlget({d2},{dim2})firesql({m17},{select department from dept where deptid = (select department from empmaster where empid = (select username from axusers where employee_id = :m_employeeid))})m_luserdept := sqlget({m17},{department})select a.username, b.usergroup from axusers a, axuserlevelgroups bwhere a.axusersid = b.axusersidfiresql({axu},{select fileserveruser from axusers where username = :username})Axp_MapUserName := sqlget({axu},{fileserveruser})firesql({axpwd},{select fileserverpwd from axusers where username = :username})Axp_MapPwd := sqlget({axpwd},{fileserverpwd})firesql({m16},{select stockdate as stockdate from vw_transcontroldates})m_stockdate := sqlget({m16},{stockdate})bapcoenergies-com.mail.protection.outlook.com25BAF.erp.cloud@bapcoenergies.com00000FF
SELECT Constraint_Name FROM AXCONSTRAINTS where 1=2
Time elapsed = 16
Db Manager Connection ends
Connection to DB Successful
Executing DoAction webservice
-----------------------------
Registering app/user variables for the session
Script path set in WEB : C:\Program Files (x86)\AgileLabs\AgileERPUAT_11\AxpertWebScripts\Axpert\tnqvdqoffaj1sxxfw5emp4ub
Registering DBMem variables
Registering DBMem variables completed
Registering ConfigParam variables
Registering ConfigParam variables completed
licredis_det=127.0.0.1:6380~00080148015301540162015201710154014632163450607080013
auth_path=C:\Program Files (x86)\AgileLabs\AgileERPUAT_11\AxpertWebScripts
axp_clientlocale=
axp_appschema=bafcotesting
axp_devschema=bafcotestingaxdef
axp_apipath=
sesid=tnqvdqoffaj1sxxfw5emp4ub
ax_evalcopy=F
rolename=ToDoList,default
responsibilies=default,todolist
M_VENDOR=
M_EMPLOYEE_ID=
M_NATIVELANG=EN
M_TAXTYPE=
M_PERIOD12=
M_PERIOD11=
M_PERIOD10=
M_PERIOD9=
M_PERIOD8=
M_PERIOD7=
M_PERIOD6=
M_PERIOD5=
M_PERIOD4=
M_PERIOD3=
M_PERIOD2=
M_PERIOD1=
AXPIMAGEPATH=\\10.0.0.3\AgileBizDocs\Attachments\Bafco\AttachFile\
AXGLO_HIDE=T
VDIM4=
VDIM3=
VDIM2=DEPT
VDIM1=C-CENTER
M_STOCKPOSTING=
AXP_DISPLAYTEXT=Welcome to AgileBiz
M_ONLINEINVPOSTING=
M_ACCTPOSTING=
M_GROUPOFCOMP=
M_CURRENCY=BD
M_FYENDDATE=
M_FYSTARTDATE=
M_FINYR=
M_BRIDENTIFIER=
M_LOCATION=STORES
M_BRANCH=MUHARRAQ
M_COMPANYCODE=
M_COMPANY=THE BAHRAIN AVIATION FUELLING COMPANY B.S.C (CLOSED)
AXGLO_USER=admin
FROMUSERLOGIN=F
axglo_recordid=1029880000001
m_external=T
AXPIMAGESERVER=\\10.0.0.3\AgileBizDocs\Attachments\Bafco\AttachFile\
AxpDbDirPath=\\10.0.0.3\AgileBizDocs\Attachments\BAFCO\AxImportDbDir
m_stockdate=10/10/2023
Axp_MapPwd=
Axp_MapUserName=
m_workflow=
m_luserdept=
m_intfinance={T}
m_dim2=Dept
m_dim1=C-Center
m_cstartdate=11/10/2023
m_employeename=
m_employeeid=0
m_tenddate=11/10/2023
m_tstartdate=11/10/2023
m_fenddate=31/12/2023
m_fstartdate=01/01/2020
m_essbranch=BAFCO-ESS
Axp_HyperLinkColColor=$00FFFFA4
m_basecurrency=BD
m_systemdate=11/10/2023
m_axuserid=1
LStr : ~~9867~9867~0~0~0~R~true~R
LReg Type : R
User Group ToDoList,default
User Roles default,todolist
Registering app/user variables for the session completed
Received XML Trigger Cancel1154660000112admindefault,todolist1L022112/05/2023 03:05:24 PMFMUHARRAQ21259000000000CI12/05/202311/10/202331/05/2023:BAF/2023/CI/BAF/2023/CI/000005BP MIDDLE EAST LLC | CCC-008BP MIDDLE EAST LLCCCC-0081154440000070RECOVERABLE CONTROL ACCOUNT | 12330224646000000032RECOVERABLE TEMP ACCOUNT | 2220072023Arad Equipment012/05/202312/05/2023BahrainBahrainBahrainBD100350000000071.000000Arad depot equipment purchased by BP Middle East 1154660000113DBB Valves - tank 5 to 12 Tank inlet body valves - MOV DBB valves 8"7616.0007616.0000.000ZRO-S20919000000305Zero rated domestic sales (0% VAT)0.00OUTPUT VAT PAYABLE | 2230010.0007616.000Arad depot equipment purchased by BP Middle East F0.000FF12/05/2023212590000000002FFT1154660000114DBB Valves - tank 7 to 12 Tank inlet body valves - MOV DBB valves 10"6720.0006720.0000.000ZRO-S20919000000305Zero rated domestic sales (0% VAT)0.00OUTPUT VAT PAYABLE | 2230010.0006720.000Arad depot equipment purchased by BP Middle East F0.000FF12/05/2023212590000000003FFT1154660000115Tank 6 to 12 fast flush tanks - 200 liters fast flush tanks 2150.0002150.0000.000ZRO-S20919000000305Zero rated domestic sales (0% VAT)0.00OUTPUT VAT PAYABLE | 2230010.0002150.000Arad depot equipment purchased by BP Middle East F0.000FF12/05/2023212590000000004FFT1154660000116Hydrant FWS 6" Inlet & Outlet - 1200 GPM3808.0003808.0000.000ZRO-S20919000000305Zero rated domestic sales (0% VAT)0.00OUTPUT VAT PAYABLE | 2230010.0003808.000Arad depot equipment purchased by BP Middle East F0.000FF12/05/2023212590000000005FFT1154660000117Transfer FWS 6" - 12 GPM 1792.0001792.0000.000ZRO-S20919000000305Zero rated domestic sales (0% VAT)0.00OUTPUT VAT PAYABLE | 2230010.0001792.000Arad depot equipment purchased by BP Middle East F0.000FF12/05/2023212590000000006FFT1154660000118Hydrant Pump along with structural base support6600.0006600.0000.000ZRO-S20919000000305Zero rated domestic sales (0% VAT)0.00OUTPUT VAT PAYABLE | 2230010.0006600.000Arad depot equipment purchased by BP Middle East F0.000FF12/05/2023212590000000007FFT1154660000119Foam skid with tank5420.0005420.0000.000ZRO-S20919000000305Zero rated domestic sales (0% VAT)0.00OUTPUT VAT PAYABLE | 2230010.0005420.000Arad depot equipment purchased by BP Middle East F0.000FF12/05/2023212590000000008FFT1154660000120Shipping & Handling Charges 2874.7082874.7080.000ZRO-S20919000000305Zero rated domestic sales (0% VAT)0.00OUTPUT VAT PAYABLE | 2230010.0002874.708Arad depot equipment purchased by BP Middle East F0.000FF12/05/2023212590000000009FFT11546600001124436980.7080.00036980.7080.00036980.7080.00036980.708FOREIGN EXCHANGE DIFFEENCE | 440001F0.0000.000TFdbOracledbxagileclouddbbafcotestingbahrainerpdd/mm/yyyy hh24:mi:ssadminlocalBlackENGLISHtruetfalseagbizdev_automationtrue111/10/2023BD$00FFFFA4BAFCO-ESS01/01/202031/12/202311/10/202311/10/2023011/10/2023C-CenterDept{T}10/10/2023\\10.0.0.3\AgileBizDocs\Attachments\BAFCO\AxImportDbDir\\10.0.0.3\AgileBizDocs\Attachments\Bafco\AttachFile\T1029880000001FadminTHE BAHRAIN AVIATION FUELLING COMPANY B.S.C (CLOSED)MUHARRAQSTORESBDWelcome to AgileBizC-CENTERDEPTT\\10.0.0.3\AgileBizDocs\Attachments\Bafco\AttachFile\ENadmindefault,todolistToDoList,defaultFtnqvdqoffaj1sxxfw5emp4ubToDoList,default~100bafcotesting2default,todolistbafcotestingaxdefbafcotesting~~9867~9867~0~0~0~R~true~RcccccccccccccccccccccccnccccccccddccccccccccccccccccccccccccccC:\Program Files (x86)\AgileLabs\AgileERPUAT_11\AxpertWebScripts127.0.0.1:6380~00080148015301540162015201710154014632163450607080013
Received SXML rcinvRecoverable InvoicesaveflagtFalseTrueTrueFalseFalseNoneDefaultFalsedc1dc11rcinvhdrFalseTrueTrueTrueTrueFalseuseriduseridCharacter100calculate00TrueTrueFalseFalseFalseusernameTrueTrueFalseFalseTrueTruesadminpurTrueuserid~adminpururoleuroleCharacter3000calculate00TrueTrueFalseFalseFalseuserrolesTrueTrueFalseFalseTrueTrueTrueuroleappdescappdescCharacter100Acceptselect app_desc from rcinvhdr where rcinvhdrid = :recordid00TrueFalseFalseTrueTrueFalseFalseFalseTrueTrueFalseFalseTrueTrueTrueappdescenteredbyEntered ByCharacter500Acceptselect :username from dual where :recordid = 0 union select createdby from rcinvhdr where :recordid = rcinvhdrid00TrueFalseFalseFalseTrueTrueFalseFalseTrueTrueFalseFalseTrueFalseFalseenteredbyenteredonEntered OnCharacter200Acceptselect sysdate from dual where :recordid = 0 union select createdon from rcinvhdr where :recordid = rcinvhdrid00TrueFalseFalseFalseTrueTrueFalseFalseTrueTrueFalseFalseTrueFalseFalseenteredonadminpuradminpurCharacter10Acceptselect decode(cnt,0,'F','T') as res from (SELECT count(username) cnt from axuserlevelgroups where usergroup in ('admin_pur') and username = :userid )00TrueFalseFalseTrueTrueFalseFalseFalseTrueTrueFalseFalseTrueTrueTrueadminpur,useridbranchBranchCharacter1000Selectselect a0.branchid, a0.branchname from branch a0,axusersbranch a1 where a0.app_desc = 1 and nvl(a0.active,'F') = 'T' and a0.branchid = a1.branch and a1.axusersid = :m_axuserid order by 200TrueFalsebranchnamebranchFalseFalseFalseFalseTruem_branchTrueTrueTrueFalseTrueTruefbranchid,scutoffdate,svoucher_prefix,adocid,ecurrency,scurrency,fcurrencyid,fexchange_rate,edbranchidTruebranch~branchid,cutoffdate,voucher_prefix,voucher_type,voucher_date,docid,currency,currencyid,exchange_rate,dbranchidbranchidbranchidNumeric150Fill00branchBRANCHIDFalseTrueTrueFalseFalseFalseTrueTrueFalseFalseTrueTruescutoffdate,edbranchidTruebranchid,branch~cutoffdate,dbranchidvoucher_typeVoucher TypeCharacter300Selectselect vouchertypeid, vouchertype, vouchercode from vouchertype where vouchertypeid = 120944000000000TrueFalsevouchertypevouchertypeTrueTrueFalseFalseTrueIIF( fieldchanged( {voucher_type},1) = {T}, {Info. can't be changed}, {T})TrueTrueTrueFalseTrueTruesvoucher_prefix,adocidTruevoucher_type~voucher_prefix,branch,voucher_date,docidvoucher_dateInvoice DateDate/Time100Accept00FalseFalseTrueFalseFalseFalseFalseTrueDate()TrueTrueFalseFalseTrue99/99/9999Truesvoucher_prefix,adocid,sfinyear,ecurrency,scurrency,fcurrencyid,fexchange_rate,edvoucher_dateTruevoucher_date~voucher_prefix,branch,voucher_type,docid,finyear,currency,currencyid,exchange_rate,dvoucher_datecurrdatecurrdateDate/Time100calculate00TrueFalseFalseFalseFalsedate()TrueTrueFalseFalseTrueTrueTruecurrdatecutoffdateDate/Time100AcceptSELECT cutoffdate from transactionrange where branch = :branchid00TrueFalseFalseTrueTrueFalseFalseFalseTrueTrueFalseFalseTrueTrueTruecutoffdate,branchid,branchvoucher_prefixvoucher_prefixCharacter200Acceptselect GetPrefix( :branch, :voucher_type, :voucher_date, 'F' ) from dual00TrueTrueFalseTrueTrueTrueFalseFalseTrueTrueFalseFalseTrueFalseadocidFalsevoucher_prefix,branch,voucher_type,voucher_date~dociddocidInvoice Doc IDCharacter300autogenerate00RECINV-voucher_prefix1True6FalseTrueTrueFalseTrueFalseTrueFalseFalseTrueFalseFalsedocid,voucher_prefix,branch,voucher_type,voucher_datevoucher_dummyvoucher_dummyCharacter300Accept00FalseFalseFalseTrueTrueFalseFalseTrueFalseTrueFalseFalseTrueTrueTruevoucher_dummysubledgercodeSelect DebtorCharacter2250Selectselect a0.subledgerid, a0.subledgerdisplay, a0.subledgername, a0.subledgercode, a1.masterid, a0.li, a1.mnamedisplay controlaccount, a2.mnamedisplay contraacc from subledger a0, master a1, customer c, master a2 where a1.category = 5 and a0.app_desc = 1 and a0.controlaccount = a1.masterid and a0.sourceid = c.customerid and c.contraaccount = a2.masterid and (nvl (a0.inactive, 'F') = 'F' or :recordid > 0) {Dynamicfilterword a0.subledgerdisplay, a0.subledgername,a0.subledgercode~Subledger,Subledger Description,Subledger#} order by 226TrueFalsesubledgerdisplaysubledgerFalseFalseFalseFalseTrueTrueTrueTrueFalseTrueTruefsubledgerdesc,fsupplier,fsubledgerid,fmname,fcontrolac,fcontraac,sdupchekTruesubledgercode~subledgerdesc,supplier,subledgerid,mname,controlac,contraac,dupchek,reference_numbersubledgerdescCharacter2000Fill00subledgercodeSUBLEDGERNAMEFalseFalseTrueTrueFalseTrueTrueTrueFalseFalseTrueFalseFalsesubledgerdesc,subledgercodesuppliersupplierCharacter250Fill00subledgercodeSUBLEDGERCODEFalseTrueTrueFalseFalseFalseTrueTrueFalseFalseTrueTrueTruesupplier,subledgercodesubledgeridsubledgeridNumeric150Fill00subledgercodeSUBLEDGERIDFalseTrueTrueFalseFalseTrueTrueTrueFalseFalseTrueTruesdupchekTruesubledgerid,subledgercode~dupchek,reference_numbermnameControl AccountCharacter2250Fill00subledgercodeCONTROLACCOUNTFalseTrueTrueFalseFalseFalseTrueTrueFalseFalseTrueTrueTruemname,subledgercodecontrolaccontrolacNumeric150Fill00subledgercodeMASTERIDFalseTrueTrueFalseFalseFalseTrueTrueFalseFalseTrueTrueTruecontrolac,subledgercodecontraaccontraacCharacter2250Fill00subledgercodeCONTRAACCFalseTrueFalseFalseFalseTrueTrueTrueFalseFalseTrueTrueTruecontraac,subledgercodefinyearFinancial YearCharacter90Acceptselect finyrcode from financial_year where :voucher_date between startdate and enddate and (upper (active) = 'T' or :recordid > 0)00TrueTrueFalseTrueFalseFalseFalseTrueiif( isempty(finyear) = {T}, {Financial Year is not defined}, {T})TrueTrueFalseFalseTrueTrueTruefinyear,voucher_datereference_numberRef NumberCharacter500Accept00FalseFalseFalseFalseTrueFalseFalseTrueTrueTrueFalseFalseTrueTruesdupchekTruereference_number~dupchek,subledgerid,subledgercodedupchekNumeric100Acceptselect count (*) cnt from (select i.suppcode || i.reference_number from invbookhdr i, (select invbookid from invbkcancelhdr where app_desc = 1 and cancel = 'F') b where i.suppcode || i.reference_number = :subledgerid || :reference_number and i.cancel = 'F' and i.app_desc = 1 and i.invbookhdrid <> :recordid and i.invbookhdrid = b.invbookid(+) and b.invbookid is null)00TrueTrueFalseTrueTrueFalseFalseFalseTrueTrueFalseFalseTrueTrueTruedupchek,subledgerid,subledgercode,reference_numberreference_dateRef DateDate/Time100Accept00FalseFalseFalseFalseTrueFalseFalseTrueTrueTrueFalseFalseTrue99/99/9999Trueesupply_dateTruereference_date~supply_datesupply_dateSupply DateDate/Time100Accept00FalseFalseFalseFalseFalseFalseFalseTruereference_dateTrueTrueFalseFalseTrue99/99/9999TrueTruesupply_date,reference_datecountryofsupplycountryofsupplyCharacter1500SelectSelect a1.countryid,a1.country from country a1 where countryid=10035000000001 order by a1.country00TrueFalsecountryTrueTrueFalseFalseFalseTrueTrueTrueFalseTrueTrueebill_country,eship_countryTruecountryofsupply~bill_country,ship_countrybill_countryBill from CountryCharacter1000Selectselect c.countryid, c.country from country c order by c.country00TrueFalsecountrycountryFalseFalseFalseFalseTruecountryofsupplyTrueTrueTrueFalseTrueTrueTruebill_country,countryofsupplyship_countryShip from CountryCharacter1000Selectselect c.countryid, c.country from country c order by c.country00TrueFalsecountrycountryFalseFalseFalseFalseTruecountryofsupplyTrueTrueTrueFalseTrueTrueTrueship_country,countryofsupplycurrencyCurrencyCharacter150Selectselect a1.CURRENCYID, a1.currency, getexrate( :branch, a1.currency , :voucher_date) as exrate from currency a1 order by 200TrueTruecurrencycurrencyFalseTrueTrueFalseTruem_basecurrencyiif( fieldchanged( {currency}, 1) = {T}, {Currency can't be changed}, {T})TrueTrueTrueFalseTrueFalsefcurrencyid,fexchange_rateFalsecurrency,branch,voucher_date~currencyid,exchange_ratecurrencyidcurrencyidNumeric150Fill00currencycurrencyIDFalseTrueTrueFalseFalseFalseTrueTrueFalseFalseTrueTrueTruecurrencyid,currency,branch,voucher_dateduedatePayment Due Dt.Date/Time100Accept00FalseFalseFalseTrueTrueFalseFalseTrueTrueTrueFalseFalseTrue99/99/9999TrueTrueduedateexchange_rateEx. RateNumeric106Fill00currencyEXRATETrueFalseFalseTrueFalseTrueiif( currency = m_basecurrency & exchange_rate # 1, {Exchange Rate should be 1 for Base Currency TXN}, {T})TrueTrueFalseFalseTrueFalseFalseexchange_rate,currency,branch,voucher_datesignatorySignatoryCharacter1000SelectSELECT SIGNATORYNAME, POSITION, SIGN FROM SALBANKAUTHDTL WHERE ( ACTIVE='T' OR :RECORDID > 0 )00TrueFalseTrueTrueFalseFalseTrueTrueTrueFalseFalseTrueTruefsignposition,fsignuserTruesignatory~signposition,signusersignpositionsignpositionCharacter500Fill00signatoryPOSITIONFalseTrueTrueFalseFalseTrueTrueTrueFalseFalseTrueTrueTruesignposition,signatorysignusersignuserCharacter100Fill00signatorySIGNFalseTrueTrueFalseFalseTrueTrueTrueFalseFalseTrueTrueTruesignuser,signatorynotesNotesCharacter10000Accept00FalseFalseFalseFalseTrueFalseFalseTrueTrueTrueFalseFalseTrueTrueenarrationTruenotes~narrationdc2Account Details2rcinvdtlTrueTrueTrueTrueTrueFalsedescriptionExpense DescriptionCharacter2000Accept00FalseFalseFalseFalseFalseFalseFalseTrueTrueTrueFalseFalseTrueTrueTruedescriptioninvdamountAmountNumeric103Accept00FalseFalseFalseFalseFalseFalseFalseTrueTrueFalseFalseFalseTrueTrueendramount,encramount,edvatamt,etotamount,evatflag,erow2flag,erow3flag,etotalinvdamount,etotvatamount,etotalndramount,etotalncramount,etotinvamt,esuppdramount,esuppcramountTrueinvdamount~ndramount,ncramount,dvatamt,dvatper,dvattype,totamount,vatflag,row2flag,rowcnt,row3flag,totalinvdamount,totvatamount,totalndramount,totalncramount,totinvamt,suppdramount,suppcramountndramountDebitsNumeric153calculate00TrueTrueFalseFalseTrueiif(invdamount>0,invdamount,0)TrueTrueFalseFalseTrueTrueedvatamt,etotamount,evatflag,erow2flag,erow3flag,etotvatamount,etotalndramount,etotinvamtTruendramount,invdamount~dvatamt,dvatper,dvattype,totamount,vatflag,row2flag,rowcnt,row3flag,totvatamount,totalndramount,totinvamtncramountCreditsNumeric153calculate00TrueTrueFalseFalseTrueiif(invdamount<0,0-invdamount,0)TrueTrueFalseFalseTrueTrueetotalncramountTruencramount,invdamount~totalncramountdvattypeVAT TypeCharacter100Selectselect v.vatmasterid, v.vatcode, v.vatname, v.vatper, v.vatdesc, m.mnamedisplay , v.vattype from vatmaster v, master m where vattype = 'Output' and vatmasterid > 1 and v.vatglaccount = m.masterid order by vatcode24TrueFalsevatcodevatmasterFalseFalseFalseFalseTrueTrueTrueTrueFalseTrueTruefdvattypeid,fdvatname,fdvatper,fdvataccount,edvatamt,etotamount,evatflag,erow2flag,erow3flag,etotvatamount,etotinvamtTruedvattype~dvattypeid,dvatname,dvatper,dvataccount,dvatamt,ndramount,invdamount,totamount,vatflag,row2flag,rowcnt,row3flag,totvatamount,totinvamtdvattypeiddvattypeidNumeric150Fill00dvattypeVATMASTERIDFalseTrueTrueFalseFalseTrueTrueTrueFalseFalseTrueTrueTruedvattypeid,dvattypedvatnameVAT NameCharacter3000Fill00dvattypeVATNAMEFalseFalseTrueTrueFalseFalseTrueTrueFalseFalseTrueFalseFalsedvatname,dvattypedvatperVAT %Numeric52Fill00dvattypeVATPERFalseFalseTrueTrueFalseTrueTrueTrueFalseFalseTrueFalseedvatamt,etotamount,evatflag,erow2flag,erow3flag,etotvatamount,etotinvamtFalsedvatper,dvattype~dvatamt,ndramount,invdamount,totamount,vatflag,row2flag,rowcnt,row3flag,totvatamount,totinvamtdvataccountdvataccountCharacter2250Fill00dvattypeMNAMEDISPLAYFalseTrueTrueFalseFalseFalseTrueTrueFalseFalseTrueTrueTruedvataccount,dvattypedvatamtVAT AmountNumeric103calculate00FalseTrueTrueFalseTrueround(ndramount * dvatper / 100,3)TrueTrueFalseFalseTrueFalseetotamount,evatflag,erow2flag,erow3flag,etotvatamount,etotinvamtFalsedvatamt,ndramount,invdamount,dvatper,dvattype~totamount,vatflag,row2flag,rowcnt,row3flag,totvatamount,totinvamttotamountTotalNumeric103calculate00FalseTrueTrueFalseTrueinvdamount + dvatamtTrueTrueFalseFalseTrueFalseetotinvamtFalsetotamount,invdamount,dvatamt,ndramount,dvatper,dvattype~totinvamtnarrationNarrationCharacter2000Accept00FalseFalseFalseFalseTrueFalseFalseTruenotesTrueTrueFalseFalseTrueTrueTruenarration,notesvatflagvatflagCharacter10calculate00TrueTrueFalseFalseFalseiif(dvatamt=0,{F},{T})TrueTrueFalseFalseTrueTrueTruevatflag,dvatamt,ndramount,invdamount,dvatper,dvattypearapamountarapamountNumeric153calculate00TrueTrueTrueFalseTrueTrueFalseFalseFalseTrueFalseearapflagFalsearapamount~arapflagarapflagarapflagCharacter10calculate00TrueTrueFalseFalseTrueIIF( arapamount # 0 , {T}, {F})TrueTrueFalseFalseTrueTrueTruearapflag,arapamountbankflagbankflagCharacter10calculate00TrueTrueFalseFalseTrueIIF( category = 3, {T}, {F})TrueTrueFalseFalseTrueTrueTruebankflagdvoucher_datedvoucher_dateDate/Time100calculate00TrueFalseFalseFalseTruevoucher_dateTrueTrueFalseFalseTrueTrueTruedvoucher_date,voucher_datedbranchiddbranchidNumeric150calculate00TrueFalseFalseFalseTruebranchidTrueTrueFalseFalseTrueTrueTruedbranchid,branchid,branchrowcntrowcntNumeric100calculate00TrueTrueFalseFalseFalseactiverow+1TrueTrueFalseFalseTrueTrueerow2flag,erow3flag,erowcnttotTruerowcnt~row2flag,dvatamt,ndramount,invdamount,dvatper,dvattype,row3flag,rowcnttotrow2flagrow2flagCharacter10calculate00TrueTrueFalseFalseFalseiif(rowcnt=2 & dvatamt > 0,{T},{F})TrueTrueFalseFalseTrueTrueTruerow2flag,rowcnt,dvatamt,ndramount,invdamount,dvatper,dvattyperow3flagrow3flagCharacter10calculate00TrueTrueFalseFalseFalseiif(rowcnt=3 & dvatamt > 0,{T},{F})TrueTrueFalseFalseTrueTrueTruerow3flag,rowcnt,dvatamt,ndramount,invdamount,dvatper,dvattypevalidrow2validrow2Character10calculate00TrueTrueFalseFalseFalseiif( isempty(accountname)={F}, {T},{F})TrueTrueFalseFalseTrueTrueTruevalidrow2dc3Attachments3rcinvgridattachTrueTrueTrueTrueTrueFalseausernameausernameCharacter1000Accept00FalseFalseFalseTrueTrueFalseFalseFalseusernameTrueTrueFalseFalseTrueTruesAxpFilePath_MyImageTrueausername~AxpFilePath_MyImage,doctypedoctypeDocument TypeCharacter500SelectSELECT DOCTYPESID, DOCTYPE FROM DOCTYPES WHERE APPLICABLETO LIKE '%FINANCE%' ORDER BY DOCTYPE00TrueFalsedoctypedoctypesFalseFalseFalseFalseTrueTrueTrueTrueFalseTrueTruesAxpFilePath_MyImageTruedoctype~AxpFilePath_MyImage,ausernameAxpFilePath_MyImageAxpFilePath_MyImageCharacter10000Acceptselect :axpimageserver || :ausername ||'\Receivables\'|| :doctype ||'\' as filepath from dual00TrueFalseFalseTrueTrueFalseFalseTrueTrueTrueFalseFalseTrueTrueTrueAxpFilePath_MyImage,ausername,doctypeAxpFile_MyImageAttachmentsCharacter10000Accept00FalseFalseFalseFalseTrueFalseFalseTrueTrueTrueFalseFalseTrueTrueTrueAxpFile_MyImagedc4Summary4rcinvhdrFalseTrueTrueTrueTrueFalserowcnttotrowcnttotNumeric100calculate00TrueTrueFalseFalseFalsetotal({rowcnt})TrueTrueFalseFalseTrueTrueTruerowcnttot,rowcnttotalinvdamountTotal Exps AmountNumeric103calculate00FalseTrueFalseFalseTruetotal({invdamount})TrueTrueFalseFalseTrueTrueesuppdramount,esuppcramountTruetotalinvdamount,invdamount~suppdramount,suppcramounttotvatamountTotal VAT AmountNumeric103calculate00FalseTrueFalseFalseTruetotal({dvatamt})TrueTrueFalseFalseTrueTrueTruetotvatamount,dvatamt,ndramount,invdamount,dvatper,dvattypetotalndramountTotal Debit AmountNumeric153calculate00TrueTrueTrueFalseTruetotal({ndramount})TrueTrueFalseFalseTrueTrueTruetotalndramount,ndramount,invdamounttotalncramountTotal Credit AmountNumeric153calculate00TrueTrueTrueFalseTruetotal({ncramount})TrueTrueFalseFalseTrueTrueTruetotalncramount,ncramount,invdamounttotinvamtTotal Invoice AmountNumeric103calculate00FalseTrueFalseFalseTruetotal({totamount})TrueTrueFalseFalseTrueTrueTruetotinvamt,totamount,invdamount,dvatamt,ndramount,dvatper,dvattypesuppdramountsuppdramountNumeric103calculate00TrueTrueFalseFalseFalseiif(totalinvdamount>0,0,0-totalinvdamount)TrueTrueFalseFalseTrueTrueTruesuppdramount,totalinvdamount,invdamountsuppcramountsuppcramountNumeric103calculate00TrueTrueFalseFalseFalseiif(totalinvdamount>0,totalinvdamount,0)+vatamount-vatrcamountTrueTrueFalseFalseTrueTrueTruesuppcramount,totalinvdamount,invdamountroundoffaccountroundoffaccountCharacter2250Acceptselect a.mnamedisplay from master a,financesetup b where a.masterid = b.roundupaccount00TrueFalseFalseTrueTrueFalseFalseFalseTrueTrueFalseFalseTrueTrueTrueroundoffaccountdiffflagdiffflagCharacter10calculate00TrueTrueFalseFalseTrueIIF( (totaldramount - totalcramount) # 0, {T}, {F})TrueTrueFalseFalseTrueTrueTruediffflagdiffdramountdiffdramountNumeric153calculate00TrueTrueFalseFalseTrueiif( (totaldramount - totalcramount) > 0, 0, abs(totaldramount - totalcramount))TrueTrueFalseFalseTrueTrueTruediffdramountdiffcramountdiffcramountNumeric153calculate00TrueTrueFalseFalseTrueiif( (totaldramount - totalcramount) > 0, (totaldramount - totalcramount), 0)TrueTrueFalseFalseTrueTrueTruediffcramountsaveflagsaveflagCharacter10calculate00TrueTrueFalseFalseFalse{T}TrueTrueFalseFalseTrueTrueTruesaveflagrejflagrejflagCharacter10calculate00TrueTrueFalseFalseFalseiif(app_desc1=5,{T},{F})TrueTrueFalseFalseTrueTrueTruerejflagrcinv1Account Postingacdetdc1True--notescontraac--CRPMGMT0totalinvdamountnotesdvataccount------dvatamt0narrationnotesvoucher_datebranchvoucher_typedocidcurrencyreference_numberreference_datemnamesubledgercodetotinvamt0--TrueFalsercinv2Posting to VAT Corevatcrdc2Truevoucher_typeRecoverable Invoicedocidvoucher_datesuppliersupply_datevoucher_datedocidship_countrybill_countrydvattypedvatper--0invdamountdvatamt0totamountcurrencyexchange_rateinvdamountdvatamt0totamountnotesTrueFalsefact_checkmaterial-iconsdc1dc2dc3dc4acdet
Transaction Journal
PopupTrueFalsejounlcustinvoice.pdffastreportTruetFalseSetCaption({dim1},{ :m_dim1})SetCaption({dim2},{ :m_dim2})SetCaption({dim3},{ :m_dim3} )SetCaption({dim4},{ :m_dim4} )ccinvcustinvoice.pdffastreportTruetFalseMark As CancelledFalseTrue
Creating Action object
Creating DbCall
Creating DbCall
select * from rcinvhdr where rcinvhdrid=0
Time elapsed = 31
Evaluating username
Result =
Evaluating userroles
Result =
Evaluating m_branch
Result =
Evaluating IIF( fieldchanged( {voucher_type},1) = {T}, {Info. can't be changed}, {T})
Result =
Evaluating Date()
Result =
Evaluating date()
Result =
Evaluating iif( isempty(finyear) = {T}, {Financial Year is not defined}, {T})
Result =
Evaluating reference_date
Result =
Evaluating countryofsupply
Result =
Evaluating countryofsupply
Result =
Evaluating m_basecurrency
Result =
Evaluating iif( fieldchanged( {currency}, 1) = {T}, {Currency can't be changed}, {T})
Result =
Evaluating iif( currency = m_basecurrency & exchange_rate # 1, {Exchange Rate should be 1 for Base Currency TXN}, {T})
Result =
Evaluating iif(invdamount>0,invdamount,0)
Result =
Evaluating iif(invdamount<0,0-invdamount,0)
Result =
Evaluating round(ndramount * dvatper / 100,3)
Result =
Evaluating invdamount + dvatamt
Result =
Evaluating notes
Result =
Evaluating iif(dvatamt=0,{F},{T})
Result =
Evaluating IIF( arapamount # 0 , {T}, {F})
Result =
Evaluating IIF( category = 3, {T}, {F})
Result =
Evaluating voucher_date
Result =
Evaluating branchid
Result =
Evaluating activerow+1
Result =
Evaluating iif(rowcnt=2 & dvatamt > 0,{T},{F})
Result =
Evaluating iif(rowcnt=3 & dvatamt > 0,{T},{F})
Result =
Evaluating iif( isempty(accountname)={F}, {T},{F})
Result =
Evaluating username
Result =
Evaluating total({rowcnt})
Result =
Evaluating total({invdamount})
Result =
Evaluating total({dvatamt})
Result =
Evaluating total({ndramount})
Result =
Evaluating total({ncramount})
Result =
Evaluating total({totamount})
Result =
Evaluating iif(totalinvdamount>0,0,0-totalinvdamount)
Result =
Evaluating iif(totalinvdamount>0,totalinvdamount,0)+vatamount-vatrcamount
Result =
Evaluating IIF( (totaldramount - totalcramount) # 0, {T}, {F})
Result =
Evaluating iif( (totaldramount - totalcramount) > 0, 0, abs(totaldramount - totalcramount))
Result =
Evaluating iif( (totaldramount - totalcramount) > 0, (totaldramount - totalcramount), 0)
Result =
Evaluating {T}
Result =
Evaluating iif(app_desc1=5,{T},{F})
Result =
select * from AxAttachWorkflow where lower(transid) = 'rcinv'
Time elapsed = 31
Submiting & Registering data
Registering Global variables data
Registering Global variables data over
Setting values over
Calling action in docoreaction
Finding and executing action node :Cancel
Starting Action Execution - Cancel
Executing task - cancel transaction
Executing CANCEL from action
Recordid=1154660000112
Transid:rcinv
recordid:1154660000112
primarytable:rcinvhdr
>>Loading transaction rcinv record 1154660000112
Select a.rcinvhdrid, a.SourceId , a.mapname , a.cancel, a.cancelremarks , a.CreatedOn, a.CreatedBy , a.ModifiedOn , a.UserName , a.branch, a.voucher_type, a.voucher_date, a.docid, a.voucher_dummy, a.subledgercode, a.subledgerdesc, a.subledgerid, a.contraac, a.finyear, a.reference_number, a.reference_date, a.supply_date, a.bill_country, a.ship_country, a.currency, a.duedate, a.exchange_rate, a.signatory, a.signposition, a.signuser, a.notes from RCINVHDR a where a.rcinvhdrid = 1154660000112
Time elapsed = 31
Loading from 1154660000112 into frame 1, row 1
Select BRANCHNAME from BRANCH Where BRANCHid = 21259000000000
Time elapsed = 15
branch = MUHARRAQ
IdValue = 21259000000000
Select VOUCHERTYPE from VOUCHERTYPE Where VOUCHERTYPEid = 1209440000000
Time elapsed = 31
voucher_type = CI
IdValue = 1209440000000
voucher_date = 12/05/2023
docid = BAF/2023/CI/000005
voucher_dummy =
Select SUBLEDGERDISPLAY from SUBLEDGER Where SUBLEDGERid = 1154440000070
Time elapsed = 31
subledgercode = BP MIDDLE EAST LLC | CCC-008
IdValue = 1154440000070
subledgerdesc = BP MIDDLE EAST LLC
subledgerid = 1154440000070
contraac = RECOVERABLE TEMP ACCOUNT | 222007
finyear = 2023
reference_number = Arad Equipment
reference_date = 12/05/2023
supply_date = 12/05/2023
Select COUNTRY from COUNTRY Where COUNTRYid = 10035000000001
Time elapsed = 31
bill_country = Bahrain
IdValue = 10035000000001
Select COUNTRY from COUNTRY Where COUNTRYid = 10035000000001
Time elapsed = 31
ship_country = Bahrain
IdValue = 10035000000001
Select CURRENCY from CURRENCY Where CURRENCYid = 10035000000007
Time elapsed = 31
currency = BD
IdValue = 10035000000007
duedate =
exchange_rate = 1
signatory =
signposition =
signuser =
notes = Arad depot equipment purchased by BP Middle East
Select a.rcinvdtlid, a.description, a.invdamount, a.ndramount, a.ncramount, a.dvattype, a.dvattypeid, a.dvatper, a.dvatamt, a.totamount, a.narration, a.arapamount, a.arapflag, a.bankflag, a.dvoucher_date, a.dbranchid,a.rcinvdtlrow from RCINVDTL a where a.rcinvhdrid = 1154660000112 Order by rcinvdtlrow
Time elapsed = 32
Loading from 1154660000113 into frame 2, row 1
description = DBB Valves - tank 5 to 12 Tank inlet body valves - MOV DBB valves 8"
invdamount = 7616
ndramount = 7616
ncramount = 0
Select VATCODE from VATMASTER Where VATMASTERid = 20919000000305
Time elapsed = 31
dvattype = ZRO-S
IdValue = 20919000000305
dvattypeid = 20919000000305
dvatper = 0
dvatamt = 0
totamount = 7616
narration = Arad depot equipment purchased by BP Middle East
arapamount = 0
arapflag = F
bankflag = F
dvoucher_date = 12/05/2023
dbranchid = 21259000000000
Loading from 1154660000114 into frame 2, row 2
description = DBB Valves - tank 7 to 12 Tank inlet body valves - MOV DBB valves 10"
invdamount = 6720
ndramount = 6720
ncramount = 0
Select VATCODE from VATMASTER Where VATMASTERid = 20919000000305
Time elapsed = 15
dvattype = ZRO-S
IdValue = 20919000000305
dvattypeid = 20919000000305
dvatper = 0
dvatamt = 0
totamount = 6720
narration = Arad depot equipment purchased by BP Middle East
arapamount = 0
arapflag = F
bankflag = F
dvoucher_date = 12/05/2023
dbranchid = 21259000000000
Loading from 1154660000115 into frame 2, row 3
description = Tank 6 to 12 fast flush tanks - 200 liters fast flush tanks
invdamount = 2150
ndramount = 2150
ncramount = 0
Select VATCODE from VATMASTER Where VATMASTERid = 20919000000305
Time elapsed = 16
dvattype = ZRO-S
IdValue = 20919000000305
dvattypeid = 20919000000305
dvatper = 0
dvatamt = 0
totamount = 2150
narration = Arad depot equipment purchased by BP Middle East
arapamount = 0
arapflag = F
bankflag = F
dvoucher_date = 12/05/2023
dbranchid = 21259000000000
Loading from 1154660000116 into frame 2, row 4
description = Hydrant FWS 6" Inlet & Outlet - 1200 GPM
invdamount = 3808
ndramount = 3808
ncramount = 0
Select VATCODE from VATMASTER Where VATMASTERid = 20919000000305
Time elapsed = 16
dvattype = ZRO-S
IdValue = 20919000000305
dvattypeid = 20919000000305
dvatper = 0
dvatamt = 0
totamount = 3808
narration = Arad depot equipment purchased by BP Middle East
arapamount = 0
arapflag = F
bankflag = F
dvoucher_date = 12/05/2023
dbranchid = 21259000000000
Loading from 1154660000117 into frame 2, row 5
description = Transfer FWS 6" - 12 GPM
invdamount = 1792
ndramount = 1792
ncramount = 0
Select VATCODE from VATMASTER Where VATMASTERid = 20919000000305
Time elapsed = 16
dvattype = ZRO-S
IdValue = 20919000000305
dvattypeid = 20919000000305
dvatper = 0
dvatamt = 0
totamount = 1792
narration = Arad depot equipment purchased by BP Middle East
arapamount = 0
arapflag = F
bankflag = F
dvoucher_date = 12/05/2023
dbranchid = 21259000000000
Loading from 1154660000118 into frame 2, row 6
description = Hydrant Pump along with structural base support
invdamount = 6600
ndramount = 6600
ncramount = 0
Select VATCODE from VATMASTER Where VATMASTERid = 20919000000305
Time elapsed = 32
dvattype = ZRO-S
IdValue = 20919000000305
dvattypeid = 20919000000305
dvatper = 0
dvatamt = 0
totamount = 6600
narration = Arad depot equipment purchased by BP Middle East
arapamount = 0
arapflag = F
bankflag = F
dvoucher_date = 12/05/2023
dbranchid = 21259000000000
Loading from 1154660000119 into frame 2, row 7
description = Foam skid with tank
invdamount = 5420
ndramount = 5420
ncramount = 0
Select VATCODE from VATMASTER Where VATMASTERid = 20919000000305
Time elapsed = 31
dvattype = ZRO-S
IdValue = 20919000000305
dvattypeid = 20919000000305
dvatper = 0
dvatamt = 0
totamount = 5420
narration = Arad depot equipment purchased by BP Middle East
arapamount = 0
arapflag = F
bankflag = F
dvoucher_date = 12/05/2023
dbranchid = 21259000000000
Loading from 1154660000120 into frame 2, row 8
description = Shipping & Handling Charges
invdamount = 2874.708
ndramount = 2874.708
ncramount = 0
Select VATCODE from VATMASTER Where VATMASTERid = 20919000000305
Time elapsed = 16
dvattype = ZRO-S
IdValue = 20919000000305
dvattypeid = 20919000000305
dvatper = 0
dvatamt = 0
totamount = 2874.708
narration = Arad depot equipment purchased by BP Middle East
arapamount = 0
arapflag = F
bankflag = F
dvoucher_date = 12/05/2023
dbranchid = 21259000000000
Select a.rcinvgridattachid, a.doctype, a.AxpFilePath_MyImage, a.AxpFile_MyImage,a.rcinvgridattachrow from RCINVGRIDATTACH a where a.rcinvhdrid = 1154660000112 Order by rcinvgridattachrow
Time elapsed = 16
Select a.rcinvhdrid, a.SourceId , a.mapname , a.cancel, a.cancelremarks , a.CreatedOn, a.CreatedBy , a.ModifiedOn , a.UserName , a.totalinvdamount, a.totvatamount, a.totalndramount, a.totalncramount, a.totinvamt, a.diffflag, a.diffdramount, a.diffcramount from RCINVHDR a where a.rcinvhdrid = 1154660000112
Time elapsed = 15
Loading from 1154660000112 into frame 4, row 1
totalinvdamount = 36980.708
totvatamount = 0
totalndramount = 36980.708
totalncramount = 0
totinvamt = 36980.708
diffflag = F
diffdramount = 0
diffcramount = 0
Loading no-save fields
Execute action from dbcall
>>Validating rcinv
>>Frame No 1
Refreshing nonsave fields during loading
Preparing userid-calculate
username = admin
Field Value - admin
Preparing urole-calculate
userroles = default,todolist
Field Value - default,todolist
Preparing appdesc-accept
recordid=1154660000112
select app_desc from rcinvhdr where rcinvhdrid = :recordid
recordid=1154660000112
Time elapsed = 46
Field Value - 1
Preparing enteredby-accept
username=admin
recordid=1154660000112
select :username from dual where :recordid = 0 union select createdby from rcinvhdr where :recordid = rcinvhdrid
username=admin
recordid=1154660000112
recordid=1154660000112
Time elapsed = 109
Field Value - L0221
Preparing enteredon-accept
recordid=1154660000112
select sysdate from dual where :recordid = 0 union select createdon from rcinvhdr where :recordid = rcinvhdrid
recordid=1154660000112
recordid=1154660000112
Time elapsed = 78
Field Value - 12/05/2023 03:05:24 PM
Preparing adminpur-accept
userid=admin
select decode(cnt,0,'F','T') as res from (SELECT count(username) cnt from axuserlevelgroups where usergroup in ('admin_pur') and username = :userid )
userid=admin
Time elapsed = 47
Field Value - F
Preparing branchid-fill
Finding linkfield
Linkfield found and assigning Query from link field
Query assigned
m_axuserid=1
select a0.branchid, a0.branchname from branch a0,axusersbranch a1 where a0.app_desc = 1 and nvl(a0.active,'F') = 'T' and a0.branchid = a1.branch and a1.axusersid = :m_axuserid order by 2
m_axuserid=1
Time elapsed = 63
Field Value - 21259000000000
Preparing currdate-calculate
Result of date = 11/10/2023
Field Value - 11/10/2023
Preparing cutoffdate-accept
branchid=21259000000000
SELECT cutoffdate from transactionrange where branch = :branchid
branchid=21259000000000
Time elapsed = 46
Field Value - 31/05/2023
Preparing voucher_prefix-accept
branch=MUHARRAQ
voucher_type=CI
voucher_date=12/05/2023 00:00:00
select GetPrefix( :branch, :voucher_type, to_date(:voucher_date,'dd/mm/yyyy hh24:mi:ss'), 'F' ) from dual
branch=MUHARRAQ
voucher_type=CI
voucher_date=12/05/2023 00:00:00
Time elapsed = 110
Field Value - :BAF/2023/CI/
Preparing supplier-fill
Finding linkfield
Linkfield found and assigning Query from link field
Query component recreating and opening again
Query component recreating again
recordid=1154660000112
axp_dynamicfilter=BP MIDDLE EAST LLC | CCC-008
select a0.subledgerid, a0.subledgerdisplay, a0.subledgername, a0.subledgercode, a1.masterid, a0.li, a1.mnamedisplay controlaccount, a2.mnamedisplay contraacc from subledger a0, master a1, customer c, master a2 where a1.category = 5 and a0.app_desc = 1 and a0.controlaccount = a1.masterid and a0.sourceid = c.customerid and c.contraaccount = a2.masterid and (nvl (a0.inactive, 'F') = 'F' or :recordid > 0) and lower(a0.subledgerdisplay)=lower( :axp_dynamicfilter ) order by 2
recordid=1154660000112
axp_dynamicfilter=BP MIDDLE EAST LLC | CCC-008
Time elapsed = 78
Query opened
Query component recreating and opening completed
Field Value - CCC-008
Preparing mname-fill
Finding linkfield
Linkfield found and assigning Query from link field
Field Value - RECOVERABLE CONTROL ACCOUNT | 123302
Preparing controlac-fill
Finding linkfield
Linkfield found and assigning Query from link field
Field Value - 24646000000032
Preparing dupchek-accept
subledgerid=1154440000070
reference_number=Arad Equipment
recordid=1154660000112
select count (*) cnt from (select i.suppcode || i.reference_number from invbookhdr i, (select invbookid from invbkcancelhdr where app_desc = 1 and cancel = 'F') b where i.suppcode || i.reference_number = :subledgerid || :reference_number and i.cancel = 'F' and i.app_desc = 1 and i.invbookhdrid <> :recordid and i.invbookhdrid = b.invbookid(+) and b.invbookid is null)
subledgerid=1154440000070
reference_number=Arad Equipment
recordid=1154660000112
Time elapsed = 94
Field Value - 0
Preparing countryofsupply-select
Field Value -
Preparing currencyid-fill
Finding linkfield
Linkfield found and assigning Query from link field
Query assigned
branch=MUHARRAQ
voucher_date=12/05/2023 00:00:00
select a1.CURRENCYID, a1.currency, getexrate( :branch, a1.currency , to_date(:voucher_date,'dd/mm/yyyy hh24:mi:ss')) as exrate from currency a1 order by 2
branch=MUHARRAQ
voucher_date=12/05/2023 00:00:00
Time elapsed = 94
Field Value - 10035000000007
invdamount = 7616
invdamount = 7616
Result of iif = 7616
invdamount = 7616
invdamount = 7616
Result of iif = 0
Preparing dvatname-fill
Finding linkfield
Linkfield found and assigning Query from link field
Query assigned
select v.vatmasterid, v.vatcode, v.vatname, v.vatper, v.vatdesc, m.mnamedisplay , v.vattype from vatmaster v, master m where vattype = 'Output' and vatmasterid > 1 and v.vatglaccount = m.masterid order by vatcode
Time elapsed = 32
Field Value - Zero rated domestic sales (0% VAT)
Preparing dvataccount-fill
Finding linkfield
Linkfield found and assigning Query from link field
Query assigned
Field Value - OUTPUT VAT PAYABLE | 223001
ndramount = 7616.000
dvatper = 0
Result of round = 0
invdamount = 7616
dvatamt = 0.000
Preparing vatflag-calculate
dvatamt = 0.000
Result of iif = F
Field Value - F
arapamount = 0
Result of iif = F
Result of iif = F
voucher_date = 12/05/2023
branchid = 21259000000000
Preparing rowcnt-calculate
activerow = 1
Field Value - 2
Preparing row2flag-calculate
rowcnt = 2
dvatamt = 0.000
Result of iif = F
Field Value - F
Preparing row3flag-calculate
rowcnt = 2
dvatamt = 0.000
Result of iif = F
Field Value - F
Preparing validrow2-calculate
Result of isempty = F
Result of iif = T
Field Value - T
invdamount = 6720
invdamount = 6720
Result of iif = 6720
invdamount = 6720
invdamount = 6720
Result of iif = 0
Preparing dvatname-fill
Finding linkfield
Linkfield found and assigning Query from link field
Query assigned
Field Value - Zero rated domestic sales (0% VAT)
Preparing dvataccount-fill
Finding linkfield
Linkfield found and assigning Query from link field
Query assigned
Field Value - OUTPUT VAT PAYABLE | 223001
ndramount = 6720.000
dvatper = 0
Result of round = 0
invdamount = 6720
dvatamt = 0.000
Preparing vatflag-calculate
dvatamt = 0.000
Result of iif = F
Field Value - F
arapamount = 0
Result of iif = F
Result of iif = F
voucher_date = 12/05/2023
branchid = 21259000000000
Preparing rowcnt-calculate
activerow = 2
Field Value - 3
Preparing row2flag-calculate
rowcnt = 3
dvatamt = 0.000
Result of iif = F
Field Value - F
Preparing row3flag-calculate
rowcnt = 3
dvatamt = 0.000
Result of iif = F
Field Value - F
Preparing validrow2-calculate
Result of isempty = F
Result of iif = T
Field Value - T
invdamount = 2150
invdamount = 2150
Result of iif = 2150
invdamount = 2150
invdamount = 2150
Result of iif = 0
Preparing dvatname-fill
Finding linkfield
Linkfield found and assigning Query from link field
Query assigned
Field Value - Zero rated domestic sales (0% VAT)
Preparing dvataccount-fill
Finding linkfield
Linkfield found and assigning Query from link field
Query assigned
Field Value - OUTPUT VAT PAYABLE | 223001
ndramount = 2150.000
dvatper = 0
Result of round = 0
invdamount = 2150
dvatamt = 0.000
Preparing vatflag-calculate
dvatamt = 0.000
Result of iif = F
Field Value - F
arapamount = 0
Result of iif = F
Result of iif = F
voucher_date = 12/05/2023
branchid = 21259000000000
Preparing rowcnt-calculate
activerow = 3
Field Value - 4
Preparing row2flag-calculate
rowcnt = 4
dvatamt = 0.000
Result of iif = F
Field Value - F
Preparing row3flag-calculate
rowcnt = 4
dvatamt = 0.000
Result of iif = F
Field Value - F
Preparing validrow2-calculate
Result of isempty = F
Result of iif = T
Field Value - T
invdamount = 3808
invdamount = 3808
Result of iif = 3808
invdamount = 3808
invdamount = 3808
Result of iif = 0
Preparing dvatname-fill
Finding linkfield
Linkfield found and assigning Query from link field
Query assigned
Field Value - Zero rated domestic sales (0% VAT)
Preparing dvataccount-fill
Finding linkfield
Linkfield found and assigning Query from link field
Query assigned
Field Value - OUTPUT VAT PAYABLE | 223001
ndramount = 3808.000
dvatper = 0
Result of round = 0
invdamount = 3808
dvatamt = 0.000
Preparing vatflag-calculate
dvatamt = 0.000
Result of iif = F
Field Value - F
arapamount = 0
Result of iif = F
Result of iif = F
voucher_date = 12/05/2023
branchid = 21259000000000
Preparing rowcnt-calculate
activerow = 4
Field Value - 5
Preparing row2flag-calculate
rowcnt = 5
dvatamt = 0.000
Result of iif = F
Field Value - F
Preparing row3flag-calculate
rowcnt = 5
dvatamt = 0.000
Result of iif = F
Field Value - F
Preparing validrow2-calculate
Result of isempty = F
Result of iif = T
Field Value - T
invdamount = 1792
invdamount = 1792
Result of iif = 1792
invdamount = 1792
invdamount = 1792
Result of iif = 0
Preparing dvatname-fill
Finding linkfield
Linkfield found and assigning Query from link field
Query assigned
Field Value - Zero rated domestic sales (0% VAT)
Preparing dvataccount-fill
Finding linkfield
Linkfield found and assigning Query from link field
Query assigned
Field Value - OUTPUT VAT PAYABLE | 223001
ndramount = 1792.000
dvatper = 0
Result of round = 0
invdamount = 1792
dvatamt = 0.000
Preparing vatflag-calculate
dvatamt = 0.000
Result of iif = F
Field Value - F
arapamount = 0
Result of iif = F
Result of iif = F
voucher_date = 12/05/2023
branchid = 21259000000000
Preparing rowcnt-calculate
activerow = 5
Field Value - 6
Preparing row2flag-calculate
rowcnt = 6
dvatamt = 0.000
Result of iif = F
Field Value - F
Preparing row3flag-calculate
rowcnt = 6
dvatamt = 0.000
Result of iif = F
Field Value - F
Preparing validrow2-calculate
Result of isempty = F
Result of iif = T
Field Value - T
invdamount = 6600
invdamount = 6600
Result of iif = 6600
invdamount = 6600
invdamount = 6600
Result of iif = 0
Preparing dvatname-fill
Finding linkfield
Linkfield found and assigning Query from link field
Query assigned
Field Value - Zero rated domestic sales (0% VAT)
Preparing dvataccount-fill
Finding linkfield
Linkfield found and assigning Query from link field
Query assigned
Field Value - OUTPUT VAT PAYABLE | 223001
ndramount = 6600.000
dvatper = 0
Result of round = 0
invdamount = 6600
dvatamt = 0.000
Preparing vatflag-calculate
dvatamt = 0.000
Result of iif = F
Field Value - F
arapamount = 0
Result of iif = F
Result of iif = F
voucher_date = 12/05/2023
branchid = 21259000000000
Preparing rowcnt-calculate
activerow = 6
Field Value - 7
Preparing row2flag-calculate
rowcnt = 7
dvatamt = 0.000
Result of iif = F
Field Value - F
Preparing row3flag-calculate
rowcnt = 7
dvatamt = 0.000
Result of iif = F
Field Value - F
Preparing validrow2-calculate
Result of isempty = F
Result of iif = T
Field Value - T
invdamount = 5420
invdamount = 5420
Result of iif = 5420
invdamount = 5420
invdamount = 5420
Result of iif = 0
Preparing dvatname-fill
Finding linkfield
Linkfield found and assigning Query from link field
Query assigned
Field Value - Zero rated domestic sales (0% VAT)
Preparing dvataccount-fill
Finding linkfield
Linkfield found and assigning Query from link field
Query assigned
Field Value - OUTPUT VAT PAYABLE | 223001
ndramount = 5420.000
dvatper = 0
Result of round = 0
invdamount = 5420
dvatamt = 0.000
Preparing vatflag-calculate
dvatamt = 0.000
Result of iif = F
Field Value - F
arapamount = 0
Result of iif = F
Result of iif = F
voucher_date = 12/05/2023
branchid = 21259000000000
Preparing rowcnt-calculate
activerow = 7
Field Value - 8
Preparing row2flag-calculate
rowcnt = 8
dvatamt = 0.000
Result of iif = F
Field Value - F
Preparing row3flag-calculate
rowcnt = 8
dvatamt = 0.000
Result of iif = F
Field Value - F
Preparing validrow2-calculate
Result of isempty = F
Result of iif = T
Field Value - T
invdamount = 2874.708
invdamount = 2874.708
Result of iif = 2874.708
invdamount = 2874.708
invdamount = 2874.708
Result of iif = 0
Preparing dvatname-fill
Finding linkfield
Linkfield found and assigning Query from link field
Query assigned
Field Value - Zero rated domestic sales (0% VAT)
Preparing dvataccount-fill
Finding linkfield
Linkfield found and assigning Query from link field
Query assigned
Field Value - OUTPUT VAT PAYABLE | 223001
ndramount = 2874.708
dvatper = 0
Result of round = 0
invdamount = 2874.708
dvatamt = 0.000
Preparing vatflag-calculate
dvatamt = 0.000
Result of iif = F
Field Value - F
arapamount = 0
Result of iif = F
Result of iif = F
voucher_date = 12/05/2023
branchid = 21259000000000
Preparing rowcnt-calculate
activerow = 8
Field Value - 9
Preparing row2flag-calculate
rowcnt = 9
dvatamt = 0.000
Result of iif = F
Field Value - F
Preparing row3flag-calculate
rowcnt = 9
dvatamt = 0.000
Result of iif = F
Field Value - F
Preparing validrow2-calculate
Result of isempty = F
Result of iif = T
Field Value - T
Preparing rowcnttot-calculate
Result of total = 44
Field Value - 44
Result of total = 36980.708
Result of total = 0
Result of total = 36980.708
Result of total = 0
Result of total = 36980.708
Preparing suppdramount-calculate
totalinvdamount = 36980.708
totalinvdamount = 36980.708
Result of iif = 0
Field Value - 0.000
Preparing suppcramount-calculate
totalinvdamount = 36980.708
totalinvdamount = 36980.708
Result of iif = 36980.708
Field Value - 36980.708
Preparing roundoffaccount-accept
select a.mnamedisplay from master a,financesetup b where a.masterid = b.roundupaccount
Time elapsed = 32
Field Value - FOREIGN EXCHANGE DIFFEENCE | 440001
Result of iif = F
Result of abs = 0
Result of iif = 0
Result of iif = 0
Preparing saveflag-calculate
Field Value - T
Preparing rejflag-calculate
Result of iif = F
Field Value - F
Refreshing nonsave fields during loading over
Assigning approval bar
newmaxrow count=4
Starting Transaction
Start Transaction Status : 0
End of Starting Transaction
Start Transaction Status : -1
Sql : select props from tstructs where lower(name)= :name order by blobno
Paramval : acdet
ParamTYpe : c
Param List : name
select props from tstructs where lower(name)= :name order by blobno
Time elapsed = 31
Step5
Post on approve = True
select * from accountshdr where accountshdrid=0
Time elapsed = 31
Evaluating {acdet}
Result =
Evaluating m_systemdate
Result =
Evaluating iif(voucher_date cutoffdate,{T},{Transactions Closed for this Voucher Date})
Result =
Evaluating voucher_number
Result =
Evaluating iif( isempty(finyear) = {T}, {Financial Year is not defined}, {T})
Result =
Evaluating {F}
Result =
Evaluating m_basecurrency
Result =
Evaluating {F}
Result =
Evaluating 0
Result =
Evaluating 0
Result =
Evaluating {F}
Result =
Evaluating iif( (ndramount # 0 & ncramount # 0), {Either Debits or Credits only can be entered}, {T})
Result =
Evaluating {--}
Result =
Evaluating {--}
Result =
Evaluating iif(masterid=21595000000003 & investbudctrl={T},{T},{F})
Result =
Evaluating iif( currency = m_basecurrency, ndramount, ndramount * exchange_rate)
Result =
Evaluating iif( currency = m_basecurrency, ncramount, ncramount * exchange_rate)
Result =
Evaluating activerow
Result =
Evaluating sumtill( {dim1}, dim1 , {dramount}, actrow)-sumtill( {dim1}, dim1 , {cramount}, actrow)
Result =
Evaluating investactual1+investactsum
Result =
Evaluating sumtill( {accountname}, accountname , {dramount}, actrow)-sumtill( {accountname}, accountname, {cramount}, actrow)
Result =
Evaluating glactual1+glactsum
Result =
Evaluating iif(glbudgetcontrol={F},{T},iif(glbudget=0,{T},iif(glactsum<0,{T},iif(glactual>glbudget,{Amount Exceeding Account Budget!!},{T}))))
Result =
Evaluating iif( (accountcurrency = m_basecurrency), dramount, dramount*sexchange_rate)
Result =
Evaluating iif( (accountcurrency = m_basecurrency), cramount, cramount*sexchange_rate)
Result =
Evaluating iif( postarap = 0, (IIF(category=5, (ndramount - ncramount), iif( category = 4, (ncramount - ndramount),0))), 0)
Result =
Evaluating IIF( arapamount # 0 , {T}, {F})
Result =
Evaluating IIF( category = 3, {T}, {F})
Result =
Evaluating voucher_date
Result =
Evaluating branchid
Result =
Evaluating iif( (ndramount + ncramount )= 0, {F},{T})
Result =
Evaluating total( {ndramount})
Result =
Evaluating total( {ncramount})
Result =
Evaluating total( {dramount})
Result =
Evaluating total( {cramount})
Result =
Evaluating IIF( (totaldramount - totalcramount) # 0, {T}, {F})
Result =
Evaluating iif( (totaldramount - totalcramount) > 0, 0, abs(totaldramount - totalcramount))
Result =
Evaluating iif( (totaldramount - totalcramount) > 0, (totaldramount - totalcramount), 0)
Result =
Evaluating {F}
Result =
Evaluating IIF ( totalndramount = totalncramount & totalndramount # 0, {T}, {Debits and Credits are not matching OR No Entries Made. Invalid Transaction})
Result =
Sql : select props from tstructs where lower(name)= :name order by blobno
Paramval : vatcr
ParamTYpe : c
Param List : name
select props from tstructs where lower(name)= :name order by blobno
Time elapsed = 32
Step5
Post on approve = True
select * from vatcore where vatcoreid=0
Time elapsed = 32
Evaluating {--}
Result =
Loading genmaps
Sql : select props from tstructs where lower(name)= :name order by blobno
Paramval : bbook
ParamTYpe : c
Param List : name
select props from tstructs where lower(name)= :name order by blobno
Time elapsed = 15
Step5
Post on approve = False
select * from bankbook where bankbookid=0
Time elapsed = 32
Evaluating m_branch
Result =
Evaluating iif( isempty(finyear) = {T}, {Financial Year is not defined}, {T})
Result =
Evaluating iif( fieldchanged( {currency}, 1) = {T}, {Currency can't be changed}, {T})
Result =
Sql : select props from tstructs where lower(name)= :name order by blobno
Paramval : rpdet
ParamTYpe : c
Param List : name
select props from tstructs where lower(name)= :name order by blobno
Time elapsed = 31
Step5
Post on approve = False
select * from ARAPDETAILS where ARAPDETAILSid=0
Time elapsed = 32
Evaluating iif( isempty(termcode) = {F}, voucher_number+{ - }+termcode, voucher_number)
Result =
Evaluating 0
Result =
Evaluating {--}
Result =
Evaluating {--}
Result =
Evaluating iif( exgainlossflag = 0 & exrate = 0, {Invalid Exchange Rate posted for AR/AP}, {T})
Result =
Evaluating iif( exgainlossflag = 0 & arapamount = 0, {Invalid AR/AP Amount }, {T})
Result =
Evaluating 0
Result =
Evaluating IIF( ABS(arapSETTLED) # 0 & fieldchanged( {docid},1) = {T}, {Document No.# can't be changed}, {T})
Result =
Evaluating iif( exgainlossflag=0, (iif( currency = m_basecurrency, arapamount, arapamount * exrate)), b_arapamount)
Result =
Evaluating iif( exgainlossflag # 0, 0, sexchange_rate)
Result =
Evaluating iif( exgainlossflag = 0 & sexchange_rate = 0, {Invalid Secondary Exchange Rate posted}, {T})
Result =
Evaluating iif( exgainlossflag = 0, (iif( accountcurrency = m_basecurrency , b_arapamount, iif( accountcurrency = currency, arapamount, b_arapamount/sexchange_rate))), 0)
Result =
Evaluating IIF( arapcheck # 0, {This TXN has children. Info. can't be cancelled/deleted.}, {T})
Result =
Evaluating str(subledgerid)+voucher_number
Result =
Sql : select props from tstructs where lower(name)= :name order by blobno
Paramval : rndof
ParamTYpe : c
Param List : name
select props from tstructs where lower(name)= :name order by blobno
Time elapsed = 31
Step5
Post on approve = False
select * from accountshdr where accountshdrid=0
Time elapsed = 31
Evaluating m_branch
Result =
Evaluating {rndof}
Result =
Evaluating iif(voucher_date> cutoffdate,{T},{Transactions Closed for this Voucher Date})
Result =
Evaluating iif( isempty(finyear) = {T} , {Financial Year is not defined}, {T})
Result =
Evaluating m_basecurrency
Result =
Evaluating iif( currency = m_basecurrency & exchange_rate # 1, {Exchange Rate should be 1 for Base Currency TXN}, {T})
Result =
Evaluating {F}
Result =
Evaluating {F}
Result =
Evaluating {--}
Result =
Evaluating {--}
Result =
Evaluating {--}
Result =
Evaluating iif( postarap = 1, (IIF(category=5, (ndramount - ncramount), iif( category = 4, (ncramount - ndramount),0))), 0)
Result =
Evaluating IIF( arapamount # 0 , {T}, {F})
Result =
Evaluating {F}
Result =
Evaluating voucher_date
Result =
Evaluating branchid
Result =
Evaluating total( {ndramount})
Result =
Evaluating total( {ncramount})
Result =
Evaluating total( {dramount})
Result =
Evaluating total( {cramount})
Result =
Evaluating {F}
Result =
Evaluating 0
Result =
Evaluating 0
Result =
Evaluating iif( checkbalance = 0, {T}, IIF ( totalndramount = totalncramount & totalndramount # 0, {T}, {Debits and Credits are not matching OR No Entries Made. Invalid Transaction}))
Result =
Sql : select props from tstructs where lower(name)= :name order by blobno
Paramval : rpdet
ParamTYpe : c
Param List : name
select props from tstructs where lower(name)= :name order by blobno
Time elapsed = 16
Step5
Post on approve = False
select * from ARAPDETAILS where ARAPDETAILSid=0
Time elapsed = 15
Evaluating iif( isempty(termcode) = {F}, voucher_number+{ - }+termcode, voucher_number)
Result =
Evaluating 0
Result =
Evaluating {--}
Result =
Evaluating {--}
Result =
Evaluating iif( exgainlossflag = 0 & exrate = 0, {Invalid Exchange Rate posted for AR/AP}, {T})
Result =
Evaluating iif( exgainlossflag = 0 & arapamount = 0, {Invalid AR/AP Amount }, {T})
Result =
Evaluating 0
Result =
Evaluating IIF( ABS(arapSETTLED) # 0 & fieldchanged( {docid},1) = {T}, {Document No.# can't be changed}, {T})
Result =
Evaluating iif( exgainlossflag=0, (iif( currency = m_basecurrency, arapamount, arapamount * exrate)), b_arapamount)
Result =
Evaluating iif( exgainlossflag # 0, 0, sexchange_rate)
Result =
Evaluating iif( exgainlossflag = 0 & sexchange_rate = 0, {Invalid Secondary Exchange Rate posted}, {T})
Result =
Evaluating iif( exgainlossflag = 0, (iif( accountcurrency = m_basecurrency , b_arapamount, iif( accountcurrency = currency, arapamount, b_arapamount/sexchange_rate))), 0)
Result =
Evaluating IIF( arapcheck # 0, {This TXN has children. Info. can't be cancelled/deleted.}, {T})
Result =
Evaluating str(subledgerid)+voucher_number
Result =
>>Loading transaction rcinv record 1154660000112
Select a.rcinvhdrid, a.SourceId , a.mapname , a.cancel, a.cancelremarks , a.CreatedOn, a.CreatedBy , a.ModifiedOn , a.UserName , a.branch, a.voucher_type, a.voucher_date, a.docid, a.voucher_dummy, a.subledgercode, a.subledgerdesc, a.subledgerid, a.contraac, a.finyear, a.reference_number, a.reference_date, a.supply_date, a.bill_country, a.ship_country, a.currency, a.duedate, a.exchange_rate, a.signatory, a.signposition, a.signuser, a.notes from RCINVHDR a where a.rcinvhdrid = 1154660000112
Time elapsed = 31
Loading from 1154660000112 into frame 1, row 1
Select BRANCHNAME from BRANCH Where BRANCHid = 21259000000000
Time elapsed = 32
branch = MUHARRAQ
IdValue = 21259000000000
Select VOUCHERTYPE from VOUCHERTYPE Where VOUCHERTYPEid = 1209440000000
Time elapsed = 31
voucher_type = CI
IdValue = 1209440000000
voucher_date = 12/05/2023
docid = BAF/2023/CI/000005
voucher_dummy =
Select SUBLEDGERDISPLAY from SUBLEDGER Where SUBLEDGERid = 1154440000070
Time elapsed = 31
subledgercode = BP MIDDLE EAST LLC | CCC-008
IdValue = 1154440000070
subledgerdesc = BP MIDDLE EAST LLC
subledgerid = 1154440000070
contraac = RECOVERABLE TEMP ACCOUNT | 222007
finyear = 2023
reference_number = Arad Equipment
reference_date = 12/05/2023
supply_date = 12/05/2023
Select COUNTRY from COUNTRY Where COUNTRYid = 10035000000001
Time elapsed = 31
bill_country = Bahrain
IdValue = 10035000000001
Select COUNTRY from COUNTRY Where COUNTRYid = 10035000000001
Time elapsed = 31
ship_country = Bahrain
IdValue = 10035000000001
Select CURRENCY from CURRENCY Where CURRENCYid = 10035000000007
Time elapsed = 32
currency = BD
IdValue = 10035000000007
duedate =
exchange_rate = 1
signatory =
signposition =
signuser =
notes = Arad depot equipment purchased by BP Middle East
Select a.rcinvdtlid, a.description, a.invdamount, a.ndramount, a.ncramount, a.dvattype, a.dvattypeid, a.dvatper, a.dvatamt, a.totamount, a.narration, a.arapamount, a.arapflag, a.bankflag, a.dvoucher_date, a.dbranchid,a.rcinvdtlrow from RCINVDTL a where a.rcinvhdrid = 1154660000112 Order by rcinvdtlrow
Time elapsed = 32
Loading from 1154660000113 into frame 2, row 1
description = DBB Valves - tank 5 to 12 Tank inlet body valves - MOV DBB valves 8"
invdamount = 7616
ndramount = 7616
ncramount = 0
Select VATCODE from VATMASTER Where VATMASTERid = 20919000000305
Time elapsed = 32
dvattype = ZRO-S
IdValue = 20919000000305
dvattypeid = 20919000000305
dvatper = 0
dvatamt = 0
totamount = 7616
narration = Arad depot equipment purchased by BP Middle East
arapamount = 0
arapflag = F
bankflag = F
dvoucher_date = 12/05/2023
dbranchid = 21259000000000
Loading from 1154660000114 into frame 2, row 2
description = DBB Valves - tank 7 to 12 Tank inlet body valves - MOV DBB valves 10"
invdamount = 6720
ndramount = 6720
ncramount = 0
Select VATCODE from VATMASTER Where VATMASTERid = 20919000000305
Time elapsed = 32
dvattype = ZRO-S
IdValue = 20919000000305
dvattypeid = 20919000000305
dvatper = 0
dvatamt = 0
totamount = 6720
narration = Arad depot equipment purchased by BP Middle East
arapamount = 0
arapflag = F
bankflag = F
dvoucher_date = 12/05/2023
dbranchid = 21259000000000
Loading from 1154660000115 into frame 2, row 3
description = Tank 6 to 12 fast flush tanks - 200 liters fast flush tanks
invdamount = 2150
ndramount = 2150
ncramount = 0
Select VATCODE from VATMASTER Where VATMASTERid = 20919000000305
Time elapsed = 31
dvattype = ZRO-S
IdValue = 20919000000305
dvattypeid = 20919000000305
dvatper = 0
dvatamt = 0
totamount = 2150
narration = Arad depot equipment purchased by BP Middle East
arapamount = 0
arapflag = F
bankflag = F
dvoucher_date = 12/05/2023
dbranchid = 21259000000000
Loading from 1154660000116 into frame 2, row 4
description = Hydrant FWS 6" Inlet & Outlet - 1200 GPM
invdamount = 3808
ndramount = 3808
ncramount = 0
Select VATCODE from VATMASTER Where VATMASTERid = 20919000000305
Time elapsed = 15
dvattype = ZRO-S
IdValue = 20919000000305
dvattypeid = 20919000000305
dvatper = 0
dvatamt = 0
totamount = 3808
narration = Arad depot equipment purchased by BP Middle East
arapamount = 0
arapflag = F
bankflag = F
dvoucher_date = 12/05/2023
dbranchid = 21259000000000
Loading from 1154660000117 into frame 2, row 5
description = Transfer FWS 6" - 12 GPM
invdamount = 1792
ndramount = 1792
ncramount = 0
Select VATCODE from VATMASTER Where VATMASTERid = 20919000000305
Time elapsed = 31
dvattype = ZRO-S
IdValue = 20919000000305
dvattypeid = 20919000000305
dvatper = 0
dvatamt = 0
totamount = 1792
narration = Arad depot equipment purchased by BP Middle East
arapamount = 0
arapflag = F
bankflag = F
dvoucher_date = 12/05/2023
dbranchid = 21259000000000
Loading from 1154660000118 into frame 2, row 6
description = Hydrant Pump along with structural base support
invdamount = 6600
ndramount = 6600
ncramount = 0
Select VATCODE from VATMASTER Where VATMASTERid = 20919000000305
Time elapsed = 31
dvattype = ZRO-S
IdValue = 20919000000305
dvattypeid = 20919000000305
dvatper = 0
dvatamt = 0
totamount = 6600
narration = Arad depot equipment purchased by BP Middle East
arapamount = 0
arapflag = F
bankflag = F
dvoucher_date = 12/05/2023
dbranchid = 21259000000000
Loading from 1154660000119 into frame 2, row 7
description = Foam skid with tank
invdamount = 5420
ndramount = 5420
ncramount = 0
Select VATCODE from VATMASTER Where VATMASTERid = 20919000000305
Time elapsed = 31
dvattype = ZRO-S
IdValue = 20919000000305
dvattypeid = 20919000000305
dvatper = 0
dvatamt = 0
totamount = 5420
narration = Arad depot equipment purchased by BP Middle East
arapamount = 0
arapflag = F
bankflag = F
dvoucher_date = 12/05/2023
dbranchid = 21259000000000
Loading from 1154660000120 into frame 2, row 8
description = Shipping & Handling Charges
invdamount = 2874.708
ndramount = 2874.708
ncramount = 0
Select VATCODE from VATMASTER Where VATMASTERid = 20919000000305
Time elapsed = 31
dvattype = ZRO-S
IdValue = 20919000000305
dvattypeid = 20919000000305
dvatper = 0
dvatamt = 0
totamount = 2874.708
narration = Arad depot equipment purchased by BP Middle East
arapamount = 0
arapflag = F
bankflag = F
dvoucher_date = 12/05/2023
dbranchid = 21259000000000
Select a.rcinvgridattachid, a.doctype, a.AxpFilePath_MyImage, a.AxpFile_MyImage,a.rcinvgridattachrow from RCINVGRIDATTACH a where a.rcinvhdrid = 1154660000112 Order by rcinvgridattachrow
Time elapsed = 32
Select a.rcinvhdrid, a.SourceId , a.mapname , a.cancel, a.cancelremarks , a.CreatedOn, a.CreatedBy , a.ModifiedOn , a.UserName , a.totalinvdamount, a.totvatamount, a.totalndramount, a.totalncramount, a.totinvamt, a.diffflag, a.diffdramount, a.diffcramount from RCINVHDR a where a.rcinvhdrid = 1154660000112
Time elapsed = 31
Loading from 1154660000112 into frame 4, row 1
totalinvdamount = 36980.708
totvatamount = 0
totalndramount = 36980.708
totalncramount = 0
totinvamt = 36980.708
diffflag = F
diffdramount = 0
diffcramount = 0
Loading no-save fields
>>Validating rcinv
>>Frame No 1
Refreshing nonsave fields during loading
Preparing userid-calculate
username = admin
Field Value - admin
Preparing urole-calculate
userroles = default,todolist
Field Value - default,todolist
Preparing appdesc-accept
Field Value - 1
Preparing enteredby-accept
Field Value - L0221
Preparing enteredon-accept
Field Value - 12/05/2023 03:05:24 PM
Preparing adminpur-accept
Field Value - F
Preparing branchid-fill
Finding linkfield
Linkfield found and assigning Query from link field
Query assigned
Field Value - 21259000000000
Preparing currdate-calculate
Result of date = 11/10/2023
Field Value - 11/10/2023
Preparing cutoffdate-accept
Field Value - 31/05/2023
Preparing voucher_prefix-accept
Field Value - :BAF/2023/CI/
Preparing supplier-fill
Finding linkfield
Linkfield found and assigning Query from link field
Field Value - CCC-008
Preparing mname-fill
Finding linkfield
Linkfield found and assigning Query from link field
Field Value - RECOVERABLE CONTROL ACCOUNT | 123302
Preparing controlac-fill
Finding linkfield
Linkfield found and assigning Query from link field
Field Value - 24646000000032
Preparing dupchek-accept
Field Value - 0
Preparing countryofsupply-select
Field Value -
Preparing currencyid-fill
Finding linkfield
Linkfield found and assigning Query from link field
Query assigned
Field Value - 10035000000007
invdamount = 7616
invdamount = 7616
Result of iif = 7616
invdamount = 7616
invdamount = 7616
Result of iif = 0
Preparing dvatname-fill
Finding linkfield
Linkfield found and assigning Query from link field
Query assigned
Field Value - Zero rated domestic sales (0% VAT)
Preparing dvataccount-fill
Finding linkfield
Linkfield found and assigning Query from link field
Query assigned
Field Value - OUTPUT VAT PAYABLE | 223001
ndramount = 7616.000
dvatper = 0
Result of round = 0
invdamount = 7616
dvatamt = 0.000
Preparing vatflag-calculate
dvatamt = 0.000
Result of iif = F
Field Value - F
arapamount = 0
Result of iif = F
Result of iif = F
voucher_date = 12/05/2023
branchid = 21259000000000
Preparing rowcnt-calculate
activerow = 1
Field Value - 2
Preparing row2flag-calculate
rowcnt = 2
dvatamt = 0.000
Result of iif = F
Field Value - F
Preparing row3flag-calculate
rowcnt = 2
dvatamt = 0.000
Result of iif = F
Field Value - F
Preparing validrow2-calculate
Result of isempty = F
Result of iif = T
Field Value - T
invdamount = 6720
invdamount = 6720
Result of iif = 6720
invdamount = 6720
invdamount = 6720
Result of iif = 0
Preparing dvatname-fill
Finding linkfield
Linkfield found and assigning Query from link field
Query assigned
Field Value - Zero rated domestic sales (0% VAT)
Preparing dvataccount-fill
Finding linkfield
Linkfield found and assigning Query from link field
Query assigned
Field Value - OUTPUT VAT PAYABLE | 223001
ndramount = 6720.000
dvatper = 0
Result of round = 0
invdamount = 6720
dvatamt = 0.000
Preparing vatflag-calculate
dvatamt = 0.000
Result of iif = F
Field Value - F
arapamount = 0
Result of iif = F
Result of iif = F
voucher_date = 12/05/2023
branchid = 21259000000000
Preparing rowcnt-calculate
activerow = 2
Field Value - 3
Preparing row2flag-calculate
rowcnt = 3
dvatamt = 0.000
Result of iif = F
Field Value - F
Preparing row3flag-calculate
rowcnt = 3
dvatamt = 0.000
Result of iif = F
Field Value - F
Preparing validrow2-calculate
Result of isempty = F
Result of iif = T
Field Value - T
invdamount = 2150
invdamount = 2150
Result of iif = 2150
invdamount = 2150
invdamount = 2150
Result of iif = 0
Preparing dvatname-fill
Finding linkfield
Linkfield found and assigning Query from link field
Query assigned
Field Value - Zero rated domestic sales (0% VAT)
Preparing dvataccount-fill
Finding linkfield
Linkfield found and assigning Query from link field
Query assigned
Field Value - OUTPUT VAT PAYABLE | 223001
ndramount = 2150.000
dvatper = 0
Result of round = 0
invdamount = 2150
dvatamt = 0.000
Preparing vatflag-calculate
dvatamt = 0.000
Result of iif = F
Field Value - F
arapamount = 0
Result of iif = F
Result of iif = F
voucher_date = 12/05/2023
branchid = 21259000000000
Preparing rowcnt-calculate
activerow = 3
Field Value - 4
Preparing row2flag-calculate
rowcnt = 4
dvatamt = 0.000
Result of iif = F
Field Value - F
Preparing row3flag-calculate
rowcnt = 4
dvatamt = 0.000
Result of iif = F
Field Value - F
Preparing validrow2-calculate
Result of isempty = F
Result of iif = T
Field Value - T
invdamount = 3808
invdamount = 3808
Result of iif = 3808
invdamount = 3808
invdamount = 3808
Result of iif = 0
Preparing dvatname-fill
Finding linkfield
Linkfield found and assigning Query from link field
Query assigned
Field Value - Zero rated domestic sales (0% VAT)
Preparing dvataccount-fill
Finding linkfield
Linkfield found and assigning Query from link field
Query assigned
Field Value - OUTPUT VAT PAYABLE | 223001
ndramount = 3808.000
dvatper = 0
Result of round = 0
invdamount = 3808
dvatamt = 0.000
Preparing vatflag-calculate
dvatamt = 0.000
Result of iif = F
Field Value - F
arapamount = 0
Result of iif = F
Result of iif = F
voucher_date = 12/05/2023
branchid = 21259000000000
Preparing rowcnt-calculate
activerow = 4
Field Value - 5
Preparing row2flag-calculate
rowcnt = 5
dvatamt = 0.000
Result of iif = F
Field Value - F
Preparing row3flag-calculate
rowcnt = 5
dvatamt = 0.000
Result of iif = F
Field Value - F
Preparing validrow2-calculate
Result of isempty = F
Result of iif = T
Field Value - T
invdamount = 1792
invdamount = 1792
Result of iif = 1792
invdamount = 1792
invdamount = 1792
Result of iif = 0
Preparing dvatname-fill
Finding linkfield
Linkfield found and assigning Query from link field
Query assigned
Field Value - Zero rated domestic sales (0% VAT)
Preparing dvataccount-fill
Finding linkfield
Linkfield found and assigning Query from link field
Query assigned
Field Value - OUTPUT VAT PAYABLE | 223001
ndramount = 1792.000
dvatper = 0
Result of round = 0
invdamount = 1792
dvatamt = 0.000
Preparing vatflag-calculate
dvatamt = 0.000
Result of iif = F
Field Value - F
arapamount = 0
Result of iif = F
Result of iif = F
voucher_date = 12/05/2023
branchid = 21259000000000
Preparing rowcnt-calculate
activerow = 5
Field Value - 6
Preparing row2flag-calculate
rowcnt = 6
dvatamt = 0.000
Result of iif = F
Field Value - F
Preparing row3flag-calculate
rowcnt = 6
dvatamt = 0.000
Result of iif = F
Field Value - F
Preparing validrow2-calculate
Result of isempty = F
Result of iif = T
Field Value - T
invdamount = 6600
invdamount = 6600
Result of iif = 6600
invdamount = 6600
invdamount = 6600
Result of iif = 0
Preparing dvatname-fill
Finding linkfield
Linkfield found and assigning Query from link field
Query assigned
Field Value - Zero rated domestic sales (0% VAT)
Preparing dvataccount-fill
Finding linkfield
Linkfield found and assigning Query from link field
Query assigned
Field Value - OUTPUT VAT PAYABLE | 223001
ndramount = 6600.000
dvatper = 0
Result of round = 0
invdamount = 6600
dvatamt = 0.000
Preparing vatflag-calculate
dvatamt = 0.000
Result of iif = F
Field Value - F
arapamount = 0
Result of iif = F
Result of iif = F
voucher_date = 12/05/2023
branchid = 21259000000000
Preparing rowcnt-calculate
activerow = 6
Field Value - 7
Preparing row2flag-calculate
rowcnt = 7
dvatamt = 0.000
Result of iif = F
Field Value - F
Preparing row3flag-calculate
rowcnt = 7
dvatamt = 0.000
Result of iif = F
Field Value - F
Preparing validrow2-calculate
Result of isempty = F
Result of iif = T
Field Value - T
invdamount = 5420
invdamount = 5420
Result of iif = 5420
invdamount = 5420
invdamount = 5420
Result of iif = 0
Preparing dvatname-fill
Finding linkfield
Linkfield found and assigning Query from link field
Query assigned
Field Value - Zero rated domestic sales (0% VAT)
Preparing dvataccount-fill
Finding linkfield
Linkfield found and assigning Query from link field
Query assigned
Field Value - OUTPUT VAT PAYABLE | 223001
ndramount = 5420.000
dvatper = 0
Result of round = 0
invdamount = 5420
dvatamt = 0.000
Preparing vatflag-calculate
dvatamt = 0.000
Result of iif = F
Field Value - F
arapamount = 0
Result of iif = F
Result of iif = F
voucher_date = 12/05/2023
branchid = 21259000000000
Preparing rowcnt-calculate
activerow = 7
Field Value - 8
Preparing row2flag-calculate
rowcnt = 8
dvatamt = 0.000
Result of iif = F
Field Value - F
Preparing row3flag-calculate
rowcnt = 8
dvatamt = 0.000
Result of iif = F
Field Value - F
Preparing validrow2-calculate
Result of isempty = F
Result of iif = T
Field Value - T
invdamount = 2874.708
invdamount = 2874.708
Result of iif = 2874.708
invdamount = 2874.708
invdamount = 2874.708
Result of iif = 0
Preparing dvatname-fill
Finding linkfield
Linkfield found and assigning Query from link field
Query assigned
Field Value - Zero rated domestic sales (0% VAT)
Preparing dvataccount-fill
Finding linkfield
Linkfield found and assigning Query from link field
Query assigned
Field Value - OUTPUT VAT PAYABLE | 223001
ndramount = 2874.708
dvatper = 0
Result of round = 0
invdamount = 2874.708
dvatamt = 0.000
Preparing vatflag-calculate
dvatamt = 0.000
Result of iif = F
Field Value - F
arapamount = 0
Result of iif = F
Result of iif = F
voucher_date = 12/05/2023
branchid = 21259000000000
Preparing rowcnt-calculate
activerow = 8
Field Value - 9
Preparing row2flag-calculate
rowcnt = 9
dvatamt = 0.000
Result of iif = F
Field Value - F
Preparing row3flag-calculate
rowcnt = 9
dvatamt = 0.000
Result of iif = F
Field Value - F
Preparing validrow2-calculate
Result of isempty = F
Result of iif = T
Field Value - T
Preparing rowcnttot-calculate
Result of total = 44
Field Value - 44
Result of total = 36980.708
Result of total = 0
Result of total = 36980.708
Result of total = 0
Result of total = 36980.708
Preparing suppdramount-calculate
totalinvdamount = 36980.708
totalinvdamount = 36980.708
Result of iif = 0
Field Value - 0.000
Preparing suppcramount-calculate
totalinvdamount = 36980.708
totalinvdamount = 36980.708
Result of iif = 36980.708
Field Value - 36980.708
Preparing roundoffaccount-accept
Field Value - FOREIGN EXCHANGE DIFFEENCE | 440001
Result of iif = F
Result of abs = 0
Result of iif = 0
Result of iif = 0
Preparing saveflag-calculate
Field Value - T
Preparing rejflag-calculate
Result of iif = F
Field Value - F
Refreshing nonsave fields during loading over
>>Writing to database tables rcinv record 1154660000112
select cancel,cancelremarks,username,modifiedon from rcinvhdr where rcinvhdrid=0
Time elapsed = 31
Cancelling in rcinvhdr
Param Type = c
cancel=T
Param Type = c
cancelremarks=Trigger Cancel
Param Type = c
username=admin
Param Type = c
modifiedon=11/10/2023 08:27:02
update rcinvhdr set cancel=:cancel,cancelremarks=:cancelremarks,username=:username,modifiedon=to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss')
where rcinvhdrid=1154660000112
select cancel,cancelremarks,username,modifiedon from rcinvgridattach where rcinvgridattachid=0
CDS Open Error Msg : csd query : select cancel,cancelremarks,username,modifiedon from rcinvgridattach where rcinvgridattachid=0 $ Error msg : ORA-00904: "MODIFIEDON": invalid identifier
uXDS\open\ Exceptio ORA-00904: "MODIFIEDON": invalid identifier
select cancel,cancelremarks,username,modifiedon from rcinvdtl where rcinvdtlid=0
CDS Open Error Msg : csd query : select cancel,cancelremarks,username,modifiedon from rcinvdtl where rcinvdtlid=0 $ Error msg : ORA-00904: "MODIFIEDON": invalid identifier
uXDS\open\ Exceptio ORA-00904: "MODIFIEDON": invalid identifier
uProvideLink\DeleteTrans\checking InTransaction.
>>Loading transaction acdet record 1154660000112
Select a.accountshdrid, a.SourceId , a.mapname , a.cancel, a.cancelremarks , a.CreatedOn, a.CreatedBy , a.ModifiedOn , a.UserName , a.branch, a.transid, a.voucher_type, a.voucher_date, a.voucher_number, a.docid, a.reference_date, a.finyear, a.bankadj, a.reference_number, a.cheque_number, a.cheque_date, a.cheque_bank, a.currency, a.exchange_rate, a.iscontra, a.postarap, a.creditdays, a.isautoreverse, a.autoreverseon from ACCOUNTSHDR a where a.SourceId = 1154660000112 and a.mapname = 'rcinv1'
Time elapsed = 31
Loading from 1154660000121 into frame 1, row 1
Select BRANCHNAME from BRANCH Where BRANCHid = 21259000000000
Time elapsed = 31
branch = MUHARRAQ
IdValue = 21259000000000
transid = acdet
Select VOUCHERTYPE from VOUCHERTYPE Where VOUCHERTYPEid = 1209440000000
Time elapsed = 31
voucher_type = CI
IdValue = 1209440000000
voucher_date = 12/05/2023
voucher_number = BAF/2023/CI/000005
docid = BAF/2023/CI/000005
reference_date = 12/05/2023
finyear = 2023
bankadj = F
reference_number = Arad Equipment
cheque_number =
cheque_date =
cheque_bank =
Select CURRENCY from CURRENCY Where CURRENCYid = 10035000000007
Time elapsed = 31
currency = BD
IdValue = 10035000000007
exchange_rate = 1
iscontra = F
postarap = 0
creditdays = 0
isautoreverse = F
autoreverseon =
Select a.accountsdtlid, a.accountname, a.accountcurrencyid, a.category, a.costcentre, a.subledger, a.ndramount, a.ncramount, a.dim1, a.dim2, a.dramount, a.cramount, a.sexchange_rate, a.sdramount, a.scramount, a.arapamount, a.termcode, a.mcreditdays, a.arapflag, a.bankflag, a.narration, a.dvoucher_date, a.dbranchid,a.accountsdtlrow from ACCOUNTSDTL a where a.accountshdrid = 1154660000121 Order by accountsdtlrow
Time elapsed = 31
Loading from 1154660000122 into frame 2, row 1
Select MNAMEDISPLAY from MASTER Where MASTERid = 24646000000032
Time elapsed = 31
accountname = RECOVERABLE CONTROL ACCOUNT | 123302
IdValue = 24646000000032
accountcurrencyid = 10035000000007
category = 5
costcentre = 0
Select SUBLEDGERDISPLAY from SUBLEDGER Where SUBLEDGERid = 1154440000070
Time elapsed = 32
subledger = BP MIDDLE EAST LLC | CCC-008
IdValue = 1154440000070
ndramount = 36980.708
ncramount = 0
Select COSTCENTRECODE from COSTCENTRE Where COSTCENTREid = 1
Time elapsed = 31
dim1 = --
IdValue = 1
Select COSTCENTRECODE from COSTCENTRE Where COSTCENTREid = 1
Time elapsed = 31
dim2 = --
IdValue = 1
dramount = 36980.708
cramount = 0
sexchange_rate = 1
sdramount = 36980.708
scramount = 0
arapamount = 36980.708
termcode =
mcreditdays = 0
arapflag = T
bankflag = F
narration = Arad depot equipment purchased by BP Middle East
dvoucher_date = 12/05/2023
dbranchid = 21259000000000
Loading from 1154660000123 into frame 2, row 2
Select MNAMEDISPLAY from MASTER Where MASTERid = 23403000000580
Time elapsed = 31
accountname = RECOVERABLE TEMP ACCOUNT | 222007
IdValue = 23403000000580
accountcurrencyid = 10035000000007
category = 1
costcentre = 0
Select SUBLEDGERDISPLAY from SUBLEDGER Where SUBLEDGERid = 1
Time elapsed = 31
subledger = --
IdValue = 1
ndramount = 0
ncramount = 36980.708
Select COSTCENTRECODE from COSTCENTRE Where COSTCENTREid = 21692000000023
Time elapsed = 31
dim1 = CRP
IdValue = 21692000000023
Select COSTCENTRECODE from COSTCENTRE Where COSTCENTREid = 23253000000000
Time elapsed = 15
dim2 = MGMT
IdValue = 23253000000000
dramount = 0
cramount = 36980.708
sexchange_rate = 1
sdramount = 0
scramount = 36980.708
arapamount = 0
termcode =
mcreditdays = 0
arapflag = F
bankflag = F
narration = Arad depot equipment purchased by BP Middle East
dvoucher_date = 12/05/2023
dbranchid = 21259000000000
Select a.accountshdrid, a.SourceId , a.mapname , a.cancel, a.cancelremarks , a.CreatedOn, a.CreatedBy , a.ModifiedOn , a.UserName , a.notes, a.totalndramount, a.totalncramount, a.totaldramount, a.totalcramount, a.diffflag, a.diffdramount, a.diffcramount, a.yeflag from ACCOUNTSHDR a where a.SourceId = 1154660000112 and a.mapname = 'rcinv1'
Time elapsed = 47
Loading from 1154660000121 into frame 3, row 1
notes = Arad depot equipment purchased by BP Middle East
totalndramount = 36980.708
totalncramount = 36980.708
totaldramount = 36980.708
totalcramount = 36980.708
diffflag = F
diffdramount = 0
diffcramount = 0
yeflag = F
Loading no-save fields
>>Validating acdet
>>Frame No 1
Refreshing nonsave fields during loading
Refresh Field - branchid Row No 1
Finding linkfield
Linkfield found and assigning Query from link field
Query assigned
select a0.branchid, a0.branchname from branch a0 where branchname != 'ALL' order by 2
Time elapsed = 31
Refresh Field Value - 21259000000000
Refresh Field - lockdate Row No 1
select lockdate from company where lockdate is not null
Time elapsed = 32
Refresh Field Value - 01/01/2024
Refresh Field - cutoffdate Row No 1
branchid=21259000000000
SELECT cutoffdate from transactionrange where branch = :branchid
branchid=21259000000000
Time elapsed = 47
Refresh Field Value - 31/05/2023
Refresh Field - voucher_prefix Row No 1
Refresh Field Value -
Refresh Field - currencyid Row No 1
Finding linkfield
Linkfield found and assigning Query from link field
Query assigned
branch=MUHARRAQ
voucher_date=12/05/2023 00:00:00
select a1.CURRENCYID, a1.currency, getexrate( :branch, a1.currency, to_date(:voucher_date,'dd/mm/yyyy hh24:mi:ss')) as exrate from currency a1 where getexrate( :branch, a1.currency, to_date(:voucher_date,'dd/mm/yyyy hh24:mi:ss')) is not null order by 2
branch=MUHARRAQ
voucher_date=12/05/2023 00:00:00
branch=MUHARRAQ
voucher_date=12/05/2023 00:00:00
Time elapsed = 171
Refresh Field Value - 10035000000007
Refresh Field - checkbalance Row No 1
Refresh Field Value - 0
Refresh Field - description Row No 1
Finding linkfield
Linkfield found and assigning Query from link field
Query assigned
branchid=21259000000000
recordid=1154660000121
select ml.masterid, ml.mnamedisplay, ml.accountno, ml.laccountno, ml.mname,
ml.fmname, ml.category, ml.nativecurrency, ml.iscontrolac, ml.dim,
ml.budgetcontrol
from master ml, master_branch mb
where ml.mtype = 1
and ml.masterid = mb.masterid
and mb.branch = :branchid
and (ml.inactive = 'F' or :recordid > 0)
order by ml.mnamedisplay
branchid=21259000000000
recordid=1154660000121
Time elapsed = 94
Refresh Field Value - RECOVERABLE CONTROL ACCOUNT
Refresh Field - dim Row No 1
Finding linkfield
Linkfield found and assigning Query from link field
Query assigned
Refresh Field Value - 0000
Refresh Field - masterid Row No 1
Finding linkfield
Linkfield found and assigning Query from link field
Query assigned
Refresh Field Value - 24646000000032
Refresh Field - iscontrolac Row No 1
Finding linkfield
Linkfield found and assigning Query from link field
Query assigned
Refresh Field Value - T
Refresh Field - glbudgetcontrol Row No 1
Finding linkfield
Linkfield found and assigning Query from link field
Query assigned
Refresh Field Value - F
Refresh Field - sdescription Row No 1
Finding linkfield
Linkfield found and assigning Query from link field
Query assigned
iscontrolac = ('T')
iscontrolac = ('T')
Query component recreating again
branchid=21259000000000
masterid=24646000000032
select a0.subledgerid, a0.subledgerdisplay, a0.subledgername, a0.fsubledgername,a0.creditdays from subledger a0 where a0.app_desc = 1 and nvl (a0.inactive, 'F') = 'F' and (a0.branch = :branchid or a0.branch = 1) and a0.controlaccount = :masterid and upper ('T') = 'T' union select a0.subledgerid, a0.subledgerdisplay, a0.subledgername, a0.fsubledgername,a0.creditdays from subledger a0 where subledgercode = '--' and upper ('T') = 'F' order by 2
branchid=21259000000000
masterid=24646000000032
Time elapsed = 78
Refresh Field Value - BP MIDDLE EAST LLC
Refresh Field - investbudget Row No 1
dim1=--
voucher_date=12/05/2023 00:00:00
select nvl(sum(yramount),0) from vw_investbudget where projectcode = :dim1 and budyear = to_char( to_date(:voucher_date,'dd/mm/yyyy hh24:mi:ss') , 'YYYY') and cancel='F' and app_desc=1
dim1=--
voucher_date=12/05/2023 00:00:00
Time elapsed = 78
Refresh Field Value - 0.000
Refresh Field - investbudctrl Row No 1
dim1=--
voucher_date=12/05/2023 00:00:00
select max(budgetctrl) from vw_investbudget where projectcode = :dim1 and budyear = to_char( to_date(:voucher_date,'dd/mm/yyyy hh24:mi:ss') , 'YYYY') and cancel='F' and app_desc=1
dim1=--
voucher_date=12/05/2023 00:00:00
Time elapsed = 78
Refresh Field Value -
Refresh Field - investflag Row No 1
Evaluating - iif(masterid=21595000000003 & investbudctrl={T},{T},{F})
masterid = 24646000000032
investbudctrl =
Result of iif = F
Refresh Field Value - F
Refresh Field - investactual1 Row No 1
voucher_date=12/05/2023 00:00:00
dim1=--
voucher_number=BAF/2023/CI/000005
select nvl(sum(dramount)-sum(cramount),0) from accountshdr a, accountsdtl b, costcentre c where to_char(a.voucher_date,'yyyy') = to_char( to_date(:voucher_date,'dd/mm/yyyy hh24:mi:ss') , 'YYYY') and a.accountshdrid=b.accountshdrid and b.dim1 = c.costcentreid and c.costcentrecode = :dim1 and a.cancel = 'F' and a.app_desc=1 and a.voucher_number <> :voucher_number and a.voucher_date <= to_date(:voucher_date,'dd/mm/yyyy hh24:mi:ss') and c.costcentreid in (select distinct costcentreid from vw_investbudget)
voucher_date=12/05/2023 00:00:00
dim1=--
voucher_number=BAF/2023/CI/000005
voucher_date=12/05/2023 00:00:00
Time elapsed = 141
Refresh Field Value - 0.000
Refresh Field - glbudget Row No 1
accountname=RECOVERABLE CONTROL ACCOUNT | 123302
voucher_date=12/05/2023 00:00:00
select nvl(sum(budgetamount),0) from vw_budgetglaccounts where accountno = :accountname and budget_year = to_char( to_date(:voucher_date,'dd/mm/yyyy hh24:mi:ss') , 'YYYY')
accountname=RECOVERABLE CONTROL ACCOUNT | 123302
voucher_date=12/05/2023 00:00:00
Time elapsed = 94
Refresh Field Value - 0.000
Refresh Field - glactual1 Row No 1
voucher_date=12/05/2023 00:00:00
accountname=RECOVERABLE CONTROL ACCOUNT | 123302
voucher_number=BAF/2023/CI/000005
select nvl(sum(dramount)-sum(cramount),0) from accountshdr a, accountsdtl b, master c where to_char(a.voucher_date,'yyyy') = to_char( to_date(:voucher_date,'dd/mm/yyyy hh24:mi:ss') , 'YYYY') and a.accountshdrid=b.accountshdrid and b.accountname = c.masterid and c.accountno = :accountname and a.cancel = 'F' and a.app_desc=1 and a.voucher_number <> :voucher_number and a.voucher_date <= to_date(:voucher_date,'dd/mm/yyyy hh24:mi:ss')
voucher_date=12/05/2023 00:00:00
accountname=RECOVERABLE CONTROL ACCOUNT | 123302
voucher_number=BAF/2023/CI/000005
voucher_date=12/05/2023 00:00:00
Time elapsed = 140
Refresh Field Value - 0.000
currency = BD
m_basecurrency = BD
ndramount = 36980.708
ndramount = 36980.708
exchange_rate = 1
Result of iif = 36980.708
currency = BD
m_basecurrency = BD
ncramount = 0
ncramount = 0
exchange_rate = 1
Result of iif = 0
Refresh Field - actrow Row No 1
Evaluating - activerow
activerow = 1
Refresh Field Value - 1
Refresh Field - investactsum Row No 1
Evaluating - sumtill( {dim1}, dim1 , {dramount}, actrow)-sumtill( {dim1}, dim1 , {cramount}, actrow)
dim1 = --
actrow = 1
Result of sumtill = 0
dim1 = --
actrow = 1
Result of sumtill = 36980.708
Refresh Field Value - 36980.708
Refresh Field - investactual Row No 1
Evaluating - investactual1+investactsum
investactual1 = 0.000
investactsum = 36980.708
Refresh Field Value - 36980.708
Refresh Field - glactsum Row No 1
Evaluating - sumtill( {accountname}, accountname , {dramount}, actrow)-sumtill( {accountname}, accountname, {cramount}, actrow)
accountname = RECOVERABLE CONTROL ACCOUNT | 123302
actrow = 1
Result of sumtill = 0
accountname = RECOVERABLE CONTROL ACCOUNT | 123302
actrow = 1
Result of sumtill = 36980.708
Refresh Field Value - 36980.708
Refresh Field - glactual Row No 1
Evaluating - glactual1+glactsum
glactual1 = 0.000
glactsum = 36980.708
Refresh Field Value - 36980.708
Refresh Field - accountcurrency Row No 1
accountcurrencyid=10035000000007
select currency from currency where currencyid = :accountcurrencyid
accountcurrencyid=10035000000007
Time elapsed = 63
Refresh Field Value - BD
accountcurrency = BD
m_basecurrency = BD
dramount = 36980.708
dramount = 36980.708
sexchange_rate = 1
Result of iif = 36980.708
accountcurrency = BD
m_basecurrency = BD
cramount = 0.000
cramount = 0.000
sexchange_rate = 1
Result of iif = 0.000
category = 5
ncramount = 0
ndramount = 36980.708
Result of iif = 0
category = 5
ndramount = 36980.708
ncramount = 0
Result of iif = 36980.708
postarap = 0
Result of iif = 36980.708
arapamount = 36980.708
Result of iif = T
category = 5
Result of iif = F
voucher_date = 12/05/2023
branchid = 21259000000000
Refresh Field - validrow2 Row No 1
Evaluating - iif( (ndramount + ncramount )= 0, {F},{T})
ndramount = 36980.708
ncramount = 0
Result of iif = T
Refresh Field Value - T
Refresh Field - description Row No 2
Finding linkfield
Linkfield found and assigning Query from link field
Query assigned
Refresh Field Value - RECOVERABLE TEMP ACCOUNT
Refresh Field - dim Row No 2
Finding linkfield
Linkfield found and assigning Query from link field
Query assigned
Refresh Field Value - 0000
Refresh Field - masterid Row No 2
Finding linkfield
Linkfield found and assigning Query from link field
Query assigned
Refresh Field Value - 23403000000580
Refresh Field - iscontrolac Row No 2
Finding linkfield
Linkfield found and assigning Query from link field
Query assigned
Refresh Field Value - F
Refresh Field - glbudgetcontrol Row No 2
Finding linkfield
Linkfield found and assigning Query from link field
Query assigned
Refresh Field Value - F
Refresh Field - sdescription Row No 2
Finding linkfield
Linkfield found and assigning Query from link field
Query assigned
iscontrolac = ('F')
iscontrolac = ('F')
Query component recreating again
branchid=21259000000000
masterid=23403000000580
select a0.subledgerid, a0.subledgerdisplay, a0.subledgername, a0.fsubledgername,a0.creditdays from subledger a0 where a0.app_desc = 1 and nvl (a0.inactive, 'F') = 'F' and (a0.branch = :branchid or a0.branch = 1) and a0.controlaccount = :masterid and upper ('F') = 'T' union select a0.subledgerid, a0.subledgerdisplay, a0.subledgername, a0.fsubledgername,a0.creditdays from subledger a0 where subledgercode = '--' and upper ('F') = 'F' order by 2
branchid=21259000000000
masterid=23403000000580
Time elapsed = 94
Refresh Field Value - --
Refresh Field - investbudget Row No 2
dim1=CRP
select nvl(sum(yramount),0) from vw_investbudget where projectcode = :dim1 and budyear = to_char( to_date(:voucher_date,'dd/mm/yyyy hh24:mi:ss') , 'YYYY') and cancel='F' and app_desc=1
dim1=CRP
voucher_date=12/05/2023 00:00:00
Time elapsed = 78
Refresh Field Value - 0.000
Refresh Field - investbudctrl Row No 2
dim1=CRP
select max(budgetctrl) from vw_investbudget where projectcode = :dim1 and budyear = to_char( to_date(:voucher_date,'dd/mm/yyyy hh24:mi:ss') , 'YYYY') and cancel='F' and app_desc=1
dim1=CRP
voucher_date=12/05/2023 00:00:00
Time elapsed = 93
Refresh Field Value -
Refresh Field - investflag Row No 2
Evaluating - iif(masterid=21595000000003 & investbudctrl={T},{T},{F})
masterid = 23403000000580
investbudctrl =
Result of iif = F
Refresh Field Value - F
Refresh Field - investactual1 Row No 2
dim1=CRP
select nvl(sum(dramount)-sum(cramount),0) from accountshdr a, accountsdtl b, costcentre c where to_char(a.voucher_date,'yyyy') = to_char( to_date(:voucher_date,'dd/mm/yyyy hh24:mi:ss') , 'YYYY') and a.accountshdrid=b.accountshdrid and b.dim1 = c.costcentreid and c.costcentrecode = :dim1 and a.cancel = 'F' and a.app_desc=1 and a.voucher_number <> :voucher_number and a.voucher_date <= to_date(:voucher_date,'dd/mm/yyyy hh24:mi:ss') and c.costcentreid in (select distinct costcentreid from vw_investbudget)
voucher_date=12/05/2023 00:00:00
dim1=CRP
voucher_number=BAF/2023/CI/000005
voucher_date=12/05/2023 00:00:00
Time elapsed = 140
Refresh Field Value - 0.000
Refresh Field - glbudget Row No 2
accountname=RECOVERABLE TEMP ACCOUNT | 222007
select nvl(sum(budgetamount),0) from vw_budgetglaccounts where accountno = :accountname and budget_year = to_char( to_date(:voucher_date,'dd/mm/yyyy hh24:mi:ss') , 'YYYY')
accountname=RECOVERABLE TEMP ACCOUNT | 222007
voucher_date=12/05/2023 00:00:00
Time elapsed = 78
Refresh Field Value - 0.000
Refresh Field - glactual1 Row No 2
accountname=RECOVERABLE TEMP ACCOUNT | 222007
select nvl(sum(dramount)-sum(cramount),0) from accountshdr a, accountsdtl b, master c where to_char(a.voucher_date,'yyyy') = to_char( to_date(:voucher_date,'dd/mm/yyyy hh24:mi:ss') , 'YYYY') and a.accountshdrid=b.accountshdrid and b.accountname = c.masterid and c.accountno = :accountname and a.cancel = 'F' and a.app_desc=1 and a.voucher_number <> :voucher_number and a.voucher_date <= to_date(:voucher_date,'dd/mm/yyyy hh24:mi:ss')
voucher_date=12/05/2023 00:00:00
accountname=RECOVERABLE TEMP ACCOUNT | 222007
voucher_number=BAF/2023/CI/000005
voucher_date=12/05/2023 00:00:00
Time elapsed = 141
Refresh Field Value - 0.000
currency = BD
m_basecurrency = BD
ndramount = 0
ndramount = 0
exchange_rate = 1
Result of iif = 0
currency = BD
m_basecurrency = BD
ncramount = 36980.708
ncramount = 36980.708
exchange_rate = 1
Result of iif = 36980.708
Refresh Field - actrow Row No 2
Evaluating - activerow
activerow = 2
Refresh Field Value - 2
Refresh Field - investactsum Row No 2
Evaluating - sumtill( {dim1}, dim1 , {dramount}, actrow)-sumtill( {dim1}, dim1 , {cramount}, actrow)
dim1 = CRP
actrow = 2
Result of sumtill = 36980.708
dim1 = CRP
actrow = 2
Result of sumtill = 0
Refresh Field Value - -36980.708
Refresh Field - investactual Row No 2
Evaluating - investactual1+investactsum
investactual1 = 0.000
investactsum = -36980.708
Refresh Field Value - -36980.708
Refresh Field - glactsum Row No 2
Evaluating - sumtill( {accountname}, accountname , {dramount}, actrow)-sumtill( {accountname}, accountname, {cramount}, actrow)
accountname = RECOVERABLE TEMP ACCOUNT | 222007
actrow = 2
Result of sumtill = 36980.708
accountname = RECOVERABLE TEMP ACCOUNT | 222007
actrow = 2
Result of sumtill = 0
Refresh Field Value - -36980.708
Refresh Field - glactual Row No 2
Evaluating - glactual1+glactsum
glactual1 = 0.000
glactsum = -36980.708
Refresh Field Value - -36980.708
Refresh Field - accountcurrency Row No 2
Refresh Field Value - BD
accountcurrency = BD
m_basecurrency = BD
dramount = 0.000
dramount = 0.000
sexchange_rate = 1
Result of iif = 0.000
accountcurrency = BD
m_basecurrency = BD
cramount = 36980.708
cramount = 36980.708
sexchange_rate = 1
Result of iif = 36980.708
category = 1
ncramount = 36980.708
ndramount = 0
Result of iif = 0
category = 1
ndramount = 0
ncramount = 36980.708
Result of iif = 0
postarap = 0
Result of iif = 0
arapamount = 0.000
Result of iif = F
category = 1
Result of iif = F
voucher_date = 12/05/2023
branchid = 21259000000000
Refresh Field - validrow2 Row No 2
Evaluating - iif( (ndramount + ncramount )= 0, {F},{T})
ndramount = 0
ncramount = 36980.708
Result of iif = T
Refresh Field Value - T
Refresh Field - sendtosite Row No 1
Refresh Field Value -
Refresh Field - sendtransid Row No 1
Refresh Field Value -
Result of total = 36980.708
Result of total = 36980.708
Result of total = 36980.708
Result of total = 36980.708
Refresh Field - roundoffaccount Row No 1
select a.mnamedisplay from master a,financesetup b where a.masterid = b.roundupaccount
Time elapsed = 31
Refresh Field Value - FOREIGN EXCHANGE DIFFEENCE | 440001
totaldramount = 36980.708
totalcramount = 36980.708
Result of iif = F
totaldramount = 36980.708
totalcramount = 36980.708
Result of abs = 0
totaldramount = 36980.708
totalcramount = 36980.708
Result of iif = 0
totaldramount = 36980.708
totalcramount = 36980.708
totaldramount = 36980.708
totalcramount = 36980.708
Result of iif = 0
Refresh Field - saveflag Row No 1
Evaluating - IIF ( totalndramount = totalncramount & totalndramount # 0, {T}, {Debits and Credits are not matching OR No Entries Made. Invalid Transaction})
totalndramount = 36980.708
totalncramount = 36980.708
totalndramount = 36980.708
Result of iif = T
Refresh Field Value - T
Refreshing nonsave fields during loading over
>>Writing to database tables acdet record 1154660000121
select cancel,cancelremarks,username,modifiedon from accountshdr where accountshdrid=0
Time elapsed = 32
Cancelling in accountshdr
Param Type = c
cancel=T
Param Type = c
username=admin
Param Type = c
modifiedon=11/10/2023 08:27:02
update accountshdr set cancel=:cancel,cancelremarks=null,username=:username,modifiedon=to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss')
where accountshdrid=1154660000121
select cancel,cancelremarks,username,modifiedon from accountsdtl where accountsdtlid=0
CDS Open Error Msg : csd query : select cancel,cancelremarks,username,modifiedon from accountsdtl where accountsdtlid=0 $ Error msg : ORA-00904: "MODIFIEDON": invalid identifier
uXDS\open\ Exceptio ORA-00904: "MODIFIEDON": invalid identifier
select cancel,cancelremarks,username,modifiedon from accountshdr where accountshdrid=0
Time elapsed = 31
Cancelling in accountshdr
Param Type = c
cancel=T
Param Type = c
username=admin
Param Type = c
modifiedon=11/10/2023 08:27:02
update accountshdr set cancel=:cancel,cancelremarks=null,username=:username,modifiedon=to_date(:modifiedon,'dd/mm/yyyy hh24:mi:ss')
where accountshdrid=1154660000121
RollBack Transaction
RollBack Transaction Status : -1
End of RollBack Transaction
RollBack Transaction Status : 0
Error in Executing task cancel transaction
Creating message node
Error in cancellation.
ORA-20119: Transaction cannot be cancelled as transaction period is closed !!!
ORA-06512: at "BAFCOTESTING.TRG_UPDT_ACCOUNTSHDR_CANCEL", line 25
ORA-04088: error during execution of trigger 'BAFCOTESTING.TRG_UPDT_ACCOUNTSHDR_CANCEL'
insert into axerrorlog values('admin',to_date('11/10/2023 08:27:02','dd/mm/yyyy hh24:mi:ss'),'Action Call','','')
Time elapsed = 31
delete from Axp_TransCheck where sessionid = 'tnqvdqoffaj1sxxfw5emp4ub'
Time elapsed = 32
Result : {"result":[{"action": "retry"}]}*$*{"error":[{"msg":"Error in cancellation.
ORA-20119: Transaction cannot be cancelled as transaction period is closed !!!
ORA-06512: at ^^dqBAFCOTESTING.TRG_UPDT_ACCOUNTSHDR_CANCEL^^dq, line 25
ORA-04088: error during execution of trigger 'BAFCOTESTING.TRG_UPDT_ACCOUNTSHDR_CANCEL'"}]}
[Compiled on 08/12/2022 01:29:00 AM] [File Version : 11.1.0.0]] [Product Version : 11.1][64Bit(0712)]
Time Used : 106.003352101331 secs
Freeing DbCall Resources
Freeing Store data
Freeing DD Map
Freeing Provide Link
Freeing Validate
Freeing Parser
Freeing Poststr
Freeing Maxrows
Freeing Fnames
Freeing NewMaxRows
Freeing tlines
Freeing workquery
Freeing Struct
Freeing EventList
Freeing Tree Obj
Freeing Workflow Obj
Done - Workflow Obj
Freeing DbCall Completed
Freeing Action Obj Resources
# 1#Saving to log
Param Type = c
sessionid=tnqvdqoffaj1sxxfw5emp4ub
Param Type = c
username=admin
Param Type = c
calledon=11/10/2023 08:27:01
Param Type = c
callfinished=11/10/2023 08:28:02
Param Type = c
structname=rcinv
Param Type = n
recordid=0
Param Type = c
servicename=Executing Action
Param Type = c
serviceresult=Error in cancellation.
ORA-20119: Transaction cannot be cancelled as transaction period is closed !!!
ORA-06512: at "BAFCOTESTING.TRG_UPDT_ACCOUNTSHDR_CANCEL", line 25
ORA-04088: error during execut
Param Type = n
timetaken=61418
Param Type = n
dbtimetaken=5278
Param Type = n
db_conntime=482
insert into axpertlog (sessionid,username,calledon,callfinished,structname,recordid,servicename,serviceresult,timetaken,dbtimetaken,db_conntime) values (:sessionid,:username,to_date(:calledon,'dd/mm/yyyy hh24:mi:ss'),to_date(:callfinished,'dd/mm/yyyy hh24:mi:ss'),:structname,:recordid,:servicename,:serviceresult,:timetaken,:dbtimetaken,:db_conntime)
Closing connection
Freeing AxProvider Resources
Destroying License Manager
Destroying License Manager XDS
Destroying License Manager Completed
Freeing DbManager Resources
Destroying Default xds in db manager
Destroying connect object
Disconnecting from db bafcotesting
Keep Connection setting false
Disconnecting...
Disconnected...
Dbx name =
ConnectionName =
DriverName =
GetDriverFunc =
LibraryName =
VendorLib =
Successfully disconnected from db bafcotesting
Destroyed connect object
Destroying GF