Page 1 of 1
Make Back Orders Show on GDN
Posted: 11 Oct 2018, 15:15
by BeckeyB
Hi,
I hope this hasn't been asked before, I did a search but didn't find anything. This is my first post, so I hope I'm doing this right...!
I need to make the GDN in our Sage 50 v24 software show the items that are still to be despatched, as we have been having customers phone thinking we have missed the items off their delivery.
I can't find any help on this on the Sage help website, although I find that a nightmare to find anything relevant TBH.
Any help would be gratefully received
Many thanks,
Beckey.
Re: Make Back Orders Show on GDN
Posted: 16 Oct 2018, 13:41
by brucedenney
The GDN is a separate table to the main table, typically you would not use a GDN but a delivery note, the delivery note is based on the SOP tables so can read how many were ordered shipped etc.
A GDN is a historical snapshot it knows noting of the order and what has happened to it, it is just about goods moving.
It may be possible to link the GDN to the Order Item table using something like the StockCode, however this is problematic if you get the same products twice on an order. You can't use the item number because item numbers can change.
My suggestion would be to use a Delivery Note
Re: Make Back Orders Show on GDN
Posted: 19 Oct 2018, 15:08
by BeckeyB
Hi Bruce,
Thanks for your reply. That's the best solution, and I now show the quantity remaining at the end of each line on our Delivery notes but can you please advise how I can get it to show lines for items that are not having any quantity despatched at time of printing but will be sent at a later date?
Thanks,
Beckey.
brucedenney wrote: ↑16 Oct 2018, 13:41
The GDN is a separate table to the main table, typically you would not use a GDN but a delivery note, the delivery note is based on the SOP tables so can read how many were ordered shipped etc.
A GDN is a historical snapshot it knows noting of the order and what has happened to it, it is just about goods moving.
It may be possible to link the GDN to the Order Item table using something like the StockCode, however this is problematic if you get the same products twice on an order. You can't use the item number because item numbers can change.
My suggestion would be to use a Delivery Note
Re: Make Back Orders Show on GDN
Posted: 24 Oct 2018, 10:09
by brucedenney
On the standard layout you need to change the filter
Code: Select all
SOP_ITEM.QTY_DESPATCH > 0.0 AND LETTER_TYPE.LETTER_TYPE = 7
to