1 Reply by Mixu

(11 replies, posted in Items and Inventory)

Hello Joe,

thank you for all your help! I have now identified the problem and made corrections accordingly. For some reason two sales orders had mismatch between quantity ordered versus quantity delivered. The only mystery is that I can't find any delivery notes showing that delivery was done double times or so. As long as there is no delivery note showing that quantities are exceeded, I cannot point out the real reason why this happened (e.g. human factor). For the first mentioned sales order I remember that we delivered half of the items in a first shipment. After that we slightly modified the sales order and then delivered the rest. Maybe this has led to this situation - cannot say...

Anyway, I directly edited the database from table 'sales_order_details' and now inventory seems to be in balance again.
.:Solved.

Thanx, Mika

Go to forum: Items and Inventory

2 Reply by Mixu

(11 replies, posted in Items and Inventory)

Joe, one question: From which database table(s) "Stock Check Sheet" is created? This information would help me a lot in solving this problem. I already verified that '-1' was due to delivering stuff which was not in the warehouse at the time of delivery.

Br,
Mika

Go to forum: Items and Inventory

3 Reply by Mixu

(11 replies, posted in Items and Inventory)

Joe, thanks for your answer.

It might be too laborious to go through those sales orders so looking for 'dirty fixes'. Anyway, I will try to find deviations with a quick peek.

I have allowed negative stock, so in that sense this kind of behavior is possible. But how this can be fixed (=set negative numbers back to zero or something else)? Can I somehow adjust 'demand' manually or by altering database?

Br,
Mika

Go to forum: Items and Inventory

4 Reply by Mixu

(11 replies, posted in Items and Inventory)

Well, some of my items has positive demand number... that's why I'm confused.

Go to forum: Items and Inventory

5 Reply by Mixu

(11 replies, posted in Items and Inventory)

I'm a bit confused; If "-1" means there is 1 item on a Sales Order not yet delivered, then what positive "1" means in the same context?

Thanks, Mika

Go to forum: Items and Inventory

6 Topic by Mixu

(11 replies, posted in Items and Inventory)

Hi,

I have few items in my inventory which have negative value in demand column in Stock Check Sheet. What would be the most reasonable root cause for this?

For instance on item has following "status":
quantity = 0, demand = -1, available = 1, on order = 0.

Any hints?

Thanx,
Mika

Go to forum: Items and Inventory

7 Reply by Mixu

(3 replies, posted in Translations)

Thanks for the reply Joe!

I just made it all over again - only this time I used the empty.po file which can be found in the /new_language_template/LC_MESSAGES (last time used the sourceforge version).

Now it seems to be working ok. It is just that we have too much "Ä" letters used in finnish words causing problems as those are seen as "ä" smile

Need to modify those when have time. If I ever have energy to do more official version of this I will send it over to you.

Go to forum: Translations

8 Topic by Mixu

(3 replies, posted in Translations)

Hello,

I just installed FA using installatron. Did not find the Finnish translation from languages, so tried to make it fast like this: took empty.po (version 2.2) from sourceforge and made translation with google translation kit. Finished it with poEdit.

For some reason, I cannot install it successfully. I have fi_FI.po and fi_FI.mo files, and I chose "add new language manually". After filling those fields the installed_languages.inc looks like this:

$installed_languages = array (
  0 =>
  array (
    'code' => 'fi_FI',
    'name' => 'Finnish',
    'path' => 'lang/fi_FI',
    'encoding' => 'iso-8859-1',
    'package' => 'fi_FI',
    'version' => '2.3.0-3',
  ),

Still the language remains in "unknown" state in the language list and the language is still english.

My question is: is there already Finnish packet somewhere? If not, what should I do to get my own "fast translation" working? The webhotel which I'm using is Finnish so I guess that locale things are ok.

Go to forum: Translations