FrontAccounting forum — Modifying Sales Invoice

Re: Modifying Sales Invoice

null@example.com (apmuthu) — Tue, 10 Jan 2017 13:34:42 +0000

The discount % is stored as an integer in the database table. Attempting to put in a string with % in it will break FA. Make a module for it.

Re: Modifying Sales Invoice

null@example.com (ssa) — Tue, 10 Jan 2017 04:55:48 +0000

Thank you. It's been fixed. Can you guide me how can I show the discount in cash not in percentage(%) in sales module? only If I give input with % Like: 5% then it will be calculated in percentage. Another problem the field only take numbers. How can I achieve all these?

Re: Modifying Sales Invoice

null@example.com (apmuthu) — Sun, 01 Jan 2017 18:23:11 +0000

What is the input you are providing to extract the related "loc_code"?

The "loc_code" is looked up in the "locations" table to get the "location_name".
The "stock_moves" table records the "loc_code" for the transaction.
The "loc_stock" table records the "loc_code" where an item is stocked.

Re: Modifying Sales Invoice

null@example.com (ssa) — Sun, 01 Jan 2017 07:31:28 +0000

How to fetch location code (loc_code) in sales invoice. It can't be fetched in the same way the location name (location_name) is fetched. Please give me some guideline.

Re: Modifying Sales Invoice

null@example.com (apmuthu) — Thu, 29 Dec 2016 09:38:36 +0000

Answered in this thread.

Re: Modifying Sales Invoice

null@example.com (ssa) — Thu, 29 Dec 2016 03:05:24 +0000

Thank you so much. It's been sorted out.
Can you please guide me the steps to develop a module? I'm stuck.

Re: Modifying Sales Invoice

null@example.com (apmuthu) — Wed, 28 Dec 2016 16:39:22 +0000

The reporting/rep107.php report file outputs the Invoice with the column formatting in $cols and $aligns arrays. The reporting/includes/doctext.inc file (included in the report file indirectly) populates the variable $aux_info with the necessary elements at line 104 - case ST_SALESINVOICE:.

Modifying Sales Invoice

null@example.com (ssa) — Tue, 27 Dec 2016 03:52:20 +0000

Hi. I'm new to frontaccounting. I need to modify the sales invoice report. I want to remove the entire last column named "due date " of the 1st Table. Then I want to create borders for each column in the 2nd table. Please suggest me how can I make this work. Thanks in advance.