[kmymoney] [Bug 478386] New: The "priceFormatted" column does not populate with 1, or any value when I save

[bugzilla_noreply at kde.org]

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 at kde.org
          Reporter: rami.g.matar at 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.