web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Adding two Company add...
Microsoft Dynamics GP (Archived)

Adding two Company addresses to an invoice

(0) ShareShare
ReportReport
Posted on by serbach 571

This is not urgent by any means; I'm simply curious...

Our invoices are formatted such that remittance information is included in two ways:

  1. Mailing address (Address code REMIT)
  2. ACH information (Address code ACH)

As this list shows, our ACH information is stored in the Company Location Master table (SY00600). The ABA# is in the Address Contact field (ADRCNTCT) and our Bank Account number is in the Address1 field. The mailing address is formatted conventionally.

The remittance section of our invoice header looks like this:

This is the Report Writer Page Header. You can see that the two "addresses" are text blocks, not fields.

My question is: how might we re-design this report to fetch the two remittance addresses as fields from GP rather than having to type them in as fixed text?

This report has already been modified to pull the Site Location Description and Address from the IV_Location_SETP table... but I'm stumped as to getting two different addresses from the SY00600 table.

Any ideas?

Sincerely,

------------------------------
Steve Erbach - Business Analyst & MS Dynamics Platform Administrator
WOW Logistics - Appleton, WI

*This post is locked for comments

I have the same question (0)
  • Verified answer
    L Vail Profile Picture
    L Vail 65,271 on at
    RE: Adding two Company addresses to an invoice

    Hi Steve,

    Here's one suggestion. Use the RW_RMAddrIDInfo user-defined function to print whatever you need. You pass in the customer ID, Address ID, and then an integer that represents which field you want to print.

    For example, I created an Address ID 'ACH' and created a calculated field to pull the Contact Name on to the SOP Invoice. Here's what the completed RW calculation looks like:

    FUNCTION_SCRIPT( RW_RMAddrIDInfo SOP_Document_HDR_TEMP.Customer Number "ACH" 1 )

    I hard-coded the Address ID 'ACH'. Here's the integer values for the fields:

    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

    Is this what you wanted?

    Kind regards,

    Leslie

  • serbach Profile Picture
    serbach 571 on at
    RE: Adding two Company addresses to an invoice

    Leslie,

    If I understand you correctly, this RW function extracts the address information fields for the Customer, yes? What I'm looking for is the address information for our company contained in the SY00600 table. A function like the one you outline above would be just the ticket; but does such a beast exist to extract from SY00600?

    Sincerely,

    Steve Erbach
    Appleton, WI

  • serbach Profile Picture
    serbach 571 on at
    RE: Adding two Company addresses to an invoice

    Leslie,

    I think I've found what I need, using your reply as a clue: the RW_CoAddrIDInfo function. I've actually used it on our statements... I just did them so long ago that I didn't think to look at its design until just now.

    Thank you very much for stimulating my memory.

    Sincerely,

    Steve Erbach

    Appleton, WI

  • L Vail Profile Picture
    L Vail 65,271 on at
    RE: Adding two Company addresses to an invoice

    Steve,

    You are right! There are so many of these little gems out there.

    Kind regards,

    Leslie

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans