https://bugs.kde.org/show_bug.cgi?id=478386
Bug ID: 478386
Summary: The "priceFormatted" column does not populate with 1,
or any value when I save
Classification: Applications
Product: kmymoney
Version: 5.1.3
Platform: Microsoft Windows
OS: Microsoft Windows
Status: REPORTED
Severity: normal
Priority: NOR
Component: database
Assignee: kmymoney-devel@kde.org
Reporter: rami.g.ma...@gmail.com
Target Milestone: ---
Created attachment 164082
--> https://bugs.kde.org/attachment.cgi?id=164082&action=edit
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()));
--
You are receiving this mail because:
You are the assignee for the bug.
