Solved

Multiple Vendor Address Locations However Purchase From Address is Corporate Address Not Location

  • 14 May 2021
  • 1 reply
  • 129 views

In our process, we buy product from a vendor. However this vendor is able to offer product produced at various locations. We need to be able to identify the producing location for regulations. Right now we add locations but in order for the purchase order to print correctly as being purchased from the main vendor all addresses have to be the main vendor and not the location. Is there a current way to add a vendor location with it's address but be able to have the purchase order report print the "corporate address"?

icon

Best answer by wfilipiak67 14 May 2021, 21:38

View original

1 reply

Userlevel 4
Badge +3

HI, 
I think there are a few ways to approach this. 
In the Report Designer, Create a Join from the Vendor table to the Address table file using the DefAddressID to AddressID (MainVendorAddr) & a join from the Vendor table to the Contact table (MainVendorContact)  using the DefContactID & ContactID (this will get you the Default Address & Contact for the vendor) 

Then change or duplicate the TO address textbox value to use the MainVendorAddr instead of the current VendorAddress

If you need this for just a single vendor, you can set a Visible Condition on the textbox (if copied)  or use the iif statement if changing the existing textbox

You could also create a new section for that vendor & make the changes there. There are two sections currently based on the PayToVendor 

I hope this helps!
 

Reply


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2022  Acumatica, Inc. All rights reserved