Re: Requirements for unique customer invoice numbers

[Victor Sterpu <..hidden..>]

This is what I was saing also. I need a new invoice number.
I proposed a unique index on invnumber. :)

The commentary is also not sufficient.
Because the reverse invoice may contain lines that don't have nothing to do with the revered invoice.

By example:
1) You have a invoice that contains product P with qty 10.
2) You have another invoice that contains product P with qty -5, and another product P1 with qty 5.

This is a valid case. Let's say products P are all defect, so we replace them with P1.
In this case, a invoice number that points back to the initial invoice is not exactly what we need.
Because we do not reverse the invoice, but only a line(partial) from the initial invoice.


david wrote:

On Wed, 2007-07-25 at 09:27 +0300, Victor Sterpu wrote:
  

Just by looking at the price.
So the reverse invoice has the same price, for the same product, but
with the quantity reversed.
This system is not 100% sure, but I don't realy need to know what
reversed the initial invoice. 
It is enough to know that the invoice has a reverse and this I know
for sure - the allocated fields tells me that.

    

IANAA etc.... but it seems to me that you must have a new invoice
number.. it's a new document. 

In my records, I put a commentary with a reference to the original
invoice number. In most cases it's obvious, but not always, so the
commentary is important.




  

Chris Travers wrote: 
    

On 7/24/07, Victor Sterpu <..hidden..> wrote: 
        A reverse invoice is a diffrent document, so I would need a
        diffrent document number.
        This is required in my country.

How do you track the reverse invoice against the original one with
the current system?

Best Wishes,
Chris Travers



____________________________________________________________________

-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >>  http://get.splunk.com/

____________________________________________________________________

_______________________________________________
Ledger-smb-users mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
  
      

-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >>  http://get.splunk.com/
_______________________________________________ Ledger-smb-users mailing list ..hidden.. https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
    

-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >>  http://get.splunk.com/
_______________________________________________
Ledger-smb-users mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users