Results 1 to 1 of 1
  1. #1
    Join Date
    Feb 2009
    Posts
    7

    Unanswered: po order qty with conversion and order units

    I have a report where in the linking i have set the po orderqty =count table
    My table is 1-24 to allow for items that i have need up to 24 labels. This works fine except when my order unit is greater then 1. For example

    x item orderqty= 2 order unit box-12 conversion 12
    this would when received for my po would = orderqty*conversion or 2*12=24
    I would show 24 items in my inventory when received.
    this relates to the report because the orderqty= table (in linking)-so since the order qty is 2 my report prints out 2 labels
    I have been trying to write a statement that looks something like this (but I keep getting errors) remember I have a join setting poline.orderqty ={count.table}
    I have several types of order units that i will have to add into the formula but for now just trying to get 1 to work.

    if {POLINE.ORDERUNIT}= "box-12" then
    {POLINE.ORDERQTY}*{POLINE.CONVERSION}else
    {POLINE.ORDERQTY}={count.table}

    here is my current sql
    max40385
    SELECT "INVENTORY"."ITEMNUM", "INVENTORY"."ORDERUNIT", "INVENTORY"."BINNUM",
    "INVENTORY"."MODELNUM", "ITEM"."DESCRIPTION", "POLINE"."ITEMNUM",
    "POLINE"."ENTERDATE", "POLINE"."PONUM", "POLINE"."ORDERUNIT", "POLINE"."ORDERQTY"
    FROM "MAXIMO"."INVENTORY" "INVENTORY", "MAXIMO"."POLINE" "POLINE",
    "MAXIMO"."ITEM" "ITEM"
    WHERE ("INVENTORY"."ITEMNUM"="POLINE"."ITEMNUM") AND ("POLINE"."ITEMNUM"="ITEM"."ITEMNUM") AND "POLINE"."PONUM"='24142' AND "POLINE"."ITEMNUM"='1201020021N'
    EXTERNAL JOIN POLINE.ORDERQTY>=
    {?C:\Documents and Settings\kpowell\My Documents\test table.xls: Sheet1_.Column1}


    C:\Documents and Settings\kpowell\My Documents\test table.xls
    SELECT `Sheet1_`.`Column1`
    FROM `Sheet1$` `Sheet1_`
    WHERE `Sheet1_`.`Column1`<={?max40385: POLINE.ORDERQTY}
    Last edited by max274; 05-15-09 at 12:35.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •