AP Transactions Field and Table Linking
However, when my transaction is saved, but not posted, I see the values from these additional fields in my smartlist, but once I post it, the values dissapear from my smartlist. Am I missing a table?
There is a place to put the alternative key which is necessary for vouchers.
So just pick another field that is unique? Why is this necessary for vouchers?
I added a second key of doc number, but got the same result. Values in those fields showed until I posted the transaction and then my extender fields were blank in my smartlist.
It wouldn't be document number. It would be Voucher Number. The window would be Payables Transaction Entry Zoom.
I believe the reason an alternate key is needed is because the voucher field is used by Payables Transaction entry and payments.
I added an inquiry with the form and window Payables transaction entry zoom and selected alternate key and chose Voucher Number. I'm still getting the same result. I see it in my smartlist until it's posted and then my extender field column in the smartlist goes blank.
For the SmartList, when you added the SmartList integration, as opposed to the Inquiry, did you add it to the Payables Transactions SmartList? Did you select Voucher Number as the SmartList field?
Is this GP 2013?
Yes. I made Key Field Voucher number-WORK and then linked to the Voucher Number field on the smartlist. It shows on my payables transaction smartlist until it's posted, then the extender field data goes blank after posting.
Does it have to do with GP's Voucher Number Field changing from VoucherNumber-Work to Voucher Number between the Work table and the OPEN table?
Yes it is GP 13
I am having the same issue, were you able to resolve this at all?
When you say you have it linked to the Work Table (PM10000), the Open Table (PM20000) and the Paid History Table (PM30200), are you referring to the linked tables in the options? If so, if you remove those Table Links, does the data display still when you post it? I want to be sure it is just a display issue and not that the data is physically getting removed.
If you would like to submit an answer or comment, please sign in to the eOne portal.