Search options (Page 34 of 246)

$config_allocation_settled_allowance value in config.php.

Explain how you wish to treat admin expenses on accrual basis.
Normal journal entries should suffice.
Otherwise, if inventorable goods are used and wish to be tracked, then open a sales order and keep adding to it and keep delivering it in part and when all are done, "invoice" it by allocating from an equivalent credit note for self expenses.

https://www.transifex.com/gnuacademy/frontaccounting-1/ -- FA 2.3.x
https://www.transifex.com/gnuacademy/frontaccounting24/  -- FA 2.4.x

Since you are only drop shipping it, have a separate PHP Application or FA module made that reads from the FA tables and do it as a cron job for population of the new application/module's tables. The only real page for the application/module would be to choose the drop ship customer and provide reports. This way, you need not divulge the rates / prices of your real customer to their downlines.

The actual value of TB_PREF is in the $db_connections[#]['tbpref'] array element in config_db.php's  that pertains to the company (#) logged in.

Whilst at it, please fix the "PM Link" for the moderator login in the top horizontal menu.

The way to do is listed in this post and it is upto the ingenuity of the deployer to do it as they deem fit.

It most certainly does. See attachment.
Which version of FA are you using?
FA 2.4.7 has been released in June 2019 and several fixes to it has been made as well till date.
This is a very old (> 2 years) issue that has been fixed.

@joe: Maybe put in this fix after checking if PHP version >= 7.

The chr(32) is to specify Ascii instead of any other collation like utf-8, etc. that would occur if a mere space was put in place of it.

Where is the Development Forum?
@joe: any secret forum....?

Thanks @joe.

Whilst we are on this, we might as well optimise the sql in the last function in sales/includes/db/sales_order_db.inc with:

--- sales/includes/db/sales_order_db.inc    Tue Jan 14 05:30:15 2020
+++ sales/includes/db/sales_order_db.inc    Tue Jan 14 05:42:21 2020
@@ -632,11 +632,9 @@
 {
         $sql = "SELECT $field
             FROM ".TB_PREF."sales_order_details d
-            WHERE order_no =
-            (SELECT order_no FROM ".TB_PREF."sales_orders o
+            LEFT JOIN " .TB_PREF."sales_orders o on d.order_no=o.order_no
             WHERE debtor_no=" . db_escape($order->customer_id) . "
-            ORDER BY order_no DESC LIMIT 1)
-            ORDER BY d.id DESC LIMIT 1";        
+            ORDER BY d.id DESC LIMIT 1";
 
         $last_query=db_query($sql, "Could not retrieve last order detail");
         $row = db_fetch_row($last_query);