Hi,
I have an issue when adding an additional qvd file to my script. I have two scripts as my sales for items and my sales for postings to general ledger get posted to different areas of the ERP system we use, so i've had to create different views, and then different qvd files.
So, I've got a script running, which i have attached to this question, the first gives me the correct figure of £532, the second gives me a figure of £500 - The invoice is just one that I have selected at random, there are a few having this problem.
The only difference between the two is the loading of the GL script, however, there are no GL postings on this paticular invoice, so, not sure why it would be affected.
LOAD
[Account Code],
[Customer],
[Access Account Code],
[Account Manager],
[Day of Month],
[Year],
[Country],
[Customer Type],
[Date],
[Month],
[Sales Revenue],
[Product Code],
[Gross Profit]
FROM
\\HDG-FILE\USERS2\Qlik\MyFile5.qvd (qvd)
