Just figured it out ...

    echo "<table class='returnto'>\n";
    echo "<tr>\n";
    echo "<td><a target='_blank' href='http://sgs4.com'>Return to sgs4.com</a></td>";
    echo "</tr>\n";
    echo "</tr></table>\n";

/themes/default/default.css

.returnto {
        font-family: Verdana, Arial, Helvetica;
    color: #cccccc;
    font-weight: bold;
    font-size: 12px;
    text-align: center;
    width: 100%;
        }


This adds a new class 'returnto'

Thanks apmuthu, that worked fine, here is the code I added to the two php files.

Line 139 login.php and Line 33 logout.php

    echo "<table class='footer'>\n";
    echo "<tr>\n";
    echo "<td><a target='_blank' href='http://sgs4.com'>Return to sgs4.com</a></td>";
    echo "</tr>\n";
    echo "</tr></table>\n";

Now, how do I edit the class 'footer' as I want to increase the font size ? Or better still create a new class.

My FA is accessed via a link on my web site, I would like to offer my users the option to return to my web site before logging in and after logging out. Which php files shoud I edit to add a "Return To" link ?

Yes that would be acceptable.

Thanks Janusz, that works perfectly.

Date              31.08.2013
Invoice No.    37754         Page 6


Hi to Elax, the TextCart extension is working perfectly also.

Cheers
Andrew

Is it possible to add page numbering to sales invoices PDF's ? Many of my invoices exptend to 6 pages and I then need to process them using Adobe Acrobat to add page numbers "1 of n" (Bates numbering), if the FA PDF generator could add page numbers automatically it would simplify this process for me.

Thanks Elax, it's working fine now and the format was easy to understand. I am using the OpenOffice spreadsheet in Mountain Lion. I can see that it will save me time as the spreadsheet allows a lot of flexibility, especially if I use the TextCart templating system.

Being able to construct a large invoice over a period of time and to save it to disk in stages is a great help to me, whereas before with the FA Direct Invoice I had to enter the complete invoice in one session, as it could only be saved at the very end of the process.

Cheers,

Andrew

Hi Elax,

I have now installed and activated TextCart 2.3.9-3 but now need your guidance again, as I cant seem to find a reference to it in any of the menu's ? In System Diagnostics the Extensions System is "OK" in green.

I hope to use it by first entering all the Sales Invoice details into Excel then, after carefully checking everything for typos, to upload the excel file into the Direct Invoice area. The details I need to enter are:

Customer
Branch
Item Code
Item Description
Quantity
Price
Customer Reference

I do not use Sales Quotations or Sales Orders, it's a very simple setup, just Direct Invoices.

Thanks
Andrew

Hi Elax,

Thanks for the prompt reply. I will try the TextCart Module, I understand it is in the FrontAccounting Package Repository but how do I access the Repository? I looked in SourceForge but could not see it there.

Regarding the page numbering of sales invoices my workaround is to edit the sales invoice PDF's using Adobe Acrobat CS6 , it allows me to add page numbering in the format "Page 1 of n" however it is a time consuming process so I hope someone can come up with a patch to the PDF creation files in FA.

regards,

Andrew

FrontAccounting 2.3.16 Build 08.05.2013
Theme: default
Mac OS 10.8.4 with Server.app
PHP  5.4.15
MySQL 5.6.10
Hackintosh

Direct Invoice: Page Numbering and Editing

Q1: Many of my Direct Invoices extend over multiple pages, sometimes up to four pages. I need to number the pages as "Page 1 of n" or similar.

Q2: Would it be possible to allow the System Administrator to edit all data in a recently entered Direct Invoice ? I know that some data can be edited - Date, Description, Quantity, Shipping Cost and Memo but I really need to be able to edit all parameters including Item Code, Price, Branch etc. It's just that some of my invoices take a long time to enter as they contain many line items and many pages, If I make one single typo error on  price that is detected only after the invoice has been entered then I have to re-enter the whole invoice again from the beginning. I am the only person that uses the system so there is no security risk.

Thanks,

Andrew

11

(3 replies, posted in Installation)

Version 2.3.9 Build 24.11.2011 Theme: Default

Thanks for the suggestions. This works fine for me, but will not survive an upgrade of course.

/access/login.php

Line 99 or thereabouts
Backspace out "name" , leaving only ""
echo "<option value=$i ".($i==$coy ? 'selected':'') .">" . $db_connections[$i][""] . "</option>";

I have also added an .htaccess file to  the main folder that whitelists only authorised users IP's

Hopefully this will block all unwanted access to the accounting system.

Cheers,

Andrew

12

(3 replies, posted in Installation)

Hi,

I need to edit the login window so as it does not display the Company Name/s . I want to hide this informatiom from Hackers. Which file should I edit ?

Thanks

Andrew

Figured it out ...

Place two alternate logo images in /company/0/images

Switch between them:  Setup/Company Setup/New Company Logo - Browse

Now I can select which logo appears when printing a specific invoice .. easy !

When entering a Direct Invoice I need to be able to select one of two Sales Invoice print formats depending on which customer I am invoicing. The difference between the two formats is slight, just a different header logo, for a division of my main company. I imagine this could be done with two versions of rep107.php but how do I integrate it with the Direct Invoice entry screen. Maybe this can be done with Dimensions? If you could just point me  in the right direction I might be able to figure it out myself.

Thanks
Andrew

Joe,

That worked perfectly. Thanks.

regards

Andrew

When entering a Sales Invoice I need to occasionally add to the body of the invoice a unique sub-heading as a text only single line.  I could do this easily with MYOB but just cannot figure out how to do it with FrontAccounting.

I have tried creating a special inventory item for text entry using - as the code and this works fine, except that it insists on a quantity of at least 1 and prints out 1 ea and a price of zero dollars. If I make the quantity zero it does not print out.

Here is an example:

-         4428197 WEIR GILLIAN - COUPERIN: ORGAN MASSES 1 ea. 0.00 0.00
CDB CD Burn Archive retrieval    1 ea. 45.00 45.00
CDL Standard CD Label charge  2 ea. 45.00 90.00
-         4767960 DAVIS/MARRINER - TIPPETT: FANFARE/SUITES 1 ea. 0.00 0.00
CDB CD Burn Archive retrieval    1 ea. 45.00 45.00
CDL Standard CD Label charge  1 ea. 45.00 45.00

This is what I really require:

-         4428197 WEIR GILLIAN - COUPERIN: ORGAN MASSES
CDB CD Burn Archive retrieval    1 ea. 45.00 45.00
CDL Standard CD Label charge  2 ea. 45.00 90.00
-         4767960 DAVIS/MARRINER - TIPPETT: FANFARE/SUITES
CDB CD Burn Archive retrieval    1 ea. 45.00 45.00
CDL Standard CD Label charge  1 ea. 45.00 45.00

Thanks

Andrew

17

(3 replies, posted in Reporting)

Answering my own question:

/reporting/includes/header2.inc

Remove color from horizontal line and set line height to minimum, also prints borders as solid black.

Line 44    $this->SetDrawColor(0, 0, 0);
Line 45    $this->Line($iline1, 1);
Line 46    $this->SetDrawColor(0, 0, 0);

Remove background fill color in headers.

Line 48 and line 52
Change F to 0


Now my Sales Invoice PDF's print perfectly in grayscale on my Brother Monochrome Laser Printer.

18

(3 replies, posted in Reporting)

I use a monochrome laser printer for printing invoices and statements. The background color (a pale blue?) in the headings does not print cleanly. I would like to remove all colors and have greyscale only PDF's. is this possible ?

Or alternatively remove all fill from the headings and just have plain white as the background.

Hi Janusz,

That worked fine, thank you. I had to comment out lines 60 and 61

Cheers

Andrew

Hi Joe,

When entering duplicate items into a Direct Sales Invoice an error message pops up "This item is already on this document. You have been warned."  Is it possible to prevent this error message from appearing ?

I need to enter a mixture of Inventory items and Text items. Most of my invoices have more than one Text item and some invoices have duplicate Inventory Items. I would prefer if the error message could be turned off.

I have assigned a hyphen "-" as the Item Code for Text items as a hyphen is quick to enter and the least visible character on the final printed invoice, as there does not seem to be a non-printing Item code for entering text .

Thanks

Andrew

21

(2 replies, posted in Accounts Payable)

Thanks Joe,

That worked fine, I edited reporting/rep108.php
Line 49      $sql = " ORDER BY "TB_PREF  "debtor_trans.reference";
and now my statements are sorted by invoice number.

For the past 10 years I have used MYOB and my customers are used to receiving statements sorted by invoice number, although I do agree that the historical balance method is the correct accounting procedure.

Cheers

Andrew

22

(2 replies, posted in Accounts Payable)

Ubuntu 11.10
frontaccounting_2.3.8

Statement printout sort order.

Hi Joe,

When printing statements I need the list of outstanding invoices to be sorted by Invoice Number as the primary key. It seems to to sort by time entered + date entered + invoice number. Can I change the sort order key by editing the php ?

Here is a link to a screenshot of a statement printout.

http://www.gtv9.com.au/statement.jpg

Thanks

Andrew

Hi Joe,

Found what was causing the problem. I had customized the invoice format by tinkering with header2.inc and the css files.

Specifically it turned out to be at line 76 in header2.inc I had increased the font size of the Company Logo from 4 to 6 but had neglected to do the same at line 80. Changing line 80 from 4 to 6 fixed the problem.

Now I have my customized invoices and can batch print them perfectly.

Thanks for your patience, I will be a bit more careful next time I mess with the code.

Cheers,

Andrew

Version 2.3.7 Build 01.09.2011
Ubuntu 11.04 Linux 2.6.38-11-server on x86_64
Intel(R) Core(TM) i3-2100 CPU @ 3.10GHz, 4

Hi Joe,

Hope you can help with this really strange issue ...

Font size progressively increases as invoices are batch printed.

Sales/Customer and Sales Reports/Customer/Print Invoices

From: SI 34678  To : SI 34686

email: no   Payment: no

Display: Print Invoices .. The first invoice 34678 appears correctly

File/Print/Print to File   output.pdf Format: PDF  Saved: Desktop

Print Preview

When stepping through the invoices the font size progressively increases.

The first invoice is correct at the default font size (which I think is 9pt) each subsequent invoice appears to be 1pt larger than the previous invoice. The final invoice is about 20 pt.

I viewed ouput.pdf on a Mac using Preview and it showed the same progressive font size increase..

Thanks

Andrew

Version 2.3.7 Build 01

Hi Joe,

When an invoice is generated, a single PDF file is stored in the folder company/O/pdf_files with a 12 digit code for the file name i.e. 4e82a84fc2986.pdf

Would it be possible to..

1. Show the actual invoice number instead of this code ?

2. For the existing file not to be overwritten ?

So that after a session of entering say 20 invoices there would be 20 PDF files in the folder.

i.e 

3011.pdf
3012.pdf
3013.pdf
etc

Thanks

Andrew