Created attachment 164082 [details]
KmmSplits table with blank values.

Hi, 

I'm using Excel to report on my KmyMoney data. I linked the SQLLite database as a live ODBC link to an Access database with Excel as a front end.

The Reporting query gets the amount value from [valueFormatted]/[priceFormatted], because I have foreign currency amounts and I need to convert everything to AUD on my reports.

I noticed that for some reason, the "priceFormatted" value is not always updated to "1" unless I exit KmyMoney, and re-open KmyMoney again. This prevents me from using SQLLite as a database all the time.  So I use XML, open and close, and re-update the SQLLite by a "Save As".

Is this issue something that can be fixed?

***


STEPS TO REPRODUCE
1. Open KmyMoney and create a few transactions. Do not close the file
2. Query the underlying kmmSplies table and check the priceFormatted column
3. it will be empty

OBSERVED RESULT
priceFormatted is blank

EXPECTED RESULT
priceFormatted should be 1 for local currency or the exchange value for foreign currency.

SOFTWARE/OS VERSIONS
Windows: 


ADDITIONAL INFORMATION
For your information, my Access Query is:

SELECT kmmAccounts.institutionId, [Parent Table].accountName, kmmAccounts.parentId, kmmInstitutions.name, kmmTransactions.entryDate, kmmSplits.postDate, kmmSplits.transactionId, kmmSplits.accountId, kmmAccounts.accountType, kmmAccounts.accountTypeString, kmmSplits.txType, kmmSplits.payeeId, kmmPayees.name, kmmAccounts.accountName, kmmSplits.memo, kmmSplits.valueFormatted, kmmSplits.value, kmmSplits.sharesFormatted, kmmSplits.priceFormatted, CCur([valueFormatted])/CCur([kmmSplits]![priceFormatted]) AS Amount
FROM [Parent Table] RIGHT JOIN ((((kmmSplits LEFT JOIN kmmPayees ON kmmSplits.payeeId = kmmPayees.id) LEFT JOIN kmmAccounts ON kmmSplits.accountId = kmmAccounts.id) LEFT JOIN kmmTransactions ON kmmSplits.transactionId = kmmTransactions.id) LEFT JOIN kmmInstitutions ON kmmAccounts.institutionId = kmmInstitutions.id) ON [Parent Table].id = kmmAccounts.parentId
WHERE (((kmmSplits.postDate)=Now()) AND ((Left([transactionId],1))="T")) OR (((kmmSplits.postDate)<Now()));