DEAR EXPERTS, I HAVE CREATED PACKING CHARGE MODULE IN TALLY ERP9 REL 5.1.2. THE PROBLEM IS EXCISE NOT CALCULATED ON PACKING CHARGE. PLEASE HELP
Mr. Kishan For Excise purpose we use to SET Packing Charges for Assessable Value Calculation in ledger master. So i think you should think on that basis to achieve your result. For that you need to allocate your UDF Pack amount to Packing Ledger master. Until that you can't get the packing forwarding added in excise assessable value. The screenshot is as follows :-
You are right Sir, but i want pack charge by itemwise, that's why i need to fix this tdl, Please Can yo help me
sir, i am using pre defined ledger in sales voucher. sgst@2.5 cgst@2.5 sgst@6 cgst@6 sgst@9 cgst@9 sgst@14 cgst@14 igst@5 igst@12 igst@18 igst@28 round off i want only using ledgers in sales voucher ex: if i sale the one 5% stock item in local state sgt2.5 and cgst2.5 will take automatically.Remining ledgers also = 0 when i take print out it will show all ledgers. i want only ledgers witch is amount. here is my code............. [Part:OTSLedgerEnteries] Line:OTSLedgerEnteries Repeat:OTSLedgerEnteries:Ledger Entries Border: Thick Left Common Border: Yes ;Scroll: Vertical Float: No [Line:OTSLedgerEnteries] Field: OTSLedgerName, OTSLedgerPercentage,OTSPercentageSing, OTSLedgerAmount Remove if: $LedgerName = $PartyLedgerName Remove if :$Ledger amount=0 [Field:OTSLedgerName] Set as : if ##SATCSDetails AND @@TaxLedgerHasTCS then $$LocaleString:"TCS : Income Tax" else + if NOT $$IsSysName:$LedgerName then $LedgerName else "" ;;; used to print on invoice Style9B Align : Right FullWidth : Yes AbatementVal: If $$Number:$STXAbatementRate = 0 Then $$String:"0" Else $$String:$STXAbatementRate LedNarr : (@@IsSales AND ##SALedgerNarr) OR (@@IsPurchase AND ##PULedgerNarr) AND $$Filtercount:LedgerEntries:LedgerNarrFltr > 0 Option : LeftAlignField : @@AcctsInvoice Width:16 [Field:OTSLedgerPercentage] Use : Rate Price Field Type : Number Align : Right Format : "NoZero,Decimals:-1" Style9 Set as : if ##SATCSDetails AND @@TaxLedgerHasTCS AND NOT $$IsSysName:$TDSRateName:Ledger:$LedgerName then @@TCSITTaxRate else + $BasicRateOfInvoiceTax Inactive : $$IsSysName:$LedgerName Invisible : NOT @@InvWithRate Width: 4 [Field:OTSPercentageSing] Set as:if $$IsEmpty:$BasicRateOfInvoiceTax then "" else "%" Set By Condition : @@TaxLedgerHasTCS AND NOT ($$IsSysName:$TDSRateName:Ledger:$LedgerName) : If $$IsEmpty@TCSITTaxRate Then "" Else "%" Inactive : $$IsSysName:$LedgerName Invisible : NOT @@InvWithRate Width: 2 Style9 [Field:OTSLedgerAmount] Use : Amount Forex Field Set as : $$SignedAmount:$Amount@VchOpposite Border: Thick Left Align: Right Width: 10 Style9
use following code in all line defined in report Code: remove if : $$isEmpty:##Fieldname This will remove the zero value entries as desired.
sir, as per your suggestion i am getting like this error [Part:OTSLedgerEnteries] Line:OTSLedgerEnteries Repeat:OTSLedgerEnteries:Ledger Entries Border: Thick Left Common Border: Yes ;Scroll: Vertical Float: No [Line:OTSLedgerEnteries] Field: OTSLedgerName, OTSLedgerPercentage,OTSPercentageSing, OTSLedgerAmount Remove if: $LedgerName = $PartyLedgerName remove if : $$isEmpty:##Fieldname [Field:OTSLedgerName] Set as : if ##SATCSDetails AND @@TaxLedgerHasTCS then $$LocaleString:"TCS : Income Tax" else + if NOT $$IsSysName:$LedgerName then $LedgerName else "" ;;; used to print on invoice Style9B Align : Right FullWidth : Yes AbatementVal: If $$Number:$STXAbatementRate = 0 Then $$String:"0" Else $$String:$STXAbatementRate LedNarr : (@@IsSales AND ##SALedgerNarr) OR (@@IsPurchase AND ##PULedgerNarr) AND $$Filtercount:LedgerEntries:LedgerNarrFltr > 0 Option : LeftAlignField : @@AcctsInvoice Width:16 [Field:OTSLedgerPercentage] Use : Rate Price Field Type : Number Align : Right Format : "NoZero,Decimals:-1" Style9 Set as : if ##SATCSDetails AND @@TaxLedgerHasTCS AND NOT $$IsSysName:$TDSRateName:Ledger:$LedgerName then @@TCSITTaxRate else + $BasicRateOfInvoiceTax Inactive : $$IsSysName:$LedgerName Invisible : NOT @@InvWithRate Width: 4 [Field:OTSPercentageSing] Set as:if $$IsEmpty:$BasicRateOfInvoiceTax then "" else "%" Set By Condition : @@TaxLedgerHasTCS AND NOT ($$IsSysName:$TDSRateName:Ledger:$LedgerName) : If $$IsEmpty@TCSITTaxRate Then "" Else "%" Inactive : $$IsSysName:$LedgerName Invisible : NOT @@InvWithRate Width: 2 Style9 [Field:OTSLedgerAmount] Use : Amount Forex Field Set as : $$SignedAmount:$Amount@VchOpposite Border: Thick Left Align: Right Width: 10 Style9 [Part:OTSInvoiceAmtwordandamount] Left Part: OTSAmountinWord Right Part:OTSInvoiceAmount Border: Thick Cover Common Border: Yes [Part:OTSAmountinWord] Line:OTSAmountinWord [Line:OTSAmountinWord] Field: Medium Prompt, Name Field Local: Field: Medium Prompt: Set as: "Amount In Words" Local: Field: Medium Prompt:Style9B Local: Field: Name Field: Set as:$$InWords:$Amount +" "+ "Only." Local: Field: Name Field: Full Width: Yes Local: Field: Name Field: Line:0 Local: Field: Name Field:Style9 Space Top:0.25 Space Bottom:0.25
Thank you very much sir,but Party A/c Name was Came. please Rectify. upload file cant availability. in this sgsg and cgst place . party name also comming. [Line:OTSLedgerEnteries] Field: OTSLedgerName, OTSLedgerPercentage,OTSPercentageSing, OTSLedgerAmount Remove if: $LedgerName = $PartyLedgerName Remove if : $$isEmpty:$$SignedAmount:$Amount@VchOpposite
I want print FREIGHT below Items details in description with HSN code and also remove from Bill sundry. what can i do? Please help me in this regard. Thanks in Advance