L'erreur lorque j'ai ajouter les fonction MAX et SUM
VL:
LOAD
CUSTOMER_TRX_ID as [VenteLigne. Pièce_ID],
INVENTORY_ITEM_ID as [VenteLigne. Article ID],
DESCRIPTION as [VenteLigne. Description Article],
if(IsNull(QUANTITY_CREDITED),0,QUANTITY_CREDITED)+if(IsNull(QUANTITY_INVOICED),0,QUANTITY_INVOICED) as [VenteLigne. Qté],
(UNIT_STANDARD_PRICE) as [VenteLigne. Prix_Theorique],
UNIT_SELLING_PRICE as [VenteLigne. Prix_de_Vente],
max((UNIT_STANDARD_PRICE))-sum(UNIT_SELLING_PRICE)*(if(IsNull(QUANTITY_CREDITED),0,QUANTITY_CREDITED)+if(IsNull(QUANTITY_INVOICED),0,QUANTITY_INVOICED)) as [VenteLigne. Remise],
UNIT_STANDARD_PRICE*(if(IsNull(QUANTITY_CREDITED),0,QUANTITY_CREDITED)+if(IsNull(QUANTITY_INVOICED),0,QUANTITY_INVOICED)) as [VenteLigne. Montant Brut],
if(INTERFACE_LINE_CONTEXT='INTERCOMPANY','Groupe','Hors Groupe') as [VenteLigne. Context],
INTERFACE_LINE_ATTRIBUTE1 as [VenteLigne. Num Cde],
EXTENDED_AMOUNT as [VenteLigne. Montant],
ORG_ID as [VenteLigne. SociétéID]
FROM
[..\QVD_Sources\RA_CUSTOMER_TRX_LINES_ALL.QVD]
(qvd)
Where
ORG_ID='155'
//or ORG_ID='158'
and (DESCRIPTION<>'Timbre Fiscal' and DESCRIPTION<>'Report')
and LINE_TYPE='LINE'
and (INTERFACE_LINE_CONTEXT='ORDER ENTRY' or INTERFACE_LINE_CONTEXT='INTERCOMPANY')
group by CUSTOMER_TRX_ID, INVENTORY_ITEM_ID
;
