1 Topic by Vdonatiello

(2 replies, posted in Report Bugs here)

Hello,

i don't know if it is a real problem or just a warning ...

every time i open the login page to access FA i get the login form but i also get a pink bow on the top with a message

see here


i have check the file the message refers to:

function check_faillog()
{
    global $login_delay, $login_faillog, $login_max_attempts;

    $user = $_SESSION["wa_current_user"]->user;

(line 158)    if (@$login_delay && ($login_faillog[$user][$_SERVER['REMOTE_ADDR']] >= @$login_max_attempts) && (time() < $login_faillog[$user]['last'] + $login_delay))
        return true;

    return false;
}

anything i could do to fix or i just ignore it

many thanks

Go to forum: Report Bugs here

2 Reply by Vdonatiello

(8 replies, posted in Items and Inventory)

apmuthu wrote:

AJAX Anyone?

sorry for the silly question, what does it mean?

Go to forum: Items and Inventory

3 Reply by Vdonatiello

(26 replies, posted in Items and Inventory)

MacPhotoBiker wrote:

I am not sure if I quite understand what you mean by "slight difference". Do you refer to the fact the the landed cost is not always exactly the same from PO to PO? If so, then yes, the only way I can see to incorporate the landed cost into stock value is to adjust the purchasing prices before receiving the goods.

i am not a programmer neither an accountant sorry if my language is not technical enough, so i use some example to better express myself ...

we import goods almost every months, the ex-work price we pay to the supplier is almost the same (they usually change the Price List every 2 years), but the real cost of acquisition the goods change every time (fluctuating exchange rates, depending on the quantity, sometime we order 3 pallets sometime we order a full container, some cost is fixed per shipment regardless the quantity or the value, i.e. issuing the master bill of lading, some cost is based on value, i.e. custom duty, some cost is based on quantity, i.e. ocean freight based on weight) therefore every time the real Cost of Goods Sold is slightly different ...

do you have advice how to handle?

i am thinking to use excel sheet and calculate outside FA the real COGS and then update the Purchasing Order so the system will take the latest cost ...

is it a good practice to value the inventory based on the latest COGS?

MacPhotoBiker wrote:

I am actually a bit surprised that this has not been implemented into FA so far, since I believe it´s rather simple: All they would need is a couple of fields where one could put both label and amount. Then the total amount is calculated and distributed over the individual lines proportionally either by amount, quantities or just equally (I can´t think of any other distribution model currently).

we are all aware that this is a free open source project, so everything we get is a nice gift, but if we could express some wishes i also would like a more efficient way to handle the Landing Costs

many thanks

Go to forum: Items and Inventory

4 Reply by Vdonatiello

(11 replies, posted in Translations)

i did change this value

 'encoding' => 'iso-8859-1'

with this

 'encoding' => 'UTF-8'

it works fine, now i can input Chinese characters and i see them displayed correctly on the output Sales Order ...

many thanks for the contribution  :-)

Vito

Go to forum: Translations

5 Reply by Vdonatiello

(11 replies, posted in Translations)

itronics wrote:

In English case the easiest way is just manually change the encoding declared in installed_langauges.inc to 'utf-8'. English alphabet have the same charcodes in utf and iso. I'm not sure it is enough to store chinese characters in database, but you can try.
Janusz

let me check if i have understood correctly

you suggest to open the file installed_languages.inc inside the folder lang

   'encoding' => 'iso-8859-1',

and change the 'iso-8859-1' into 'utf-8' (lower case or upper case)

is that right?

Go to forum: Translations

6 Reply by Vdonatiello

(6 replies, posted in Banking and General Ledger)

tom wrote:

Here is the direct link with no registration required.

Also other courses as well.

http://www.kutztownsbdc.org/course_listing.asp

dear Tom,
i enjoyed the above e-course very much
thanks for your suggestion

Go to forum: Banking and General Ledger

7 Reply by Vdonatiello

(26 replies, posted in Items and Inventory)

i enjoyed reading this thread, i am also very interested in dealing with Landed Cost ...

i assume that FA doesn't offer a proper solution to handle this specific issue ... so we need to use Excel, calculate these costs modify the Purchasing Price and so the Inventory Cost

i would like to ask how do you handle the slight difference in the Landed Cost time to time,  do you update the Purchasing Cost every shipment?

many thanks in advance

Go to forum: Items and Inventory

8 Reply by Vdonatiello

(5 replies, posted in Banking and General Ledger)

joe wrote:

You simply do the changes you want, after that you do a company backup. After that you do a rename of  the backup to the name you want.
After that you can create new companies with this new COA.

Joe

dear Joe,

am i right to assume that once a set of COA has been chosen for a company, it can not be changed?

in my case i have picked one and was trying to experiment with the Training Co., later i want to switch to another set of COA and keep experimenting before go wit the Real Company ...

so if i want keep experimenting with another set of COA, i can not do with the first Taining Co., but i should set a new Training Co., is that right?

thanks in advance

Go to forum: Banking and General Ledger

9 Reply by Vdonatiello

(5 replies, posted in Banking and General Ledger)

apmuthu wrote:

Place the resultant sql file with a "0_" prefix for the tables in the frontaccounting/sql folder and see that it is included in the installed_extensions.php file along with a meaningfull name, whilst incrementing the array index variable in the said file.

When creating a new company, you will now find it available in the dropdown list for the COA.

dear apmuthu,
i am afraid your suggestion is too technical for a lay man
thanks

Go to forum: Banking and General Ledger

10 Reply by Vdonatiello

(11 replies, posted in Translations)

itronics wrote:

Unfortunatelly  FA does not support utf well in this version. This is fixed in forthcoming 2.4 version.
You can eventually change encoding for English to utf-8 in installed_languages.inc: surely iso-8859-1 does not support chinese language.
Janusz

dear Janusz,

you are right, the language i have as default is 

C    English    iso-8859-1    No    Unknown    None

in the "Install/Update Languages" table below i have 2 other Englis options, en_NZ  English (NZ) and en_US  English (US), but both are iso-8859-1    :-(

could you suggest me how to find and add a new language (english utf-8) ?

many thanks

Go to forum: Translations

11 Reply by Vdonatiello

(11 replies, posted in Translations)

apmuthu wrote:

Check includes/page/header.inc file if any hardcoded changes might be a temporary workaround.

sorry apmuthu,

i am not clear ... i should check the above file for language setting? i don't know coding so that file for me is meaningless ... i have used "find" function and i have noticed the 

$_SESSION['language']

appears 3 times ...

if you suggest me to hardcode it and apply some change could you be more specific to guide me

many thanks in advance

Go to forum: Translations

12 Reply by Vdonatiello

(5 replies, posted in Items and Inventory)

in addition i would like to know what is the "item" field number of characters and in case i need can i increase ?

some of my "item" description are quiet lengthy, for example one wine full name is: "Semonte AltoValpolicella Classico Superiore Ripasso DOC  西蒙特阿尔多 瓦波利切拉经典特酿瑞帕索红葡萄酒"

many thanks

Go to forum: Items and Inventory

13 Reply by Vdonatiello

(5 replies, posted in Items and Inventory)

hello gnulab,

i have understood that there are only dimension 0, 1 , 2

before example was trying to explain what i was looking for ... but actually most of our products have 4 level of category
1. wine or oil or pasta
2. country
3. wine region
4  producer
5. i.e for wine is white, red, sparkling

thanks for sharing some good idea :-)

Go to forum: Items and Inventory

14 Topic by Vdonatiello

(5 replies, posted in Banking and General Ledger)

I am afraid my question is too easy but I haven't find the answer ... I would like to change the COA I have chosen for the training co., during Installation wizard ...

I have tried in Setup > Update Company and in Setup > Company Setup but both windows don't give such option

Go to forum: Banking and General Ledger

15 Reply by Vdonatiello

(5 replies, posted in Items and Inventory)

many thanks for your answer

category name, item name and item description have a number of characters limit, i.e. i must control my category no be more than 20 characters?

Go to forum: Items and Inventory

16 Reply by Vdonatiello

(11 replies, posted in Translations)

hello Joe,

i have the same problem ... i want to add in the item name and description after English some Chinese characters but i get all ???

  • in Setup > Preferences i have selected Language : English

  • in Setup > Install Languages i have installed and activated zh_CN Chinese Simplified UTF-8 Installed 2.3.0-1  installed Yes

as u have suggested i have checked MySql and i have got this:

Character Set and Collation

Collation                                       Description
...
utf8_bin                                     Unicode (multilingua), Binario
utf8_general_ci                        Unicode (multilingua), case-insensitive
utf8_general_mysql500_ci           Unicode (multilingua)
utf8_unicode_ci                        Unicode (multilingua), case-insensitive
...

could you suggest me how to type few chinese words in the name and description fields?

many thanks

Go to forum: Translations

17 Reply by Vdonatiello

(8 replies, posted in Items and Inventory)

Hi InfoComm,

i am reading your post and i noticed you have used 1000 categories ...

i am going to upload my items and categories, there are not as much as yours, i used to have my items under category and sub-category and sub-sub-category ... now that it is not possible with FA we have only 1 level of category ... i suppose we need to be smart and find a workaround and experiment a new way of define category ...

since you are dealing with some many i am sure u already had some idea ... if you dont mind to share how you have organized your category i'd appreciated

many thanks

Go to forum: Items and Inventory

18 Topic by Vdonatiello

(5 replies, posted in Items and Inventory)

i have a question on item and category

i have tried to read as carefully as possible the fa wiki and the forum for clues ... i have understood that every item belongs to a category and there is only 1 level of category and not sub-category ... i have read that there is some user that had input over 1000 categories ...

sorry, my experience is limited so i think if i use a real example i can explain myself better:
i am going to import my list of items, about 300 wines from different wine regions and in our current excel file we have different level of categories such as:
oil    > extra virgin olive oil
oil    > olive oil
wine > france > white
wine > france > red
wine > italy    > red    > piedmont
wine > italy    > red    > tuscany
wine > italy    > white > piedmont
wine > italy    > white > tuscany
wine > italy    > sparkling

since i have only one category i can use, i should group the above classification in a long description, thus i should create a category "wine france white", another "wine france red". another "wine italy white", another "wine italy red" and so on ...

or do you have better and more efficient suggestion?

thanks

Go to forum: Items and Inventory

19 Reply by Vdonatiello

(9 replies, posted in FA Modifications)

carmelr,

thanks for your reply

in the near future we will be 2 people using FA for the "Real Co." but i will be the "superuser" and i so i will be the only one to use the "Training Co.", my partner will use only the "Real Co."

furthermore we are on a shared webserver hosting plan and we have bought a database package including 100 MB and only 5 database, so i don't want to use 2 databases for the accounting only (of course if possible)

i have noticed the first Training Co. has "table pref 0_", then when i create the real Co. i suppose i should assign "table pref 1_", isn't it?

what is exactly "table pref"? is it to prevent company overlapping?

thanks

Go to forum: FA Modifications

20 Reply by Vdonatiello

(9 replies, posted in FA Modifications)

from FA wiki

Create Companies.

Never use the same database for two or more companies unless you really trust every admin on all companies. As Backup and Restore area is not reserved for site admin, but available for any single company admin, tables which belong to other companies can be overwritten accidentally or intentionally without warning.

I understand your suggestion for assigning a new database to every new company.
How about the Training Co., which you suggest to keep for testing purposes, after some testing then I feel confident and I start the Real Company ... Should that be in a different database or you think it can share the same database with the Training Co.?

Many thanks

Go to forum: FA Modifications

21 Reply by Vdonatiello

(3 replies, posted in Setup)

Hello,

I have a question which fits well under this post title: "Dimension and Company"

I have been reading both wiki and other posts here but still not very clear and maybe a real case could help also future readers

Here is the question: I would like to ask which is the best practise  in the following case: 2 different companies, or 1 company with different branche, or 1 company with different dimension?

I have a wholesale company, I import product and distribute b2b. I am opening a small shop to sell some of the products b2c. The inventory is the same. Sales: I could use different set of Pricing (wholesale and retail). Invoice and tax are not a constrain, I could use the same name or different name as I prefer (I'm writing from China, still same flexibility here)

Which solution in theory would you suggest?

Many thanks

Go to forum: Setup

22 Reply by Vdonatiello

(15 replies, posted in Installation)

itronics wrote:

Also 500 Error sometimes is triggered by .htaccess files on unusual apache configurations. Try remove the .htaccess file temporarily form fa folder.
Janusz

hi Janusz,

i did rename the .htaccess and now i can access the Installer ...

i will proceed and see if everything else is ok

removing the the .htaccess file expose my website to some danger?

thanks so much for everybody help so far

Vito

Go to forum: Installation

23 Reply by Vdonatiello

(15 replies, posted in Installation)

apmuthu wrote:

Click on my nickname on the left of my post here in this thread and click on the email link. This forum does not have PM facility enabled for users.

i have clicked on the nickname on the left side, there is a website link, but there is not a email link :-(

apmuthu wrote:

Remove / rename the .htaccess file first and try.

/mydomain
   /dir
   /dir
   /fa (755) the one i have create to upload F.A. 2.3.12
   /other dir
   /index.php

there is not .htaccess file

i am hopeless :-) i dont understand why i can not access the Installer :-)

Go to forum: Installation

24 Reply by Vdonatiello

(15 replies, posted in Installation)

apmuthu wrote:

[...]
Any issues, provide access on PM.

thanks for your availability ...i am afraid to look stupid ... how to send you PM?

Go to forum: Installation

25 Reply by Vdonatiello

(15 replies, posted in Installation)

no more doubts no pre-requisites ... somehow i managed to get the webhosting to adjust the php file

now the configuration is:

PHP Version 5.3.16

- session.auto_start    Off
- magic_quotes_gpc    Off
- register_globals        Off

can anyone have an idea why i dont get anything but the 500 error? i dont understand, i dont know what else i should do ...

Go to forum: Installation