Share
ReportHi 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
You’re offline. This is a read only version of the page.
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,
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).
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.
RomRyan
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
#1
Almas Mahfooz
3
User Group Leader
All responses (
Answers (
