1 Reply by surreyhills

(12 replies, posted in Announcements)

I have recently added some pages to the Wiki.  One of them has been subsequently changed. The person changing it took perfectly good English and made it grammatically incorrect.  I could change it back but we could end up competing.  Is there a moderator type function we can call on?

Note: The page in question is GL Account Classes. 'Chart of Accounts' is singular so you should use 'is' not 'are', e.g. The Chart of Accounts is.  If it were Charts of Account then it would be plural.

Go to forum: Announcements

2 Reply by surreyhills

(7 replies, posted in Report Bugs here)

I have the same error on supplier Direct Invoice.  Direct GRN works but Direct Invoice gives the following

At file G:\ServerFolders\Documents\htdocs\FATest\purchasing\includes\db\supp_trans_db.inc:45:
Cannot insert a supplier transaction record
error code : 1265
error message : Data truncated for column 'ov_discount' at row 1
sql that failed was : INSERT INTO 0_supp_trans (trans_no, type, supplier_id, tran_date, due_date, reference, supp_reference, ov_amount, ov_gst, rate, ov_discount, tax_included) VALUES ('3', '20', '2', '2008-12-31', '2009-01-01', '3', '123', '10', '0', '1', '', '0')

The bug is due to a fix made before in line 456 in po_entry_items.php which waas commented out and left ov_discount as null not 0.0. I have changed the code to:

//    MRB 16-10-12 - ov-discount set to zero to avoid DB error on insert
            $inv->ov_discount = 0.0;
// End of fix 16-10-12

which works.

Go to forum: Report Bugs here

3 Reply by surreyhills

(8 replies, posted in Installation)

You might want to look at this post http://urbangiraffe.com/2005/08/20/mysterious-406-error/ it shows where the Apache configuration could be giving you problems.

Go to forum: Installation

4 Reply by surreyhills

(29 replies, posted in Modules Add-on's)

I have just installed this module and tried to amortise an asset and got the error:
DATABASE ERROR : could not add asset valuation
error code : 1305
error message : FUNCTION surreyhills.get_asset_value does not exist
sql that failed was : INSERT INTO 0_asset_valuations (asset_id, valuation_year, asset_value) VALUES ('1','2013','289.92')

Looking at the error and the install SQL there seems to be an error in the SQL.  When it creates the trigger it uses get_asset_value rather than 0_get_asset_value which is the routine defined.

I will correct the SQL and start again to see if this works.

Go to forum: Modules Add-on's

5 Reply by surreyhills

(29 replies, posted in Modules Add-on's)

Thanks, so simple when you know how.
Regards
Mike

Go to forum: Modules Add-on's

6 Reply by surreyhills

(29 replies, posted in Modules Add-on's)

This might be through ignorance.  I have just installed the Asset Register and I have three new menu options:

Items and Inventory - Asset Type Entries & Asset Entries
Banking and General Ledger - Amortisation Posting

All are greyed out.  I could not find any description of how to use it.  Is there any intro to the module?

Go to forum: Modules Add-on's

7 Reply by surreyhills

(9 replies, posted in Items and Inventory)

I have come late to this but what I do is create an inventory item for hours worked and give it a sales price.  When I create a quote I add all the items I am going to use but with a zero sales price.  I add an entry for the estimated hours worked with a sales price.  Your quote then has a value of the hours to be worked.  When it is delivered the items you included from your inventory are taken from the stock.  So your stock has been depleted, the cost of sales has been recorded (ie. the cost of purchase) and your revenue is your hours worked (mm2 in your case).  The difference between Cost of Sales and Revenue is your profit

Hope this helps

Go to forum: Items and Inventory