Search options (Page 29 of 246)

Try to put in both languages in the name itself or alter the rep107.php accordingly.

No one seems to indicate if they are accountants!

@joe can this be included into the core with a Company Setup flag in sysprefs table?

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`);