No vat amount shown in this code..please help ============================== ; [#Part: EXPSMP AccDetails] ; Add : Lines : At End : EXPSMP AccRounOffDetails [#Line: EXPSMP AccDetails] Empty : $$IsEmpty:$Amount AND $RemoveZeroEntries OR @@TaxLedgerHasService OR @@IsVATCSTLed OR @@IsVATSurLed Or ($LedgerName = $PartyLedgerName) [Line : EXPSMP AccRounOffDetails] Use : EXPSMP AccDetails Delete : Explode Delete : Empty Delete : Option Local : Field : EXPINV AccDesc : Set as : "Rounded Off" Local : Field : EXPINV AccAmount : Set as : $Amount-($$CollAmtTotal:InventoryEntries:$Amount) ; [#Part: EXPINV AccInfo] ; Add : Lines : At End : EXPINV AccRounOffDetails [#Line: EXPINV AccDetails] Empty : $$IsEmpty:$Amount AND $RemoveZeroEntries OR @@IsVATCSTLed OR @@IsVATSurLed Or ($LedgerName = $PartyLedgerName) [Line : EXPINV AccRounOffDetails] Use : EXPINV AccDetails Delete : Explode Delete : Empty Delete : Option Local : Field : EXPINV AccDesc : Set as : "Rounded Off" Local : Field : EXPINV AccAmount : Set as : $Amount-($$CollAmtTotal:InventoryEntries:$Amount) [#Line: EXPINV Column1] Add : Right Field : Before : EXPINV AmountTitle : SAPP TOTAmt, SAPP VATAmt Local : Field : SAPP TOTAmt : Info : "Amount" ; change the name Local : Field : SAPP VATAmt : Info : "VAT Amt" [#Line: EXPINV Column2] Add : Right Field : Before : EXPINV AmountTitle : SAPP TOTAmt, SAPP VATAmt Local : Field : SAPP TOTAmt : Info : "" Local : Field : SAPP VATAmt : Info : "" [#Part: EXPINV Details] Total : SAPP VATAmt, SAPP TOTAmt [#Part: EXPINV InvInfo] Total : SAPP VATAmt, SAPP TOTAmt [#Part: EXPINV AccInfo] Total : SAPP VATAmt, SAPP TOTAmt [#Line: EXPINV InvDetails] Add : Right Field :Before: EXPINV Amount : SAPP TOTAmt, SAPP VATAmt Local : Field : EXPINV Amount : Set as: #SAPPTOTAmt + #SAPPVATAmt ;; Local : Field : SAPP TOTAmt : Set As: $AdditionalDetails.Amount ;[Report: MyReport];;;;;;;;;;;;;;;;;;;;;;;;;;;;new line [Field: SAPP TOTAmt] Use : Amount Field Style : Normal Bold Set as : $Amount Border : Thin Left [Field: SAPP VATAmt] Use : Amount Field ;Number Field Style : Normal Bold Set as : $$VATAmt Border : Thin Left [#Line: EXPINV InvSubTotal] Add : Right Fields: Before : EXPINV ValueSubTotal : SAPP TOTAmt, SAPP VATAmt Local : Field : EXPINV ValueSubTotal : Set as : "" Local : Field : SAPP VATAmt : Set as : "" Local : Field : SAPP TOTAmt : Set as : "" [#Line: EXPINV AccDetails] Add : Right Field : Before : EXPINV AccAmount : SAPP TOTAmt, SAPP VATAmt Local : Field : SAPP VATAmt : Set as : "" Local : Field : SAPP TOTAmt : Set as : "" [#Line: EXPINV Totals] Add : Right Field : Before : EXPINV Total : SAPP TOTAmt,SAPP VATAmt Local : Field : SAPP VATAmt : Set as : $$Total:SAPPVATAmt Local : Field : SAPP TOTAmt : Set as : $$Total:SAPPTOTAmt [System: Formula] SAPPVatFilter : @@IsVATCSTLedTube ;$LedgerName Contains "VAT" ;$TaxType:Ledger:$LedgerEntries[1].LedgerName = "VAT" SAPPCSTFilter : @@IsVATSurLedTube ;$LedgerName Contains "CST";$TaxType:Ledger:$LedgerEntries[1].LedgerName= "CST" SAPPVATCSTFilter : @@SAPPVatFilter OR @@SAPPCSTFilter IsVATCSTLed : $LedgerName Contains "Vat" or $LedgerName Contains "CST" ;@@InvoiceVATLedger OR @@InvoiceCSTLedger IsVATSurLed : $LedgerName Contains "Surcharge" SAPVATPer : $$FilterValue:$BasicRateofInvoiceTax:LedgerEntries:1:IsVATCSTLed ;IF $$IsEmpty:$$FilterValue:$BasicRateofInvoiceTax:LedgerEntries:1:IsVATCSTLed Then $$Number:0 Else $$FilterValue:$BasicRateofInvoiceTax:LedgerEntries:1:IsVATCSTLed SAPVATSurPer : $$FilterValue:$BasicRateofInvoiceTax:LedgerEntries:1:IsVATSurLed ;IF $$IsEmpty:$$FilterValue:$BasicRateofInvoiceTax:LedgerEntries:1:IsVATSurLed Then $$Number:0 Else $$FilterValue:$BasicRateofInvoiceTax:LedgerEntries:1:IsVATSurLed
