Search options (Page 2 of 12)

I do see some differences... (table entry order, defaults, etc)

So I guess that the large jump I made caused some of the sql/alter.[sql|php] scripts to not run correctly

Has that been fixed in fa2.4.x?

I will load my db into fa2.3.26 and then to 2.4.6 and see if the db is better...

Tom

Well that explains it!

The extension I downloaded when running 2.4.6 contained an older version of the hooks.php file that did not contain

    function __construct() {
        $this->module_name = 'osc_orders';
    }

I downloaded the first 8-10 extensions from setup->install.activate extensions and found only a couple have the constructor called

I did not check github but I see the osc_orders was updated as part of what may have been a global update...

i am the author of osc_orders and I have a small update I would like to make..

I'd do it myself but I am not very good with git yet and only have this one change to be made...

Can do apply it to the sources? (2 lines changed) or I can email/pm the updated file...
Below: The updated file is on the right ">"

tom@w2vy:/var/www/html/fa/modules/osc_orders$ diff osCommerce.php /tmp/osCommerce.php 
432,433c432
<                 $cart->document_date = Today();
<                 // $_POST['OrderDate'] = $cart->document_date;
---
>                 $cart->document_date = sql2date($order['date_purchased']);
442c441
<                 $cart->due_date = Today();
---
>                 $cart->due_date = sql2date($order['date_purchased']);

Thanks!
Tom
ps. I just attached it as a txt file! I knew there as a way...

Ok, I looked around and it does have the add_rapp_function call

I am thinking that it has something to do with security

The code has:

define ('SS_OSCORDERS', 106<<8);

and

            case 'orders':
                $app->add_rapp_function(2, _('osCommerce Import'),
                    $path_to_root.'/modules/osc_orders/osCommerce.php', 'SA_OSCORDERS');
        }

Is 106 correct?

Any ideas? The module is listed as "osCommerce Order and Customer Import Module"
In the Install/Activate extension

Yes I activated it

The CVS Import items is working fine (# 105)

Tom

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

I tried that but I can't because I had already received items on the PO

humm... that does not help.

Which lines appear wrong?

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

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

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

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?