Just copy the existing Customer report (rep103.php) from the /reporting folder to the /company/X/reporting folder where X is the company number.
Then start modify this copied report.
Joe
It's much more fun, when you can discuss your problems with others...
You are not logged in. Please login or register.
FrontAccounting forum → Posts by joe
Just copy the existing Customer report (rep103.php) from the /reporting folder to the /company/X/reporting folder where X is the company number.
Then start modify this copied report.
Joe
Ah, I forgot to explain that /Company/X/reporting, where X is your Company number (0, 1 etc.).
/Joe
I guess the easiest way for you is to copy the existing Customer Report from /reporting to /Company/X/reporting and modify/add the info you want. That way you don't interphere with the existing report. FA Always tries to find a local report in the Company folder Before using the reports in /reporting folder.
/Joe
Check the file config.php. There is a flag for doing this. I am out of office at present, so I can't recall the name.
Joe
Another thing. When you do a sales invoice, the shipping cost would never include a COGS account.
The shipping here is for outgoing compensation for the shipping costs that have been entered another way.
Please talk to a local accountant regarding these issues.
Joe
If you haven't bought the service you have no transaction to GL COGS.
If you have bought the service, the GL COGS account is updated when you made a supplier invoice.
/Joe
This has now been implemented. HG repository updated. Will also go to next minor release.
/Joe
Sounds reasonable. I will look into this.
Joe
Create a backup file. Take this file into a text editor replace the table prefix, X_, where X is your company number, with the new table prefix for your test company. Use this file to be restored on your test company.
Joe
This bug has now been fixed, and the HG repository will be updated in a while.
You can download the file /sales/sales_order_entry.php1. Rename it to sales_order_entry.php and replace the file in the /sales folder.
/Joe
ATTN.
If you downloaded the previous sales_order_entry.php1 file, then please re-download this one.
AN error in the confirm (cancel) was not performed correctly.
Ah, now I understand what is going on.
Your version of MySql has detected a bug. When a quotation is not yet saved (not completed), FA should not try to delete the quotatin as well as update the audit trail when the quotation is not completed.
I will fix this later tonight. There are other forms needing to be fixEd as well.
In older versions of MySql it was no problems running these sql scripts.
/Joe
I cannot reproduce this error.
The error is thrown in the file /sales/includes/db/sales_order_db.inc
function delete_sales_order($order_no, $trans_type)
{
begin_transaction();
hook_db_prevoid($trans_type, $order_no);
$sql = "DELETE FROM ".TB_PREF."sales_orders WHERE order_no=" . db_escape($order_no)
. " AND trans_type=".db_escape($trans_type);
db_query($sql, "order Header Delete");
$sql = "DELETE FROM ".TB_PREF."sales_order_details WHERE order_no ="
.db_escape($order_no) . " AND trans_type=".db_escape($trans_type);
db_query($sql, "order Detail Delete");
delete_reference($trans_type, $order_no);
add_audit_trail($trans_type, $order_no, Today(), _("Deleted."));
commit_transaction();
}
If the $order_no is empty, the error should have been trown in one of the prior database calls.
The file /includes/db/audit_trail_db.inc shows the
function add_audit_trail($trans_type, $trans_no, $trans_date, $descr='')
{
$sql = "INSERT INTO ".TB_PREF."audit_trail"
. " (type, trans_no, user, fiscal_year, gl_date, description, gl_seq)
VALUES(".db_escape($trans_type).", ".db_escape($trans_no).","
. $_SESSION["wa_current_user"]->user. ","
. get_company_pref('f_year') .","
. "'". date2sql($trans_date) ."',"
. db_escape($descr). ", 0)";
db_query($sql, "Cannot add audit info");
// all audit records beside latest one should have gl_seq set to NULL
// to avoid need for subqueries (not existing in MySQL 3) all over the code
$sql = "UPDATE ".TB_PREF."audit_trail SET gl_seq = NULL"
. " WHERE type=".db_escape($trans_type)." AND trans_no="
.db_escape($trans_no)." AND id!=".db_insert_id();
db_query($sql, "Cannot update audit gl_seq");
}
The sql sentence INSERT INTO ... throws the empty result. This is strange
Please can somebody help me to track this, if possible?
/Joe
I just wonder how this is possible. The Sales Quotation must at leat have a number of 1.
Can you please add some information to this?
/Joe
Which versions are you running? MySql, PHP and OS.
/Joe
@apmuthu
Your solution didn't accept jpg files in my environment.
The elsif sentence was originally badly written.
Your solution has been changed from
elseif (@strtoupper(substr(trim($_FILES['pic']['name']), @in_array(strlen($_FILES['pic']['name']) - 3, array('JPG','PNG','GIF')))))
to a much more reliable sentence
elseif (!in_array(strtoupper(substr(trim($_FILES['pic']['name']), strlen($_FILES['pic']['name']) - 3)), array('JPG','PNG','GIF')))
Please download the file items.php1. Rename it to items.php and replace it in /inventory/manage folder.
HG repository willbe updated in a while.
/Joe
I am not sure if we have an extension for this. Maybe sombody in the audience can help us.
Joe
Have you considered using Manufacturing. You could use simple assembling. These assembled items could also be bought if needed.
Joe
In this case you buy the tool by entering the asset account. At year end (or periodically) you do your depreciations on a depreciations account.
Please talk to a local accountant for these type of questions.
/Joe
Tools and Equipment is here an inventory account (assets). Expense accounts for minor tools are placed in Expense and should be used for minor purchases.
Joe
Check that your account 1821 is belonging to the correct account group.
Joe
As I told you before I am no expert on this. Maybe someone in the audience can convince me to change the algorithms.
The else part is for use when you have accepted negative stock in system and general GL setup and the current stock is below 0.
Joe
Please read about how to use dimensions in the wiki.
Joe
You should also remove it from the file, config_db.php. Be careful, however, to delete the right things.
/Joe
Well, as I told in another topic, I am not an expert in Manufacturing. These routines were written by somebody else several years ago.
Maybe someone in the audience can help us, or you may be the guy . Just try to explain in simple terms what should be changed. Thank you in advance.
/Joe
FrontAccounting forum → Posts by joe
Powered by PunBB, supported by Informer Technologies, Inc.
Currently installed 4 official extensions. Copyright © 2003–2009 PunBB.