Search options (Page 28 of 245)

Account Types appears in the bank_accounts table and in the menu Banking & GL => Bank Accounts and has the following values / choices:

0 => Savings Account
1 => Chequing Account
2 => Credit Account
3 => Cash Account

Expect these functionalities and choices to be hard coded in the php scripts. How do we use it to summarise them?

The wiki entry asks to allocate a single GL account to many Bank Entries at:
https://frontaccounting.com/fawiki/index.php?n=Help.BankAccounts

Also there is very little info on Account Tags in the wiki. at:
https://frontaccounting.com/fawiki/index.php?n=Help.AccountTags

@joe: Need to refurbish the end of year routines to make sure that the client balances are automatically made along with unpaid and partially paid invoice data for allocation of payments in the subsequent year. This needs to be done for suppliers as well. The appropriate stock moves too need to be taken care of.

Sales => Sales Types
Choose to Include or Exclude Tax in prices.

Turn on debug in the config file and see what errors accrue.

Petty cash is treated like a bank account in FA. That is why you will find it in the bank_accounts table (check using the standard Chart of Accounts with demo data).

The sql construct starting at line 107 refers to an alias: Demmand. Is it used and is the mis-spelling intended? The said column does not appear to be explicitly named anywhere in usage.

The only indexes worth creating are:

ALTER TABLE 0_sales_orders ADD INDEX FromStkLocIdx (from_stk_loc); 
ALTER TABLE 0_stock_master ADD INDEX MBFlagIdx (mb_flag); 

The function stock_demand_manufacture is recursive in nature to cycle through all BOMs that may have other BOMs as part of itself. Check that the BOMs do not have any parent entities as part of the downline.

What is the size of your gzipped sql backup from FA?
Maybe it can be simulated in a quarantined cloud container and provide the reports and study the sqls that need to be optimised.

We need to first try it on say PHP 5.3.3 / MySQL 5.1 on a test Debian 6.0 container. This can be tedious and time consuming besides the discerned attention to technical detail. Is it worth it?

In each menu item you want add / edit role separation do the following:

1. Take a FA sql backup
2. Add a record in the menu item
3. Take another FA sql backup
4. Compare the 2 backups and see what SQL statements are needed for the Add operation.
5. Edit the record in the above menu item for the fields desired to be edited (or in it's entirety)
6. Take yet another FA sql backup
7. Compare the last 2 backups and see what SQL statements are needed for Edit operation.
8. Compare the field list for the Add and Edit operation's SQL statements.

Now either code the PHP in a way that achieves the above (OR)
Create a new MySQL DB (non-edit) user giving it suitable rights over the desired tables/fields and program the FA mysql_connect based on the logged in (non-edit) user and switch to those credentials.

rep302.php - Inventory Planning Report - Line 52
rep303.php - Stock Check Sheet - Line 164

The above reports have a function getTransactions() which uses item.description in the GROUP BY clause - this assumes that each item.stock_id can have different item.description(s) - may even try to remove the offending Line making sure it is unique or make an index for it with:

ALTER TABLE `1_stock_master` ADD INDEX `ItemDetailIdx` (`description`); 

@kvvaradha: In case your offering is commercial / encrypted / FA version dependent, just place a link to your product's web page with info and costs so that it can be useful to the FA users who want to trust and buy your product and compare with other Open Source offerings.

Patient's Name and Case are the 2 new form fields in Sales => Direct Delivery and Sales Order in your demo. Where is the batch Selection? The Invoice against Sales Delivery has a Batch button though. None of the Purchase links have any Batch feature.

Provide some sample data to experience the Batch details.

You can do away with the 0_cases table and keep the data as a comma delimited string in a setting in the 0_sys_prefs table.

The other extra tables used are 0_stock_batch, 0_stock_batch_moves.

The 0_stock_batch_moves table can be accommodated within the core 0_stock_moves table (possibly others above too) with some combination of innocuous values in unused fields of price, reference and standard_cost.

No. the "quot" here is the htmlentity for a quote character in the characterset.