Hi,
My challenge is that I would like to link a unique G/L entry to the sales invoice line which generated it. I cannot see any field with which to do this 100% robustly.
I have an invoiced sales report where the primary purpose is to analyse product details and categorisations. Due to data demands, I have used NL sum formulas to do reduce data size which works perfectly.
However, as we sell in multiple currencies, I now have to summarise the currencies separately. If I could link the invoice line to G/L entry, I could then add the converted value from the G/L also which would be ideal to give a full report in our primary currency.
We invoice several hundred orders per day so exporting all the data to do a currency calculation is not practical.
Thanks, Guy