[development-axapta] Problem with Planned Purchase Orders

Wed, 20 Jul 2005 01:25:07 -0700

Dear All,

I have a problem and I don´t find any solution for it. Can anybody
help me?

I have to show only these records in "Planned Purchase Orders",
where the sum of "Available physical Qty" in all other Warehouses
are greater than the "Required Qty".

My first solution was to build up the Select-Join-Statement, insert
all concerned records to a RecordSorted List, set the DataSource
ReqTransPO as temp and afterwards insert all records from the
RecordSorted List to ReqPO.
That doens't work, I got an SQL-Error.
I think the problem is, that after setting the ReqTransPO as temp,
the Data is only available on the Client?

My second solution was to build up the Select-Join-Statement in the
executeSection() of ReqPO.
That does't work either, because it seems that I loose all Innner-
Join relations (ReqTrans, InventTable).
I think the problem is that I do not get the complete Record with
the below Select-Join-Statement.

Here is the mentioned Select-Join-Statement:
    select reqPO
        group by ReqPlanId, ItemId, RecId
        join sum(AvailPhysical) from InventSum
            where inventSum.ItemId          == reqPO.ItemId   &&
                  inventSum.AvailPhysical   >= reqPO.Qty
                join covInventDim
                    where covInventDim.inventDimId ==
reqPO.CovInventDimId
                    exists join inventDim_Location
                        where inventDim_Location.InventLocationId !=
covInventDim.InventLocationId;


Mit freundlichen Grüssen / Best Regards

Markus Sendelbach
YAHOO! GROUPS LINKS



Reply via email to