FrontAccounting forum — Modifying Sales Invoice

Re: Modifying Sales Invoice

2017-01-10T13:34:42Z

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

2017-01-10T04:55:48Z

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

2017-01-01T18:23:11Z

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

2017-01-01T07:31:28Z

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

2016-12-29T09:38:36Z

Answered in this thread.

Re: Modifying Sales Invoice

2016-12-29T03:05:24Z

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

2016-12-28T16:39:22Z

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

2016-12-27T03:52:20Z

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.