Search options (Page 74 of 246)

When you upload the FA code to your server, there is only a config.default.php file which is a template for your real config.php file which gets created along with the config_db.php file when the install is complete. Some other files too get created on completion of install.

Explain what you did to "clear the existing entries". The default password is "password" and the default user is "admin". Restoring your company file will need to take care of the table prefix to match that which is in the config_db.php for the said company.

Refer this Post for update mechanism and non use of deprecated update_journal function.

The outstandings seem to be computed for each line independently without being cumulative. This is wrong.
The allocations get summed up even for previous years as the date in the common WHERE clause is taken instead of being a specific range for allocations alone.

@kvvaradha: Provide your patch to include in the core. During such editing, does the reference number of the entry change?

This is a new file in FA 2.4.x. Looks like it was made to be linked into an Edit Journal button on journal entries listing.

@kvvaradha: Good catch.
Wonder how it slipped thru for so long.

@joe: can commit it by removing the last closing bracket in the doc_date line.

When the same company is both a customer and a supplier, allocations can be made separately if monies are available in ban/cash to make payment to supplier side and if receipts are available from the customer side to allocate to customer invoices.
If no such amounts in the bank and from the Customer receipts are available to allocate, a form of adjustment allocation is needed between the Customer side and Supplier Side of the same company.
A credit note equated debit note to sum zero will be needed.

For example, Company A supplies $ 100/- worth of goods and takes delivery of $75 worth of our products. If we pass a Journal Entry to transfer $75 from the supply side to the customer side to pay for the Sales Invoice, the allocations would not appear to have been done on both sides, but mere amounts tallied. Here we pass a Credit Note to the Customer Side and a matching debit note to the Supply side and then allocate the credit and debit notes to the customer and supplier invoices.

Is it that you are sending goods to your customer (retailer) on the basis of some invoice raised on them and then if your goods remain unsold you have agreed to take return of it from your retailer and / or agree to pay the retailer for his shelf space rental as your prorata cost sharing agreement as you control the price at which your product must be sold to the end customer which if too high will render most unsold and make of poor returns to your retailer?

If this is the case, make the retailer a supplier of rental services to you and then make a Supplier invoice to the extent of the rental and then pay / adjust / allocate accordingly.

First off, I assume that you have no extensions installed that need db modifications.

A similar DB schema check will need to be done for all tables and for all records in lookup tables.
Note that the default document numbering system now has a pattern template in FA 2.4.x.

Some Chart of Accounts in FA 2.3.x and even in FA 2.4.x have field order differences with the standard sql/en_US-new.sql chart.

After synch-ing the chart, then see if an upgrade withing FA is necessary (Setup=>Software Upgrade). In each instance backup before and after such interventions.

The table definition of the 0_budget_trans table in FA 2.4.x is:

CREATE TABLE `0_budget_trans` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `tran_date` date NOT NULL DEFAULT '0000-00-00',
  `account` varchar(15) NOT NULL DEFAULT '',
  `memo_` tinytext COLLATE utf8_unicode_ci NOT NULL,
  `amount` double NOT NULL DEFAULT '0',
  `dimension_id` int(11) DEFAULT '0',
  `dimension2_id` int(11) DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `Account` (`account`,`tran_date`,`dimension_id`,`dimension2_id`)
) ENGINE=InnoDB;

It has just 7 fields and the memo_ field is the 4th one.

Which Chart of Accounts did you start out with?

At Line 52 in reporting/rep101.php, the value of the $sql variable for the first available debtor_no in the second Date Range (2018) in the function get_open_balance() is:

SELECT 
    SUM(IF(t.type = 10 OR (t.type IN (0 , 1) AND t.ov_amount>0), -ABS(t.ov_amount + t.ov_gst + t.ov_freight + t.ov_freight_tax + t.ov_discount), 0)) AS charges
   ,SUM(IF(t.type != 10 AND NOT(t.type IN (0 , 1) AND t.ov_amount>0), ABS(t.ov_amount + t.ov_gst + t.ov_freight + t.ov_freight_tax + t.ov_discount) * -1, 0)) AS credits
   ,SUM(IF(t.type != 10 AND NOT(t.type IN (0 , 1)), t.alloc * -1, t.alloc)) AS Allocated
   ,SUM(IF(t.type = 10, 1, -1) * (ABS(t.ov_amount + t.ov_gst + t.ov_freight + t.ov_freight_tax + t.ov_discount) - ABS(t.alloc))) AS OutStanding
FROM 1_debtor_trans t
WHERE t.debtor_no = '1'
  AND t.type <> 13
  AND t.tran_date < '2018-01-01'
GROUP BY debtor_no;

The output corresponding to the statements attached is:

charges    credits    Allocated    OutStanding
-6540        -6540            0            0

Do you want to zero out the Charges and Credits in this instance?