how to fillter by dimension in Proj Invoices Table

(0) Share

Report

Posted on by Wael Shazly

175

how to filter the data by pass dimantion val check the following code :

ProjInvoiceJour  projInvoiceJour;
    Amount invVal;

    select sum(invoiceamount) from projInvoiceJour
    where projInvoiceJour.InvoiceDate  >= _startDate
       && projInvoiceJour.InvoiceDate  <= _endDate;
      // need to filter by dimision

    invVal = projInvoiceJour.InvoiceAmount ;

    
    return invVal;

*This post is locked for comments

All responses (2)

Answers (1)

Wael Shazly 175 on at

Like (0)

Report

RE: how to fillter by dimension in Proj Invoices Table

Many thanks
Verified answer

Rustem Galiamov 8,072 on at

Like (1)

Report
RE: how to fillter by dimension in Proj Invoices Table

You should use DefaultDimensionView and related table.

As example how to use it for CustInvoiceJour and Department dimension:

CustInvoiceJour custInvoiceJour; DefaultDimensionView dimView; OMOperatingUnit operationUnit; while select custInvoiceJour join dimView where dimView.DefaultDimension == custInvoiceJour.DefaultDimension join operationUnit where operationUnit.RecId == dimView.EntityInstance && operationUnit.omOperatingUnitType == OMOperatingUnitType::OMDepartment && operationUnit.Name == departmentName { info(custInvoiceJour.InvoiceId); }