FrontAccounting forum — PDF

Re: PDF

null@example.com (rafat) — Wed, 25 Nov 2020 17:04:38 +0000

@areePOM

I think

https://frontaccounting.com/fawiki/index.php?n=Help.ReportsAndAnalysis

Is a good starting point to understand how PDF's are generated by frontaccounting. It is very hard to understand the coding of these files..but if you spend a good amount of time (and you are a very good programmer) you might end up decoding how you can manipulate them to your needs.

I would say the three major files you need to look for are:

1) reporting/includes/header2.inc

This is the first overlay that defines the horizontal lines and columns...on its own.. its empty..just the border lines and the rectangles you see on an invoice for example.I would call it the report empty overlay.

2) reporting/includes/doctext.inc

This is what what document data you need included within these line and boxes but not the data itself (within the above template).

3) reporting/repXXX.php are the the php coding that extracts that data using SQL queries to place the data within the above two files. i.e rep107.php for invoice, rep111.php for quotes .....etc.

Good luck..

Re: PDF

null@example.com (kvvaradha) — Wed, 25 Nov 2020 11:15:58 +0000

By editing the pdf generator program files you can get your customized pdf. But if you want to edit an generated pdf you have to use pdf editing software's to do

Re: PDF

null@example.com (areePOM) — Wed, 25 Nov 2020 04:08:14 +0000

apmuthu - that is not what I am looking for.

joe - Can you explain a little more?

My other question too is - Can I edit the PDF? I would like to delete some items on there.

Re: PDF

null@example.com (joe) — Sun, 22 Nov 2020 08:22:33 +0000

I would rename the Invoice to Contract or Contract/Invoice. And create a service item as a sub contract. Then either use normal payments/prepayments and allocations.
Then you can send the Statements out to your customers.

/Joe

Re: PDF

null@example.com (apmuthu) — Sun, 22 Nov 2020 03:54:38 +0000

Just use the ledger statement for the specific Customer's Account.

Banking & General Ledger => Balance Sheet Drilldown => Current Assets => Accounts Receivable => Choose your customer Account and get your list.

@joe: Which report best provides for Customer Ledger Folio with a means of emailing out selected customers for periodical account confirmation of balances?

Re: PDF

null@example.com (areePOM) — Sun, 22 Nov 2020 00:41:49 +0000

Sorry, I just remember we don't use invoices as much. We sent client's a copy of their balance statement each time they make a payment towards their contract fee. We are wondering how to show their total contract fee on that balance statement? Is there a way?

What is "rep107.php"??? Where do I look for that at the time of the invoice preparation? Also, again, can this be done to the PDF of the customer balance statement?

Re: PDF

null@example.com (apmuthu) — Tue, 17 Nov 2020 02:54:50 +0000

Where would you store the "total agreed contract value" in FA at the time of making the Purchase/Sales Order? Probably as free form text in the Memo field?

At the time of invoice preparation, the reporting/rep107.php (Invoice Script) can be customised to change / eliminate wordings / fields but to get data that was not stored is well nigh impossible!

PDF

null@example.com (areePOM) — Mon, 16 Nov 2020 15:17:53 +0000

On printed pdf invoice, how do you get rid of “item code” section? Can you modify the pdf at all? Some areas words are cut off, also would like to get rid of some wordings on the PDF.

Is there a way to add a field to show a full contract amount? - Not what was paid, but like the total service amount that was agreed amount the client and us on the invoice?