Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

A/P cash report for wire transfer payments

Posted on by Microsoft Employee

Hi,

We use wire transfer to pay our A/P vendor once a while. We record the transaction thru payables manual payment entry window and select payment method of "cash".

We are trying to get a report from GP2015 for all these wire transfer payments on a monthly basis. We cannot find any report that will list out all the "cash" payments, nor do we find any under the smartlist. Any idea?

Thank you!

*This post is locked for comments

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: A/P cash report for wire transfer payments

    Smart list can be built.

    Data can be found here.

    select * from pm30200 where doctype = 6 and docnumbr = ''  

    --PM Paid Transaction History File  

    --PM_Paid_Transaction_HIST

    select * from cm20200 where cmtrxnum = ''

    --CM Transaction

    --CM_Transaction

    select * from sy06000 where customervendor_id = ''

    --Address Electronic Funds Transfer Master  

    -- AddressEFT

    Cheers

    Sanjay

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

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans