Search options (Page 73 of 245)

@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?

On the 4th day of the Official Release of FA 2.4.4, the SF Download stats are here.

Does this mean that all standard Chart of Accounts are made with Default Company permissions and that on creating a non default company with it does not automatically remove such Super Admin privileges for it?

It is pertinent to have such a message to accommodate records prior to inducting this table in FA and for records that straddled fiscal years when the older ones have been purged.