Topic: Customer Branch??
I am New To FA please tell me what is a use of Customer Branch , its need and usage. can i perform all my transaction without allocating customer branch to any customer?
It's much more fun, when you can discuss your problems with others...
You are not logged in. Please login or register.
FrontAccounting forum → Accounts Receivable → Customer Branch??
I am New To FA please tell me what is a use of Customer Branch , its need and usage. can i perform all my transaction without allocating customer branch to any customer?
Customer Branches is a kind of delivery address etc. You can have many Customer Branches and at least one is required.
/Joe
Hello Joe,
Our business really doesn’t need the customer branch; it is a unnecessary extra step. Can I configure FA to stop requiring the Customer Branch?
and Our business doesn’t need the customer branch
Hello,
When you create a new customer, you must at least create one customer branch. This is necessary in existing framework. Anyway, to automate it, you may edit the file at
vi sales/manage/customers.php
under the function handle_submit(&$selected_id)
else
{ //it is a new customer
begin_transaction();
add_customer($_POST['CustName'], $_POST['cust_ref'], $_POST['address'],
$_POST['tax_id'], $_POST['curr_code'], $_POST['dimension_id'], $_POST['dimension2_id'],
$_POST['credit_status'], $_POST['payment_terms'], input_num('discount') / 100, input_num('pymt_discount') / 100,
input_num('credit_limit'), $_POST['sales_type'], $_POST['notes']);
$selected_id = db_insert_id();
add_branch($selected_id, $_POST['CustName'], $_POST['cust_ref'],
$_POST['address'], '1', '1', '1', get_company_pref('default_sales_act'),
get_company_pref('default_sales_discount_act'), get_company_pref('debtors_act'), get_company_pref('default_prompt_payment_act'),
'DEF', $_POST['address'], 0, '1','1', $_POST['notes']);
Please Note:
This is just my opinion, some parameters are hardcoded to show you the sample. maybe there are better ways to solved your issue. if you try this piece of code, it will work but you need to cater for update function too. The others area you should look into is how it create the contact for this customer.
Cheers,
tclim
thanks awesome person " tclim "
The actual way of automatically create a branch from an existing customer (via add or edit customer in the new customer form) seems to work pretty well , isn't it ?
I understand though it's a pain to have to do it for every single customers.
One of the problems when creating an automatic branch when creating a customer is which Tax Group to use on the branch. Likewise which Location to use.
Well, this can be fixed, by using the first ones, but is this good enough? We are having an internal descussion.
/Joe
We have decided to add six fields from the branch when creating a new customer, so we can create a default branch.
This branch can of course be edited later. The HG repository is updated. This change will go to the next minor release.
/Joe
Yes it is a bit of a pain when most of your customers are personal people rather than businesses. I have learnt to live with it since I found the Add or Edit link above the customer "General Notes" This takes you to the branch where you only have to enter the customers Phone Number and email address and it is all made for you (eg the branch and contact).
Perhaps tclims code could be extended by putting these two fields on separate lines in the General Notes field (I often past data in there from an email or web order when doing the data entry as an interim step anyway). Read each line in the Notes and if it contains an "@", place it in the email field otherwise place it in the phone number field. This would let you complete the branch and the contact for a complete customer record.
We have decided to add six fields from the branch when creating a new customer, so we can create a default branch.
This branch can of course be edited later. The HG repository is updated. This change will go to the next minor release./Joe
Sorry Joe, I missed this on my initial reading of this thread so my last post is obsolete.
I think the only fields required would be these (what are the other two?)
Phone Number:
Secondary Phone Number:
Fax Number:
E-mail:
Perhaps you could add some conditional code that only shows these extra fields and does the auto adds to the branch and contact tables if a flag like AutoCreateBranch is set. For this release, this flag might be able to live in the config file and migrate to the Company setup table on the next major release.
While working on this, adding a link to customer maintenance page from the Transaction maintenance screens and a drill down on the customer maintenance table to the transactions would be two very useful additions to the application.
The six fields are:
Default Inventory Location.
Default Shipping Company.
Tax Group.
Sales Person.
Sales Area.
Sales Group.
These fields are pre-filled with default values (minus Sales Group that can be empty).
These fields are only available when creating a new customer. When looking at existing customers they vanish.
The rest of the Branch fields are copied from the Customer data.
Yes, these links would be good to have. Will have a look.
/Joe
One question RodW.
What do you mean with a drill down on the Customer Maintenance to the transactions. Isn't a link just sufficient?
/Joe
You are right RodW, regarding the fields you mentioned to go to the default contacts on the Customer/Branch.
I will have to add them too.
/Joe
The six fields are:
Default Inventory Location.
Default Shipping Company.
Tax Group.
Sales Person.
Sales Area.
Sales Group.These fields are pre-filled with default values (minus Sales Group that can be empty).
These fields are only available when creating a new customer. When looking at existing customers they vanish.The rest of the Branch fields are copied from the Customer data.
Yes, these links would be good to have. Will have a look.
/Joe
Joe I may be missing something (still on 2.3.4 - gotta catch up ) but as all of these currently get a default value when a branch is added anyway so there is no need to add them to the customer record is there? Aren't we just over complicating things?
Perhaps if AutoAddBranch is enabled all you would need to do is to display a status message that says something like:
"Branch has been automatically created and some fields contain default data, please check default Branch values on this link here"
One question RodW.
What do you mean with a drill down on the Customer Maintenance to the transactions. Isn't a link just sufficient?/Joe
Yes, I think a simple link to the Customer Transaction Enquiry screen would be sufficient that was pre-populated with the customer name in the "Select a Customer:" prompt. Personally, I think the default date range should be set to more than one months data, probably the last 12 months or to the start of the current fiscal year.
You are right RodW, regarding the fields you mentioned to go to the default contacts on the Customer/Branch.
I will have to add them too./Joe
That would be great Joe.
Just one more thought. While you are mucking about with the customer screens, I wonder if it would be worth adding a couple of sales totals and even current balances as that is probably something that is sorely missing. Simplest would be a table of total sales for fiscal year in the system, eg for me:
Balances Total Current 30 days 60 days 90+ days
$ $ $ $ $
Sales
2011/12 $
2010/11 $
2009/10 $
Bells and whistles would be to present an array of monthly sales for each fiscal year. eg for me:
Balances Total Current 30 days 60 days 90+ days
$ $ $ $ $
Sales Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun Total
2011/12 $ $ $ $ $ $ $ $ $ $ $ $ $
2010/11
..
The link to the Customer transactions could be the fiscal year label which would set default values for the date range
Sorry to keep adding to your todo list but these statistics are not really visible anywhere and most competing systems would show this sort of stuff. It is not really relevant to my current business as there is not much repeat business but in a previous B2B situation it would be vital data.
If you can get these reporting routines established then you would be set to write a customer size report that listed each customer by total annual sales by month from the biggest down. These sorts of reports generally need some $ value filters on total annual sales so that you could set a cutoff at say $500 to limit the data set. Everybody needs to know their top 10 customers .
Finally, on the subject of links, these screens
Sales Quotation Entry
Sales Order Entry
Direct Delivery
Direct Tax Invoice
Need a link that says Add or Edit beside the Customer and Branch fields which take you back to the appropriate maintenance screen. This would let a user quickly maintain the customer record in the middle of a transaction which is also a sorely lacking feature in FA that most competing systems would support.
I think you'd tick a lot of boxes with these suggested features implemented in a subsequent release.
Damnn, I just realised that these links might need to respect security settings (eg. They should not be displayed if the user does not have appropriate rights!) I'll leave that as an exercise for the dev team
RodW, I guess you missed the F2 key, that brings up the customer and allows editing, in all the documents.
By changing the row 45 in /sales/inquiry/customer_inquiry.php to:
customer_list_cells(_("Select a customer: "), 'customer_id', null, true, false, false, true);
will enable the F2 key so you can look at the customer. This will be changed into the HG repository.
The theme, exclusive, has a lot of the features you request.
At first, let us just stay with the links between the forms.
/Joe
Thanks Joe, I will check the Exclusive Theme after I upgrade to current version. The Install Themes hangs on my system (2.3.4). Nothing opens.
Thanks Joe,
I have tested the customer inquiry by replacing the code and press on F2, it works great. Thanks for the tips.
Cheers,
tclim
Thanks Joe,
I have tested the customer inquiry by replacing the code and press on F2, it works great. Thanks for the tips.
Cheers,
tclim
x 2 but I still can't maintain the Themes, Languages, Extensions and Charts of Accounts in Setup after upgrading to 2.3.7. Any ideas what to look for?
Hello rodw,
I have just replied your request on another topic at
https://frontaccounting.com/punbb/viewtopic.php?id=2485
Please have a look.
Cheers,
tclim
FrontAccounting forum → Accounts Receivable → Customer Branch??
Powered by PunBB, supported by Informer Technologies, Inc.
Currently installed 4 official extensions. Copyright © 2003–2009 PunBB.