Skip to main content

The following IAL query is accepted by the Developer, but I cannot schedule the update in the Configuration tool. 

 

SELECT COMPANY,
           CONTRACT,
           INVOICE_ID,
           ITEM_ID,
           SERIES_ID,
           INVOICE_NO,
           DEL_IDENTITY,
           DELIVERY_ADDRESS_ID,
           VAT_CURR_AMOUNT,
           NET_CURR_AMOUNT,
           GROSS_CURR_AMOUNT,
           ORDER_NO,
           LINE_NO,
           RELEASE_NO,
           RMA_NO,
           RMA_LINE_NO,
           CATALOG_NO,
           DESCRIPTION,
           INVOICED_QTY,
           SALE_UM,
           INVENTORY_UM,
           CALC_UOM_VOLUME,
           SALE_UNIT_PRICE,
           ACCOUNTING_PERIOD,
           ACCOUNTING_YEAR,
           COMP_CUST,
           PART_PRODUCT_FAMILY,
           OBJSTATE,
           OBJSTATE_HEAD
      FROM IFSAPP.olap_customer_invoice_item
WHERE COMPANY IN ('HH','TJC','CANCO','SS-WJD', 'SS-PD', 'SS-FEW', 'SS-INTSALES', 'SS-LI', 'SS-DV', 'SS-220', 'SS-EAH', 'SS-HOLDINGS', 'SS-NOL', 'SS-OAH', 'SS-USSALES','HHGLOBALELIM','203')

Be the first to reply!

Reply