Boyum Validation Macro Calculate Delivery Date Automatically for Specific Groups

Carla van Zyl

• October 02, 2023 08:44

Good Day, 

We are trying do add a validation where Delivery Dates For Import Suppliers are Automatically calculated by using the docdate on the PO and adding the amount of days as per the expected lead time indicated on the SQL query and add when the Supplier Type Is part of the Import Supplier Group. I have done this so far but its not working. Any advise on how to fix, or what is wrong

 

 

Vote

0

• 

  Geoff Booth

  • October 02, 2023 17:13

  Hi Carla,

  If you query the CRD1.Country field you will see that it stores the 2 digit abbreviation for the country not the full name. i.e. Canada = CA

  Hope this helps

Please sign in to leave a comment.