Postable GLs

[neil.interactit]

I am producing a GL lookup ...

Code: Select all

Dim ledger As New JiwaApplication.Entities.GeneralLedger.Account()
ledger.Search(_purchaseOrderForm)
accountNo = ledger.AccountNo

This lookup list includes both postable and non-postable accounts. It appears elsewhere in Jiwa that you can display a lookup with only postable accounts ... how do you do this?

[Mike.Sheen]

Supply the FilterSQL parameter - e.g.:

Code: Select all

Dim ledger As New JiwaApplication.Entities.GeneralLedger.Account()
ledger.Search(_purchaseOrderForm, "GL_Ledger.PostingAcc = 1 AND GL_Ledger.IsEnabled = 1 ")
accountNo = ledger.AccountNo

[neil.interactit]

Awesome thanks.