Bank billet generation for AR

[Alexandre]

Hi Nathan,

I’m working around another feature for perp_ar that is the generation of bank billets and I would like your help for some questions. It’s my preliminar work way:

1. I’m working with a library php for generation of bank billets called BoletoPHP (http://www.boletophp.com.br). It generates billets for the main brazilian banks, including several international banks. It’s in portuguese and can be expanded;

2. I’m thinking about use the admin>>perp_ledger>>bank accounts screen for include the information of bank agency, that not exists and is necessary for billet generation;

3. The idea for generation is use the report generation structure, creating another report, like report_invoice, requesting from user what client, invoice and bank he wants to generate the billet. It’s the work wich I don’t know how to do. Can you help me to start, please?

What do you think about it?
Is it interesting?

Thanks and regards.

[ngegw]

Hi Nathan,

I’m working around another feature for perp_ar that is the generation of
bank billets and I would like your help for some questions.

“Bank billets” doesn’t machine translate well. Is this some sort of
electronic payment / fund transfer?
I’ll assume it’s some kind of EFT system for the rest of this reply,
if not, please clarify.

I’m all for an integrated electronic funds transfer system in
projectERP. That would be great.
It would be best placed in perp_ledger, and used by both perp_ar and
perp_ap (and others) as something optional.

1. I’m working with a library php for generation of bank billets called
   BoletoPHP (http://www.boletophp.com.br).

Google’s machine translation of that site into English is poor, so I
can’t really understand what’s involved.
A quick read of the code gives me some concern: it’s not really a
library that can be called from another web application. eGroupWare
and pERP have gone to great pains to avoid mixing PHP and HTML. The
eTemplate engine is the current preferred way of generating user
interface, so you will have to create some way of using eTemplate to
generate the UI. eTemplate also handles the translations, and it
looks like BoletoPHP has no provision for this.
If BoletoPHP can handle batched transactions, I may be able to add
Canadian banks in as well.
Since the code is entirely in Portuguese, I will be unable to offer
much assistance in integration. You should also commit to the ongoing
maintenance of this addition.

2. I’m thinking about use the admin>>perp_ledger>>bank accounts screen for
   include the information of bank agency, that not exists and is necessary for
   billet generation;

That is a possibility, but there may not be enough room in the list;
each row is large compared to the other rows in pERP. It may be
better to add on a EFT section, with a link from each bank account to
the EFT settings for that bank account.

3. The idea for generation is use the report generation structure, creating
   another report, like report_invoice, requesting from user what client,
   invoice and bank he wants to generate the billet. It’s the work wich I don’t
   know how to do. Can you help me to start, please?

pERP’s report system was designed to generate pretty pages for normal
people. It is not well suited to the type of files that banks like.
If the bank wants a fixed record width flat text file, don’t try to
use the report system.
In addition to not being the right thing for the job, it has no
provisions to prevent duplication. You can easily generate the same
report several times in a row.

If a bank billet is just a special form or paperwork, the report
system would work fine. See
http://www.projecterp.org/mediawiki/index.php/Reports.

What do you think about it?
Is it interesting?

The EFT should probably be tied into the Payment / Receipt sections,
either explicitly (there’s a button or something there) or behind the
scenes so that the transaction is properly recorded.

If you have any further questions I would be happy to answer.
Nathan

---

The Next 800 Companies to Lead America’s Growth: New Video Whitepaper
David G. Thomson, author of the best-selling book “Blueprint to a
Billion” shares his insights and actions to help propel your
business during the next growth cycle. Listen Now!
http://p.sf.net/sfu/SAP-dev2dev

---

Perp-developers mailing list
Perp-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/perp-developers

[Alexandre]

Excuse me for my english, the correct term would ‘Bank Slip’.

The Bank Slip is a payment form widely used in Brazil.

Exemple: http://www.boletophp.com.br/boletophp/boleto_cef.php

Thanks.

[ngegw]

Excuse me for my english, the correct term would ‘Bank Slip’.

The Bank Slip is a payment form widely used in Brazil.

Exemple: http://www.boletophp.com.br/boletophp/boleto_cef.php

Ok, much simpler. I haven’t seen one of those in Canada for years…
You should be able to do something with the report system, See
http://www.projecterp.org/mediawiki/index.php/Reports.

Nathan

---

Centralized Desktop Delivery: Dell and VMware Reference Architecture
Simplifying enterprise desktop deployment and management using
Dell EqualLogic storage and VMware View: A highly scalable, end-to-end
client virtualization framework. Read more!
http://p.sf.net/sfu/dell-eql-dev2dev

---

Perp-developers mailing list
Perp-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/perp-developers

[Alexandre]

Hi Nathan,

I made a bank slip generation structure and it worked fine using reports system. However, I have some questions:

1. The bank slips should be generated in html, because of the barcode, and it’s interrupting the routine of report generation before the generation of .ODT file. Do you know some better way to do this?

2. There is no standard setup for generation of bank slips for all banks, and because this, each bank slip have your setup. Then, I would need to create a configuration area for this. Is it a good idea? How do you sugest I do it? What the better way to do it?

Tomorrow I will send you a patch of what I already made.

Thanks.

[ngegw]

Hi Nathan,

I made a bank slip generation structure and it worked fine using reports
system. However, I have some questions:

1. The bank slips should be generated in html, because of the barcode, and
   it’s interrupting the routine of report generation before the generation of
   .ODT file. Do you know some better way to do this?

There are two ways you could investigate. One is to somehow get the
HTML into the ODT file, the other is to investigate the barcode
generator that comes with pERP. It’s in perp_api/inc/barcode. There
are some examples in the manufacturing section that use it.

2. There is no standard setup for generation of bank slips for all banks,
   and because this, each bank slip have your setup. Then, I would need to
   create a configuration area for this. Is it a good idea? How do you sugest I
   do it? What the better way to do it?

I think the best way is to use the eTemplate for the report and let
the user pick the bank. Then, based on their selection use the
appropriate ODT template for the selected bank. If you want to get
fancy, you could remember which bank for next time. See some of the
other reports for examples.

Nathan

---

Beautiful is writing same markup. Internet Explorer 9 supports
standards for HTML5, CSS3, SVG 1.1, ECMAScript5, and DOM L2 & L3.
Spend less time writing and rewriting code and more time creating great
experiences on the web. Be a part of the beta today
http://p.sf.net/sfu/msIE9-sfdev2dev

---

Perp-developers mailing list
Perp-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/perp-developers

[Alexandre]

Hi, Nathan.

I’m trying generate bank slip how perp report. I was able to access all data that needed. but still do not know how to generate barcode.

I am sending you the code.

In config bank account, the field ‘number account’ must contain ‘number of agency/ number of account’. for example: 1234/1234567-8. This is default of brasilian banks.

Thanks

patch.txt (12.3 KB)
class.bank_slip.inc.php (23.2 KB)bank_slip.odt (24.1 KB)

[ngegw]

Hi, Nathan.

I’m trying generate bank slip how perp report. I was able to access all data
that needed. but still do not know how to generate barcode.

I am sending you the code.

Looks fine, but your report (class.bank_slip.inc.php) has three issues
I need you to fix:

1. I know this is designed just for Brazil, but please use the lang()
   function to wrap your errors. This will make it easier if other
   countries can use your work. Use a short English identifier, then use
   eGW’s translation tools.
   ex: lang(‘unknown bank’) gets translated by eGW to “Este banco não
   está disponível para a geração de boleto.” or “This bank is not
   available for bill generation” or “Cette banque n’est pas disponible
   pour la génération de projet de loi” as appropriate for the user.

2. When you give an error message in the get_data() function, you
   have to die, not break. Ex. lines 460, 497. Breaking results in the
   ODF being included in the page.

3. The formatting in that file is unreadable. I know you’ve copied &
   pasted, but it should be at least properly indented. 30 seconds with
   a code beautifier will work wonders.

I am curious about the error “Este banco não está disponível para a
geração de boleto.”. It looks like this error is generated if the
bank account is not named one of two possible values. If this is
the case, you should improve the error message with a list of allowed
names. You may also want to look at the org_name of the associated
bank address instead of the bank account name.

Nathan

---

Increase Visibility of Your 3D Game App & Earn a Chance To Win $500!
Tap into the largest installed PC base & get more eyes on your game by
optimizing for Intel® Graphics Technology. Get started today with the
Intel® Software Partner Program. Five $500 cash prizes are up for grabs.
http://p.sf.net/sfu/intelisp-dev2dev

---

Perp-developers mailing list
Perp-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/perp-developers

[Alexandre]

Hi, Nathan.

I followed your recommendations and I resolved some problems. But I found a new problem.

In data array

Array
(
[invoice] => Array
(
[0] => Array
(
[invoice_id] => 4
[our_reference] => 800000hhhh-9
[their_reference] => 00000

                .
                .
                .

                [bankaccount] => Array
                    (
                        [bank_account_id] => 100.02
                        [bank_account_name] => Caixa
                        [bank_account_number] => 1234567
                        [bank_address] => 421
                        [currency] => BRL
                        [payment_methods] => 
                        [sort_order] => 1
                        [address_link] => Array
                            (
                                [app] => addressbook
                                [id] => 421
                                [title] => 
                            )

                        [bank_agency_number] => 4321
                        [bank_account_dv] => 8
                        [carteira] => SR
                        [bank_code] => 104-0
                        [linha] => 10498.00004 0hhhh.432104 00012.345674 2 47820000005000
                    )

            )

    )

[4_line] => Array
    (
        [0] => Array
            (
                [line_number] => 0
                [human_line_number] => 1
                [quantity] => 2
                [unit_price] => 10,00
                [description] => produto 01
                [line_type] => 0
                [general_ledger_account] => 100.01
                [gl_transaction_line] => 
                [line_no] => 0
                [line_price] => 20,00
            )

        [1] => Array
            (
                [line_number] => 1
                [human_line_number] => 2
                [quantity] => 3
                [unit_price] => 10,00
                [description] => produto 02
                [line_type] => 0
                [general_ledger_account] => 100.01
                [gl_transaction_line] => 
                [line_no] => 1
                [line_price] => 30,00
            )

    )

[4_0_detail] => Array
    (
    )

[4_1_detail] => Array
    (
    )

[4_taxes] => Array
    (
    )

)

I can to use the data of array [‘invoice’]like this:
[invoice.our_reference;noerr;]

But I can’t to use the data of array [‘4_line’] like this:

[4_line.description;noerr;] or [4_line.0.description;noerr;]

This is same problem that happened in purcharse_order report

http://www.egroupware.org/forum#nabble-td888762

What I can to do?
Thanks.

[ngegw]

Hi, Nathan.

I followed your recommendations and I resolved some problems. But I found a
new problem.

In data array

Array
(
[invoice] => Array
(
[0] => Array
(
[invoice_id] => 4
[our_reference] => 800000hhhh-9 …
)

[4_line] => Array
(
[0] => Array
(
[line_number] => 0
[human_line_number] => 1
[quantity] => 2
[unit_price] => 10,00
[description] => produto 01
)

       [1] => Array
           (
               [line_number] => 1
               [human_line_number] => 2
               [quantity] => 3
               [unit_price] => 10,00
               [description] => produto 02
           )

   )

…
)

I can to use the data of array [‘invoice’]like this:
[invoice.our_reference;noerr;]

But I can’t to use the data of array [‘4_line’] like this:

[4_line.description;noerr;] or [4_line.0.description;noerr;]

It does have to be in the template like this:
[[invoice.invoice_id]_line;block=begin]
[[invoice.invoice_id]_line.description;noerr]
[[invoice.invoice_id]_line;block=end]

You line with the hard-coded ID would not work because it needs to be
in a block.

This is same problem that happened in purchase_order report

Did you ever find a solution for that?

Nathan

---

Increase Visibility of Your 3D Game App & Earn a Chance To Win $500!
Tap into the largest installed PC base & get more eyes on your game by
optimizing for Intel® Graphics Technology. Get started today with the
Intel® Software Partner Program. Five $500 cash prizes are up for grabs.
http://p.sf.net/sfu/intelisp-dev2dev

---

Perp-developers mailing list
Perp-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/perp-developers

[Alexandre]

It does have to be in the template like this:
[[invoice.invoice_id]_line;block=begin]
[[invoice.invoice_id]_line.description;noerr]
[[invoice.invoice_id]_line;block=end]

You line with the hard-coded ID would not work because it needs to be
in a block.

This way don’t work for me. This is exactly the same problem of purchase order report.

There is another way of to do this?

[Alexandre]

this error happens too in invoice report.

I’m sending the broken report e data array.

Thanks.

Invoice_010101.odt (13.5 KB)
data_array.txt (9.11 KB)

[Alexandre]

the problem is still happening because of special characters.

When I create a invoice without special characters ,the reports work fine.

Do you think we must contact the TBS developer?

Thanks

[ngegw]

the problem is still happening because of special characters.

When I create a invoice without special characters ,the reports work fine.

Do you think we must contact the TBS developer?

Certainly you could contact them, but it’s not solely a problem with TBS.
I have never been able to duplicate this problem - all my special
characters come out fine.
PCSLists, if you have any help to offer that would be great.

Nathan

---

Increase Visibility of Your 3D Game App & Earn a Chance To Win $500!
Tap into the largest installed PC base & get more eyes on your game by
optimizing for Intel® Graphics Technology. Get started today with the
Intel® Software Partner Program. Five $500 cash prizes are up for grabs.
http://p.sf.net/sfu/intelisp-dev2dev

---

Perp-developers mailing list
Perp-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/perp-developers

[Alexandre]

for generation bank slip, I need generate a barcode in odt file. I can to do this? what’s the best way of to do this?

Thanks.

[ngegw]

for generation bank slip, I need generate a barcode in odt file. I can to do
this? what’s the best way of to do this?

I don’t know about the best way, but pERP has built-in support for
PEAR’s Image_Barcode. This example is from
perp_manufacturing/inc/report/class.build_tag.inc.php. See the odt
template for how to use it.

$tmp_name = tempnam($GLOBALS[‘egw_info’][‘server’][‘temp_dir’],
‘barcode_’) . ‘.png’;
$barcode_path = EGW_INCLUDE_ROOT . ‘/perp_api/inc/barcode/image.php’;
exec(“php $barcode_path code={$bar_code} encoding=code128 >> $tmp_name”);
$data[‘barcode’][‘path’] = $tmp_name

Known encodings:
$list = array(
‘ean13’ => ‘EAN-13’,
‘upca’ => ‘UPC-A’,
‘code128’ => ‘Code 128’,
‘Code39’ => ‘Code 39’,
‘int25’ => ‘Int 25’,
‘postnet’ => ‘US Post POSTNET’
);

Nathan

---

Increase Visibility of Your 3D Game App & Earn a Chance To Win $500!
Tap into the largest installed PC base & get more eyes on your game by
optimizing for Intel® Graphics Technology. Get started today with the
Intel® Software Partner Program. Five $500 cash prizes are up for grabs.
http://p.sf.net/sfu/intelisp-dev2dev

---

Perp-developers mailing list
Perp-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/perp-developers

[PCSLists]

Certainly you could contact them, but it’s not solely a problem with TBS.
I have never been able to duplicate this problem - all my special
characters come out fine.
PCSLists, if you have any help to offer that would be great.

Hi Nathan, hi Alexandre,

This problem with TBS and special chars was solved by me of a strange way!!
Setup of egroupware indicates that php.ini php_admin_value mbstring.func_overload must to be 7, but the reports only works for me if I change it for value 0, counteracting the recommendation of eGW. It worked for me.
About this, I have a question for you, Nathan, What I have to add in egroupware.conf for the reports works with mbstring=0 allowing all the system to work with value 7?

I hope to be helpfull!
Thanks

[Alexandre]

I don’t know about the best way, but pERP has built-in support for
PEAR’s Image_Barcode. This example is from
perp_manufacturing/inc/report/class.build_tag.inc.php. See the odt
template for how to use it.

Happened a problem in this report. In file perp_api/inc/barcode/image.php on line 3:

require_once(‘Image/Barcode.php’);

But don’t exist this file.

Thanks.

[ngegw]

I don’t know about the best way, but pERP has built-in support for
PEAR’s Image_Barcode. This example is from
perp_manufacturing/inc/report/class.build_tag.inc.php. See the odt
template for how to use it.

Happened a problem in this report. In file perp_api/inc/barcode/image.php on
line 3:

require_once(‘Image/Barcode.php’);

But don’t exist this file.

Sounds like you did not install PEAR’s Image_Barcode.

---

Increase Visibility of Your 3D Game App & Earn a Chance To Win $500!
Tap into the largest installed PC base & get more eyes on your game by
optimizing for Intel® Graphics Technology. Get started today with the
Intel® Software Partner Program. Five $500 cash prizes are up for grabs.
http://p.sf.net/sfu/intelisp-dev2dev

---

Perp-developers mailing list
Perp-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/perp-developers

[Alexandre]

Thanks, I installed and it’s working. But I have doubts about this.

In the .odt template build_tag.odt there are fixed barcodes and I observed that the tinyDoc can’t add or change pictures dynamically in OpenOffice documents.
http://www.tinybutstrong.com/tbsooo.php#limitations

How can I make it work?