cancel
Showing results for 
Search instead for 
Did you mean: 

Query

Former Member
0 Kudos

Hi

Scenario is if series 2009 is selected then VAT,CST should be displayed in Tax Codes , if series B is selected then BED10,BEd8 should be listed in Tax Codes.

Thanks

Accepted Solutions (1)

Accepted Solutions (1)

former_member325312
Active Contributor
0 Kudos

Hi Manish

I was trying u r query only but we r not maintiaing any refernce of series nos in OSTC table so there is no possibility of getting According to Series Numbers As Input......

but i have wrote Individually

SELECT CODE,NAME FROM OSTC

WHERE CODE like 'V%' OR CODE like 'C%'

in this if we r maining series nos then we can get seperately but there is no chance ..............

regards

Jenny

Answers (2)

Answers (2)

Former Member
0 Kudos

Closed.

former_member325312
Active Contributor
0 Kudos

Hi Manish

1).this is only for VAT And CST

SELECT T0.[DocNum], T0.[DocDate], T0.[CardCode], T0.[CardName], T1.[ItemCode],

T1.[Dscription], T1.[Quantity],T1.[TaxCode]

FROM OPCH T0 INNER JOIN PCH1 T1 ON T0.DocEntry = T1.DocEntry

WHERE T0.[Series] =[%0] and T1.[TaxCode] like 'V%' or T1.[TaxCode] like 'C%'

2).this is only for Bed10,Bed8

SELECT T0.[DocNum], T0.[DocDate], T0.[CardCode], T0.[CardName], T1.[ItemCode],

T1.[Dscription], T1.[Quantity],T1.[TaxCode]

FROM OPCH T0 INNER JOIN PCH1 T1 ON T0.DocEntry = T1.DocEntry

WHERE T0.[Series] =[%0] and T1.[TaxCode] like 'B%'

i think this vil solve ur problem.......

But i will Try Meanwhile to combine and make a single query

regards

Jenny

Former Member
0 Kudos

Hi Jenny

My requirement is when i select A series then it should list only Vat,CST Tax Codes in A/R Invoice rows Tax Code column , if i select B series then it should display only BED* tax codes in A/r Invoice rows tax Code column

Thanks