tag:blogger.com,1999:blog-14548861.post4136173908121096190..comments2023-09-12T06:07:23.275-05:00Comments on MBS Guru: The VBA Source for making the Purchases Account Required in PO Entrymbsguruhttp://www.blogger.com/profile/13675896847183138852noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-14548861.post-91460982232881918492009-12-09T19:51:05.300-06:002009-12-09T19:51:05.300-06:00That's great! Not the same thing though. The...That's great! Not the same thing though. The trigger will automatically assign the account if one does not default in. Why not just assign the clearing account as the default for the Vendor instead of using the trigger?<br /><br />If you want the right account on the PO Line and can't use a single default account this customization is a good way to ensure that the right account number is entered by the user during PO entry without any additional steps.<br /><br />Thanks for the feedback.mbsguruhttps://www.blogger.com/profile/13675896847183138852noreply@blogger.comtag:blogger.com,1999:blog-14548861.post-61757148266126870842009-12-09T18:34:14.513-06:002009-12-09T18:34:14.513-06:00I have also accomplished this with the use of a SQ...I have also accomplished this with the use of a SQL Table Trigger. You can use the trigger to assign a clearing account to an empty PURCH distribution and auto reverse it with a MISC distribution. The users can then code the distributions in summary using MISC distributions.<br /><br />Thanks for the post!Unknownhttps://www.blogger.com/profile/16217587741416227460noreply@blogger.com