Try to get Address 1 from PO's to appear on Check Remittance

[clintwolf]

Hello, we process all of our payables as PO's as it allows us to use the "Ship to" address fields to store extra information.

I want to display both the PO number and Address 1 on the check remittance.

I've gotten the PO number to display by linking:

[PM PaymentApply To Work File] -> [PM Transaction OPEN File]

Now i need to get Address 1 from [Purchase Order Line] to link to a table. Ideally [PM Transaction OPEN file] as it has the PO number in there, but it is not in any of the Key's.


Please help.

Thanks

 

[winthropdc]

If you have the Vendor ID and the Address Code you can use the RW_PMAddrIDInfo() Report Writer (RW) function as a user defined function in a calculated field. The parameters are:

in 'Vendor ID' IN_Vendor_ID;
in 'Address Code' IN_Address_Code;
in integer IN_Field;

{
IN_Field should use the following values:-
1 = Contact Name
2 = Address 1
3 = Address 2
4 = Address 3
5 = City
6 = State
7 = Zip
8 = Country
9 = Phone 1
10 = Phone 2
11 = Phone 3
12 = Fax
13 = Country Code
}

For more info on RW functions see

http://blogs.msdn.com/developingfor...ing-the-built-in-report-writer-functions.aspx

David Musgrave [MSFT]
Escalation Engineer - Microsoft Dynamics GP
Microsoft Dynamics Support - Asia Pacific

Microsoft Dynamics (formerly Microsoft Business Solutions)

http://www.microsoft.com/Dynamics

http://blogs.msdn.com/DevelopingForDynamicsGP

Any views contained within are my personal views and not necessarily Microsoft policy.
This posting is provided "AS IS" with no warranties, and confers no rights.