1

(27 replies, posted in Installation)

In FA 2.4.8>Setup>Transactions References> I set the Pattern = 1500 for Traction Type = Journal Entry. I then created two Journal Entries Trial 1 and Trial 2. Trial 1 was a $27 Debit into Petty Cash from Club Dues, and Trial 2  was a $15 Debit into the Savings Account from Raffle Ticket Sales. Immediately after entering the second JE, I did a Journal Inquiry and a GL Inquiry with the results below.

Journal Inquiry:
Date        Type            Trans #    Counterparty    Reference    Amount    Memo                                         
04/01/2020    Journal Entry    1079                    1500        54.00    Timothy Goolsby - Key #82 - Sale & Deposit
04/01/2020    Journal Entry    1080                    1501        30.00    John Davis - Irish Visitor - MVMAC Hat      

Editing Trans 1079:
Account Code    Account Description    Dimension    Debit    Credit    Memo       
1065            Petty Cash                         20.00            Timothy Goolsby - Key #82 - Sale & Deposit       
4025            Sale of Gate Keys                         5.00            Timothy Goolsby - Key #82 - Sale       
2442            Gate Key Deposits Liability                               15.00        Timothy Goolsby - Key #82 - Deposit       
1065            Petty Cash                         27.00            trial 1       
4445            Club Dues                                   27.00            trial 1       
Search GL accounts       
Add Item
                                        Total    47.00    47.00   


Editing Trans 1080:
Account Code    Account Description    Dimension    Debit    Credit    Memo       
1065            Petty Cash                     11.00            John Davis - Irish Visitor - MVMAC Hat       
4010                    Sales of Caps, T-Shirts, etc.             11.00    John Davis - Irish Visitor - MVMAC Hat       
1061                    Savings Account             15.00            trial 2       
4448                    Income from Raffles                     15.00    trial 2       
Search GL accounts       
Add Item
                                        Total    26.00    26.00   
                                       
GL Inquiry:                                       
Type    #    Reference    Date    Account    Dimension    Person/Item            Debit    Credit    Memo
Journal Entry    1079    1500    04/01/2020    1065 Petty Cash                 27.00            trial 1    Edit
Journal Entry    1079    1500    04/01/2020    4445 Club Dues                         27.00    trial 1    Edit
Journal Entry    1080    1501    04/01/2020    1061 Savings Account        15.00            trial 2    Edit
Journal Entry    1080    1501    04/01/2020    4448 Income from Raffles                     15.00    trial 2    Edit

Note
1. The Journal Inquiry again shows multiple JE's for each Reference transaction 1500 and 1501
2. The total for each JE on the Edit screen is different than that shown in Journal Inquiry listing -
    $47 vs $54 for Ref 1500
    $26 vs $30 for Ref 1501
3. The Listing for the GL Inquiry gives the correct information for both JE's.

Any ideas as to what is going on?

2

(27 replies, posted in Installation)

A couple of questions have arisen after the upgrade from 2.3.26 to 2.4.8. When I do Journal Inquiry over the last default dates, 2.4.8 gives

03/21/2020    Journal Entry    1069        658    432.21    Al Siegwart - Chk #1290 - Miscellaneous Training and Club Expenses
                                                                                        - Trainer airplane + AMA Club 1-Yr Fee Savings Account - IOD
                                                                                        Interest Earned

When I go to edit it to check the details for Check #1290 and Interest earned, I get

1070    PayPal                           36.01        Jack Fitzpatrick - 2020 Dues - PayPal       
4445    Club Dues                                  36.01    Jack Fitzpatrick - 2020 Dues - PayPal       
1060    Checking Account                       432.03    Al Siegwart - Chk #1290 - Miscellaneous Training and Club Expenses       
5687    AMA Expenses                 100.00        Al Siegwart - Chk #1290 - Miscellaneous Training and Club Expenses       
5614    Training Expenses            332.03        Al Siegwart - Chk #1290 - Miscellaneous Training and Club Expenses       
1061    Savings Account                0.18        Savings Account - IOD Interest Earned       
4440    Interest from Savings Account          0.18    Savings Account - IOD Interest Earned

That is, the Trans # 1069/Reference 658  really refers to 3 Journal Entries  - one for Check #1290, one for membership dues for Jack Fitzpatrick, and one for the Interest paid on the savings account.

When I run the same Journal Inquiry in 2.3.26 I get 3 separate Journal Entries -

02/26/2020    Journal Entry    1069    1056        36.01    Jack Fitzpatrick - 2020 Dues - PayPal
02/26/2020    Journal Entry    1068    1055      432.03    Al Siegwart - Chk #1290 - Miscellaneous Training and Club Expenses -
                                                                                Trainer airplane + AMA Club 1-Yr Fee
03/02/2020    Journal Entry    1085    1072      0.18     Savings Account - IOD Interest Earned

Which brings me to my question: What is the "Reference" number? In looking at the Journal Inquiries I see that the reference number is the same as older Tran #'s. I'm trying to figure out whether the updated 2.4.8 database accurately reflects the 2.3.26 data going back to 2012. The Balance Sheet shows the same totals, and the GL Inquiry shows all of the same Journal Entries as between 2.3.26 and 2.4.8. Why is the Journal Inquiry goofed up?

3

(27 replies, posted in Installation)

Rereading my last post, understand that all 44 lines mentioned in the error log were commented out. After that, the update took quite a while but eventually worked.

Seems like this should also work for Iffig...

4

(27 replies, posted in Installation)

kvvaradha, I took the approach mentioned in your last paragraph, editing the alter2.4.sql file. I opened it in a text editor and made each of the lines mentioned in the log file a comment by inserting '* rjp   '  at the beginning. Thus line 30 became

# rjp  ALTER TABLE `0_tax_group_items` ADD COLUMN `tax_shipping` tinyint(1) NOT NULL default '0' AFTER `rate`;

Similarly, lines 36 and 37 became

# rjp  ALTER TABLE `0_sales_order_details` ADD KEY `stkcode` (`stk_code`);
# rjp  ALTER TABLE `0_purch_order_details` ADD KEY `itemcode` (`item_code`);

This modification allowed me to update the software without errors

5

(27 replies, posted in Installation)

Experience similar to Iffig - updating from 2.3.26 to 2.4.8 on Windows 10 Wamp server. Followed the steps outlined by kvvaradha. When I log as administrator in the company "0" and do a software upgrade, the process fails. I get the following error messages:

30:Duplicate column name 'tax_shipping'
36:Duplicate key name 'stkcode'
37:Duplicate key name 'itemcode'
39:Duplicate column name 'bank_account'
41:Duplicate column name 'tax_included'
45:Duplicate column name 'bank_charge_act'
48:Duplicate column name 'transaction_days'
50:Duplicate column name 'prep_amount'
51:Duplicate column name 'alloc'
53:Duplicate column name 'prep_amount'
54:Duplicate column name 'alloc'
59:Duplicate column name 'invoiced'
68:Duplicate column name 'prep_amount'
79:Duplicate column name 'no_purchase'
80:Duplicate column name 'dflt_no_purchase'
83:Duplicate column name 'rate'
86:Duplicate column name 'save_report_selections'
87:Duplicate column name 'use_date_picker'
88:Duplicate column name 'def_print_destination'
89:Duplicate column name 'def_print_orientation'
143:Duplicate column name 'dimension_id'
144:Duplicate column name 'dimension2_id'
151:Duplicate column name 'usage'
152:Duplicate column name 'memo'
155:Duplicate column name 'person_id'
159:Duplicate column name 'person_id'
199:Duplicate column name 'reg_type'
255:Can't DROP 'branch_code'; check that column/key exists
256:Can't DROP 'SupplierID_2'; check that column/key exists
257:Can't DROP 'type'; check that column/key exists
260:Duplicate column name 'fixed_asset'
273:Duplicate column name 'depreciation_method'
274:Duplicate column name 'depreciation_rate'
275:Duplicate column name 'depreciation_factor'
276:Duplicate column name 'depreciation_start'
277:Duplicate column name 'depreciation_date'
278:Duplicate column name 'fa_class_id'
279:Unknown column 'actual_cost' in '0_stock_master'
288:Duplicate column name 'unit_cost'
289:Unknown column 'std_cost' in '0_wo_requirements'
291:Can't DROP 'last_cost'; check that column/key exists
294:Unknown column 'assembly_account' in '0_stock_master'
295:Unknown column 'dflt_assembly_act' in '0_stock_category'
308:Unknown column 'counter' in '0_budget_trans'

Lots of errors to fix, but I don't know where to start. Please give me some ideas.