Full Ledger details

Hi, Please help me on the below code

It is working fine in Purchase Order in Item-Mode

But it is not working in Purchase Invoice in Item-Mode though I have checked in developer mode and field name in both voucher type is same.

[#Field:EI AccAllocName]
Delete:Table
Add:Table:MyLedgerColl

[Collection:MyLedgerColl]
Use : Alias Collection,Table EndofList
Title : $$LocaleString:"List of Ledger"
Type : Ledger
Fetch : Name
Report : Ledger
Variable : LLedger
Trigger : LLedger
IsODBCTable : Yes
Add : SubTitle : $$LocaleString:"Ledger Name","Parent Group"
Add :Format :$Parent,15
Fetcharent, PartyGSTIN, IsTDSApplicable, IncomeTaxNumber
Add : SubTitle : $$LocaleString:"Ledger Name","PAN"
Add :Format :$IncomeTaxNumber,10
Add : SubTitle : $$LocaleString:"Ledger Name","TDS"
Add :Format :$IsTDSApplicable,5
Add : SubTitle : $$LocaleString:"Ledger Name","Gstin"
Add :Format :$PartyGSTIN

 

for purchase use [#Field: EI Consignee]

 

Thanks for the reply

That I have done but this at the time of Purchase ledger selection in Item Invoice Mode

 

Further can you help how to provide filter in attached code

1. If voucher type is Sales / Sales Order then only ledger shown in the dropdown that of under Debtors Group
2. If voucher type is Purchase / Purchase Order then edger shown in the dropdown that of under Creditor Group

 

Iam new to TDL and don't know how to add filters

Please find below code, Kindly help to filter list as per voucher type like fir Purchase Invoice only creditors party should show to select


[#Field:EI Consignee]
Delete:Table
Add:Table:MyLedgerColl

[#Field:ACLSLed]
Delete:Table
Add:Table:MyLedgerColl

[#Field:EI PartyLedger]
Delete:Table
Add:Table:MyLedgerColl

[#Field:EI Buyer]
Delete:Table
Add:Table:MyLedgerColl

[#Field:EI AccAllocName]
Delete:Table
Add:Table:MyLedgerColl

[Collection:MyLedgerColl]
Use : Alias Collection,Table EndofList
Title : $$LocaleString:"List of Ledger"
Type : Ledger
Fetch : Name
Report : Ledger
Variable : LLedger
Trigger : LLedger
IsODBCTable : Yes
Add : SubTitle : $$LocaleString:"Ledger Name","Parent Group"
Add :Format :$Parent,15
Fetcharent, PartyGSTIN, IsTDSApplicable, IncomeTaxNumber
Add : SubTitle : $$LocaleString:"Ledger Name","PAN"
Add :Format :$IncomeTaxNumber,10
Add : SubTitle : $$LocaleString:"Ledger Name","TDS"
Add :Format :$IsTDSApplicable,5
Add : SubTitle : $$LocaleString:"Ledger Name","Gstin"
Add :Format :$PartyGSTIN

 

Hi

Please reply

 

[#Collection:List of Ledgers]
Optionis_DrsGrp:Not $$IsCmpOwner And Not $$CmpUserName = "gokul"; And Not $$CmpUserName = "Bala"

[!Collectionis_DrsGrp]
Child Of:$$GroupSundryDebtors
Belongs To:Yes