When updating the customer ledgers, the Ex Ref field can contain
Invoice Number;
Our Order Number; or
Customer Order number
As it is possible to delete invoices from the Invoices and Credits module after they have been posted, and it can contain invoices and credits not posted, any report run using them can be inaccurate in values of actual Sales, particularly for each customer.
A fix to this problem is to have an option to place the product code in the Ex Ref field so that the posted Invoice/Credit can be tracked back to the product used to invoice it directly. There would then be a direct link from the ledgers back to the product codes if so desired.
At the moment any such reporting exports the transactions to excel where I have to decode the Details back to the product, which causes headaches when the product descriptions change.
Guest
