[GNC] 'entries' table content - link with taxtables

Hello All, Is it normal that there is a link to taxtable entries(entries.b_taxtable = taxtables.guid) instead of NULL in invoice entries which are not taxable? It makes a lot of confusions when building SQL queries... ___ gnucash-user mailing list g

[GNC] Tax tables changing

I have renamed some of taxtables and see the same old names in my bills and invoices. I also see a lot of records with the same taxtable names in Postgresql table "taxtables". Could some body explain the logics of this table? What is "parent" in it? Thank you, Dimon. _

[GNC] Wrong running balances in reports

Appears in reports when you sorting by date and you have 2 transactions of the same date. Needs recalculation of running balance. Example of General Ledger report: VAT Output                     Dr                Cr     Running Balance 31/12/19 O.. LTD €25,080.00-€212,124.82 31/12/19 R.. GMB

Re: [GNC] Working with dates in Postgresql DB

SQL to check your records and revise the procedure which posts the data to DB? Thank you, Dimon. On Apr 29, 2020 at 19:50, wrote: On Apr 29, 2020, at 2:18 AM, finf...@gmail.com wrote: Dear John, Thank you for your response.

Re: [GNC] Working with dates in Postgresql DB

pr 29, 2020 at 19:50, wrote: On Apr 29, 2020, at 2:18 AM, finf...@gmail.com wrote: Dear John, Thank you for your response. I have collected some statistics from my DB. My DB has 1724 records - transactions. This is my SQL query, it is pretty simple and shows all t

Re: [GNC] Working with dates in Postgresql DB

ment with exact date in it I suppose to see this POST DATE the same wherever in Cyprus or UK or USA. But entering the same date I can have 5 different results. How it works and what is the reason - I have no idea... Maybe you can give some examples and the algorithm to convert these dates? Where el

[GNC] Working with dates in Postgresql DB

Hi, I have found a strange thing trying to create my report with SQL queries from Postgresql Gnucash database. The column post_date in transactions table stores values in timestamp format (-MM-DD hh:mm:ss). If I compare the post date in the transaction inside Gnucash program and in Pos

[GNC] cMakeError.log errors - building Gnucash 3.10

I have these errors in cMakeError.log after cmake: Can anybody explain how to fix that? Performing C++ SOURCE FILE Test HAVE_OFX_BUG_39 failed with the following output: Change Dir: /home/dfg/Applications/build-gnucash-3.10/CMakeFiles/CMakeTmp Run Build Command:"/usr/bin

[GNC] Error in Income and GST statement

When you have purchase of a fixed asset, you miss the tax and purchase amount in the report. It looks like this report does does not check FA accounts. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or t

[GNC] Customizing of trial balance report to have a standard appearance for auditors

Hello! Can you please help in customizing the trial-balance.scm to add some data in this report? These is what I need to see there: - the opening balance for start-date - the sum of debits - the sum of credits - the ending balance for end-date - the subtotals per account group in the bala