Skip to Content
avatar image
Former Member

query for puchase order

Hi, At the moment, we use a system that works ok for our puchasing. We have problems thou with some product that sell really good and we never have enough and some others we have to much always... For now we work just with the minimum level stock, but we would like to add stock maximum and ReorderQty in order to have a better and more detailed purchasing system! This is the Query we use at the moment. If u could give me some good advices how and where to bring in the Stock maximum and ReorderQty, that would be awesome! Thanks in advance SELECT T0.[ItemCode] as [Cod Articulo], T0.[ItemName], T0.[ItmsGrpCod] T0.[CardCode] T0.[QryGroup1] T0.[QryGroup6] T0.[QryGroup7] T0.[QryGroup8] T0.[QryGroup9] T0.[ByWh] a T0.[SuppCatNum] T0.[FrgnName], T0.[OnHand] +T0.[OnOrder]/3 - T0.[iscommited] - (2*T0.[MinLevel]) (-)] ,T0.[MinLevel], -5*T0.[MinLevel]/10 T0.[U_PF_ T0.[U_PF_FactDctoCompra], T0.[OnHand] as [Stock],(T0.[OnHand] +T0.[OnOrder]/3 - T0.[iscommited] - (2*T0.[MinLevel]))*( T0.[U_PF_ListaPrecioProv]*T0.[U_PF_FactDctoCompra]) as [Costo Compra], T0.[U_PF_ListaPrecioProv]*T0.[U_PF_FactDctoCompra] as [Costo Unidad], T0.[OnOrder] - T0.[iscommited] + T0.[OnHand] as [Proyectado], T0.[OnHand] as [Stock], T0.[iscommited] as [Comprometido], T0.[OnOrder] as [Solicitado], T0.[PurPackUn] as [Und p/Caja], T0.[QryGroup2] as [Obsoleto], T0.[QryGroup3] as [Hasta agotar Stock], T0.[U_Currency] as [Moneda],  T0.[FrozenComm] FROM OITM T0 WHERE  T0.[QryGroup1] = 'Y'    ORDER BY T0.[QryGroup9], T0.[QryGroup8], T0.[QryGroup7], T0.[QryGroup6]

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Sep 15, 2015 at 07:56 PM

    Hello Florian,

    Your posting did not provide enough information to understand the issue.

    Kindly elaborate more by giving more details.

    Regards,

    Selim Batur

    Add comment
    10|10000 characters needed characters exceeded