1 Topic by jebba

(0 replies, posted in Wish List)

Hi, here is a concrete example of what I would like to do. We have all the items/kit/BoM set up for a Prusa Mendel in FA. I also have a spreadsheet (CSV) of the McMaster-Carr part numbers. McMaster has a variety of ways to place orders in their system. One way I can do it is just write a little script that parses the latest prusa_parts.csv file and POSTS it over to them. I could then POST the order into FA.

McMaster also supports EDI, but I don't see support for this in FA.

Coming to my question: which is the cleanest/best way to automate part ordering with FA?

Thanks!

-Jeff Moe

Go to forum: Wish List

2 Reply by jebba

(8 replies, posted in Banking and General Ledger)

I used the table prefix and it fixed the error with "System and General GL Setup". I haven't set it up to close out the year yet.

Go to forum: Banking and General Ledger

3 Reply by jebba

(8 replies, posted in Banking and General Ledger)

Thanks for your quick reply.

I believe the inability to close out empty years was the result of a problem with the SQL in the COA. If I tried to go to "System and General GL Setup" with this COA it gives a SQL error, which I believe is related.

To reproduce:

* Start a new company
* Use the 8 digit GAAP USA COA
* I typically use no TABLE prefix (e.g. no 0_), this may be related
* Goto "System and General GL Setup"
* BONK!

-Jeff

Go to forum: Banking and General Ledger

4 Topic by jebba

(8 replies, posted in Banking and General Ledger)

Hi,

I am starting a new company and am thrilled to be able to use such an advanced free software accounting package. It was quite a pleasant surprise to find it.

In the process of looking at various COAs, I would do thusly:

1) start new company with new COA
2) Add a new fiscal year for 2011
3) Set current fiscal year to 2011
4) Go delete the old fiscal years that came stock in the COA (e.g. 2008, 2009, 2010, when the company didn't exist).

This worked fine with some COAs, but failed with this one: 8 digit GAAP compatible American chart of accounts. I have version 2.3.0-2.

I go to close 2008 and it gives me the error:

"The Retained Earnings Account should be a Balance Account or the Profit and Loss Year Account should be an Expense Account (preferred the last one in the Expense Class)"

All numbers are 0, as no data has been entered.

How do I fix this?

Thanks!

-Jeff

Go to forum: Banking and General Ledger