Hi Crbookkeeping,

"I presume you meant
  reports->journal entries -> all"

Yes, you are correct.  "Journal Entries" is accounting term and "Transactions Details" is non-accounting terms.  You can find the setting for terminology under Setup, User Preferences and Options.

If your target is mainly about sales invoice, you can go to Reports,  Journal Entries, Sales.  Then, the report will only shows sales invoice entries.

If you want to further filter the report, you can click the Filter Report option on the left hand side in the Sales Journal - Modify Report window.  Then, put a check mark to Use your filter specification.  I am going to use invoice #27925 as an example.  In the screen shot below, ADJ is the value used for reverse entry.

By using the filter specification above, the following result will show up:

As mentioned from your previous discussion, there can be issues when using Sage 50 as ERP.  Again, we apologize that Sage 50 is not a ERP system, so it may not be able to serve your requirement if you need ERP functionality.

For people who are interested of the original question, you can follow the link below.

http://sagecity.na.sage.com/support_communities/sage_50_accounting_ca/f/151/t/75281.aspx

Hope this helps

Keith

I am aware of the advanced filtering, too bad there isn't a 'contains' and an 'ends with' option

your example is a perfect example of what an audit trail should be

the system knows that J164 became J165 became J166, and it should be able to group them

together as part of the report when I filter for just 'starts with 27925'

without me having to remember/filter for ADJ or any other pre/suffix

I'm just presenting this as an idea to enhance the product

thanks

Actually, the system doesn't 'know' that J164 became J165.  There's nothing different between the final transaction of a series of corrections, and a correct entry that has never been adjusted.

The only connection between the original entry and a reversal, are the 'Source' and the 'Comment' fields.  

Since the text is auto-generated, and is always consistent, it might be possible to track a series of changes by parsing out the text of the source - i.e. if the source for J20304 is 'ADJINV12345, Rev. of J19822, Corr. is J20305 then you could follow it back.  

The problem is that there's nothing stored with J20305 that indicates that the particular transaction came from an adjustment, so there's really no way to work backwards, especially if J20305 was recorded with a different invoice number.  

Even if there was an automatic two-way audit trail showing every adjustment, or a flag on a transaction indicating that it was the result of an adjustment, the trail would go cold if the earlier transaction was reversed, then a new one entered.

I know it can be done... Quickbooks does it ... and it's handy when trying to understand how/when an invoice/payment/etc goes sideways

To clarify, it would be possible to record references on each adjustment transaction, of the back trail of adjustments that created a final invoice.  However, this isn't something that can be changed in a report.

I'll have to take your word on what QuickBooks can do.  I tried to open an eval copy to try a few remodels of an invoice, it showed an error message that it couldn't read the file, said it could repair the file, asked for elevated permissions, then a blank screen called "QuickBooks File Doctor" opened up, then... nothing.

If you have access to QuickBooks, and a test file, please try this:  

- Create an invoice.

- Reverse the invoice.

- Create the same invoice again.

Is there an audit trail back from the last entry, showing all three?

To clarify, it would be possible to record references on each adjustment transaction, of the back trail of adjustments that created a final invoice.  However, this isn't something that can be changed in a report.

I'll have to take your word on what QuickBooks can do.  I tried to open an eval copy to try a few remodels of an invoice, it showed an error message that it couldn't read the file, said it could repair the file, asked for elevated permissions, then a blank screen called "QuickBooks File Doctor" opened up, then... nothing.

If you have access to QuickBooks, and a test file, please try this:  

- Create an invoice.

- Reverse the invoice.

- Create the same invoice again.

Is there an audit trail back from the last entry, showing all three?

This is an audit trail of today's transactions (and there are many filter options) - it warned me about creating the second invoice #2, but I proceeded

in the first case, it shows at what time the void (or deletion if I'd done so) occurred and what the prior transaction was, and if the user had been someone other than 'admin' - who dunnit

and this is handy if you looking for a transaction (ie. per the bank statement deposit) of 7.56, and you can't find the transaction - the audit trail allows you to ask 'who dunnit' and discover that the reversal was incorrect per the situation s/he was trying to solve