TAX CODE

TAX CODE

(1)Tax Formula

                                  (2)  Tax Types

                                                                (3)     Tax Type Combination

                                                                                                                     (4)      Tax Codes

Tax Code:-I am going to create this Tax code BED 12.5%+ VAT 5% (VAT 4% + AVAT 1%)

BED 12.5%+ VAT 5% (VAT 4% + AVAT 1%)

Now create Tax Type

ADDVAT--------now create ADDVAT Attributes like ADDITIONAL VAT@1%

VAT-----------------VAT Attributes like VAT@4%

BED----------------BED Attributes like BED @ 12.5%

(1)Tax Type

 

 

Now Tex Type combinationL  (2)

(3)

 

(4)

TAX FORMULA

Crystal Reports Query For SAP Business one 

(1) Select Ordr.CardCode,ordr.cardname,Ordr.DocDate,Ordr.DocDueDate,RDR1.Weight1,Ordr.DocNum,
RDR1.Dscription,RDR1.PriceAfVAT,RDR1.PriceBefDi,ORDR.VatSum,ORDR.DiscPrcnt,ORDR.DiscSum,
RDR1.ItemCode,RDR1.Quantity,ORDR.DocTotal,ordr.Address
,ordr.Address2

from ORDR INNER JOIN RDR1 ON ORDR.DocEntry = RDR1.DocEntry where DocNum='100031';

(2) Select DocEntry from ORDR where DocNum='100026'

(3)Purchase Data

SELECT  OPOR.DocEntry,OPOR.docnum,NNM1.SeriesName,OPOR.Cardcode,OCRD.Cardname,OPOR.Address2,OPOR.Address ,oPOR.docdate, OPOR.DocDueDate,

(Select Top 1 CRD7.Taxid2 from CRD7 where CRD7.Cardcode = OCRD.Cardcode and CRD7.Taxid2 is not null) as Cust_VAT_No,
(Select Top 1 CRD7.Taxid3 from CRD7 where CRD7.Cardcode = OCRD.Cardcode and CRD7.Taxid3 is not null) as Cust_CST_No,
(Select Top 1 CRD7.taxid11 from CRD7 where CRD7.Cardcode = OCRD.Cardcode and CRD7.Taxid11 is not null) as Cust_TIN_No,
OPOR.DocDate as iss_Date,OPOR.Footer,OCPR.Name,
OSHP.TrnspName,OCTG.PymntGroup,OPOR.Comments,

OPOR.NumAtCard as OrderNo_date,
POR1.ItemCode ,POR1.Dscription as Item_Name,POR1.Quantity ,POR1.Price as Ass_Value_Per_Unit,POR1.LineTotal,POR1.DiscPrcnt,
odln.docnum as DC_No ,odln.docdate as DC_Date,OITM.INUoMEntry,ochp.ChapterID ,octg.PymntGroup,

(Select distinct isnull(POR4.taxrate,0) from POR4 where POR4.statype=-90 and POR4.docentry=OPOR.Docentry  )As "RATEBED@12.5",
(Select distinct isnull(Sum(POR4.taxsum),0) from POR4 where POR4.statype=-90 and POR4.docentry=OPOR.Docentry  )BED@125,


(Select distinct isnull(POR4.taxrate,0) from POR4 where POR4.statype=1 and POR4.docentry=OPOR.Docentry  )RATEVAT@4,
(Select distinct isnull(Sum(POR4.taxsum),0) from POR4 where POR4.statype=1 and POR4.docentry=OPOR.Docentry )VAT@4,

(Select distinct isnull(POR4.taxrate,0) from POR4 where POR4.statype=7 and POR4.docentry=OPOR.Docentry  )RATEADDVAT@1,
(Select distinct isnull(Sum(POR4.taxsum),0) from POR4 where POR4.statype=7 and POR4.docentry=OPOR.Docentry )ADDVAT@1,
(Select distinct isnull(POR4.taxrate,0) from POR4 where POR4.statype=4 and POR4.docentry=OPOR.Docentry  )RATECST@2,
(Select distinct isnull(Sum(POR4.taxsum),0) from POR4 where POR4.statype=4 and POR4.docentry=OPOR.Docentry )CST@2,
POR12.Transcat,OPOR.DocTotal,
(Select Top  1 State from CRD1 where CRD1.State is not null and CRD1.CardCode = OPOR.CardCode ) as Party_State,
(Select Top 1 ORDR.Taxdate from ORDR INNER Join DLN1 ON ORDR.DocEntry = DLN1.BaseEntry where DLN1.DocEntry = POR1.BaseEntry  ) as ORDR_Date,
OITM.FrgnName as part_No,N.SeriesName as Series_Name,OPOR.Header as Header,oitm.FrgnName,OPOR.TaxDate,OPRQ.DocNum AS 'INDNO' ,OPRQ.DocDate AS 'INDDATE',OCPR.Name,
PRQ1.Quantity as 'INDQTY',POR12.FormNo,OITM.InvntryUom,POR1.Text


FROM         OPOR INNER JOIN
                      POR1 ON OPOR.DocEntry = POR1.DocEntry INNER JOIN
                      OITM ON POR1.ItemCode = OITM.ItemCode LEFT OUTER JOIN
                      OCTG ON OPOR.GroupNum = OCTG.GroupNum LEFT OUTER JOIN
                      OCPR ON OPOR.cntctcode = OCPR.cntctcode LEFT OUTER JOIN
                      OSHP ON OPOR.TrnspCode = OSHP.TrnspCode INNER JOIN
                      OCRD ON OCRD.Cardcode = OPOR.Cardcode INNER JOIN
                      NNM1 ON OPOR.Series = NNM1.Series LEFT OUTER JOIN
                      POR12 ON OPOR.Docentry = POR12.Docentry LEFT OUTER JOIN
                      ODLN ON POR1.BaseEntry = ODLN.DocEntry LEFT OUTER JOIN
                      NNM1 N ON ODLN.Series = N.Series LEFT OUTER JOIN
                      OCHP ON OCHP.absentry = oitm.ChapterID LEFT OUTER JOIN
                      PRQ1 ON PRQ1.DocEntry = POR1.BaseEntry AND PRQ1.ItemCode = POR1.ItemCode
                      LEFT OUTER JOIN OPRQ ON OPRQ.DocEntry = PRQ1.DocEntry LEFT OUTER JOIN
                      OUSR ON OUSR.USERID = OPOR.UserSign          
                    
where  OPOR.DocEntry=  {?DocKey@}