Friday, March 3, 2017

Dynamics GP - National Accounts - Parent customer cannot see child invoices in apply sales documents screen

Tables

  • RM00105 - National Account master
  • RM00101 - CPRCSTNM - Defines parent account

Solution
  • The parent account needs to have itself as a value in the CPRCSTNM field
  • run this script to set all national account parents to themselves
update rm00101 set cprcstnm = custnmbr where custnmbr in (select cprcstnm from RM00105)

No comments:

Post a Comment