Re: [GNC] Negative assets!
On 09/06/2018 05:07 PM, Muhammad Bashir Al-Noimi wrote: On 09/06/2018 02:49 PM, Adrien Monteleone wrote: Credit Cards are usually liabilities, not Assets. Actually it's an asset because it's very special card provided by my company. Click that credit card account in the CoA and then click the Edit Account button . What fundamental type is it? Asset? Liability? Asset Also, out of curiosity, does a Balance Sheet also show negative Current Assets? In the attachment you can find my Balance Sheet all the red values are incorrect. I may discovered the problem. In the attachment you can find that "Imbalance-USD" contains on duplicated incorrect transactions which I didn't create them!!! Do you have any suggestion for this strange case? Thanks very much guys I could fix the problem by following these steps: 1. Manually deleted all the duplicated transactions in "Imbalance-USD" 2. Manually deleted all empty transactions in "Imbalance-USD" 3. Emptied "Assets:Current Assets:GAU" then re-entered same transactions once again. It seems that my database entries corrupted because I didn't point to a correct account during deleting the old accounts. -- Best Regards, Muhammad Bashir Al-Noimi Skype+Telegram+GMail: mbnoimi ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Negative assets!
On 09/06/2018 05:25 PM, Geert Janssens wrote: Yes, that means the transactions you deleted were transferred to imbalance-USD because you didn't assign them to a new account. Does your book use multiple currencies ? Yes, I use multi-currencies -- Best Regards, Muhammad Bashir Al-Noimi Skype+Telegram+GMail: mbnoimi ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Negative assets!
Op donderdag 6 september 2018 16:07:35 CEST schreef Muhammad Bashir Al-Noimi: >I may discovered the problem. >In the attachment you can find that "Imbalance-USD" contains on >duplicated incorrect transactions which I didn't create them!!! >Do you have any suggestion for this strange case? Yes, that means the transactions you deleted were transferred to imbalance-USD because you didn't assign them to a new account. Does your book use multiple currencies ? Regards, Geert ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Negative assets!
Credit Cards are usually liabilities, not Assets. To not see a balance as a ‘Current Asset’ for an account that isn’t really a current asset makes sense. Though I’m not sure the code involved is paying attention to account type more than the sub-account’s location in the tree. Click that credit card account in the CoA and then click the Edit Account button. What fundamental type is it? Asset? Liability? Also, out of curiosity, does a Balance Sheet also show negative Current Assets? Regards, Adrien > On Sep 6, 2018, at 4:05 AM, Muhammad Bashir Al-Noimi > wrote: > > On 09/06/2018 11:55 AM, Geert Janssens wrote: > > Most transactions not showing a balance is odd. > > See this transaction as example: > When I open it from "Assets:Current Assets:TRY:Kocamustafapasa - > CreditCard" it appears correctly as shown below: > But when I open same transaction from "Current Assets and select > Edit>Open Subaccounts" it appears without a balance as shown below: > -- > Best Regards, > Muhammad Bashir Al-Noimi > Skype+Telegram+GMail: mbnoimi > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Negative assets!
On 09/06/2018 11:55 AM, Geert Janssens wrote: Most transactions not showing a balance is odd. See this transaction as example: When I open it from "Assets:Current Assets:TRY:Kocamustafapasa - CreditCard" it appears correctly as shown below: But when I open same transaction from "Current Assets and select Edit>Open Subaccounts" it appears without a balance as shown below: -- Best Regards, Muhammad Bashir Al-Noimi Skype+Telegram+GMail: mbnoimi ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Negative assets!
On 09/06/2018 11:55 AM, Geert Janssens wrote: Most transactions not showing a balance is odd. Have you tried to run check & repair on your assets account and its children ? I did, nothing changed. -- Best Regards, Muhammad Bashir Al-Noimi Skype+Telegram+GMail: mbnoimi ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Negative assets!
Op donderdag 6 september 2018 10:47:56 CEST schreef Muhammad Bashir Al-Noimi: >On 09/06/2018 05:37 AM, John Ralls wrote: > >Well, make completely sure. With the accounts page open, select >View>Filter By... and make sure that all of the account types are >selected on the “Account Type" tab and that Show hidden accounts is >selected on the “Other” tab. There’s another way to get there as well: >You can select Current Assets and select Edit>Open Subaccounts, which >will open a register showing all of the transactions from Current >Assets and all of its sub accounts in the normal order. That might help >you see the transactions that drive it to a negative balance. > >I did that, I couldn't find any negative transactions (only a tiny one >which I already know it). But I noticed most transactions don't reflect >any balance while others did, does this related to my problem? > >How much is the discrepancy? IOW, if you add up all of the (positive) >totals showing in the first-level sub accounts and then add the >opposite of the (negative) total showing in Current Assets, what’s the >difference? > >The discrepancy is big because when I calculate all my assets manually >(multi-currencies) they did match the sub-accounts. > >Are there any transactions in Current Assets? Being a placeholder >prevents you from adding transactions from the register, but there are >other ways that transactions can get into it, including being >transferred there when you delete a sub-account. Double clicking on it >won’t work because it’s a placeholder so you have to use Edit>Open >Account or pick Open from the context menu when Current Assets is >selected. > >When I disabled "Placeholder" feature for "Current Assets" and "Assets" >I found both of them are empty. >THIS IS REALLY STRANGE I DID NOT FACE ANY PROBLEM WITH GNC BEFORE >ALTHOUGH I USE IT SINCE YEARS AGO >Thanks a lot John for the patience. Most transactions not showing a balance is odd. Have you tried to run check & repair on your assets account and its children ? Geert ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Negative assets!
On 09/06/2018 05:37 AM, John Ralls wrote: Well, make completely sure. With the accounts page open, select View>Filter By... and make sure that all of the account types are selected on the “Account Type" tab and that Show hidden accounts is selected on the “Other” tab. There’s another way to get there as well: You can select Current Assets and select Edit>Open Subaccounts, which will open a register showing all of the transactions from Current Assets and all of its sub accounts in the normal order. That might help you see the transactions that drive it to a negative balance. I did that, I couldn't find any negative transactions (only a tiny one which I already know it). But I noticed most transactions don't reflect any balance while others did, does this related to my problem? How much is the discrepancy? IOW, if you add up all of the (positive) totals showing in the first-level sub accounts and then add the opposite of the (negative) total showing in Current Assets, what’s the difference? The discrepancy is big because when I calculate all my assets manually (multi-currencies) they did match the sub-accounts. Are there any transactions in Current Assets? Being a placeholder prevents you from adding transactions from the register, but there are other ways that transactions can get into it, including being transferred there when you delete a sub-account. Double clicking on it won’t work because it’s a placeholder so you have to use Edit>Open Account or pick Open from the context menu when Current Assets is selected. When I disabled "Placeholder" feature for "Current Assets" and "Assets" I found both of them are empty. THIS IS REALLY STRANGE I DID NOT FACE ANY PROBLEM WITH GNC BEFORE ALTHOUGH I USE IT SINCE YEARS AGO Thanks a lot John for the patience. -- Best Regards, Muhammad Bashir Al-Noimi Skype+Telegram+GMail: mbnoimi ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Negative assets!
> On Sep 5, 2018, at 5:51 PM, Muhammad Bashir Al-Noimi > wrote: > > On 09/06/2018 03:25 AM, John Ralls wrote: >> That’s Assets:Current Assets on the Accounts page, right? Not an entry in >> the summary bar at the bottom of the page? > YES; It's an account in Accounts tree defined as a placeholder. > >> Might you have hidden accounts with negative balances? > I'm pretty sure all the sub accounts in Assets are in positive values. Well, make completely sure. With the accounts page open, select View>Filter By... and make sure that all of the account types are selected on the “Account Type" tab and that Show hidden accounts is selected on the “Other” tab. There’s another way to get there as well: You can select Current Assets and select Edit>Open Subaccounts, which will open a register showing all of the transactions from Current Assets and all of its sub accounts in the normal order. That might help you see the transactions that drive it to a negative balance. How much is the discrepancy? IOW, if you add up all of the (positive) totals showing in the first-level sub accounts and then add the opposite of the (negative) total showing in Current Assets, what’s the difference? Are there any transactions in Current Assets? Being a placeholder prevents you from adding transactions from the register, but there are other ways that transactions can get into it, including being transferred there when you delete a sub-account. Double clicking on it won’t work because it’s a placeholder so you have to use Edit>Open Account or pick Open from the context menu when Current Assets is selected. Regards, John Ralls ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Negative assets!
On 09/06/2018 03:25 AM, John Ralls wrote: That’s Assets:Current Assets on the Accounts page, right? Not an entry in the summary bar at the bottom of the page? YES; It's an account in Accounts tree defined as a placeholder. Might you have hidden accounts with negative balances? I'm pretty sure all the sub accounts in Assets are in positive values. -- Best Regards, Muhammad Bashir Al-Noimi Skype+Telegram+GMail: mbnoimi ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Negative assets!
> On Sep 5, 2018, at 8:09 AM, Muhammad Bashir Al-Noimi > wrote: > > On 09/05/2018 06:06 PM, Muhammad Bashir Al-Noimi wrote: >> On 09/04/2018 05:55 PM, John Ralls wrote: >>> When you deleted the accounts, what did you tell GnuCash to do with the >>> transactions? >> I don't remember exactly. >> >>> Do you have any Imbalance-XXX accounts? >> Yes I've these accounts but they are empty. > BTW, All the accounts are correct. I couldn't find any strange transaction > just the negative -red- value of "Current Assets" account. That’s Assets:Current Assets on the Accounts page, right? Not an entry in the summary bar at the bottom of the page? Might you have hidden accounts with negative balances? Regards, John Ralls ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Negative assets!
On 09/05/2018 06:06 PM, Muhammad Bashir Al-Noimi wrote: On 09/04/2018 05:55 PM, John Ralls wrote: When you deleted the accounts, what did you tell GnuCash to do with the transact ions? I don't remember exactly. Do you have any Imbalance-XXX accounts? Yes I've these accounts but they are empty. BTW, All the accounts are correct. I couldn't find any strange transaction just the negative -red- value of "Current Assets" account. -- Best Regards, Muhammad Bashir Al-Noimi Skype+Telegram+GMail: mbnoimi ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Negative assets!
On 09/04/2018 05:55 PM, John Ralls wrote: When you deleted the accounts, what did you tell GnuCash to do with the transact ions? I don't remember exactly. Do you have any Imbalance-XXX accounts? Yes I've these accounts but they are empty. -- Best Regards, Muhammad Bashir Al-Noimi Skype+Telegram+GMail: mbnoimi ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Negative assets!
> On Sep 4, 2018, at 3:12 AM, Muhammad Bashir Al-Noimi > wrote: > > Hi, > After deleting some sub accounts under "Assets" I get negative value in > "Current Assets". I manually look for any transaction(s) related to > "Current Assets" but I failed to find any transaction related to it. > How can I fix negative assets? > NOTES: > * I use multi-currencies. > * I'm unable to see any negative values under "Current Assets" sub > accounts. > * All "Current Assets" sub accounts defined as "Asset" account type. > When you deleted the accounts, what did you tell GnuCash to do with the transactions? Do you have any Imbalance-XXX accounts? Regards, John Ralls ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Negative assets!
Hi, After deleting some sub accounts under "Assets" I get negative value in "Current Assets". I manually look for any transaction(s) related to "Current Assets" but I failed to find any transaction related to it. How can I fix negative assets? NOTES: * I use multi-currencies. * I'm unable to see any negative values under "Current Assets" sub accounts. * All "Current Assets" sub accounts defined as "Asset" account type. -- Best Regards, Muhammad Bashir Al-Noimi Skype+Telegram+GMail: mbnoimi ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.