Page 1 of 1

Goods Despatched Note Audit Trail

Posted: 27 Mar 2019, 12:01
by samuelmaiia
Hello,

I am having issues to amend the "Goods Despatched Note Audit Trail".
I want to add a field that would show the unit price of each item.


If not possible, how would you answer to the following question:

"I want to know how many products and the respective unit sales price we sent last week / last month ( GDN date) .

Thank you

Re: Goods Despatched Note Audit Trail

Posted: 27 Mar 2019, 12:28
by brucedenney
I am not sure why you are doing this from GDN's why not use the Stock Transaction History?

"I want to know how many products and the respective unit sales price we sent last week / last month ( GDN date)"

The Product Module report>Product Profit>Product Profit would be a good starting point, you can remove the profitability stuff, add in the GDN Number, alter the periods to be dates rather than accounting periods if needed.

Have a look at it and let me know.

Re: Goods Despatched Note Audit Trail

Posted: 27 Mar 2019, 12:54
by samuelmaiia
Hi Bruce,
First of all, thanks very much for your reply :)

I want to do it through the Sales Orders Module, because we have two sites.
To know which site sent what we add on Sales Order Analyse 3 the name of the site "ev" or "f1".

So I was asked the question "how many products and respective unit prices we sent last week/ month from the two different sites.
The Goods Despatched Note Audit Trial has everything I want except the unit price.

Thank you :)

Re: Goods Despatched Note Audit Trail

Posted: 27 Mar 2019, 13:09
by brucedenney
I think you can link the Sales Order into the Profitability report, using a join on the Reference Field and the Order Number and so get the value from Analysis 3 available to add to the report if that is the issue.