Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Could someone please help me with expressions? Have SAGE X3 table QVD files for tables GACCDUDATE, SINVOICE, SINVOICED and BPCUSTMVT.
Hi
You could share more information
Ok here goes. Am finding it difficult to join the two tables GACCDUDATE with SINVOICE from X3 to start off with. The Left Join function in order to "pair up" the two tables. My second challenge would be to build dynamic expressions in order to define the Ageing split between Current, 30 days, 60 days, 90 days and 120+ days.