Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / ANYONE KNOW HOW TO GET...
Finance | Project Operations, Human Resources, ...
Answered

ANYONE KNOW HOW TO GET THE ORIGINAL TRANSACTION AMOUNT ON A GP SMARTLIST FOR A PAYABLE IMPORTED FROM A DIFFERENT SYSTEM?

(1) ShareShare
ReportReport
Posted on by GP_TruckMate_anyone... 10

Hi All! Appreciate any help i can get. Currently we are importing our payables transactions from TruckMate (it has it's benefits but definiately NOT an accounting software. write that down). Currently we use a workflow system called Synergize for our AP integration into Truckmate. From there, since we ultimately report our finances out of GP, we then need to export the payables from TruckMate into GP. We currently use Integration Manager (which from what i understand, is pretty outdated -- anyone use this?) 

The why doesnt necessarily matter at this point, but we've processed several duplicate payments to vendors. In Smartlist -- i was hoping to create a unique combination (in excel) to identify vendor & original invoice amount. Unfortunately, invoice # is not a unique identifier since the AP clerk changed the invoice# to force it through when it was identified as a duplicate. (she is no longer with the company). MY ISSUE IS: whenever i run a SmartList based on payables transaction date, the current & ORIGINAL transaction amount show as $0 -- to be clear it's already been paid. DOES ANYONE KNOW HOW TO GET THE ORIGINAL TRANSACTION AMOUNT ON A GP SMARTLIST FOR A PAYABLE IMPORTED FROM A DIFFERENT SYSTEM?

ALSO-- very open to hearing about other instances in which people import from other systems into Great Plains (we're migrating to 365 -- but currently just in Great Palins).

Thanks everyone!!!!

Categories:
Microsoft Dynamics GP
  • Isaac Olson Profile Picture
    Isaac Olson on at
    RE: ANYONE KNOW HOW TO GET THE ORIGINAL TRANSACTION AMOUNT ON A GP SMARTLIST FOR A PAYABLE IMPORTED FROM A DIFFERENT SYSTEM?

    Hello,

    I am glad to hear that this helped you on your original issue.  We like to keep our forums with one question and one resolution so they are easier for others to search and find answers in the future.  If you could ask this additional question in its own forum post that would be greatly appreciated.

    Thanks!

    Isaac Olson

    Microsoft Support

  • GP_TruckMate_anyoneelseoutthere Profile Picture
    GP_TruckMate_anyone... 10 on at
    RE: ANYONE KNOW HOW TO GET THE ORIGINAL TRANSACTION AMOUNT ON A GP SMARTLIST FOR A PAYABLE IMPORTED FROM A DIFFERENT SYSTEM?

    Yes -- docamnt worked perfectly! thank you!!

  • GP_TruckMate_anyoneelseoutthere Profile Picture
    GP_TruckMate_anyone... 10 on at
    RE: ANYONE KNOW HOW TO GET THE ORIGINAL TRANSACTION AMOUNT ON A GP SMARTLIST FOR A PAYABLE IMPORTED FROM A DIFFERENT SYSTEM?

    Looking at Historical documents -- that helps a lot! Thank you!! 

  • Verified answer
    Isaac Olson Profile Picture
    Isaac Olson on at
    RE: ANYONE KNOW HOW TO GET THE ORIGINAL TRANSACTION AMOUNT ON A GP SMARTLIST FOR A PAYABLE IMPORTED FROM A DIFFERENT SYSTEM?

    Richard is right on here.  Since it is with Payments you might actually be looking at the PM10300 table which would be CHEKTOTL instead of DOCAMNT.

    So depending on whether the Payment is in Work (unposted), Open (posted but not fully applied), or History (fully applied) you could check the CHEKTOTL, or DOCAMNT column for the amount that the document was posted for.  I am not sure if you are using Manual Payments or Computer check payments so I included both for WORK for your reference, but the CHEKTOTL amount is most likely the field that you are looking for.

    --WORK

    select CHEKTOTL,* from PM10300 --(PM Payment WORK or PM_Payment_WORK)

    select DOCAMNT,* from PM10400 --(PM Manual Payment WORK File or PM_Manual_Payment_WORK)

    --OPEN

    select DOCAMNT,* from PM20000 --(PM Transaction OPEN File or PM_Transaction_OPEN)

    --HISTORY

    select DOCAMNT,* from PM30200 --(PM Paid Transaction History File or PM_Paid_Transaction_HIST)

    I hope this helps!

    Isaac Olson

    Microsoft Support

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: ANYONE KNOW HOW TO GET THE ORIGINAL TRANSACTION AMOUNT ON A GP SMARTLIST FOR A PAYABLE IMPORTED FROM A DIFFERENT SYSTEM?

    The DOCAMNT is the amount of the invoice. The CURTRXAM is the amount left to be paid so if the invoice has been fully paid this amount will be zero.What field are you displaying as the original amount? I would suggest you look  into SmartConnect from eOne which has versions for both GP and BC. Are you looking at open or historical invoices?

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

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans