Multiple Vendor Addresses

  • Multiple Vendor Addresses

    Posted by Elizabeth McQuiston on February 23, 2020 at 1:49 pm
    • Liz McQuiston

      Member

      February 23, 2020 at 1:49 PM

      We are having more and more Vendors using a different pay to address than the company physical address (usually a Bank dropbox).Ā  We like our vendor card to have the address provided on the W-9 (which matches the company’s “official address”), but in order for checks to be mailed to the payment address we have to enter it instead.

      How are other companies handling this?Ā  We know how to have multiple ship to addresses for product delivery, but there doesn’t seem to be a similar feature for payments.

      We are running BC, Webclient, on prem, hosted in Azure.

      ——————————
      Liz McQuiston
      Corporate Controller
      Superior Walls of America
      New Holland PA
      Running BC on Prem
      ******************************
      BCUG/NAVUG Board of Advisors
      Delaware Valley Chapter Leader
      ——————————

    • Robert Buccigrossi

      Member

      February 24, 2020 at 5:49 AM

      We setup our vendor card to reflect the address for payment mailings. Then we created a vendor order address card for the physical location, where we were sending the PO.Ā  Some of our vendors have multiple order addresses. So we had our partnerĀ program a simple modification to always select the order address ending in “B” to be used on the PO. Maybe not the best option, but it has worked well.

      ——————————
      Robert Buccigrossi
      PT Tech, LLC
      Wadsworth OH
      ——————————
      ——————————————-

    • Joseph Flynn

      Member

      February 24, 2020 at 10:02 AM

      We create an Order Address record called “REMIT” for each vendor. We then have a small modification to the check print report to source the address from the Order Address record.

      ——————————
      Joseph Flynn
      Sr. Dynamics NAV Developer
      Gold Star Foods INC
      Ontario CA
      ——————————
      ——————————————-

    • Gregory Alford

      Member

      February 24, 2020 at 10:07 AM

      We took the route of having two vendor cards. V002479 would be the normal vendor card. ZREMIT2479 is where we send the payment. In the invoicing fast tab for the vendor we enter ZREMIT2479. This seems to be working well for us.

      ——————————
      Gregory Alford
      Director of Technical Resources
      Tri Star Metals LLC
      Carol Stream IL
      ——————————
      ——————————————-

    • Cynthia Priebe

      Member

      February 24, 2020 at 7:53 PM

      I lean toward creating an Order Address that you would use for payments. This would require modifying the check report. You could add a check box for “Remit-to” on the Order Address card and only allow one per vendor to be checked. Use this address for checks.Ā Ā 

      Or you could just add a fasttab to the vendor card for Remit-to Address. Again, modify the check report.

      My concern over the Buy-from/Pay-to multiple vendor approach is that the Pay-to Vendor is used to write the vendor ledger entries, not the Buy-from. The Pay-to Vendor will be used for 1099 reporting, not the Buy-from. The Pay-to Vendor is on the Value Ledger Entries. All of this may be undesirable side effects of using a Pay-to Vendor to resolve a remit-to vs. physical address issue. However, none of this may matter in your situation.

      It looks like you have a few ideas to consider! Let us know what you decide to do. I think there may be many others trying to address the same issue watching this forum.

      ??

      ——————————
      Cynthia Priebe
      New View Strategies
      “The NAV & BC training and process experts”
      ——————————
      ——————————————-

    • Cynthia Priebe

      Member

      February 24, 2020 at 7:56 PM

      Or you can just add a fasttab for Remit-to address to the Vendor card and modify the check report to use it.

      ——————————
      Cynthia Priebe
      New View Strategies
      “The NAV & BC training and process experts”
      ——————————
      ——————————————-

    • Michael Heatherly

      Member

      February 26, 2020 at 11:52 AM

      We have several suppliers that we represent multiple product lines for.Ā 

      They require different order addresses, but use the same remittance address.Ā 

      We set up supplier codes to be Base Code -P for purchase and -R FOR Remit.

      The -P purchase vendor card point to the Remit Vendor.

      Sometimes new supplier codes need to be created and the Purchasing Department does not clarify the remittance when setting up the Purchase Vendor Card.Ā 

      This needs to be set up at the very beginning since a Remittance link only works for Purchase Receipts occurring after that setup is initiated.Ā 

      You can have some initial receipts that are forced to be paid to the Purchase vendor card.Ā 

      The Purchasing Manager gets excel based price updates which he loads by Vendor so the -P helps with the segregation for the Rapid Start

      ——————————
      Michael Heatherly
      controller
      Lesman Instrument Company
      BENSENVILLE IL
      ——————————
      ——————————————-

    Elizabeth McQuiston replied 6 years, 1 month ago 1 Member · 0 Replies
  • 0 Replies

Sorry, there were no replies found.

The discussion ‘Multiple Vendor Addresses’ is closed to new replies.

Start of Discussion
0 of 0 replies June 2018
Now

Welcome to our new site!

Here you will find a wealth of information created for peopleĀ  that are on a mission to redefine business models with cloud techinologies, AI, automation, low code / no code applications, data, security & more to compete in the Acceleration Economy!