The main thing is you know what the figures mean which is fine if you are the only one relying on them. But if you need to show them to somebody that is used to seeing financial statements, formatting them close to the standards is a good idea. Having said that, then you want to show the business in the best light so there is no easy answer.

I started by running a creditor for me and then paid it out to Capital Introduced once i got things set up and now if I buy something with my personal money, I either get the business to reimburse me for the expense to get it into the books or post it to Capital Introduced if I don't want it back.

Tom start here

http://www.cliffsnotes.com/study_guide/ … 21002.html
Pick your structure and get your chart of accounts to agree with the correct format.

I've had a go at replying a couple of times but have lost my post. Sorry.

If you are a company, you should leave your loan as is. If you are a sole trader or partnership, you need an extra account in the equity section where retained earnings called Capital Introduced. Journal you loans to this account. Leave the retained earnings as is. I also keep an account for drawings which records the money I take out and this is a bit simpler than what the link proposes how it should be treated if you got a CPA to prepare your books. The sum of these three accounts will give you what you want. A simple total of what the business is worth!

I just overwrite the product price. Eg. Have RRP $995, sell for $945. You have to make sure GL Accounts is correctly set up if you apply a 10% discount so the P&L reflects the correct position in your country.

Thanks, I might look at SVN and Eclipse for Windows. I also have Dreamweaver here so I'll look at that as well as it supports SVN and liv links to a server.

Thanks TCLIM, I have done that and it works well but in the address block, this does not alter the linespacing. So now I need a fix for the linespacing as simply changing the linespacing and restoring it (similar to how you have shown how to restore the font size), breaks the rest of the report. Text no longer lines up with the boxes and detail lines print on top of each other.

Try it. If you scroll down the file to //Address1 and use 12 point ($this->fontSize += 3;) and set the Line Height to
$this->lineHeight +=3;

See what happens when you restore the line height.

Just a general question.

How are people managing the customisations they make to the code so they can be applied to a new FA release with minimal effort?

I want to increase the text size on the address to 12 point to comply with postal addressing standards.

adding $this->fontSize += 3; Before printing Address1 in header2.inc works but the line spacing is too tight. When I change the line height, this fixes the address block but breaks the rest of the report. (Yes I am restoring font size and line height after the address is rendered).

How can I restore the lineHeight and Row settings to continue to render the report correctly?

8

(15 replies, posted in Setup)

I tested Tclim's demo and it seems to have worked as I can now save the € (euro) symbol in a currency which can't be done on my system.

I don't have much need for Multi-currency so I am not right up with this.

Invoices etc (PDF's) The symbol is not used but the report footer says "All amounts shown in EUR". So where is the symbol used? The only place I can see it is used is on the Currency input screen. Did this become too hard in the past and the 3 character Currency code was settled on throughout FA? Should the Report definitions and some of the Inquiry pages now be updated to use the symbol?

gci305 wrote:

I have written even to adminnistrators of this forum, and i´m yet to get a response. It seems that the people in charge of this forum don´t care much about the users of the program. At least, this is my experience for now.

Hope someone with the right skills can help a fellow user.

This has not been my experience with the development team. They provide better support than many commercial products. But you have to be specific, confine your support to bugs and improvements. You can't expect them to hold your hand on how to configure the system to your needs.

The tax system is very powerful and should handle tax for any country provided it is correctly set up.

So here are some pointers for you.
1. Look at the Tax inclusive option which will not display tax per line and display the total tax in the invoice footer.
2. Modifying the invoice layout and text can be achieved by modifying one include file which you should find if you search.
3. A better alternative to 2 (which I have adopted) may be to write a language file that deals with the taxation nomenclature used in your country.
4. Make sure the GL codes for tax accounts and shipping are correctly set up to post charges to the correct group of accounts. Eg. here, Shipping charges must go to a income account not credited against an expense.

lordas101 wrote:

It'll be very good, if we can sell cash direct invoice and when place invoice somewhere to put tick mark without invoice smile

Perhaps you could create a customer called "cash sales" and post each cash sale to this customer. At the end of the day, bank the proceeds of cash sales to this customer's account (the end of day customer balance  should then be NIL).

itronics wrote:

The links are displayed but do nothing The new screen is never opened.

What you mean? The page request never ends, or the page displayed is empty, or.. ?
All the options use network connection to FA package repository, so if you try to use them without internet connection you can encounter problems.
Janusz

Januz, when clicking on the menus, the cursor goes to the hourglass and times out without any further response. The new scren is not opened.  After that, I have to close the browser before FA will work again. I am using chrome, but IE does the same.

My instance of FA is hosted on a VPS and I used Webmin on the server to download a 600 mb file from another web server by http: today.

Tclim

Thanks,  I tried setting the folder permissions as you have described but this did not fix it so I guess I will try a full new install installation and see what happens. I was hoping I did not have to muck about with the live database.

In my system, these menu options are not functioning on the setup menu.
Install/Update Languages
  Install/Activate Extensions
  Install/Activate Themes
  Install/Activate Chart of Accounts

These functions used to work.

All user permissions are set correctly. The links are displayed but do nothing The new screen is never opened.

Could this be a permissions issue on a particular folder or something?

Can anyone give me a few pointers on where to look?

tclim wrote:

Hi RodW,

  Welcome back. I will inform you when the Virtualmart modules are ready. Thanks you for your support.

Cheers,

tclim

Thanks Tclim. Look forward to it. I have not had much time  for FA recently. Busy on other things.

15

(21 replies, posted in Accounts Receivable)

tclim wrote:

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?

16

(21 replies, posted in Accounts Receivable)

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.

17

(4 replies, posted in Setup)

You need to look at the contact for the supplier and select Orders in the "Contact Active for" field. Note you can select more than one value in this field.

The dev team may have different ideas but I thought that FA had been audited for security issues and the results had been incorporated into the installer. I have added an SSL certificate to my web server and forced the FA folder to only open in SSL which is probably a good idea if it is hosted externally.

19

(7 replies, posted in FA Modifications)

joe wrote:

RodW,
The auto add customer branch is implemented in the HG Repository to go into next minor release.

Maybe we could have the transactions in the bottom of the screen if a link is pressed?

/Joe

Joe, you know the code base so whatever is easiest when considering the discussion on the other "Customer Branch??" thread. If you implemented the sales totals for each fiscal year I suggested, clicking on a link beside the fiscal year could list the transactions here but this implies you'd probably only see invoices so you might also need to include a link to the transaction screen anyway just in case you were looking for a delivery or sales order.

Rod

20

(21 replies, posted in Accounts Receivable)

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 sad

21

(21 replies, posted in Accounts Receivable)

joe wrote:

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.

joe wrote:

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 smile .

22

(21 replies, posted in Accounts Receivable)

joe wrote:

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 smile ) 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"

23

(21 replies, posted in Accounts Receivable)

joe wrote:

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.

24

(7 replies, posted in FA Modifications)

I am surrised nobody has weighed in on this issue. I don't think a popup is the answer but there should be a link on the

mdutra555 wrote:

Quote/Sales Order/Direct Delivery/Invoice entry.

screens that open the And and Manage Customer screen.

Tclim has posted some code to auto-add the customer branch which goes some way towards fixing what you want on another thread.

I've just thought of a way to fix the auto add customer branch issue so I'll post it in the other thread.

I also think it would be good to have some links on the Customer and branch maintenance screens to open up the Transaction History pages filtered for that customer as I am forever jumping around to sort out simple things.

25

(21 replies, posted in Accounts Receivable)

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.