Search options (Page 58 of 246)

That should be a breeze with a cronjob.
Make one entry in VirtueMart in the normal course of wok and compare the before and after backups of VirtueMart and see what gets inserted and what is modified.

Manually make the corresponding entry in FA and compare the before and after backups of the FA DB and check what gets inserted and what gets modified.

Now it should be easy to make an sql construct to select from VirtueMart table(s) and then insert into the FA DB. These sqls caan then be made generic with variables as placeholders and used in a php script that handles the necessary insert/update sqls.

Which direction?
From FA to Virtue Mart or from Virtue Mart to FA ?

DB: Database
Each Database is comprised of tables which in turn is comprised of records which have several fields which are the smallest nuggets of data you can query out.

Would you like to make the master entries in FA and have them sucked into Virtue Mart or the reverse way?

If you had to sell a new item, where would you enter it - FA or Virtue mart? Once the data is entered into one application, the other would have to take it in from there. If you start entering master data in both applications without synching them, it would lead to chaos.

Similarly, the transactional data like daily sales - would you like to have them taken into FA from Virtue Mart or the other way around?

The function get_invoice_range() in the invoice report reporting/rep107.php uses the sql:

SELECT trans.trans_no, trans.reference
FROM 1_debtor_trans trans 
LEFT JOIN 1_voided voided ON trans.type=voided.type AND trans.trans_no=voided.id
WHERE trans.type=10 AND ISNULL(voided.id);

which extracts the invoices to be printed and example of it is:

trans_no    reference
1    001/2017
2    002/2017
3    003/2017
4    004/2017

The function get_customer_trans in sales/includes/db/cust_trans_db.inc uses the sql:

SELECT trans.*, ov_amount+ov_gst+ov_freight+ov_freight_tax+ov_discount AS Total,
    cust.name AS DebtorName, cust.address, 
    cust.curr_code, 
    cust.tax_id,
    trans.prep_amount>0 AS prepaid,
    com.memo_, 
    1_shippers.shipper_name, 
    1_sales_types.sales_type, 
    1_sales_types.tax_included, 
    branch.*, 
    cust.discount, 
    1_tax_groups.name AS tax_group_name, 
    1_tax_groups.id AS tax_group_id 
FROM 1_debtor_trans trans
    LEFT JOIN 1_comments com ON trans.type=com.type AND trans.trans_no=com.id
    LEFT JOIN 1_shippers ON 1_shippers.shipper_id=trans.ship_via, 
    1_debtors_master cust, 
    1_sales_types, 
    1_cust_branch branch, 
    1_tax_groups 
WHERE trans.debtor_no=cust.debtor_no
  AND 1_sales_types.id = trans.tpe
  AND branch.branch_code = trans.branch_code
  AND branch.tax_group_id = 1_tax_groups.id;

The delivery date is in another record (type=13) and not in the invoice record (type=10).

Ensure that the fixed asset you wish to delete does not have any transactions in FA first.

Make an extension to implement this ether with a sys_prefs flag to toggle the functionality or have an option in the report request form as a parameter. ST_CUSTDELIVERY (13) in gl_trans table has the trans_date as the delivery date.

An extension with a separate table should be designed and a page showing undelivered items and their client/order details should be presented to select from to make a delivery schedule. The order will be qualified with a delivery schedule ID to make it a primary key in it. On delivery, separate delivery orders would get created from this combination uniquely.

Short of this, make a separate delivery application and then import into FA by studying the DB Anatomy of a Delivery Order in FA.

FA has plugin extensions capability. All extensions are loaded in from the Default Company and can be activated for any or all of the companies in that FA instance.

A list of extensions are in my repo. All official extensions are available for installation from within the default Company login in FA in the Setup tab.

In your case, you will need to make an extension for your workflow or have someone make it for you by posting a bounty in the Job Offers board.

Search the Wiki and the Forum before posting though.

Yes, they are part of the Advanced PHP debugger.

@joe: Line 186 in admin/db/maintenance_db.inc can be preceded with:

if (!(is_array($db_connections)) $db_connections = array($db_connections);

Can actually revert the whole commit and introduce the indices stated in my commit and commented in the original commit..

The issue here is that the alias of the table in addressing the field may be required in some MySQL versions. Therefore the field "account" referred to in the existing sql was sought by you to be replaced by "trans.account" which is okay. The NULL check is still retained.

Try to insert the following php code as the first code in the helloworld.php file after the php opening tag:

$path_to_root="../..";

This may be a problem with your specific version of PHP and/or platform for scope and visibility.

What versions of PHP/MySQL/Apache (or other WebServer) and platform (Linux/Windows) are you using?

PHP 5.3.1 on Windows XP SP3 running XAMPP 1.7.3 has it's output on localhost attached and working.