Search options (Page 48 of 247)

The EAN8 barcode type is hardcoded in the reporting/rep303.php file in lines 327-329:

$barcode = str_pad($trans['stock_id'], 7, '0', STR_PAD_LEFT);
$barcode = substr($barcode, 0, 8); // EAN 8 Check digit is auto computed and barcode printed
$rep->write1DBarcode($barcode, 'EAN8', $rep->cols[$firstcol++], $bar_y + 22, 22, $SysPrefs->pic_height, 1.2, $style, 'N');

The default FA reporting/includes/barcodes.php file is from the TCPDF 's 1dBarcode library when used.

The reporting/rep303.php file however uses another library's extracted barcode functionality which supports only the following subset of formats:

EAN, EAN-8, EAN-13, GTIN-8, GTIN-12, GTIN-14, UPC, UPC-12 coupon code, JAN

Using another subset of TCPDF from a GitHub project for barcode generation is also feasible. This library is set to be PHP 5.4+ compatible but for backwards compatibility with PHP 5.3.x, just replace all instances of "= []" with "= Array()" in it's src/BarcodeGenerator.php file.

Sample code for using it in a standalone manner would be:

<?php
include('src/BarcodeGenerator.php');
include('src/BarcodeGeneratorPNG.php');

$generator = new Picqer\Barcode\BarcodeGeneratorPNG();
file_put_contents('src/files/081231723897-code128.png', $generator->getBarcode('081231723897', $generator::TYPE_CODE_128));
echo '<img src="data:image/png;base64,' . base64_encode($generator->getBarcode('081231723897', $generator::TYPE_CODE_128)) . '">';

The above will both generate a file and display it inline as well.

Delete branches first and then delete customer with no branch. Transactions may be pertaining to the first branch created when the customer was created.

Send it to ME :-)
I'll atleast update it in the FA24extensions repo which has some fixes over the years that others have reported or that which I just stumbled upon.

Setup => Company Setup => tick "Use Barcodes on Stocks" and optionally tick "Company Logo on Reports" if logo is present and desired.

Items and Inventory => Items => Add New Item
You will now see the EAN-8 Barcode which if clicked, will yield a random EAN-8 barcode

Any other barcodes you will need to make changes in the codebase and you can also use third party online tools to generate them like:

https://barcode.tec-it.com/en/EAN8
https://www.free-barcode-generator.net/code-128/

Items and Inventory => Inventory Reports => Stock Check Sheets => Select "Yes" for "Show Pictures" and optionally "Inventory Column" and now all barcodes will be listed.

Since you want code-128 barcode and one barcode per sheet with your fields listed there, just edit the Stock Check Sheets reporting/rep303.php file to suit your need.

If you need technical assistance for it, post your specs and bounty in the Jobs board and hopefully someone will assist you.

Your definition of "old" customers are those with no transactions for upto 4 years.
Look for persistent opening balances that have not been adjusted too in a long time.

1. check the debtors_master for full list of customers / suppliers.
2. check the debtor_trans for their old transactions to start with
3. then shortlist the ones that do not appear from a date 4 years ago
4. check if they appear in any of the various voucher types and keep only those which do not appear after a certain date four years ago.
5. Now these customers are in the crm_* tables and in the debtor_master and should not be in your recent debtor_trans table.
6. Copy these debtor_master and crm_* entries into an archive first
7. Now go ahead and delete the specific entries in their current db tables.

Many other tables like voided, gl_trans, cust_branch, etc., too can possibly sport remnants of such customers' transactions.

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

Updated Dutch (nl_NL) translations. See Links above.

180 strings left to translate.

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

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?

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

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?