Need more, need help now? we offer pay-as-you-go support, no contract, tenth of an hour billing, expert help, fast service, no call queue
We can offer lower cost Sage50cloud subscriptions for customer using pay-as-you-go support or who are self-supporting.
Need integration, your shipping system, your website, your invoicing system, your crm.
Need a bespoke solution, Mini Manufacturing, Spreadsheet order import, Back to back orders.
Want web hosting, email, your own domain name, a shop, we do it all!

Goods Despatched Note Audit Trail

Report design issues and solutions.
Post Reply
samuelmaiia
User
User
Posts: 2
Joined: 27 Mar 2019, 11:43
Sage Version: v2018 24 UK/Europe/Africa

Goods Despatched Note Audit Trail

Post by samuelmaiia » 27 Mar 2019, 12:01

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

User avatar
brucedenney
Site Admin
Site Admin
Posts: 4123
Joined: 28 Feb 2006, 09:56
Sage Version: v2017 23 UK/Europe/Africa

Re: Goods Despatched Note Audit Trail

Post by brucedenney » 27 Mar 2019, 12:28

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.
For just about anything Sage :- switch to subscription, pay-as-you-go support, sagecover, upgrades, application integration, reports, layouts, analysis or any other help making life with sage easier/less time consuming Contact me. Image

samuelmaiia
User
User
Posts: 2
Joined: 27 Mar 2019, 11:43
Sage Version: v2018 24 UK/Europe/Africa

Re: Goods Despatched Note Audit Trail

Post by samuelmaiia » 27 Mar 2019, 12:54

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 :)

User avatar
brucedenney
Site Admin
Site Admin
Posts: 4123
Joined: 28 Feb 2006, 09:56
Sage Version: v2017 23 UK/Europe/Africa

Re: Goods Despatched Note Audit Trail

Post by brucedenney » 27 Mar 2019, 13:09

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.
For just about anything Sage :- switch to subscription, pay-as-you-go support, sagecover, upgrades, application integration, reports, layouts, analysis or any other help making life with sage easier/less time consuming Contact me. Image

Post Reply

Who is online

Users browsing this forum: No registered users and 1 guest