Skip to Content

Query for Packing Label.

Dear Experts,

Greetings from India.

Am learning to create Crystal reports from SAP B1 and trying to create a first layout for a packing label. Though query is good enough and fetching results in SAP, cannot generate code in CR. Can anyone guide me?

SELECT distinct T0.[DocNum], T0.[CardName], T1.[GSTRegnNo], T1.[GSTType], T2.[StreetS], T2.[BlockS], T2.[CityS], T2.[ZipCodeS], T3.[Name], T4.[Name] FROM OINV T0 inner join CRD1 T1 on T0.CardCode=T1.CardCode INNER JOIN INV12 T2 ON T0.[DocEntry] = T2.[DocEntry] INNER JOIN OCST T3 ON T2.[StateS] = T3.[Code] INNER JOIN OCRY T4 ON T2.[CountryS] = T4.[Code] WHERE T0.[DocNum] =[%0] and T0.[Series] =504

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers