Hello everybody! Do you know if the GL impact page...
# generalw
William Lim
03/02/2020, 1:20 PMHello everybody! Do you know if the GL impact page (from ‘actions’ drop down list of a transaction’) is customizable? I would like to add another column 🙂
m
Matt
03/02/2020, 1:31 PMNope it isn't sorry.
w
William Lim
03/02/2020, 1:31 PMOh… well ok, from what I read, it is only possible to add a line?
k
KevinJ of Kansas
03/02/2020, 3:11 PMYou can create a custom sublist to get the same effect
KevinJ of Kansas
03/02/2020, 3:11 PMthere's a suite answers article on it
KevinJ of Kansas
03/02/2020, 3:11 PMyou can do custom GL plugins (suite script) to change the GL impact if it is not correct - note that I generally recommend against this unless absolutely necessary
w
William Lim
03/02/2020, 3:13 PMOkay thanks for the advice, can I embed a report to a sublist? I know that it is possible for saved search. Yeah I saw something about GL plugins but it aims at adding new lines if I am not wrong.
j
Jirae
03/02/2020, 9:08 PMIf it's any other field (custom field), unfortunately no you cannot add them. But if this is a custom segment, it can be configured to appear on GL Impact page as a column. https://www.keystonebusinessservices.net/blog/applying-custom-segments-to-transactions/.
w
William Lim
03/03/2020, 12:29 PMThanks a lot for your help ! Unfortunately I need to add a column from the financial report (e.g. Amount in foreign currency)
j
Jirae
03/03/2020, 5:07 PMaww 😞 unfortunately it's not possible currently within GL Impact page, how about just creating a separate saved search to display the GL information of transaction with the needed field
w
William Lim
03/03/2020, 5:16 PMIt could be a solution but I didn’t find how to retrieve data displayed in GL impact page …
William Lim
03/03/2020, 5:16 PMinto a saved search
j
Jirae
03/03/2020, 5:18 PMyou just need to replicate the columns from GL Impact page using saved search, you need the columns Account, Amount, Amount(Foreign Currency), Location/Class/Subsidiary
k
KevinJ of Kansas
03/03/2020, 5:27 PM Copy code
Add Item Name and other fields on a GL Impact
Published 02/27/2018 02:19 PM | Updated 08/30/2019 08:10 PM | Answer Id: 69284
Applies To
Product: NetSuite 2019.1
Scenario
Enhancement 170723 (Transactions > GL Impact page > Customer would like the item ID or name to be displayed beside each line for audit purposes) is logged to track the customization for the GL Impact.
As an alternate solution, saved search can be created to show item name or other necessary fields in the GL Impact once viewed from a transaction.
Solution
1. Use the below URL portion:
app/common/search/search.nl?id=-36&e=T&cu=T&whence=
2. Rename the Search Title. Then click on Save and Run
3. Click on the Edit this Search.
4. Under the Results tab > Columns subtab, add the Item field.
5. Click Save.
* Take note of the Internal ID of the new Saved Search.
6. Go to any Transaction record and generate GL Impact by going over Actions > GL Impact.
7. Change searchid parameter on the URL from -36 to the Internal ID of new Saved Search.
8. Press Enter.w
William Lim
03/03/2020, 5:36 PMHello! Thanks for your feedback! By the way, the step 7 does not allow us a fixed change of the GL impact if I am not wrong
William Lim
03/03/2020, 5:37 PM@Jirae I will try to build the saved search as you told me, thank you very much !!!!
William Lim
03/03/2020, 5:49 PMOne last question, is it possible to set a column field (in the saved search) for debit amount is foreign currency (this data can be displayed in the report)
William Lim
03/03/2020, 5:49 PM?
k
KevinJ of Kansas
03/03/2020, 5:50 PMYou might have to throw a case statement to split foreign currency into debit or credit columns.
KevinJ of Kansas
03/03/2020, 5:51 PMI'd also expect some challenges around some specific accounts on transaction types
KevinJ of Kansas
03/03/2020, 5:51 PM(where the sign is reversed for some silly reason)
KevinJ of Kansas
03/03/2020, 5:52 PMFor example - Expense account lines on an invoice mess with the sign on some amount fields.
j
Jirae
03/03/2020, 6:08 PMw
William Lim
03/03/2020, 6:53 PM@KevinJ of Kansas I don’t really understand the concept of Case statement but Im gonna take a look on it. Thank you @Jirae for the link !
William Lim
03/03/2020, 7:03 PMActually I found information on it, thanks guys
William Lim
03/04/2020, 1:09 PMBy the way @KevinJ of Kansas, could you tell me where did you get the link Enhancement 170723 of the post above?
k
KevinJ of Kansas
03/04/2020, 4:31 PMSearch in Suite Answers for this number @William Lim 69284
w
William Lim
03/04/2020, 4:31 PMThank you ! I appreciate !
William Lim
03/04/2020, 6:39 PMBy any chance, do you know how I can modify these fields? I am currently facing an issue regarding the currency rate linked to them and I would like to change them
k
KevinJ of Kansas
03/04/2020, 7:01 PMYour currency rate is dicated by the account and the user preference
w
William Lim
03/04/2020, 8:28 PMOkay got it, thanks 🙂
8 Views