Community Add-Ons

The original invoice.php din't show the correct incl. Excl VAT.

Problem fixed.

Easy install:

1. Backup your orginal invoice.php in catalog/admin
2. Upload new invoice.php to catalog/admin

Done..

Hope this helps, your requirements

This is an update in GERMAN to a serious business look for the orders form with:
- colored frames
- colored text
- your logo
- customer Nr. (important for i.e german shops)
- order Nr.
- order date
- billing date (important for i.e german shops)
- billing Nr. (important for i.e german shops)
- a greeting text
- the international bank informations at the bottom (hard coded)

ONLY the updated invoice.php for the admin - NO complete package

pls install

" catalog/admin/includes/languages/turkish "

French version + stylesheet

there is a smaill bug, use this code to add in stylesheet.css (or use the file attached here):

2]- Add this row at the end in catalogadminincludesstylesheet.css
/* Contribution Prof_Invoice&PackingSlip */
.pageHeading-invoice { font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 10px; color: #000000; font-weight: normal; padding: 3px; }
.pageHeading-invoice2 { font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 10px; color: #666666; font-weight: normal; border: 1px ridge #CCCCCC; padding: 3px; }
.dataTableHeadingContent-invoice { font-family: Verdana, Arial, sans-serif; font-size: 10px; color: #ffffff; font-weight: bold; border: 1px ridge #000000;}
.main-payment { font-family: Verdana, Arial, sans-serif; font-size: 12px; background-color: #FFFF99; border: 1px ridge #000000; }

=============================================
Professional Invoice and Packing Slip
=============================================

This contribution adds an Invoice number (linked to Order Number), Invoice Date (linked to Order Date) and a
more professional layout for Invoice and Packing Slip.


-Features-------------------------------------
. Invoice Number (linked to Order Number)
. Invoice Date (linked to Order Date)
. Invoice number restart to zero every new year
. Invoice start to your old number Invoice (if you have)
. Order Number (printed in Invoice)
. Order Number (printed in Packing Slip)
. Order Date (printed in Invoice)
. Order Date (printed in Packing Slip)
----------------------------------------------
-To Do-------------------------------------
. When you want to modify an Invoice Number you can edit "TABLE_INVOICE" in DB.
I'm sorry but I can't simplify it, because I'm not a programmer! :-)
Giorgio Abbate
----------------------------------------------

-Authors--------------------------------------

Updated version 0.2 (29/10/2004) by Chiocciola www.oscommerceitalia.com

Updated version 0.1 (23/10/2004) by Giorgio ABBATE abbate_giorgio@libero.it
www.proseccoroad.com - www.newroad.com

Original version by Chiocciola www.oscommerceitalia.com
----------------------------------------------

-ChangeLog------------------------------------

Version 0.2 Now the invoice number restart to zero every new year. A little bug fixed.

Version 0.1 Modify the layout for Professional use.
Write this redame file (very clean and pretty) and include modified file for easy installation in
osCommerce 2.2 clean installation. Test on my pc and on-line.
+ Italian translation addon.

----------------------------------------------

!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
! !
! Install Partita IVA & Codice Fiscale contribution first! !
! Download here: http://www.oscommerce.com/community/contributions,1180 !
! This contributions adds 2 fields to Customers page: !
! - VAT Number !
! - Tax Identification Number !
! !
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!


-Easy Installation---------------------------------

1]- Backup,backup, backup, backup, backup, backup, backup!! ;-)

2]- If you have a fresh and clean installation of oscommerce-2.2ms2, please copy and paste the file
downloaded, in your catalog directory.

3]- Execute SQL script "table_invoice.sql"

4]- That's it!

========
= Note =
===========================================================================================================================
= If you aren't sure of your OSC version use Compare and Merge software (http://www.compareandmerge.com) and compare it!! =
===========================================================================================================================


-Manual Installation---------------------------------

1]- Substitute file "invoice.php" and "packingslip.php" in catalogadmin


2]- Add this row at the end in catalogadminincludesstylesheet.css
/* Contribution Prof_Invoice&PackingSlip */
.pageHeading-invoice { font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 10px; color: #000000; font-weight: normal; padding: 3px; }
.pageHeading-invoice2 { font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 10px; color: #666666; font-weight: normal; border: 1px ridge #CCCCCC; padding: 3px; }
.dataTableHeadingContent { font-family: Verdana, Arial, sans-serif; font-size: 10px; color: #ffffff; font-weight: bold; border: 1px ridge #000000;}
.main-payment { font-family: Verdana, Arial, sans-serif; font-size: 12px; background-color: #FFFF99; border: 1px ridge #000000; }

3]- Add this row at the end in catalogadminincludesdatabase_tables.php
//Contribution Prof_Invoice&PackingSlip START
define('TABLE_INVOICE', 'table_invoice');
//Contribution Prof_Invoice&PackingSlip END

4]- In file catalog/includes/languages/english/invoice.php add this rows
(you make this modification for every language you use!)

/* Invoice mod START */
define('ENTRY_HEADLINE', 'Invoice');
define('ENTRY_INVOICE_NUMBER', 'Invoice n°:');
define('ENTRY_INVOICE_NUMBER_PREFIX', 'PR04-');
define('ENTRY_INVOICE_NUMBER_CENTER', '00');
define('ENTRY_INVOICE_NUMBER_SUFFIX', '-N1');
define('ENTRY_INVOICE_DATE', 'Date:');
define('ENTRY_ORDER_NUMBER', 'Order N°:');
define('ENTRY_ORDER_DATE', 'Order Date:');
define('ENTRY_FOOTER', 'Invoice footer<br><br><br><br>Invoice footer<br>Invoice footer: 12345/67890');
/* Invoice mod END */


5]- In file catalog/includes/languages/english/packingslip.php add this rows
(you make this modification for every language you use!)

/* Packingclip mod START */
define('ENTRY_HEADLINE', '***');
define('ENTRY_INVOICE_NUMBER_PREFIX', 'PR04-');
define('ENTRY_INVOICE_NUMBER_CENTER', '00');
define('ENTRY_INVOICE_NUMBER_SUFFIX', '-N1');
define('ENTRY_ORDER_NUMBER', 'Order N°:');
define('ENTRY_ORDER_DATE', 'Order Date:');
define('ENTRY_FOOTER', 'Invoice footer<br><br><br><br>Invoice footer<br>Invoice footer: 12345/67890');
/* Packingclip mod END */


6]- Copy logo-invoice.gif in catalogadminimages (create your Logo)

7]- Copy the folder "borders" in catalogimages (create your borders if you want)

8]- Execute SQL script "table_invoice.sql"

*]- That's it!

If you have problem for a correct print.
You simply modify your browser settings.

Please see the screenshot attached.

Best Regards

P.S. Instructions for MS Explorer and Netscape.

=============================================
Professional Invoice and Packing Slip
=============================================

This contribution adds an Invoice number (linked to Order Number), Invoice Date (linked to Order Date) and a
more professional layout for Invoice and Packing Slip.

---!! Screenshot Included !!---


-Features-------------------------------------
. Invoice Number (linked to Order Number)
. Invoice Date (linked to Order Date)
. Invoice number restart to zero every new year
. Invoice start to your old number Invoice (if you have)
. Order Number (printed in Invoice)
. Order Number (printed in Packing Slip)
. Order Date (printed in Invoice)
. Order Date (printed in Packing Slip)
----------------------------------------------

****************************
ITALIAN

Contribution per la numerazione delle fature in modo indipendente dall'ordine ID.
La numerazione della fattura riparte da zero a ogni inizio anno.
Se si cancella un ordine, non ci sono "buci" nella numerzione delle fatture.