I have various Customer Delivery addresses attached to a Supplier record and the delivery address has a contact name and a telephone number.
But when I add the telephone number to the PO layout it prints as blanks. I am using PURCHASE_DEL_ADDR.TELEPHONE. It would be very useful to have this data printed out on our POs to suppliers.
There is supposedly a report that prints delivery addresses out but when I ran that it only showed two delivery addresses against that supplier when I know it has at least 6 .
And I'm assuming that the SALES_DEL_ADDR.TELEPHONE_2 that seems to be available appears to come from the Customer record rather than a Purchase Supplier which is not what I want.
Am I missing something or is my understanding of Sage 50 files and their field names very limited.
Grateful for any feedback
Thanks for using Sage City.
That 100% is the correct variable to use for delivery addresses in the purchase order. Is this filled in on each of the Suppliers. We have a great guide online here, Which shows all the variables in Sage.
The report to use is under Suppliers > Reports > Supplier Details > Company Delivery Address’s.
If the reports are not running correctly, This could be an indication of an issue in the software, We would advise at this point to run a Re-index of Supplier Delivery Address’s. To then see if this resolves the issue your having.
Thanks Michael - you've certainly pointed me in the right direction however there is a conflict in your answer.
Depending on how one uses Sage a Purchase Order can use either Company delivery addresses or Supplier delivery addresses. The variable I was using doesnt work for me as I was selecting a Company delivery address rather than one from the supplier. I've replaced both the contact and telephone number variables to be COMPANY_DEL_ADDR.CONTACT_NAME and COMPANY_DEL_ADDR.TELEPHONE unless there is a way of dynamically selecting that data.
It's a shame that the selected delivery address contact name and telephone number aren't carried over/included into the Purchase Order file structure - it would make life a lot easier for everyone