cancel
Showing results for 
Search instead for 
Did you mean: 

Query for Packing Label.

former_member224264
Participant
0 Kudos

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

Accepted Solutions (0)

Answers (0)