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
I am upgrading from 2.3.16 to 2.4.6 and I added my two extensions back in but they do not show up in the menus
I am guessing I had to add them manually, I just forgot how
osc_orders and import_items
I also have a minor update to osc_orders, last time I think I emailed it to Joe, is that the case still or is there a place to upload them?
Tom
Steps to Upgrade it
1. Backup the database from your current version FA 2.3.24 .
2. Install a new fresh FA 2.3.26 on separate directory.
3. Restore the database which you backed up on FA2.3.24 and login as admin in FA 2.3.26
4. Again here Backup database from 2.3.26 and save it on your pc
5. Download Fresh New FA copy, 2.4.4 and install it fresh.
6. Now you need to Restore the backup you exported from FA2.3.26
7. Now when you login as administrator, FA will ask you to update your database.
8. Now go to Software Upgrade. You can see Update option, Just click and update the Database.Once these steps done successfully, everything will be alright with new version.
I have seen these steps mentioned in a few posts.
Why do you say to upgrade to Ver 2.3.26 (last version of FA2.3) before moving to FA2.4.x?
Does this last version save things differently or the upgrade?
I ask because In Theory any FA2.3 version should have the same DB structure
Tom
If I am changing an account from one checking acount (1060) to another (1062) should I transfer the funds out before the change and back in after?
I tried that but I can't because I had already received items on the PO
I entered a PO and received items upon it.
Now I need to cancel the whole thing (drop ship order cancelled)
I have not been invoiced by the supplier.
Is there a clean way to do this?
It almost seems that I need to create a dummy invoice and then do a return.
Is there a simpler eay?
Tom
humm... that does not help.
Which lines appear wrong?
can you show us the first few lines of the csv file?
tom
What sets the duration?
Right now it seems to be 10 days... I can't find any setting that changes this.
In
Since you don't want the Capital Introduced back, do you fold that into the Profit/Loss at the end of the year?
from re-reading this thread it looks like when the year is closed things get accumulated automatically into profit/loss.
So where did you put the Capital Introduced? Class/Group?
It seems if I put it in the right place in the COA it will get rolled into the profit/loss automatically.
tom
Maybe I am handling things incorrectly...
I use the Loan from Shareholders for then I use personal money for expenses that can be written off to the business.
I do not what that money back, as the business usually ends up at an operating loss.
Maybe there is a better way to do this.
tom
What I am trying to do is take the retained earnings and get rid of them, I think it was a mistake from 2 years ago.
Last year when I needed to put money into the business I deposited it as a Loan from shareholders.
I want to convert that to a loss without messing with the bank accounts.
Oh My... I think the light bulb just went on...
Do I need to do two Journal Entries?
Like:
Debit 2680 Loans
Credit 9990 Year Profit/Loss
Is a Credit to 9990 a Loss?
tom
Well this is all it says...
When you start a new Company, you should check that the Fiscal Year is setup correctly. If this is not your starting Fiscal Year, then you should start by creating the starting Fiscal Year. After you have corrected the starting Fiscal Year, you can delete other Fiscal Years if there are no transactions in them. Now set this new Fiscal Year on your company by selecting Setup tab, Company Setup.
If the first year is setup as Jan 01 2011 - Dec 31 2011 and your starting Fiscal Year should be Jul 01 2011 - Jun 30 2012, then you must first create a short dummy year, Jan 01 2012 - Jun 30 2012. Create another Year Jul 01 2012 - Jun 30 2013. Set the company to use this year. Now close and delete the year Jan 01 2011 - Dec 31 2011. Close and delete the short dummy year Jan 01 2012 - Jun 30 2012. And then create the correct broken Fiscal Year Jul 01 2011 - Jun 30 2012. After the creation, set this Fiscal Year as active on the company. You are now ready to make your transactions. You have 2 fiscal years and you are using the current one.
When you reach the end of your Fiscal Year, you have to create another new Fiscal Year. When you want to switch Fiscal Year on your company, go into company setup and do that. When you have finished your year-end entries, you may close the Fiscal Year.
A closed Fiscal Year can no longer be used for entries. When a Fiscal Year is closed, the difference between all asset and liability accounts are brought forward as a Journal Entry where the Default account for Retained Earnings is credited (if this is a profit, otherwise it is debited). And the default account Profit/Loss Year is debited (if this is a profit, otherwise it is credited).
You can have as many Fiscal Years running as you want, but for performance reasons you should not have more than needed (by your legislations). When you delete a Fiscal Year, the assets, liabilities and equities are brought forward. All other unneeded transactions such as documents are deleted.
Tips and Tricks
----------------------
I searched for "YEAR" and did not find anything relating to year end close-out.
This really needs to be in the wiki!
(all of the above... well the important activities)
How do I get rid of retained earnings?
Do I do a Bank Payment and select that account?
How about converting Loans from Shareholders to loss?
Pay it back somehow?
tom
Are you downloading the backup or just saving it to the server disk?
When it comes up empty are you trying to View it online?
tom
I think you mean this post: https://frontaccounting.com/punbb/viewtopic.php?id=2451
I did not see any replies to it...
Is that the right way?
I will go look, AGAIN
Sorry!
What is the right way in FA to write off a debt as a loss?
I have some invoices that were either never paid, or I never received full payment on.
I guess I will end up with the invoice fully paid but with money in Bad Debts (5620) and then I assume when I close the year
that money will show up as a Loss.
Tom
Thanks for letting us know!
Not for the *same* item, but I do have for example
STONE Bulk with UOM 1LB and
4LB Stone with UOM each
The Bulk stone is my purchased inventory and the 4LB Bag is a Manufactured Item.
Here is the general flow of a given Raw Material:
1) Buy 50lb box of Lab Stone (Supp Unit 50lb Box, Conversion factor 50)
2) STONE Inventory Level becomes 50
3) Sell 5 Units of Stone Bulk
4) STONE Inventory Level becomes 45
5) Get an Order for 3 4LB Bags of stone
6) Manufacturer 3 "4LB Bags"
7) STONE Inventory Level becomes 33
You can have different versions so long as you can manufacturer the secondary items.
tom
Gee like that is not blatant advertising, are we stupid?
Chris,
How about the osc_import?
The way I use it is when I have new orders I can log into FA and do a few clicks and tell it to import new customers
and import new orders and then I continue with FA as normal.
There is also options to verify item code and prices and price update FA->osc
tom
ex-osC core developer
I may be missing something, but aren't there hooks already for maintaining the current Exchange Rate from your base currency (EUR) and others (like USD)
tom
You can define your own units for each inventory item.
I maintain bulk inventory in LBS of which I 'manufacture' bags of 1/4, 1/2, 3/4 and 1LB, so it sounds a lot like what they need.
I buy things in 50lbs or 20kg buckets and use the purchasing pricing and UOM conversion to restock myself.
tom
Yes, see the Readme.txt and post here is you still have problems.
It should be under Items and Inventory -> Import CSV Items
tom
It almost sounds like a second setting would really be needed.
DECIMAL_PLACES_INTERNAL (accounting use) and DECIMAL_PLACES_EXTERNAL (seen by customers)
The problem is that at some point you need to actually round from 3 places to 2 places so that when you deal with
the ledger you never have partial pennies, invoices and payments need to be exact.
These 3 decimal place costed items, do you often sell 1 or 2?
sounds like money... are you dealing with 1/8ths?
tom
FrontAccounting forum → Posts by tom
Powered by PunBB, supported by Informer Technologies, Inc.
Currently installed 4 official extensions. Copyright © 2003–2009 PunBB.