Request to add the 'transaction ref' field to the Invoice Line Items report and the Credit Note Line Items report
Completed
Adding the 'transaction ref' field to the Invoice Line Items report and the Credit Note Line Items report will allow us to accurately compare invoices & credit notes previously exported from aX (and imported into our accounting system) to invoices and credit notes currently in aX.
The 'transaction ref' field is unique to each line item and therefore allows us to compare line by line.
-
Official comment
Hi Katie,
Adding an additional field to a report is usually straightforward and in some cases more difficult.
We will review what is required here and we'll implement this if it does not require much effort.
Just to clarify your comments: Any transaction field will only be unique to an invoice line item if there is one item on the invoice.
More than one item, or, more than one payment against an invoice will result in transaction values appearing several times on some reports.
Comment actions -
Hi Michael,
We were under the impression that the 'Transaction Ref' field was unique to each invoice/credit note line item.
SST exports invoices and credit notes monthly via the MYOB export tool. The export files are opened in excel with each row in the spreadsheet representing a line item of an Invoice/ Credit Note. The Transaction Ref (column BE for invoices, column Z for credit notes) seems to be unique to each row regardless of payments applied.
Please let me know if you require copies of our reports.
kind regards
-
Hi all,
Just a courtesy message to let you know that this is still due to be released next Wednesday 22nd as per Michael's previous messages. You can find the details in our Release Notes: https://axcelerate.zendesk.com/hc/en-gb/articles/360001479216.
Hopefully this helps out with your reporting needs!
Please sign in to leave a comment.
Comments
4 comments