You’re offline. This is a read only version of the page.
420
Hi Folks,
We have a situation where we would like to map a field from the Journal Transaction entry screen (w/ regular batch module type = GL) so that it updates to PJtran when the transaction is posted. The field in question is gltran.ExtRefNbr (used from the aptran side posting more traditionally).
We have certain transactions entered through GL journal entries that it would be nice to carry forward this field w/ the posting and keep it tagged to the transaction.
Anyone done this before or any thoughts in relation?
Many thanks,
Justin
Alex / Jana - thank you both for the responses!
The trigger seems like an option to explore for sure - have you seen it done in practice for this type of purpose (specifically making the jump from GLtran to PJtran) - if so, did it stick as a usable option for the long-term?
Jana - thanks for those points about the FTT - thats certainly a part of the equation here. For the user fields, we unfortunately have used those already so it would take a bit of effort to re-purpose them (though it is an option).
Many thanks,
Justin
Hello,
I agree a trigger will do it. But its Financial Transaction transfer that brings over the batch to project (pjtran) from GL...So any trigger would have to be attached to the PAGLT00 process executable (crtd_prog)
Anyway, I would just use USER1 in gltran to USER1 in pjtran, relabel it for your use..both the fields (extrefnbr and user1 are hidden, Call user1 extrefnbr in GL and you have your mapping. Thats the easiest way to do it without knowledge of programming.
Thank you
Jana MacDonald
Microsoft Dynamics SL Support
Hi Justin,
I don't think that there is anywhere in the system where you could made this kind of changes. Here what we do in this kind of case, we use triggers on the source table. What is the most important is to have it to be the more efficient possible, you don't want the GL period closing to take more time than is it required to ;)
Hope it will help you, have a nice day,
Alex.
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...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (