Purchase Order Delivery Address - Telephone number wont print

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
Ken

Parents
  • 0

    Hi Ken,

    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.

    Regards.

    Michael,

    Sage UKI

Reply
  • 0

    Hi Ken,

    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.

    Regards.

    Michael,

    Sage UKI

Children
  • 0 in reply to Michael Goossens

    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