51 Topic by tom

(14 replies, posted in Banking and General Ledger)

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

Go to forum: Banking and General Ledger

52 Reply by tom

(23 replies, posted in Modules/Add-on's)

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?

Go to forum: Modules/Add-on's

53 Reply by tom

(2 replies, posted in Accounts Receivable)

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

Go to forum: Accounts Receivable

54 Topic by tom

(2 replies, posted in Accounts Receivable)

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

Go to forum: Accounts Receivable

55 Reply by tom

(2 replies, posted in Banking and General Ledger)

apmuthu wrote:

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

Go to forum: Banking and General Ledger

56 Reply by tom

(4 replies, posted in Installation)

apmuthu wrote:

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

Go to forum: Installation

57 Reply by tom

(23 replies, posted in Modules/Add-on's)

You are right, I meant to say Woocommerce plugin

Go to forum: Modules/Add-on's

58 Topic by tom

(23 replies, posted in Modules/Add-on's)

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...

Go to forum: Modules/Add-on's

59 Topic by tom

(2 replies, posted in Banking and General Ledger)

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

Go to forum: Banking and General Ledger

60 Reply by tom

(4 replies, posted in Installation)

I have my old fa 2.4.6 up and running and it does not happen there (does have ssl)

My new site is local on my LAN and does not have SSL just yet... (docker fun)

Could that be it?
Is the a setting I need to adjust while I am not using https?

Go to forum: Installation

61 Topic by tom

(4 replies, posted in Installation)

If I want to add an item to a SO I type the Item Number  in "Item Code" and the Item Description changes to the item

That is how my old installation ran but running FA 2.4.18 i sometimes see the Item Code and Description field rapidly toggle between the previous value and one I just typed. It is almost like each field has an onChange action and they are battling it out

I have found that if I type in Item Code and instead of enter or tab, if I switch to a different browser tab and go back then it is correct

Anyone seen anything like this?

I am using Brave Browser... Saying that suggests to me I should try a different browser...

I tried Chrome and it did the same thing. video attached

Go to forum: Installation

62 Reply by tom

(8 replies, posted in Manufacturing)

I figured out the problem!

I have some items in my BOM that have a 0 quantity this seems to no longer work.

If I remove the q=0 items I can assemble them again!

Go to forum: Manufacturing

63 Reply by tom

(8 replies, posted in Manufacturing)

I think I am getting closer to seeing what the issue is.

On the old site if I open the database in phpmyadmin the wo_requirements table has 8000 records and on the imported site only 300

I also get an error from myphpadmin when browsing that table that looks like a php issue

I am going to try mysqldump and see if I get all 8000 records for that table

--- error below

Warning in ./libraries/sql.lib.php#613
count(): Parameter must be an array or an object that implements Countable

Backtrace

./libraries/sql.lib.php#2128: PMA_isRememberSortingOrder(array)
./libraries/sql.lib.php#2062: PMA_executeQueryAndGetQueryResponse(
array,
boolean true,
string 'gotgrit_fa24',
string '0_wo_requirements',
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
string '',
string './themes/pmahomme/img/',
NULL,
NULL,
NULL,
string 'SELECT * FROM `0_wo_requirements`',
NULL,
NULL,
)
./sql.php#221: PMA_executeQueryAndSendQueryResponse(
array,
boolean true,
string 'gotgrit_fa24',
string '0_wo_requirements',
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
string '',
string './themes/pmahomme/img/',
NULL,
NULL,
NULL,
string 'SELECT * FROM `0_wo_requirements`',
NULL,
NULL,
)

Go to forum: Manufacturing

64 Reply by tom

(8 replies, posted in Manufacturing)

Humm... I did delete a handfull of closed fiscal years, but other than that not much.

I'll look at a known good backup and see what that table looks like..

Might I need to recreate the BOMs used to manufacture  that product?

Go to forum: Manufacturing

65 Reply by tom

(8 replies, posted in Manufacturing)

>  wo_requirements the highest id is 8616 and the SQL refers to 8652

The SQL refers to id = 8652 and the highest id in the table is 8616, what could cause the code to refer to a non-existent record?

Go to forum: Manufacturing

66 Topic by tom

(8 replies, posted in Manufacturing)

I have ported my db from 2.4.6 to 2.4.18

I have a number of products are are assembled with a BOM and when I have all the items required I get the following error

<b>DATABASE ERROR :</b> The work requirements issued quantity couldn't be updated<br>error code : 1048<br>error message : Column 'unit_cost' cannot be null<br>sql that failed was : UPDATE 0_wo_requirements SET
                unit_cost = (units_issued*unit_cost+0)/(units_issued+0),
                units_issued = units_issued + '0'
            WHERE id = '8652'<br><br><br>

I am am able to enter other work orders

in wo_requirements the highest id is 8616 and the SQL refers to 8652

strange

I am using PHP 7.4.33 and mysql 8.0

Go to forum: Manufacturing

67 Reply by tom

(11 replies, posted in Setup)

We're circling around semantics.

Old computers can run modern (more secure) versions of Linux...

So anyway ..

The bottom line is that while PHP8 is supported, it sounds like PHP5 is recommended

Right?

Go to forum: Setup

68 Reply by tom

(11 replies, posted in Setup)

I didn't mean to spark a Holy War!

I have run the recent server versions of Ubuntu (like 22.04) on 10 year old systems, add memory and they run well.
Older computers do not mandate old operating systems (unless we're talking about Windows lol)

I am sure Air gapped / VPN system won't be cheap and old smile

All kidding aside, with such a discrepancy between recommended support (PHP5) and current releases it sounds like a official docker image would really make installs easier.

And in fact putting the install inside a container provides some additional isolation...

Go to forum: Setup

69 Reply by tom

(11 replies, posted in Setup)

PHP 5?

The release announcement for 2.4.18 says PHP 8

Is that wrong?

Go to forum: Setup

70 Reply by tom

(11 replies, posted in Setup)

Well I started looking at the diffs between my version and the update files and then I tried the obvious and downloaded a fresh 2.4.6 unziped it and compared against my files

No changes... I guess all my updates were included in the 2.4.6 release (actually I had a fa23 directory, so maybe in 2.3...)

Whew this will be easy

Is there an official docker image?

I run almost everything I can in dockers for portability

Tom

Go to forum: Setup

71 Reply by tom

(11 replies, posted in Setup)

I recall making code changes, I think many were pushed back into the main source.
I am fairly sure I did not make db changes, I guess we'll find out.

myqsl_diff may come in handy...

Tom

Go to forum: Setup

72 Topic by tom

(11 replies, posted in Setup)

I have Version 2.4.6 Build 24.12.2018 and want to upgrade to the latest version so I can get PHP8 support.

The latest is 2.4.18

Assuming I have not modified the database will a 2.4.6 backup restore ok in 2.4.18

I am going to wipe the old Fiscal Years, but want to keep inventory, manufacturing and COA, etc

Tom
(yes I been gone for a very long time)

Go to forum: Setup

73 Reply by tom

(1 replies, posted in Modules Add-on's)

Any comments?

I got some github messages, but not sure if they were even for this version of osc_orders or some private build

Go to forum: Modules Add-on's

74 Topic by tom

(1 replies, posted in Modules Add-on's)

I have a new update for the osc customer/order import module

It now makes sure the debtor_ref branch_ref names are unique for the FA pulldown menus

It could use another review to see if I missed anything else obvious smile

Thanks
Tom

Go to forum: Modules Add-on's

75 Reply by tom

(21 replies, posted in Modules Add-on's)

Braath Waate wrote:

Aha, I see that now.  There isn't any city tax in Florida, just county and state, as you have said.  Sorry for the confusion.

No problem.

That shows the simplicity of the osCommerce Tax groups.

When a customer enters their state as Florida, they are then presented with a State Pulldown list that includes ALL the tax groups within Florida and the descriptive name helps THEM pick the right one, after all they know where they live and what tax rates the are subject to.

It was a perfect solution for eCommerce 10 years ago.

Tom

Go to forum: Modules Add-on's