Notifications
Announcements
No record found.
Hi all,
I want to default my credit Account after lost focus event on Reference field.
Any idea on VBA?
RomRyan
*This post is locked for comments
Hi Romryan,
If you want to default an account (Could be either debit or credit), have you considered using "Quick Journals"?
(Tools - Setup - Financial - Quick Journal) and (Transactions - Financial - Quick Journal).
==========================
The above may or may not be suitable depending on your business requirements. Can you tell me more about the exact requirement? (Does the value of the reference determine what account number will be used for the credit? If so, how many different reference/credit account combinations are you using, etc...)?
======================================
I personally try to avoid using VBA with grids as it can sometimes prove difficult, especially if you are trying to put a value in the grid based on something in a header. (And especially consider what happens if after you enter the transaction you need to go back and update the Reference field...) however someone with more experience in VBA Grids might have a simple solutions for you.
Thank you,
Justin
Justin,
My requirements is that When creating a GL transaction,I am using a voucher number from payable management window as the reference in GL Transaction Entry window.
When that reference field is filled with the voucher number,then a certain Credit account number should be automatically populated on the Grid.
I am not limited to VBA only,I welcome any other suggestion.
Can you tell me the purpose of this GL Transaction (...because normally you post the PM invoice, and this would have the distributions on it and flow To/Through GL)? What is the purpose of this "2nd" GL transaction?
If you are doing many of these transactions, I would explore the possibility of importing these transactions (eConnect or Integration Manager).
Its a client requirements that's why am going this abnormal way.
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
mtabor 1
