1 Reply by johnyu2012

(3 replies, posted in Installation)

No, the password cannot be saved.  After I login, usually browser like Chrome will offer to save the passowrd but it doesn't.  I wonder it has anything to do with https or not because the ssl cert is not recognized.

Go to forum: Installation

2 Topic by johnyu2012

(3 replies, posted in Installation)

Is there a way to enable autocomplete for login password?

Go to forum: Installation

3 Reply by johnyu2012

(9 replies, posted in Accounts Payable)

I found out how to do it.  You have void the supplier invoice first before voiding the purchase invoice delivery.

Go to forum: Accounts Payable

4 Reply by johnyu2012

(5 replies, posted in Accounts Payable)

Thanks! Working great.

Go to forum: Accounts Payable

5 Reply by johnyu2012

(5 replies, posted in Accounts Payable)

It will be easier to look up the purchase invoice delivery against the purchase invoice if the supplier's reference is shown on both places.

Go to forum: Accounts Payable

6 Topic by johnyu2012

(5 replies, posted in Accounts Payable)

When you go into the supplier inquiry, the supplier reference number is not showing on the supplier reference but on the purchase order inquiry, it does show.  Is it bug or did I do something wrong?

Go to forum: Accounts Payable

7 Reply by johnyu2012

(9 replies, posted in Accounts Payable)

I tried the void transaction in the setup.  It will not do and says "The entered transaction does not exist or cannot be voided."

Go to forum: Accounts Payable

8 Reply by johnyu2012

(9 replies, posted in Accounts Payable)

Can you tell me how to void the direct purchase invoice?

Go to forum: Accounts Payable

9 Reply by johnyu2012

(9 replies, posted in Accounts Payable)

Anybody knows the answer?

Go to forum: Accounts Payable

10 Reply by johnyu2012

(2 replies, posted in Setup)

Thanks!

Go to forum: Setup

11 Topic by johnyu2012

(2 replies, posted in Setup)

Is there a way to do form increment on user based?  For example, user 1 setup sales order for Y001 and user 2 setup sales order for H001 etc?

Go to forum: Setup

12 Topic by johnyu2012

(9 replies, posted in Accounts Payable)

I am trying to make things easy for my staff.  When the products arrive, I want them to use direct invoice so it will create all the other forms automatically for them.  If they want to make any changes, for example items A for 50 pcs instead of 100 pcs to go to warehouse A, should they go to supplier transaction inquiry and look up the purchase order delivery form to make a change.  It looks like you can view but you cannot edit it.  How to actually make a change?

Go to forum: Accounts Payable

13 Reply by johnyu2012

(3 replies, posted in Accounts Receivable)

Thanks!

Go to forum: Accounts Receivable

14 Topic by johnyu2012

(3 replies, posted in Accounts Receivable)

For example: If the sales order has 3 items and delivered from 3 different warehouses, how can this be done?  It looks like you can only choose from one warehouse.

Go to forum: Accounts Receivable

15 Topic by johnyu2012

(1 replies, posted in Jobs wanted/offered, non-free offers)

I have been testing for FA for a couple days already.  I like it a lot.   But in order to really migrate for my company, there are still quite a few customization needed to be done.  I am looking for an expert who knows FA code inside out but most importantly is he has to have good attitude and responsive.  It is because I have had bad experience with programmer who is very lazy and unprofessional after collecting money.  Please let me know who is interested in this job.  Thanks!

Go to forum: Jobs wanted/offered, non-free offers

16 Reply by johnyu2012

(3 replies, posted in Accounts Receivable)

Thank you!  Works great.

Go to forum: Accounts Receivable

17 Topic by johnyu2012

(3 replies, posted in Accounts Receivable)

I don't understand why each customer needs a customer branch to create a invoice.  For example, I have 6 retails and one office.  If the staff in one of the retails has to create an invoice for a new customer, why he has to create a new customer branch then a customer?  Isn't it kind of duplicate the effort because the delivery address is linked to customer branch, not customer?  Is there a easier way to do this?

Go to forum: Accounts Receivable

18 Reply by johnyu2012

(24 replies, posted in FA Modifications)

Successfully added the extra fields today.  Thank you for all the help.

Go to forum: FA Modifications

19 Reply by johnyu2012

(24 replies, posted in FA Modifications)

Thank you for the clearance.

Go to forum: FA Modifications

20 Reply by johnyu2012

(24 replies, posted in FA Modifications)

If you don't use foreign key and references to link the table, how do you link all the tables with relationship?  When I look at the Entity relationship diagram, it does have relationships between tables.

Go to forum: FA Modifications

21 Reply by johnyu2012

(24 replies, posted in FA Modifications)

In addition, is there any docs to explain what each file and folder in FA does?  What is its function?  In that case, it will be a lot easier to study the code.

Go to forum: FA Modifications

22 Reply by johnyu2012

(24 replies, posted in FA Modifications)

I am looking into zh_HK-utf8.sql since this is where all the tables get created.  I tried to create a table called stock_extra_fields and link it up to the stock_master table.  In the stock_extra_fields, the primary key is called stock_extra_id and I should have that also in the stock master to create a 1 on 1 relationship.  That's how I do it.

CREATE TABLE `0_stock_extra_fields` (
  `stocks_fields_id` varchar(20) NOT NULL default '',
  `long_description_1` varchar(200) NOT NULL default,
  `long_description_2` varchar(200) NOT NULL default,
  `long_description_3` varchar(200) NOT NULL default,
  PRIMARY KEY  (`stocks_fields_id`)
  FOREIGN KEY (`stocks_fields_id`) REFERENCES 0_stock_master(`stocks_fields_id`)
) ENGINE=InnoDB  ;

But the interesting thing is I don't see any other create table use REFERENCES to create relationship.  How does FA create relationship for tables?

Go to forum: FA Modifications

23 Reply by johnyu2012

(24 replies, posted in FA Modifications)

I guess what you mean is to create an extra table for the custom fields and then link it up to the stock master table.  Insert or update the stock_master table in the meanwhile also do it for the custom fields table.  And at the end, all this work can be put in as a new extension.  I will try to do that.  I am pretty sure somebody will find it useful for some extra fields for the items.

Go to forum: FA Modifications

24 Reply by johnyu2012

(2 replies, posted in Items and Inventory)

Thanks!  That helps a lot.

Go to forum: Items and Inventory

25 Reply by johnyu2012

(24 replies, posted in FA Modifications)

I can add the custom fields into the stock_master table and also able to show the fields in items.php.   But when I want to add an item, it won't because I have not updated the insert into statement yet.

Error message : Field 'long_description_1' doesn't have a default value
sql that failed was : INSERT INTO 2_stock_master (stock_id, description, long_description, category_id, tax_type_id, units, mb_flag, sales_account, inventory_account, cogs_account, adjustment_account, assembly_account, dimension_id, dimension2_id, no_sale, editable) VALUES ('P3612', 'Venice Blanco', 'df', 'dfw', 'gg', 'fgdsg', '1', '1', 'ea.', 'B','4020', '1520', '5020', '1520','1520','0')

I looked through the sql folder.  It looks like it is only for creating tables when I create the company.  It looks like it uses a function called submit center to add the new row.   When I looked into this submit center function, it does not take me to the insert statement.  Where is this insert statement supposed to be?  Where is the location?

Go to forum: FA Modifications