i have try this code for Mrp [Field:SCS MRP Qty] Use:Rate Field Set as : @MRPRateSetVal Set Always : Yes Skip : Yes MRPRateSetVal : If $$IsEnd:$StockItemName Then "" Else + If NOT $$IsEmpty:$MRPRate Then $MRPRate + Else If $$IsEmptylocPartyStateName OR $$IsSysNamelocPartyStateName Then $$GetEIStkItemMRP:$StockItemName:$Date Else + $$GetEIStkItemMRP:$StockItemName:$DatelocPartyStateName locPartyStateName: $$BaseOwner:$VATPartyLedState Inactive : $$IsEnd:$StockItemName OR $$IsSysName:$BaseUnits:StockItem:$StockItemName OR $$IsEmptyMRPRateSetVal
HI Sir Try this below code Before this need to enable VAT Details in F11 --> F3 Features [Field: EXPINV MRPValue] Use : EXPINV MRPTitle Set Always : Yes Align : Right Set as : @MRPRateSetVal ;;$MRPRate Set Always : Yes Skip : Yes MRPRateSetVal : If $$IsEnd:$StockItemName Then "" Else + If NOT $$IsEmpty:$MRPRate Then $MRPRate + Else If $$IsEmptyPartyStateName OR $$IsSysNamePartyStateName Then $$GetEIStkItemMRP:$StockItemName:$Date Else + $$GetEIStkItemMRP:$StockItemName:$DatePartyStateName PartyStateName : If @@IsGSTOnAndAppl Then $$BaseOwner:$GSTVchPartyState Else $$BaseOwner:$VATPartyLedState
please correct my code [Field:SAS Item Description] Use: Simple Field Set as: if NOT $$IsSysName:$StockItemName then @@InvItemName else + "Mrp : "+ @MRPRateSetVal Width: 35 Line:0
[#Field: EXPINV MRPTitle] Use : Name Title Field Width: @@NameWidth - 15 Info : $$LocaleString:"Sale Rate" Align : Centre Style : Small Border : Thin Left Invisible : NOT @@InvWithMrp
[#Field: EXPINV MRPTitle] Use : Name Title Field Width: @@NameWidth - 15 Info : $$LocaleString:"Sale Rate" Align : Centre Style : Small Border : Thin Left Invisible : NOT @@InvWithMrp
Dear Sir, Try This Code [#Line : EXPINV Column1] Option : SAL EXPINV Column1 : @@IsSales [!Line : SAL EXPINV Column1] Local : Field : EXPINV MRPTitle : Set as : "Sales" [#Line : EXPINV Column2] Option : SAL EXPINV Column2 : @@IsSales [!Line : SAL EXPINV Column2] Local : Field : EXPINV MRPTitle : Set as : "Rate"
Respected Experts What's Wrong in this TDL? ;;======TO SHOW IGST RATE & MRP IN SALES & PURCHASE VOUCHER ONLY FOR DISPLAY====== [#Line : EI ColumnOne] Option : Global EI ColumnOne [!Line: Global EI ColumnOne] Add : Right Fields : At Beginning : IAMRPT, IAMVAT [Field : IAMRPT] Info : "MRP" Align : Centre Width : @@NumberWidth Style : Small bold [Field : IAMVAT] Info : "IGST%" Align : Centre Width : @@NumberWidth Style : Small bold [#Line : EI ColumnTwo] Option : Global EI ColumnTwo [!Line: Global EI ColumnTwo] Add : Right Fields : At Beginning : IAMRPT, IAMVAT Local : Field : IAMRPT : Info : " " Local : Field : IAMVAT : Info : " " [#Line : EI InvInfo] Option : Global EI InvInfo [#Line : CI InvInfo] Option : Global EI InvInfo [!Line: Global EI InvInfo] Add : Right Fields : At Beginning : IAMRP, IAMVA [Field : IAMRP] Use : Number Field Set As : If $$IsEmpty:$ExciseMRPRate Then $$GetExciseMRPRateForStkItem:$StockItemName:$..ExciseUnitName Else $ExciseMRPrate Align : Centre Border : Thin Left Right Skip : YES [Field : IAMVA] Use : Number Field Set As : $GSTIGSTRate:StockItem:$StockItemName Format : "NoZero, Percentage" Align : Centre Border : Thin Left Right Skip : YES ;;=====HSN-SAC CODE IN VOUCHER ENTRY [#Collection: List of Stock Items] Use : Alias Collection Title : $$LocaleString:"List of Stock Items" Type : Stock Item Fetch : Name Report : Stock Item Variable : SStockItem Trigger : SStockItem IsODBCTable : Yes ;;Unique : $StockItemName Add :Format :$GSTIGSTRate Fetch:GSTIGSTRate Add :Format :$MRP Fetch:MRP ;;TO SHOW GST DETAILS IN STOCK SUMMARY [#Collection: List of Stock Items] Add:Sub Title :"Item Name" [#Collection: List of Stock Items] Add:Sub Title :"GST" Add :Format :$GSTIGSTRate Fetch:GSTIGSTRate [#Collection: List of Stock Items] Add:Sub Title :"MRP" Add :Format :$MRP Fetch:MRP [#Collection: List of Stock Items] Add:Sub Title :"CL Qty" ;;=====END OF CODE========
Small correction..... [#Line : EI ColumnOne] Option : Global EI ColumnOne [!Line: Global EI ColumnOne] Add : Right Fields : At Beginning : IAMRPT, IAMVAT [Field : IAMRPT] Info : "MRP" Align : Centre Width : @@NumberWidth Style : Small bold [Field : IAMVAT] Info : "GST%" Align : Centre Width : @@NumberWidth Style : Small bold [#Line : EI ColumnTwo] Option : Global EI ColumnTwo [!Line: Global EI ColumnTwo] Add : Right Fields : At Beginning : IAMRPT, IAMVAT Local : Field : IAMRPT : Info : " " Local : Field : IAMVAT : Info : " " [#Line : EI InvInfo] Option : Global EI InvInfo [#Line : CI InvInfo] Option : Global EI InvInfo [!Line: Global EI InvInfo] Add : Right Fields : At Beginning : IAMRP, IAMVA ;;;******************* Field definition changed. ********************** [Field : IAMRP] Use : Number Field Set As : @MRPRateSetVal Align : Centre Border : Thin Left Right Skip : YES MRPRateSetVal : If $$IsEnd:$StockItemName Then "" Else + If NOT $$IsEmpty:$MRPRate Then $$Number:$MRPRate + Else If $$IsEmptyPartyStateName + OR $$IsSysNamePartyStateName + Then $$GetEIStkItemMRP:$StockItemName:$Date Else + $$GetEIStkItemMRP:$StockItemName:$DatePartyStateName PartyStateName : $$BaseOwner:$VATPartyLedState [Field : IAMVA] Use : Number Field Set As : $GSTIGSTRate:StockItem:$StockItemName Format : "NoZero, Percentage" Align : Centre Border : Thin Left Right Skip : YES ;;=====HSN-SAC CODE IN VOUCHER ENTRY [#Collection: List of Stock Items] Use : Alias Collection Title : $$LocaleString:"List of Stock Items" Type : Stock Item Fetch : Name Report : Stock Item Variable : SStockItem Trigger : SStockItem IsODBCTable : Yes ;;Unique : $StockItemName Add :Format :$GSTIGSTRate Fetch:GSTIGSTRate Add :Format :$MRP Fetch:MRP ;;TO SHOW GST DETAILS IN STOCK SUMMARY [#Collection: List of Stock Items] Add:Sub Title :"Item Name" [#Collection: List of Stock Items] Add:Sub Title :"GST" Add :Format :$GSTIGSTRate Fetch:GSTIGSTRate [#Collection: List of Stock Items] Add:Sub Title :"MRP" Add :Format :$MRP Fetch:MRP [#Collection: List of Stock Items] Add:Sub Title :"CL Qty" ;;=====END OF CODE========
Small correction..... [#Line : EI ColumnOne] Option : Global EI ColumnOne [!Line: Global EI ColumnOne] Add : Right Fields : At Beginning : IAMRPT, IAMVAT [Field : IAMRPT] Info : "MRP" Align : Centre Width : @@NumberWidth Style : Small bold [Field : IAMVAT] Info : "GST%" Align : Centre Width : @@NumberWidth Style : Small bold [#Line : EI ColumnTwo] Option : Global EI ColumnTwo [!Line: Global EI ColumnTwo] Add : Right Fields : At Beginning : IAMRPT, IAMVAT Local : Field : IAMRPT : Info : " " Local : Field : IAMVAT : Info : " " [#Line : EI InvInfo] Option : Global EI InvInfo [#Line : CI InvInfo] Option : Global EI InvInfo [!Line: Global EI InvInfo] Add : Right Fields : At Beginning : IAMRP, IAMVA ;;;******************* Field definition changed. ********************** [Field : IAMRP] Use : Number Field Set As : @MRPRateSetVal Align : Centre Border : Thin Left Right Skip : YES MRPRateSetVal : If $$IsEnd:$StockItemName Then "" Else + If NOT $$IsEmpty:$MRPRate Then $$Number:$MRPRate + Else If $$IsEmptyPartyStateName + OR $$IsSysNamePartyStateName + Then $$GetEIStkItemMRP:$StockItemName:$Date Else + $$GetEIStkItemMRP:$StockItemName:$DatePartyStateName PartyStateName : $$BaseOwner:$VATPartyLedState [Field : IAMVA] Use : Number Field Set As : $GSTIGSTRate:StockItem:$StockItemName Format : "NoZero, Percentage" Align : Centre Border : Thin Left Right Skip : YES ;;=====HSN-SAC CODE IN VOUCHER ENTRY [#Collection: List of Stock Items] Use : Alias Collection Title : $$LocaleString:"List of Stock Items" Type : Stock Item Fetch : Name Report : Stock Item Variable : SStockItem Trigger : SStockItem IsODBCTable : Yes ;;Unique : $StockItemName Add :Format :$GSTIGSTRate Fetch:GSTIGSTRate Add :Format :$MRP Fetch:MRP ;;TO SHOW GST DETAILS IN STOCK SUMMARY [#Collection: List of Stock Items] Add:Sub Title :"Item Name" [#Collection: List of Stock Items] Add:Sub Title :"GST" Add :Format :$GSTIGSTRate Fetch:GSTIGSTRate [#Collection: List of Stock Items] Add:Sub Title :"MRP" Add :Format :$MRP Fetch:MRP [#Collection: List of Stock Items] Add:Sub Title :"CL Qty" ;;=====END OF CODE========
This code has a weird problem It shows MRP in saved vouchers which are reopened. While entering in voucher it always shows MRP as 0 even before item is selected. Also the MRP is black in the list of Stock items. GST Rate Works fine
This code has a weird problem It shows MRP in saved vouchers which are reopened. While entering in voucher it always shows MRP as 0 even before item is selected. Also the MRP is black in the list of Stock items. GST Rate Works fine