75,730
*This post is locked for comments
Richard,
I love it! "usual list of miracles that had to be performed",
Boy, how many 'pre-sales' meetings have we attended where even we were impressed with all of the things GP can do?
Thanks for the memories :)
Kind regards,
Leslie
Thanks Leslie, I was just perusing the list of functions that a salesman had promised and I was coming up with the usual list of miracles that had to be performed. I see you point about how to exit. I will code this up and see how much trouble I can get into. It is always the unexpected consequences that gets you!
Hi Richard,
So long as you are not using the Web Client, I think you can accomplish this pretty easily with VBA. If you want the distribution entry window to always open in 'expanded' mode, add the window and the expand button to your VBA project and put the following code in the 'After Open' event:
Private Sub Window_AfterOpen()
Me.ScrollingWindowExpandButton = 1
End Sub
If you want the next distribution line to use the same account number that you just used, include the DistributionAccountNumber field into your project, store the last account number used in a variable and then set the new line's account number to the value of the variable. Something like this:
Option Explicit
Dim DistAcct As String
Private Sub DistributionAccountNumber_AfterGotFocus()
If Me.DistributionAccountNumber.Empty = True Then _
Let Me.DistributionAccountNumber = DistAcct
End Sub
Private Sub DistributionAccountNumber_AfterUserChanged()
Let DistAcct = Me.DistributionAccountNumber
End Sub
Of course, you would need to handle how the system will behave on the last line, so that you can end the entry, but that can also be done with VBA.
I do prefer a Dexterity solution like SOMA recommended, but it might be a good exercise to start with VBA so that you can nail down the actual requirements. What sounds easy to begin with, quickly complicates as the client starts using it.
Kind regards,
Leslie
Sorry for my late response.
I have done some customization in dexterity, similar to your requirement. But, the customization in not a separate one. This is part of some addons. So, I don't have the source code for the customization.
I am ready to develop this requirement.
If you interested, Can you send me the full requirement document?
Contact details:
Mail: soma.moorthy@gmail.com
Skype id : soma.moorthy2
Soma. this is for a GP 2013 cloud server and I can go either way on this. Please let me know cost and if source code will be provided. I was going to develop this using DYANMCIS.VBA but if you can create it in Dexterity and save me the bother, so much the better.
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,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (