How to Deactivate Stock Item from Tally.ERP 9, How to Hide Stock Item from Tally.ERP 9, Free TDL

-

How to Deactivate Stock Item from Tally.ERP 9, How to Hide Stock Item from Tally.ERP 9, Free TDL


How to Disable / De-activate Stock Item from List at the time of Entry
(Free Tally.ERP9 and Tally Prime TDL)

There is a situation sometimes you cannot delete Stock Item which is already used in the voucher from Tally.ERP 9 or Tally Prime software and you want to remove that Stock Item from the list so that it is not wrongly selected during entry.

Or there is a situation where some old items that are discontinued now those you can Disable / De-activate from the List at the time of new Transaction.


And there comes the need to Disable or De-activate that stock item from the list. The below code will help you in doing so.


We will show you both with or without customization.

To view the benefits of this customization.

Go to Gateway of Tally > Voucher > Sales.

As you can see below Screenshot you can see 4 GB Pendrive Item in the List, 


Now as 4 GB Pendrive Item is no more in the deal so We have to Disable or De-activate that stock item from the list.

Now after applying this customization you will get an option to Disable or De-activate that stock item in the Item alteration screen as per the below screenshot.





After Disable or De-activate that stock item let's check by making a new transaction,

As per the below screenshot you can see now we are not getting those Disable or De-activated stock items in the list at the time of Sales Entry,




You can also get a separate report for a list of Disabled or De-activated stock items list as per the below Screenshot from the Gateway of Tally.






To Configure the TDL file : 

Step 1. Download TDL file,

Step 2. Open your Tally.ERP9 Software And Press F12 on your keyboard,

Step 3. Go to Product and Features,

Step 4. Press F4 to manage local tdl

Step 5. Provide Full Path of the TDL file with Name and Extension,


Note: Files extensions which can be attached to Tally.ERP9 software are .tcp , .tdl, .txt


Step 6. If you see tdl loaded on the below screen it means you have successfully attached the code.

Step 7. Open your company in which you want to disable or de-activate Stock Item.

Step 8. At Gateway of Tally Screen ( Main Screen after opening Tally.ERP9 Software). Go to Inventory Info.

Step 9. Select Stock Item then select Alter then from the drop-down list select the stock item which you want to disable/de-activate.

Step 10. You will find one new option "De-Activate this Stock Item ?" turn that option to YES and your stock item will get disabled from Tally.ERP9 software.



Note:- By doing this you are only hiding the stock item from the list but it will be there in your Tally.

Actual Tally Data & all the data related to it will still be there in the main Data folder. 

To Actually delete that stock item from your Tally Data you will need to delete all the vouchers related to that stock item which you want to delete or Edit those voucher and select different Item in place of that stock item and then Tally.ERP9 software will allow you to delete that Stock Item.


Code : 


[#Menu: Gateway of Tally]

Add: Key Item: "De-Activated Item Report" :D : Display: Turn off StockItem List 


[Report : Turn off StockItem List]

Form : Turn off Item

Family      : $$Translate:"Turn- off Stock Item List"

[Form : Turn off Item]

Use : DSP Template

Part : Turn off Item

Height : 100% Screen

Width : 100% Screen 

Delete : Bottom Button

Delete : Button

Local : Button : DSPAutoColumns : Inactive : Yes

Local : Button : ReportConfig   : Inactive : Yes

Local : Button : FilterButton   : Inactive : Yes

Local : Button : ValueButton    : Inactive : Yes

Local : Button : RelReports : Inactive : Yes

Local : Button : Inv Reports : Inactive : Yes

Local : Button : Acct Reports : Inactive : Yes


[Part : Turn off Item]

Part : Turn off Item Title,Turn off Item Name

Vertical : Yes

Border : Thin Box

[Part : Turn off Item Title]

Line : Turn off Item Title

[Line : Turn off Item Title]

Field : Turn off Item SNo,Turn off Item Name,Turn off Item Group,Turn off date,Turn off Item Reason

Local : Field : Default : Align : Centre

Local : Field : Default : Style : Normal Bold

Local : Field : Turn off Item SNo  : Set as : "S.No"

Local : Field : Turn off Item Name : Set as : "Turn- off Stock Item List"

Local : Field : Turn off Item Reason : Set as : "Reasons"

Local : Field : Turn off date : Set as :"Turn- off Date"

Local : Field : Turn off Item Group: Set as : "Under Group"

Border : Thin Bottom


[Part : Turn off Item Name]

;;Height : 95% Screen

Line : Turn off Item Name

Repeat  : Turn off Item Name : NSTurn offItem

Scroll : Vertical

CommonBorder : Yes

Float : No

[Line : Turn off Item Name]

Field : Turn off Item SNo,Turn off Item Name,Turn off Item Group,Turn off date,Turn off Item Reason

Option : Alter on Enter

[Field : Turn off Item SNo]

Use : Name Field

Set as : $$Line

Style : Normal

Width : 10% Screen

Align : Centre

Border : Thin Right


 

[Field : Turn off Item Name]

Use : Name Field

Set as : $Name

Width : 30% Screen

Align : Left

Style : Normal

Alter : StockItem

Variable : StockItemName

Border : Thin Right


[Field : Turn off Item Reason]

Use : Name Field

Set as : $NDAReason:StockItem:$StockItemName

Width : 20% Screen

Align : Left

Space Left : 1% Screen

Style : Normal Italic



[Field: Turn off date]

Use : Name Field

Set as : $NSSActDate:StockItem:$StockItemName

Width : 20% Screen

Align : right

Space Left : 1% Screen

Style : Normal Italic

Border : Thin Right




[Field : Turn off Item Group]

Use : Name Field

Set as : $Parent:StockItem:$StockItemName

Width : 20% Screen

Align : Centre

Space Left : 1% Screen

Style : Normal

Border : Thin Right


[Collection : NSTurn offItem]

Type : StockItem

Fetch : Name

Filter : NSSFilter1


[#Part: STKI Desc]

Add     : Lines : NDeact 


[Line : NDeact]

Fields : Medium Prompt, NActive, Simple Field, NActDate, NDAReason

Local   : Field : Medium Prompt : Info : $$LocaleString:"Do you want Turn- off ?:"

Local : Field : Simple Field  : Info : " On : "

Local : Field : Color : Red

Local : Field : Simple Field  : Skip : Yes

Invisible : Not $$IsCmpOwner

 

[Field  : NActive]

Use     : Logical Field

Storage : NSSActive

Set Always : Yes


[Field  : NActDate]

Use     : Uni Date Field

Storage : NSSActDate

Set as: if  $NSSActive="yes" then $$value else ""

Set Always : Yes

SkipOn : NOT $NSSActive


[Field : NDAReason]

Use : Voucher Narration Field

Storage : NDAReason

Set as: if  $NSSActive="yes" then $$value else "" 

Set Always : Yes

SkipOn : NOT $NSSActive


[System : Formula]

NSSFilter :  $NSSActive:StockItem:$Name = "No"

NSSFilter1  : Not  $NSSActive:StockItem:$Name = "No"


[#Collection : Vch Stock Item Extract]

Filter : NSSFilter


[System : UDF]


NSSActive : Logical : 901

NSSActDate : Date  : 902

NDAReason : String : 903

;;End of the Code

Comments

Post a Comment

Popular posts from this blog

Free TDL for Print Barcode in Tally Prime and Tally.ERP 9

-
Image
 Free TDL for Print Barcode in Tally Prime and Tally.ERP 9 We can Print Barcode from Tally from Using Tally Customization and print Barcode on Barcode label or Sticker. You also scan with Barcode Scanner and once you will scan the same item will come to selection automatically at time of entry or report. To enable the customize please follow the below steps. 1. Go to Gateway of Tally > F11: Features > Accounting Features. 2. Set “Yes” to the option “Enable Label Printing” for label printing. 3. Set “Yes” to the option “Enable Barcode Label Printing “for Barcode in label printing. Code : ;; Sri Ganeshji : Sri Balaji : Sri Pitreshwarji : Sri Durgaji : Sri Venkateshwara [#Form : Sales Color] Add : Print : EI LabelPrinting ;; Adding Label Printing Report to the already existing Report/s. [Report : EI LabelPrinting] ...
Read more

Free Tally TDL for Print UPI QR Code iN Tax Invoice with Bank Details

-
Image
Free Tally TDL for Print UPI QR Code iN Tax Invoice with Bank Details Hello Frnds, By Using this TDL now you can Print your UPI QR Code in Tax Invoice copy with your Bank Details so your Customer Can Pay Easily and You also can Get the Payment fast. In Invoice the UPI QR Code will look like below Image :  You can download TDL from below Link :  # As we are providing many TDLs free of charge we request you to please Donate something as per your Wish to motivate us and we develop more TDLs 👇 Donate Download  
Read more

Free Tally TDL for Display HSN and GST Rate in Sales and Purchase in Tally

-
Image
Free Tally TDL for Display HSN and GST Rate in Sales and Purchase in Tally You can See / Display your Item Wise HSN in Tally. You can See / Display your Item Wise GST Tax Rate. Same you can do for Sales as well as for purchase also. You can use this Free Tally TDL  in Tally.ERP 9 and Also you can Use in Tally Prime. You can find HSN and Tax Rate as per below-attached Screenshot. Code :  [#Line : EI ColumnOne] Option : Global EI ColumnOne           [!Line: Global EI ColumnOne] Add : Right Fields : At Beginning : IAHSNcodeT, IAMVAT , IAMCGST ,IAMSGST  [Field : IAHSNCodeT] Info : "HSN/SAC Code" Align : Centre Width : 15 Style : Small bold COLOR   : BLUE background : yellow [Field : IAMVAT] ...
Read more

Item Wise Last Sales and Purchase Price

-
Image
 Item Wise Last Sales and Purchase Price Hello Friends.. Here you can check Item Wise Last Sales and Purchase Price in Tally while Making Sales Transaction Based on the buying and selling prices of each stock item, you may want to maintain the rates such that they automatically appear when you pass a transaction. You can do this in Tally.ERP 9 and Tappy Prime by providing the standard cost (for purchase), and standard price (for sales) for each stock item.  You can maintain rates for the stock items on a daily basis or a specific period based on your business needs.  When you record the purchase and sales invoices, the standard cost and standard price will appear for that stock item automatically. Also, you may want to fix the selling price of items at different rates to customers, based on the type of the customer or your preferences.  For this, in Tally.ERP 9,...
Read more

Free TDL for Auto WhatsApp from Tally.ERP9

-
Image
Free TDL for Auto WhatsApp from Tally.ERP9 | How to send Whats app from Tally | Tally to Whats App Hello Friends, This is Very Useful Tally customization for All the Users as of nowadays, As this is the Most liked and Most demandable Tally customization from So log we have decided to give this customization to you guys free of cost. By using this customization you can send What's App your invoice information to your customer. At the time of Sales once you will save the entry as soon as Tally will ask you for what's app information if you want to wants App you can make Yes or else you can make it No. Here you will have the choice to Whats App or not. Here I will show you screen by screen how to use this customization, Once you download the file from the below-provided download link you can...
Read more

Free Tally TDL for Change Any font in Tally

-
Image
 Free Tally TDL for Change Any font in Tally Hi Friends, If you want to change fort in Tally you can get this code and make necessary changes in Tally font. You can simply choose the font and it set in Tally. Video Link :  https://youtu.be/an-L0sXHLcY You can download free TDL from Below Link  Download For More TDLs Free Tally TDL for Display HSN and GST Rate in Sales and Purchase Video : https://youtu.be/m502hopGmqI Free Tally TDL for Whats App Invoice direct from Tally Video : https://youtu.be/r9eSeFKwz8o Free Tally TDL for Voucher Alteration History, Entry History Module Video : https://youtu.be/pKPf9kx0Kmc
Read more

Free Tally TDL for Detailed Balance Sheet TDL for Tally Prime and Tally.ERP9 | New Tally Prime

-
Image
Free Tally TDL for Detailed Balance Sheet TDL for Tally Prime and Tally.ERP9 | New Tally Prime A balance sheet is a financial statement that reports a company's financial position. This report shows the balance between the assets and liabilities of a firm. The balance sheet follows the fundamental accounting equation: Assets = Liabilities + Owner's Equity. By Using this Customized TDL for Detailed Balance Sheet you can get a detailed format of the Balance sheet. This Customized TDL for Detailed Balance Sheet will work for both Tally Prime and Tally.ERP9 In Current Tally Balance sheet report will not extend at detailed Group level or Sub Group Level or Ledger Level but after using Our Tala Customization you can resolve that issue and get a detailed report at the end level. This report will help you a lot in your business to grow up or to take some business development decisions in your...
Read more

Free TDL for Document Attachment System for Tally Prime | New Tally Prime

-
Image
Document Attachment System for Tally In Tally, you can attach any document in any Transaction, for this, you need a Tally customization file which you can download free of cost. In Tally, you will get an option for attaching any file in every entry. You can attach the below file format in Tally and later on you can open and check. PDF Excel JPG Notepad HTML You can insert and check inserted transaction as per the below screenshot. This add-on allows the user to attach the relevant documents for any Voucher. User can assign documents for Ledger and Stock Item also. The documents can be viewed directly from Tally Software from Ledger Report, Voucher Screen or Master Screen. Code :  [#Part: VCH Narration]  Add : Switch    : BankDetRcpt : B...
Read more

Free Tally TDL for Auto Email facility Sales Invoice in PDF for Tally | Free TDL for Tally Prime

-
Image
Hello Friends, This is Very Useful Tally customization for All the Users as of nowadays, As this is the Most liked and Most demandable Tally customization from So that we have decided to give this customization to you guys free of cost. By using this customization you can Email your invoice information to your customer at the time of Save the Invoice. At the time of Sales once you will save the entry as soon as Tally will ask you for information do you want to send an Email? You can make Yes or else you can make it No. Here you will have the choice Do you want to send an Email or not. Here I will show you screen by screen how to use this customization, Once you download the file from the below-provided download link you can deploy customization in Tally. After deploy make sure you have Configured Email Configuration and also note that you have entered Party Email ID ...
Read more

Free Tally TDL for GST Rate And HSN in Stock Summary

-
Image
Free Tally TDL for GST Rate in Stock Summary Free Tally TDL for HSN in Stock Summary Dear Friends  By Using This TDL you can View HSN and GST Rate in Stock Summary  You can Export the same if you want in Excel or PDF or Some Other Format and you can do the Filter or Play around. As per Below Mentioned Screenshot :  You can Download the TDL free of Cost from Below Mentioned Link and We also request you to  please Donate something as per your Wish to motivate us and we develop more TDLs  As we are providing many TDLs free of charge and we develop more TDLs 👇 DONATE DOWNLOAD
Read more