« Ftmvend | Main | Table trigger summary »
July 28, 2008
AP Direct Deposit
The address type and sequence has to match on 4 tables: ftvvend,goremal,gtvemal, and gxrdird in order for direct deposit to work correctly. The problem is it gets out of sequence when the address is updated via a form or the web between the four tables. I modified st_spraddr_insert_row to put the 4 tables back in sync if the address being inserted is the type on the gxrdird record with ap_ind set to 'Y'. The code shouldn't fire if it's any other address type being inserted. Worked ok so far when changing from ftvvend. Testing for via the web still
Posted by wendlerb at July 28, 2008 10:37 AM
Comments
Post a comment
Thanks for signing in, . Now you can comment. (sign out)
(If you haven't left a comment here before, you may need to be approved by the site owner before your comment will appear. Until then, it won't appear on the entry. Thanks for waiting.)