1,126

(2 replies, posted in Items and Inventory)

Make sure that the id of the fiscal years are in the same order as the year ranges themselves! Closing FYs will otherwise be a nightmare.

You may want to make a separate comment like entry below the tallied values in a different column so as not to confuse accountants.

1,128

(13 replies, posted in Report Bugs here)

Will need to revert this commit - see this post.

What is the purpose of getting the last_sales_order_detail() field (in this case, 'stk_code' which is the stock_id)? Byusing this commit, we are making the default choice of the Item description select box override the actual selection made in it. Should this be restricted to only those with editable description alone if used at all?

New FA 2.4.6+ install on Windows XAMPP 1.7.3, PHP 5.3.1, MySQL 5.0
Browser FireFox 52.9 ESR on WinXP SP3

Using sql/en_US-demo.sql Chart.

Sales => Direct Invoice
Changing the Item Code results in the next Item Description select box being correctly updated by Ajax.
Changing the Item Description select box momentarily changes the Item Code and then the Item Code reverts back to what it was along with the old Item Description appropriate to it.

Tested with and without Barcode enablement in Company Setup page.
Recent commits discussed in this post culminating in this commit may have something to do with it. Rolling back the said commit makes FA happy like before.

That is how it is expected to be.
PL will be clear and detailed only before closure.
BS will become clear by itself only after closure as the Profit/Loss gets transferred to it.

1,131

(8 replies, posted in Translations)

Updated Dutch (nl_NL) translations. See Links above.

180 strings left to translate.

Check on a clean install of FA 2.4.6+

1,133

(1 replies, posted in Banking and General Ledger)

Thanks. Wiki-ed it.
Screenshot upload to wiki - settings awaited.

1,134

(6 replies, posted in Wish List)

Alternatively, make a separate table that holds debtor_masters' primary key (debtor_no) matched to an account number in osCommerce in the latter and create a view that provides for direct import into FA from it.

Are you all getting this error in your reports or in the screen display / drilldown view itself?

@joe: Has the BS/PL got their Cr/Dr switched on closure of Fiscal Year?

Instead of changing FA core operations, try to change the Balance Sheet report to suit your needs.

Should we not check if real_name is blank instead of a single space?

This is how double entry accounting works. Financial Year closure means that all P&L are lumped together and transferred to BS from PL which gets zeroed out to start the new fiscal year afresh.

Make a Kit item of your "product and service" sold to your customer.
Since you know all the costs - landed cost - book it all a the price of the product bought from the Supplier.
Do not directly book the Supplier Invoice to the COGS. Do it through the Supplier Account where you can allocate the payments too.

1. Supplier Advance Proforma Invoice.
2. Advance to Supplier: Dr Supplier, Cr Bank
3. Cr - Import, Delivery, Custom Duties, etc,, Cr - Supplier for Direct Goods Cost, Dr. Purchases Expenses for Goods+Costs
4. Take into stock: Cr Supplier, Dr Stocks
5. (Optional) Allocate Payment to Supplier: Dr Supplier, Cr Supplier
6. Make Kit Item of Unit Goods and variable units of Install Service Charges
7. Invoice Kit Item to Customer - Dr Customer, Cr Sales
8. Payment from Customer - Cr Customer, Dr Bank
9. (Optional) Allocate Payment from Customer - Dr Customer, Cr Customer

@joe: anything more standard?

1,140

(9 replies, posted in Reporting)

Which field in FA do you want to use as Barcode and what code type of barcode do you want?

Once the Barcode type and value field are ascertained, you can use TCPDF to generate them as needed.

Create a separate independent form that suits your need and then submit it as separate entities into the standard FA Form. A sort of POS to dovetail into your FA.

In the sql/en_US-new.sql standard chart, the fields with the word description in them are defined thus:

# grep description en_US-new.sql | grep -v KEY

  `description` varchar(60) NOT NULL DEFAULT '',
  `description` varchar(60) NOT NULL DEFAULT '',
  `description` varchar(60) DEFAULT NULL,
  `reason_description` char(100) NOT NULL DEFAULT '',
  `description` tinytext NOT NULL COMMENT 'usage description',
  `description` tinytext,
  `description` tinytext,
  `description` varchar(60) NOT NULL DEFAULT '',
  `description` varchar(200) NOT NULL DEFAULT '',
  `description` varchar(60) NOT NULL,
  `supplier_description` char(50) NOT NULL DEFAULT '',
  `description` tinytext,
  `description` varchar(60) NOT NULL,
  `description` varchar(60) NOT NULL DEFAULT '',
  `description` varchar(60) NOT NULL DEFAULT '',
  `description` tinytext,
  `description` varchar(50) DEFAULT NULL,
  `description` varchar(60) NOT NULL DEFAULT '',
  `description` varchar(200) NOT NULL DEFAULT '',
  `long_description` tinytext NOT NULL,
  `description` varchar(200) NOT NULL DEFAULT '',
  `long_description` tinytext NOT NULL,
  `description` tinytext,
  `description` varchar(60) DEFAULT NULL,
  `description` char(50) NOT NULL DEFAULT '',

In FA v2.5 alpha, it may be useful to classify the description field differently and standardize their field length / type uniformly.

In the following files that refer to supplier_description, there is no truncation occurring in the code (except where function text_row() is used):

inventory/purchasing_data.php
inventory/includes/db/items_purchases_db.inc
purchasing/includes/purchasing_db.inc
purchasing/includes/db/po_db.inc
reporting/rep209.php

Hence, a mere increase in field size is sufficient ordinarily.

However, where a form field restricts input size / max width using the function text_row() defined in includes/ui/ui_input.inc, changes in 4th (size) and 5th (max width) arguments will also be needed. This is so only in the first file listed above.

Switch from Credit to Debit and vice versa as needed.

1,145

(9 replies, posted in Report Bugs here)

Please try with a windows machine and the latest Firefox. Also post the URL for the right and wrong PDF paths.

Have a look at the other charts - this is so for a new table with the new structure to be created should one already exist with possibly a different structure.

Refer my chart repo for any changes from the official package.

There is no data for the 0_security_roles table in it.
Refer my commit.

@joe: can correct it in the official package.

1,148

(9 replies, posted in Report Bugs here)

Try Firefox browser or any other non chrome browser and see if it displays correctly. Also try to do a "Save As" of the download file link and see if it comes in correctly.

1,149

(9 replies, posted in Report Bugs here)

Change settings in browser for PDF viewer to be native viewers or specific programs - Acrobat / SumatraPDF.

Check the latest FA24extensions repo for changes to the extensions of interest.