1,415
We notices that we could input ONLY UPTO 30 CHARACTERS into Great Plains Distribution Reference in A/P Transaction Entry. Is it possible to increase these 30 charactes limit?
(This is under Purchasing/ AP Transaction Entry/ Payable Transaction Entry Distribution/ 3rd line- Distribution Reference)
*This post is locked for comments
Barbara,
Just to clarify this a little, you cannot change the actual length of this field in the database regardless of the toolset you use. What you can do with Extender and/or VBA is add another field and logic to carry it along so it replaces the Distribution Reference with another field that can act as a longer replacement.
It's not as easy as it sounds as you need to write your own add/edit/delete logic within VBA (if you want to replace the field on the window) or end up with an extras window with Extender, which has the add/edit/delete logic but can't really replace the field on the window. In theory you could combine the two but Extender is a bear to reference from outside itself. For these issues at my company we use the native toolset Dexterity but that is not end user friendy.
Another thing to consider is that this AP Distribution Reference rolls forward to the GL Entry reference which itself is 30 chars which with either of the above tools will not be blank as the real AP DR is blank. Might be best to write to the notes field or attached a secondary document with OLE notes.
Best of luck.
Tim
You can purchase GP Extender that will get you close to what you need or you could use Visual Studio, Dynamics VBA, Dexterity or a host of other solutions. GP Extender requires no programming the other would require progamming.
Thank you, Melissa! How to do cutomization?
Not without customization as that is the field length in the database.
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 (