It's much more fun, when you can discuss your problems with others...
You are not logged in. Please login or register.
FrontAccounting forum → Posts by tom
If I use a CSV Import file for inventory adjustments and I have the correct price for each record then WILL FA compute the correct gain or loss?
Or maybe the question is are there some other matching transactions I need to generate and import as well?
The FIFO aspect is one I am not sure FA handles properly, I want to get this right now so I don't discover an issue 5 years from now and have to clean up a big mess...
I am not overly concerned with live import, I was considering monthly import maybe via CSV profit/loss and tax reporting
I saw your other post, not sure which thread is most appropriate...
The basic thought process is to keep track of crypto may be something like
Treat the crypto like an inventory item (physical asset) and then import transactions much like 'Inventory Adjustments'
The GL transactions would track the value if each individual inventory item
It is much like knowing how much each item is as you sell it, as opposed to averaging the cost across all the inventory on hand
(Can FA do this now? It is could be used on normal inventory items)
Some transactions would appear as Income and others would be converting between crypto/FIAT (ie USD, etc)
I am not sure how these actions are handled with the GL accounts
I need some education on this.
Would the Import Transactions be a good place or should I take break off and make a new module?
Tom
It dawned upon me that what I referred to as "current asset value" was actually Cost Basis.
I also think that both the Cost Basis, Unrealized Gains and Profit are all Tax/Reporting issues.
So I think I need to better understand how item cost is calculated and used in inventory.
More later
Tom
One aspect of my business is to perform cryptocurrency mining (Proof Of Work) generating income as an asset.
How could we manage this type of ledger?
Generally Crypto is considered an Asset and POW coins more so since they can not be minted (created) out of thin air.
My first thought is they are very much like an Inventory Item (Physical Asset) that has an account (GL?) tracking the realized value.
For example if I earn 20 coins while the value (price) is $0.50 the value/income if $10.00
If I sell 5 coins at $1.50 that would obviously be an additional $5 of income and I think typically the income would be calculated on the oldest unsold coins, First In, First Out
So at this point we have $15 of income and a current asset value of (20-5)*1.50 = $22.50 with Unrealized gains of $15.00
Are my thoughts on this reasonably accurate?
I think these point are common to all localities, but the calculation of Long/Short Term Gains would be left to tax calculations
I am not looking to pay someone to do this, but could use some help.
I do not believe such a fundamental feature qualifies as an add-on that is sold.
So I am asking for anyone who has the skills to do it contribute their time which is the whole point of open source.
Supporting Crypto will help keep FA relevant and I do not think these changes will be overly dramatic to implement.
Anyone interested in working with me?
--
Tom
PS
I have been using FA for over 15 years and have submitted every modification I needed for my shop as either a patch or extension.
For example:
Bank Fees on customer payments
osCommerce customer/order import extension
I am currently working on a WooCommerce order import extension which I will make freely available in the core FA repo
My son and I are also deploying FA as a turnkey application on Flux Web services (runonflux.io) which is a distributed compute network on a blockchain
Ok, I was able to manually import the US demo data and I get an error:
ERROR 1067 (42000) at line 35: Invalid default value for 'tran_date'
The table is:
CREATE TABLE `0_attachments` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`description` varchar(60) NOT NULL DEFAULT '',
`type_no` int(11) NOT NULL DEFAULT '0',
`trans_no` int(11) NOT NULL DEFAULT '0',
`unique_name` varchar(60) NOT NULL DEFAULT '',
`tran_date` date NOT NULL DEFAULT '0000-00-00',
`filename` varchar(60) NOT NULL DEFAULT '',
`filesize` int(11) NOT NULL DEFAULT '0',
`filetype` varchar(60) NOT NULL DEFAULT '',
PRIMARY KEY (`id`),
KEY `type_no` (`type_no`,`trans_no`)
) ENGINE=InnoDB;
I am using mysql:8.3.0 (docker image)
Maybe I need to use an older version. The docs did not recommend any specific mySQL version...
Thanks!
ps. I don't think I can use an older mysql due to some clustering that is being done.
I did see that the valid date range is : The supported range is '1000-01-01' to '9999-12-31'.
Will the default value of 1000-01-01 cause any SQL issues?
I am doing a fresh install on a new hosting platform
In the setup wizard I get the db connection setup ok, but when I import the COA with or without demo data I get
504 Gateway Timeout
any suggestions where to look?
Is the import data local or being pulled from an FA site?
Tom
Is the zip file better than git master branch?
The README.md file has a GitHub Mirror Link:
https://github.com/FrontAccountingERP/FA
Both the github mirror and sf.net git do not have release tags for 2.4.18 so is master the latest release?
I am building a docker image and it's usually best to refer to the version tag so a rebuild doesn't get an unexpected update.
(Yes I know it is really mature... just good practice...)
Maybe a 2.4.18 tag could be added? (github or sf, either is fine)
Tom
The README.md file has a GitHub Mirror Link:
https://github.com/FrontAccountingERP/FA
Both the github mirror and sf.net git do not have release tags for 2.4.18 so is master the latest release?
I am building a docker image and it's usually best to refer to the version tag so a rebuild doesn't get an unexpected update.
(Yes I know it is really mature... just good practice...)
Maybe a 2.4.18 tag could be added? (github or sf, either is fine)
Tom
I feel I am being dense, but I will ask anyway.
So if I want to submit updates or bug fixes I should github or git.code.sf.net?
Tom
I would have but all the webpages point to CVS and sf and the labels are not current
Is there a repo I can access / clone / help again?
I found the problem
elseif( $Mode == 'Delete')
{
//the link to delete a selected record was clicked instead of the submit button
$cancel_delete = 0;
// PREVENT DELETES IF DEPENDENT RECORDS IN 'bank_trans'
if (key_in_foreign_table($bank_id, 'bank_trans', 'bank_act') || key_in_foreign_table(get_post('account_code'), 'gl_trans', 'account'))
{
$cancel_delete = 1;
display_error(_("Cannot delete this bank account because transactions have been created using this account."));
}
get_post('account_code') returns 1060 and the bank_id I am trying to delete has account 1063
Maybe it should get t he account from the bank account info...
What's the best way to fix this?
This worked:
$myrow = get_bank_account($bank_id);
if (key_in_foreign_table($bank_id, 'bank_trans', 'bank_act') || key_in_foreign_table($myrow['account_code'], 'gl_trans', 'account'))
Tom
I am having problems deleting old bank accounts, even some I have not used for many years.
I have deleted all but the current Fiscal Year.
In bank inquiry I found opening balances for this year in gl_trans and bank_trans and even with those removed I can't delete the bank account
This account uses GL 1063 (and it's the only bank account using that one)
I have 4 that all use 1060 which may need more care
Suggestions?
How do you increase that time?
I have been using FA for a business since 2010 and the ownership has changed from a single owner to LLC
I want to delete the past years and reset the GL accounts to 0
I assume the first step is to delete all previous years
Wow that was easier than I thought...
I do see some some balances that are wrong, but just deleting the years did most of what I wanted
Maybe not so much wrong... but I did find I could not delete long gone bank accounts.
It seems what FA 2.4.6 I was able to create more than one 1060 bank account...
I may need advice on how to remove the extra ones
Tom
I am not much of a WordPress dev, would it be a fools errand to have a FA add-on that pulled the data directly from the WP/woo database directly?
OK I'll look at closer.
I found that I did not have any modifications in my 2.4.6 site, so I did not need to apply any to 2.4.18
When I look at orders in the Delivery Against SO fa/sales/inquiry/sales_orders_view.php?OutstandingOnly=1
The orders show the SubTotal, not Account Total
The addition is Sales Tax, now maybe there was a change between 2.4.6 and 18 in this area
Just 3 current accounts of shareholders.
Sorry I am a bit thick...
3 GL accounts? like 2681-2683 and then the current balance would be available from a GL Inquiry?
--
update:
Yes that works and makes sense.
Thanks
Check out one of the first lines in includes/session.inc file for the SECURE_ONLY constant.
I tried NULL (as the comment suggested if you need http access) as well as true and no change
You are right, I meant to say Woocommerce plugin
Does anyone have an extension that allows importing orders etc from a WordPress site?
Or a WordPress plugin that talks to FA
I wanted to see what is around before I consider making one...
In my past usage of FA I have been the only shareholder and from time to time used "Loans From Shareholders" account
Now my son's have joined me and we now have 3 possible shareholders to get loans from (interest free)
To keep things straight I wanted to create a bank account for each of us to track the total liability
Do I make 3 new GL accounts under 2680 and assign those GL to each bank account used for this?
(I tend to think not - with the quick entries for "Loan from shareholder" and "loan repayment"
Or do I create 3 Bank Accounts as a "Credit Account" but what GL account?
And then use the Load/Repay to deposit and withdraw from the Credit Account
Tom
FrontAccounting forum → Posts by tom
Powered by PunBB, supported by Informer Technologies, Inc.
Currently installed 4 official extensions. Copyright © 2003–2009 PunBB.