alanmacc
Member
Hi
Not sure if this is the right place to post this question ........
We use the Dispatch Schedule report to allow our dispatch area to pick and load items for customers, however we have an issue with this if going to more than one delivery address, the report currently shows
(CURRENT LAYOUT)
R5500027
Version DC008
Start Date Despatch Schedule
End Date By Cust No,
CUST NUMBER 1234
CUST NAME ASHOP
Part Number Cust part Number Description Order No Type Ship TO Cust Ref Qty Req Date Method
abc123 xxxx112 Widgit 12345 SO 1977 Order 10 20/04/11 Air
NOTE THAT NO ADDRESS IS ACTUALLY PRINTED
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
(WISH LIST)
R5500027
Version DC008
Start Date Despatch Schedule
End Date By Cust No,
CUST NUMBER 1234 123
CUST NAME ASHOP Main Street
A Town
Part Number Cust part Number Description Order No Type Ship TO Cust Ref Qty Req Date Method
abc123 xxxx112 Widgit 12345 SO 1977 Order 10 20/04/11 Air
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
R5500027
Version DC008
Start Date Despatch Schedule
End Date By Cust No,
CUST NUMBER 1234 123
CUST NAME ASHOP Main Street
A Different Town
Part Number Cust part Number Description Order No Type Ship TO Cust Ref Qty Req Date Method
abc123 xxxx112 Widgit 12345 SO 1978 Order 10 20/04/11 Air
As you can see it does not actually show tghe delivery address it only shows the delivery address number, on this example it is fine as it is all being shipped to the one address, but if this was going to more than one it wold merely use a diffrernt delivery address number in the ship to field, my question is ....
Could this be populated to actually print the address then if the customer has a second delivery to a different address it would group and list the address as a header ?
WIndows XP - Oracel Enterprise One - SQL ORAHOME92
Not sure if this is the right place to post this question ........
We use the Dispatch Schedule report to allow our dispatch area to pick and load items for customers, however we have an issue with this if going to more than one delivery address, the report currently shows
(CURRENT LAYOUT)
R5500027
Version DC008
Start Date Despatch Schedule
End Date By Cust No,
CUST NUMBER 1234
CUST NAME ASHOP
Part Number Cust part Number Description Order No Type Ship TO Cust Ref Qty Req Date Method
abc123 xxxx112 Widgit 12345 SO 1977 Order 10 20/04/11 Air
NOTE THAT NO ADDRESS IS ACTUALLY PRINTED
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
(WISH LIST)
R5500027
Version DC008
Start Date Despatch Schedule
End Date By Cust No,
CUST NUMBER 1234 123
CUST NAME ASHOP Main Street
A Town
Part Number Cust part Number Description Order No Type Ship TO Cust Ref Qty Req Date Method
abc123 xxxx112 Widgit 12345 SO 1977 Order 10 20/04/11 Air
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
R5500027
Version DC008
Start Date Despatch Schedule
End Date By Cust No,
CUST NUMBER 1234 123
CUST NAME ASHOP Main Street
A Different Town
Part Number Cust part Number Description Order No Type Ship TO Cust Ref Qty Req Date Method
abc123 xxxx112 Widgit 12345 SO 1978 Order 10 20/04/11 Air
As you can see it does not actually show tghe delivery address it only shows the delivery address number, on this example it is fine as it is all being shipped to the one address, but if this was going to more than one it wold merely use a diffrernt delivery address number in the ship to field, my question is ....
Could this be populated to actually print the address then if the customer has a second delivery to a different address it would group and list the address as a header ?
WIndows XP - Oracel Enterprise One - SQL ORAHOME92