Improvement SQLWHERE to extend GL DISTRIBUTION

Description

This change permit to extend the functionality of the GL Distribution . Extending the condition with a SQLWHERE you can user every field inside each dimension of the fact_acct

SQL WHERE : @M_Product_ID@ IN (SELECT M_Product_ID FROM M_Product WHERE Description='X') OR @C_BPartner_ID@ IN (SELECT C_BPartner_ID from C_BPartner WHERE Description='Z')

So the GL Distribution could be applyed where the product is in the select e.g. has a category group or whatever

Tested on iDempiere 7.1

Environment

None

Attachments

3
  • 17 Apr 2020, 11:00 AM
  • 17 Apr 2020, 10:59 AM
  • 17 Apr 2020, 10:57 AM

Activity

Show:

MarcoL April 17, 2020 at 11:01 AM

The 2Pack hasEntity type “cnet”

Details

Assignee

Reporter

Labels

Priority

Created April 17, 2020 at 10:57 AM
Updated November 23, 2020 at 2:23 PM