You’re offline. This is a read only version of the page.
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!!!!
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
Yes -- docamnt worked perfectly! thank you!!
Looking at Historical documents -- that helps a lot! Thank you!!
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
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?
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
290,522
Super User 2024 Season 2
#2
Martin Dráb
228,441
Most Valuable Professional
#3
nmaenpaa
101,148
Share
Report
All responses (
Answers (