Is it correct to filter on ARInvoice using a statement like :
Where<ARInvoice.status.IsEqual<"Closed">>
?
Best answer by Vignesh Ponnusamy
View originalIs it correct to filter on ARInvoice using a statement like :
Where<ARInvoice.status.IsEqual<"Closed">>
?
Best answer by Vignesh Ponnusamy
View originalHi
You cannot use string like that, instead reuse the constant defined in the existing ARDocStatus class. Example below,
Where<ARInvoice.status.IsEqual<ARDocStatus.closed>
Good Luck,
Thank you, Vignesh. that was helpful
what about ARInvoice Terms? is there any class in which the terms are defined?
Hey
From a quick check I think the termsID is being fetched from the database. To be able to use a constant value you can create a BQL field, set the required value and use it the query. Below is an example,
public class custPrefix : PX.Data.BQL.BqlString.Constant<custPrefix>
{
public custPrefix() : base("%500%") { }
}
Note: User the Bql data format similar to the TermID. Hope that helps.! Feel free to post back if you have any questions.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.