Help needed for if condition

Dear sir,

help required in field. if the stock item does not have HSN code we should get "N/A" .
by default i am getting "not found" when hsn is not given.

[Field:invhsnum]
Use : Name Field
;Set as:$GSTHSNCode:StockItem:$StockItemName

Set as:if $$isempty:$GSTHSNCode:StockItem:$StockItemName then $$LocaleString:"N/A" ELSE $$LocaleString:$GSTHSNCode:StockItem:$StockItemName
Align :right;Center
Skip : Yes
Width:10
Set Always: Yes

 

Try to Do it Like This

Code:

[Field:HSNCode]
Use:Name Field
Set As:$_HSNCode:StockItem:$StockItemName
Set By Condition:($$IsEmpty:$$Value):"N/A"

 

Thank u Himanshu bhai for the reply and help. but still the code is not working.

 

Dear sir,
the code is working fine only while generating new vouchers but not working in saved vouchers.
Thank u Amit sir for the help.

 

s

sir, after saving the voucher and again in alteration mode, the hsn is not displayed for any items.

 

sir,
the error was in the emoji code.

Set as : If $$IsEmpty@HSNCodeNew Then "N/A" Else @@HSNCodeNew

Set as : If $$IsEmpty@@HSNCodeNew Then "N/A" Else @@HSNCodeNew

 

dear Amit sir, This is working fine in one company which is newly created in april2021 but not working for other company which is 4 years old. i just given hsn tax rate and hsn code for exsiting items in old company. in old company newly created stock item the code is working correctly.
what might be the problem i dont know. please identify the error.

[Field: HSNCode]
Use : Name Field
Set as : If $$IsEmpty@HSNCode Then "N/A." Else @@HSNCode
Set Always : Yes
Skip : Yes
Align : Centre
Width : 8
Invisible : NOT @@IsSales

[System : Formula]
HSNCode : $$GetGSTTransInfo:$Date:$GSTEntryLedgerName:$StockItemName:"HSNCode"

 

sir, this code is not working for me.

 

sir,
i modified Himanshu bhai code .now it is working fine in new company and also in old company

[Field:HSNCodenew]
Use:Name Field
Set As:$gstHSNCode:StockItem:$StockItemName
Set By Condition$$IsEmpty:$gstHSNCode:StockItem:$StockItemName):"N/A"
Set By Condition$$IsEmpty:$GSTIGSTRate:StockItem:$StockItemName):"N/A"
Set Always : Yes
Skip : Yes
Align : Centre
Width : 8

 

Thank u Himanshu bhai for the code. your syntax helped to solve my query.
Also special Thanks u Amit sir for uninterrupted support and guidance.
Amit sir syntax also helped me to learn the logic and understand that result can be achieved in very ways.

 

dear sir,
help needed in this code. here i am taking hsn rate of tax in my UDF . if my stock item has no hsn rate then it should be blank or N/A.
as hsn rate is using number field, we are getting as "0%" for stock item which has no hsn rate.
i tried use:name field instead of number field. it is working fine but % symbol will not come with it.
also another problem stock item with "0%"(zero) will not be be displayed if we use name field.

please suggest some solution for this?

[Field:hsnrat1]
Use: number field
Set as:$GSTIGSTRate:StockItem:$StockItemName
set By Condition$$IsEmpty:$GSTIGSTRate:StockItem:$StockItemName):" "
Format: "no comma, percentage"
Width: 5
Style: NORMAL BOLD
Align : Center
Skip : YES
Set Always: Yes

 

Your Welcome Sir, As Amit sir suggested.. You really need to understand why some methods are not working for you but working for us... I'll suggest to learn Tally XML Schema to understand it completely....

 

himanshu bhai please suggest any link or video for learning Tally XML schema.

 

Sir you can follow this YT Channel, sooner he will be uploading video on tally schema

https://youtube.com/playlist?list=PLY9SvfhJqe-fP5fHfmeWmtG2QLTut0SYR

Teja Sir Video on Reading XML:-


.. After watching these you can export a voucher in xml and compare that xml with voucher in tally... And you will find that method name and xml tag is same...

 

Thank u very much Himanshu bhai.