Description |
Log in to Customer: Alabama Farmers as irelyadmin/i21by2015/01
Go to Panels / Grain Valuation Test Panel
Click Query Builder
Query Tab throws 404.15 error (see screenshot)
!pastedImage_d24662_0.png!
This is running a long, very complex query with many substrings and sums:
Select
SubString(Cast(gacntmst.gacnt_cnt_rev_dt As CHAR), 5, 2) + '-'
+ SubString(Cast(gacntmst.gacnt_cnt_rev_dt As CHAR), 7, 2) + '-'
+ SubString(Cast(gacntmst.gacnt_cnt_rev_dt As CHAR), 1, 4) As ContractDate1,
gacntmst.gacnt_cus_no As Customer, gacntmst.gacnt_pur_sls_ind,
SubString(Cast(gacntmst.gacnt_bot_option As varCHAR), 1, 3) + ' '
+ SubString(Cast(gacntmst.gacnt_bot_option As varCHAR), 4, 2),
Sum(gacntmst.gacnt_un_bot_prc) As Price,
Sum(gacntmst.gacnt_un_bal * gacntmst.gacnt_un_bot_prc) As 'Extended Amount',
Sum(gacntmst.gacnt_un_bal * gacntmst.gacnt_un_bot_prc) / Sum(gacntmst.gacnt_un_bal) As WAP,
Sum(gacntmst.gacnt_un_bal * gacntmst.gacnt_un_bot_basis) / Sum(gacntmst.gacnt_un_bal) As WAB,
Sum(gacntmst.gacnt_un_bal * gacntmst.gacnt_un_frt_basis) / Sum(gacntmst.gacnt_un_bal) As WAF,
gacntmst.gacnt_com_cd, Sum(gacntmst.gacnt_un_bal) As Balance,
gacntmst.gacnt_cnt_no, gacntmst.gacnt_bot_option, gacntmst.gacnt_cnt_no, gacntmst.gacnt_loc_no,
gacntmst.gacnt_no_un, gacntmst.gacnt_signed_yn, gacntmst.gacnt_beg_ship_rev_dt, gacntmst.gacnt_remarks_4
From gacntmst
Group By
SubString(Cast(gacntmst.gacnt_cnt_rev_dt As CHAR), 5, 2) + '-'
+ SubString(Cast(gacntmst.gacnt_cnt_rev_dt As CHAR), 7, 2) + '-'
+ SubString(Cast(gacntmst.gacnt_cnt_rev_dt As CHAR), 1, 4),
gacntmst.gacnt_cus_no, gacntmst.gacnt_pur_sls_ind,
SubString(Cast(gacntmst.gacnt_bot_option As varCHAR), 1, 3) + ' '
+ SubString(Cast(gacntmst.gacnt_bot_option As varCHAR), 4, 2),
gacntmst.gacnt_com_cd, gacntmst.gacnt_cnt_no, gacntmst.gacnt_bot_option, gacntmst.gacnt_loc_no,
gacntmst.gacnt_no_un, gacntmst.gacnt_signed_yn, gacntmst.gacnt_beg_ship_rev_dt, gacntmst.gacnt_remarks_4
Having Sum(gacntmst.gacnt_un_bal) > '0.000'
Order By gacntmst.gacnt_com_cd, gacntmst.gacnt_loc_no
|