CAN ANYONE PUT A TDL FOR to veiw purchase reference Bill no... STATE & DATE

TDL FOR to veiw purchase reference Bill no... STATE & DATE in purchase register

TDL FOR to veiw purchase reference Bill no... STATE & DATE in purchase register


this image will help you understand the requirements

 

here is the code ......................

;;TDL ------------------supplier info no

[#Line: DBTitle1]

Fields : DSP VchDateTitle, DSP VchAcctTitle

Add:Field:AfterSP VchAcctTitle:BILLCol23

Add: Field: After:BILLCol23:OTSPurchaseDatetitle



[Field:BILLCol23]

Set As : " Supplier Invoice Ref."
Width : 15
Align : center
color: red
Style : Normal Bold
border : Thin Left Right

[Field:OTSPurchaseDatetitle]

Use: Name Field
Set as: "Date"
Width : 10
color: red
Align : center
Style : Normal Bold
border : Thin Left Right

[#Line: DSP VchDybkDetail]
Add: Right Fields:Before SP VchType:Refnobb
Add: Right Fields: After: Refnobb: OTSPurchaseDate
Add: Right Fields: Before: Refnobb : OTSstatx

[Field:Refnobb]
Use :Name Field
Set As : $REFERENCE
Width : 15
Align:right
color : blue
Style : Normal bold
Border: Thin Left right

[Field:OTSPurchaseDate]
Use: Simple Field
Set as: IF $$IsEmpty:$ReferenceDate Then $UDFReferenceDate Else $ReferenceDate
Width : 10
Align:right
color : green7
Style : Normal
Border: Thin Left right

[Field:OTSstatx]
Use :Name Field
Set As : $voucherAddress
Width : 14
Align:centre
color : geranium
Style : Normal bold
Border: Thin Left right



[#Collection : Filtered Vouchers of Company];;;;;;;;;;;;;;;;;;;;For Data Coming in Purchase Register

Fetch:UDFReferenceDate, ReferenceDate

;;------------------------- i want to add STATE also here

PLEASE HELP !!!

 

Try this

Set As : $LedStateName:Ledger:$LedgerName

 

ITS NOT WORKING !!


[Field:OTSstatx]
Use :Name Field
Set As : $StateName:Ledger:##LedgerName
Width : 14
Align:centre
color : geranium
Style : Normal bold
Border: Thin Left right


---- PLEASE STATE IT WILL BE NAME FEILD OR SIMPLE FEILD ?

 

$Ledstatename:Ledger:$Ledgername

 

NO ITS NOT SHOWING !!!

 

Try this

Set As : $LedStateName:Ledger:$PartyLedgerName + "-" + $$getGSTStateCode:$LedStateName:Ledger:$PartyLedgerName

Working proper.

 

yes !!! its working good !! very very thanks to you sir !!

 

Dear Experts,

Can u provide the Field name of below .



Thanks,
Mukesh

 

Field Name is
LED GSTPartyDetails

 

Sorry

Field Name is
LED GSTPartyType

 

Set as : $GSTNatureofSupply:Ledger:#EIConsignee