Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Year | Period | Document code | Clearing DocumentNumber | AR value | Invoice number | cheque number | payment term |
2024 | 12 | RV | 353535 | 100 | 12345 | N30 | |
2024 | 12 | AB | 353535 | -100 | |||
2025 | 1 | DZ | 353535 | 100 | 55557 | ||
2025 | 2 | RV | 989998 | 500 | 67899 | N60 | |
2025 | 3 | DZ | 989998 | 500 | 88995 |
INVOICES | |||||
Year | Period | Document code | Clearing DocumentNumber | AR value | Invoice number |
2024 | 12 | RV | 353535 | 100 | 12345 |
2024 | 12 | AB | 353535 | -100 |
PAYMENTS | |||||
Year | Period | Document code | Clearing DocumentNumber | AR value | cheque number |
2025 | 1 | DZ | 353535 | 100 | 55557 |
Hi, you can use tables with all fields as dimensions except AR Value, which can be a measure like:
Invoice table: Sum({<[Document code]={'RV','AB'}, [Clearing DocumentNumber]=P([Clearing DocumentNumber]),[payment term],[Invoice number],[cheque number]>} [AR value])
Payments table: Sum({<[Document code]={'RV','AB'}, [Clearing DocumentNumber]=P([Clearing DocumentNumber]),[payment term],[Invoice number],[cheque number]>} [AR value])
You can also use [Document code]*={'RV','AB'} if you want to filter Document code values