Topic: Invoice Editable

The Invoice in FA as a whole is not editable. Specially in case of sales of components (inventory items) it is not recommended to make invoice editable. But in case of sales of Service Items following option shall be considerable.

When we click the EditInvoice Icon on Customer Transaction Inquiry page it shall open following document with following parameters.

http://localhost/bx242/sales/sales_order_entry.php?NewInvoice=72&InvoiceNo=70

Where NewInvoice refers to the Auto Sales Order of the Invoice No 70.

While processing this document the system shall check the InvoiceNo parameter and execute the Void Routine to void the previous invoice.

This Edit option shall be available to 2 type of companies

1. Total Service Based Company. A check can be added in company setup.
2. A Company selling components but has enabled Negative Inventory in Setup.

I couldn't code it completely so if admin can consider it then it will be a good solution to all FA Users

Regards.

Re: Invoice Editable

I am not really understand with what you mean. If you want to ask detail, please send PM to me.

Re: Invoice Editable

Thanks I have done it. I have made Invoice Editable. When an Invoice is edited and processed the old invoice is automatically voided and new invoice is created with the same Reference Number.

Re: Invoice Editable

@joe: is this desirable in the default FA?

Re: Invoice Editable

No, I don' t think so. In the core we should not allow full editing. It sends a wrong signal. I would leave it as is.

Joe

Re: Invoice Editable

@joe: I agree.
@boxygen: Zip, upload and paste link to changed files for this "feature" so that it can become an extension someday and be available for reference.

Re: Invoice Editable

Sure I will

Re: Invoice Editable

@apmuthu Here is the extension Invoice Editable

Regards.

Post's attachments

FA_Inv_editable_boxygen.zip 18.2 kb, 9 downloads since 2017-10-21 

You don't have the permssions to download the attachments of this post.

Re: Invoice Editable

I have updated so please update the attachment as well

Re: Invoice Editable

Updated.

The diff of your new file added as compared to the stock FA 2.4.2+ master apart from whitespace changes are::

--- sales/includes/ui/sales_order_ui.inc    Sun May 21 21:49:30 2017
+++ sales/includes/ui/sales_order_ui.inc    Sat Oct 21 22:32:51 2017
@@ -236,6 +236,10 @@
         display_note(_("Marked items have insufficient quantities in stock as on day of delivery."), 0, 1, "class='stockmankofg'");
 
     div_end();
+
+        if(list_updated('stock_id')) //added by faisal phuong
+            set_focus('stock_id');
+
 }
 
 // ------------------------------------------------------------------------------
@@ -265,6 +269,9 @@
     else
     {
         customer_list_row(_("Customer:"), 'customer_id', null, false, true, false, true);
+        If (isset($_GET['InvoiceNo']))
+            hidden('InvoiceNo', $_GET['InvoiceNo']); //Added by Faisal for Invoice Edit
+            
 
         if ($order->customer_id != get_post('customer_id', -1))
         {

Re: Invoice Editable

How do you get this difference file?

Re: Invoice Editable

You can use tools like WinMerge.

Re: Invoice Editable

I think this can be useful, I had to edit invoice a few times.
Thank you for sharing!

Re: Invoice Editable

Dear Members,

1. Can the FA generate a Invoice, with all the details of the organisation and address etc.

2. How do I create a Tax Invoice with 18% and 28% Indian GST rates in FA system and also make modification when the rates change? I need to print the same Invoices with all the organisation information for the purpose of Audit. Pls help and advice.

regards,
Sandeep
Sandeepleo1@gmail.com

Re: Invoice Editable

So 2 of our clients use SAP. Ideally according to their process:

1) there should be a proforma invoice from our side (in FA) indicating approximate price
2) We supply a commodity which has variable quantity and variable rates on a daily basis (agri commodities)
3) Based on the delivery, our clients generate a GRN and then a backdated PO in their SAP. The GRN carries the invoice number which ideally should have been shipped along with the material (agri commodity)

Now because of the stupid implementation of the SAP system...
4) Based on proforma invoice, using Proforma Invoice number they generate the GRN
5) Our final invoice should then carry the final amount, final quantity, final rates, the invoice number as depicted in proforma invoice  , etc.

Due to the low margin nature of the business, we can not afford to hire too many people to handle the process heavy nature. And, we supply from many locations.

What we do:
So we end up giving series of invoice numbers to these 2 clients i.e. <ourName>/17-18/Client1/Location1/<Invoice Series> and <ourName>/17-18/Client1/Location2/<Invoice Series>. The client accounts team knows which number is going to come next. So they generate GRNs against invoice numbers (invoices which we make later). All we need to do is make invoices. Process is simple.

We have still not evaluated FA completely yet. However, if we can not define series client wise and location wise in invoice numbers... then "Invoice Editable" sounds like a good idea.

Re: Invoice Editable

FA has just 1 series for each Voucher Type. A default Prefix can be used. The same number of characters must be in the final invoice number and it is editable. It will be preferable to have the same running number but with different prefixes to identify the Client/Location pair. Since both Client and Location are available in the transaction detail, a well crafted sql will be able to report when grouped by accordingly so as to remain within FA's single numbering series for all sales.