แก้ไขรายงานภาษีซื้อ
โพสต์แล้ว: จันทร์ ธ.ค. 10, 2012 4:04 pmผมแก้รายงานภาษีซื้อ(การเงิน /4/1) ที่ ;7 รายละเอียดเช็ค วันทีเช็คผ่าน ที่มาจากสมุดรายวันPV ออกมาถุกต้อง
แต่~BANK1 ~BRANCH1 ~REMARK ไม่แสดงออก
Ih:: ;7 bktrnh->voucher isvat->docnum ;7
Ib: ##àªç¤# ~CHQNUM1 ~CHQDAT1 ~CHQAMT1 ~BANK1 ~BRANCH1 ~REMARK ;7
Ib: ~CHQSTAT1 ~PASSDAT1 ~BANK1 ;7
[master file]
File=ISVAT
Alias=A
Tag=ISVAT2
System=DATA_PATH
[item file]
File=BKTRN
Alias=B
Tag=BKTRN13
System=DATA_PATH
Filter=CHQSTAT#'20'.AND.CHQSTAT#'22'
File=bkmas
Alias=XD
Tag=bkmas1
System=DATA_PATH
[relate file]
File=bktrnh
Clone From=bktrn
Alias=AX
Tag=bktrn13
System=DATA_PATH
Master file=ISVAT
Master-Related field=VOUVHER
File=bkmash
Clone From=BKMAS
Alias=XS
Tag=bkmas1
System=DATA_PATH
Master file=BKTRNH
Master-Related Field=BNKACC
~CHQNUM1: 0, "", "BKTRNH->CHQNUM", ""
~CHQDAT1: 0, "", "BKTRNH->CHQDAT", ""
~CHQAMT1: 0, "999,999,999.99", "BKTRNH->AMOUNT", ""
~BANK1: 0, "", "Bank", "Bank = @p_istab(BKTRNH->BNKCOD,01,0,10); bank=IIF(BKTRNH->BKTRNTYP='QR',bank+' ',SUBSTR(BKMASH->SHORTNAM,1,10))"
~BRANCH1: 0, "", "Branch", "Branch = IIF(BKTRNH->BKTRNTYP='QR',BKTRNH->BRANCH,' ')"
~REMARK1: 0, "", "BKTRNH->REMARK", ""
~BANKX: 0, "", "bankx", "bankx = BKMASH->BNKNAM - ' (ÊÒ¢Ò' - BKMASH->BRANCH -')'; abb_bank = BKMASH->SHORTNAM"
~CHQSTAT1: 0, "", "p_istab( BKTRNH->CHQSTAT, 02, 1, 13 )", ""
~PASSDAT1: 0, "", "pass_dat", "pass_dat=IIF(BKTRNH->CHQSTAT='1',BKTRNH->TRNDAT,STOD(' '))"
แต่~BANK1 ~BRANCH1 ~REMARK ไม่แสดงออก
Ih:: ;7 bktrnh->voucher isvat->docnum ;7
Ib: ##àªç¤# ~CHQNUM1 ~CHQDAT1 ~CHQAMT1 ~BANK1 ~BRANCH1 ~REMARK ;7
Ib: ~CHQSTAT1 ~PASSDAT1 ~BANK1 ;7
[master file]
File=ISVAT
Alias=A
Tag=ISVAT2
System=DATA_PATH
[item file]
File=BKTRN
Alias=B
Tag=BKTRN13
System=DATA_PATH
Filter=CHQSTAT#'20'.AND.CHQSTAT#'22'
File=bkmas
Alias=XD
Tag=bkmas1
System=DATA_PATH
[relate file]
File=bktrnh
Clone From=bktrn
Alias=AX
Tag=bktrn13
System=DATA_PATH
Master file=ISVAT
Master-Related field=VOUVHER
File=bkmash
Clone From=BKMAS
Alias=XS
Tag=bkmas1
System=DATA_PATH
Master file=BKTRNH
Master-Related Field=BNKACC
~CHQNUM1: 0, "", "BKTRNH->CHQNUM", ""
~CHQDAT1: 0, "", "BKTRNH->CHQDAT", ""
~CHQAMT1: 0, "999,999,999.99", "BKTRNH->AMOUNT", ""
~BANK1: 0, "", "Bank", "Bank = @p_istab(BKTRNH->BNKCOD,01,0,10); bank=IIF(BKTRNH->BKTRNTYP='QR',bank+' ',SUBSTR(BKMASH->SHORTNAM,1,10))"
~BRANCH1: 0, "", "Branch", "Branch = IIF(BKTRNH->BKTRNTYP='QR',BKTRNH->BRANCH,' ')"
~REMARK1: 0, "", "BKTRNH->REMARK", ""
~BANKX: 0, "", "bankx", "bankx = BKMASH->BNKNAM - ' (ÊÒ¢Ò' - BKMASH->BRANCH -')'; abb_bank = BKMASH->SHORTNAM"
~CHQSTAT1: 0, "", "p_istab( BKTRNH->CHQSTAT, 02, 1, 13 )", ""
~PASSDAT1: 0, "", "pass_dat", "pass_dat=IIF(BKTRNH->CHQSTAT='1',BKTRNH->TRNDAT,STOD(' '))"