Goods Delivery Note and despatch date.

Posted by D_Smith PM | on Mon, 09/05/2011 - 15:09 3515 4 comments | report

Hi,

I use Sage 50 Accounts Professional 2010.

When I despatch goods, I use Sage to print and record a despatch note.

I have used Sage Report designer to edit the file GDNPRNT.layout and I am mostly happy with it - apart from one thing - the despatch date.

I record despatch quantities in the Sales order Processing window by selecting the sales order and clicking on the amend icon. I allocate stock, then despatch the stock.

I am prompted for a decision as to whether or not I want a GDN, to which I click yes.

Later, when I want to view the despatches from an order, I click into the order and click on the Despatched tab.

There I am presented with a list of GDN numbers and the date of the despatch - this date reflects the date when I recorded the despatch. This is what I want :-) , but....

when I choose a GDN number and click on print GDN, I have problems with the Despatch date.

In Sage Report Designer, I used the variable: Sales_Order.Despatch_Date

The problem is that when I choose to print the GDN, Sage takes one of 2 dates:

1. The date in the Due Date of the Order Details tab.

2. If the due date is blank, it takes the date I decide to print the GDN - which is not always the date of the despatch. Sometimes I email the GDN to the customer with an invoice a few days later than the actual despatch date.

I would like to find a variable that records the despatch date as the date I recorded the despatch (as above :-) ) and for that date to show whenever I print the GDN.

Hope someone can help.

Comments

Despatch Date

johndon68 | Tue, 10/05/2011 - 20:32 | Permalink

I've not tried it but on the SOP_ITEM table, there is a field DELIVERY_DATE that may give you what you want.

John

It has to be a code bug.......

D_Smith | Thu, 12/05/2011 - 10:15 | Permalink

Further to my post above I have today found another problem when I click on the Print GDN button regarding invoice numbers.

Background:

A customer order so far has had 2 part despatches from me:

1st despatch 06.04.11 - GDN number 11 - Invoice number 169

2nd despatch (TODAY) 12.05.11 - GDN number 15 - Invoice number 200

Yesterday, this Sales order only had one record of a despatch, GDN 11.

If I had clicked on Print GDN, it would have correctly shown the invoice number as invoice 169.

This morning I despatched the second despatch and correctly invoice number 200 shows when I click Print GDN for GDN number 15.

But now, if I click Print GDN for GDN number 11, the related invoice number it reports is invoice number 200 - which is very wrong - invoice number 169 relates to GDN 11, not invoice number 200.

It seems to me that Sage is reporting the last invoice number recorded when I click the Print GDN button - I've only just today, picked this up. Glad I did, it could lead to a lot of confusion when printing/emailing despatch notes.

This, along with the problem I encountered in my first post, would appear to me as a code issue with the software - I can use the Report Designer to some extent - but hard coding is beyond me :-)

Anyone else having the same issues?

ps..Thanks to John for suggestion above - I looked for the variable you mentioned, but couldn't find it in the GDNPRNT.layout file. In the end I removed the date field altogether and have had to resort to printing the despatch note, writing it in by hand, scanning it, saving as pdf, and then emailing it to the customer. Hard work :-)