Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
qlikmick
Contributor II
Contributor II
‎2016-12-14 03:42 AM

Building a debtors ageing balance report from SAGE X3

Could someone please help me with expressions?  Have SAGE X3 table QVD files for tables GACCDUDATE, SINVOICE, SINVOICED and BPCUSTMVT. 

677 Views
0 Likes
2 Replies
el_aprendiz111
Specialist
Specialist
‎2016-12-14 09:05 AM

Hi

You could share more information

513 Views
qlikmick
Contributor II
Contributor II
‎2016-12-14 09:11 AM
Author

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. 

513 Views
0 Likes