Search options (Page 16 of 25)

Hi,
apmuthu wrote 'Anatomy of adding 1 customer', which you can find  here
You could also have a look at sql/en_US-demo.sql which I think has only 2 customers and 2 suppliers and look at the relationship between tables:-
debtors_master
cust_branch
crm_persons
crm_contacts

There is also an ER diagram its for V2.3, but 2.4 is very similar

And there is a full how-to here.

@kvvaradha you're right I'm over thinking it.

Thanks for all your help

I've tried adding the security area again, but still appears as an additional menu item

The sql output gives 40 opening brackets, but 44 closing brackets???

SELECT supp.supp_name, supp.curr_code, 0_payment_terms.terms,

        Sum(IFNULL(IF (trans.type=20 OR trans.type=2
      OR (trans.type=0 AND (trans.ov_amount + trans.ov_gst + trans.ov_discount)>0), 1, -1)*
            ABS(trans.ov_amount + trans.ov_gst + trans.ov_discount) - trans.alloc),0)) AS Balance,

        Sum(IF ((TO_DAYS('2018-06-15') - TO_DAYS(IF (trans.type=20 OR trans.type=21,trans.due_date,trans.tran_date))) > 0,IF (trans.type=20 OR trans.type=2
      OR (trans.type=0 AND (trans.ov_amount + trans.ov_gst + trans.ov_discount)>0), 1, -1)*
            ABS(trans.ov_amount + trans.ov_gst + trans.ov_discount) - trans.alloc),0)) AS Due,
        Sum(IF ((TO_DAYS('2018-06-15') - TO_DAYS(IF (trans.type=20 OR trans.type=21,trans.due_date,trans.tran_date))) > 30,IF (trans.type=20 OR trans.type=2
      OR (trans.type=0 AND (trans.ov_amount + trans.ov_gst + trans.ov_discount)>0), 1, -1)*
            ABS(trans.ov_amount + trans.ov_gst + trans.ov_discount) - trans.alloc),0)) AS Overdue1,
        Sum(IF ((TO_DAYS('2018-06-15') - TO_DAYS(IF (trans.type=20 OR trans.type=21,trans.due_date,trans.tran_date))) > 60,IF (trans.type=20 OR trans.type=2
      OR (trans.type=0 AND (trans.ov_amount + trans.ov_gst + trans.ov_discount)>0), 1, -1)*
            ABS(trans.ov_amount + trans.ov_gst + trans.ov_discount) - trans.alloc),0)) AS Overdue2,
        supp.credit_limit - Sum(IFNULL(IF(trans.type=21, -1, 1) 
            * (ov_amount + ov_gst + ov_discount),0)) as cur_credit,
        supp.tax_group_id

I think the problem is here 4 opening brackets - 5 closing:-
\purchasing\includes\db\suppliers_db.inc

94:         $value = "IF (trans.type=".ST_SUPPINVOICE." OR trans.type=".ST_BANKDEPOSIT."
95:       OR (trans.type=".ST_JOURNAL." AND (trans.ov_amount + trans.ov_gst + trans.ov_discount)>0), 1, -1)*
96:             ABS(trans.ov_amount + trans.ov_gst + trans.ov_discount) - trans.alloc)";

Which makes sense as the OR is called 4 times...

I cannot find when this was changed...

From my understanding of the above Line 96 should be:-

96:             ABS(trans.ov_amount + trans.ov_gst + trans.ov_discount) - trans.alloc";

Hi, Dimensions (Cost Centers) are what you need, read about them in the wiki
As you are new to FA, you may want to set up an additional installation (or company) of FA for testing, etc, you can then experiment with dimensions without affecting your company accounts

You can assign the same class, category, etc to say a motor and then use the same depreciation method for the remaining period of time which will give you the same result

There is an option to sell at wholesale or retail rate, would that help?

You may want to look at https://tcpdf.org/

But from what I understand FA uses a customised older version (I think) but most should be relevant.

FA's tcpdf.php file is in reporting/includes do not modify this file! but each function is very well commented so is useful.

Hope this helps

May not solve your problem as used for ordering, but could help:-

stack-overflow mysql order varchar field as integer not sure how you could use this to select next, but maybe you can?

More here @ DBA SE pad the front with zeros or use CAST

Another one here uses a different method to sort by length 1st... the article also mentions a php function natsort() which may be worth investigating

So, looking at https://imgur.com/HXysVQP you will see the top of the table of transaction references which is accessed by Setup -> Transaction References, for each existing reference you have the option to edit or delete, you also have the option to create a new transaction reference at the bottom of the table.
To edit an existing transaction reference click the edit icon and you will see this screen:- https://imgur.com/1Nbyczu, now you may or may  not be able to edit the prefix (in this case the prefix is 'PB') depending if you have entered transactions using this reference or not; but even if you have you can change the prefix by creating a new reference and if necessary making it the default for this type.
For added functionality you can also use placeholders discussed here and here.