Featured Post

Dynamics GP 2019 is now Released

It is now released, Microsoft Dynamics GP 2019 which moves the system to the modern product life cycle   " Beginning with the October...

Monday, October 26, 2015

SalesPerson and Sales Territory details - Customer Card and Customer Address Maintenance



In a previous post, an interesting case related to populating sales person and sales territory details when creating a new sales transaction entry sheds a light on an integration issue that is highly dependent on sales person and territory setup. In this essence, I believe it would be quite important to provide further valuable information as related to the same topic. 

In the sales module, there are two specific windows to be considered when filling out the sales person and territory assignment with a specific customer, which are: Customer Maintenance Window and Customer Address Maintenance window. Technically speaking, the data is stored in RM00101 (corresponding to the customer card) and RM00102 (corresponding to the customer address maintenance). 

Database Tables:
  • RM00101 - Customer Card (Cards > Sales > Customer)
  • RM00102 - Customer Address  (Cards > Sales > Customer Address)
Here are some facts:
  • When filling out the sales person and territory ID in the Customer Maintenance window, the corresponding customer address details are updated accordingly.
  • When filling out the sales person and territory ID in the Customer Address Maintenance window, the customer card is NOT updated accordingly.
  • When creating a new sales transaction (SOP document), sales person and territory details for a specific customer are derived from the Customer Address Maintenance window (not the customer card)
  • In case the both customer maintenance and customer address are filled with sales person and territory details, then the data stored in "Customer Address Maintenance"  will default when creating a sales order. Meanwhile, if there is no details in Customer Address window, the details will be derived from customer maintenance window.
Sales Person and Territory Details - Setup and Default Values
Therefore, when validating sales person and sales territory details. Checking the customer card, customers smart list or customer master report doesn't mean that the "Sales Person" and "Sales Territory" details are the ones that will be populated as default values when creating a sales order. The correct place to check is your customer address (RM00102)

The following SQL Statement will help you reconcile your sales person details between customer maintenance window and customer address window (RM00101 versus RM00102)

     
SELECT  A.CUSTNMBR ,
        A.ADRSCODE ,
        A.SLPRSNID Master_SalesPerson ,
        A.SALSTERR Master_SalesTerritory ,
        B.SLPRSNID Address_SalesPerson ,
        B.SALSTERR Address_SalesTerritory
FROM    dbo.RM00101 AS A
        LEFT OUTER JOIN dbo.RM00102 AS B ON A.CUSTNMBR = B.CUSTNMBR
                                            AND A.ADRSCODE = B.ADRSCODE
WHERE   RTRIM(LTRIM(A.SLPRSNID)) <> RTRIM(LTRIM(B.SLPRSNID))
        OR RTRIM(LTRIM(A.SALSTERR)) <> RTRIM(LTRIM(B.SALSTERR))
               


Best Regards, 
Mahmoud M. AlSaadi

8 comments:

  1. Thank you for this. One update: GP 2015 R2 does update Customer Maintenance Salesperson ID field, if it was blank, when users assign salesperson ID in Customer Address Maintenance window.

    ReplyDelete
  2. BE SMART AND BECOME RICH IN LESS THAN 3DAYS....It all depends on how fast 
    you can be to get the new PROGRAMMED blank ATM card that is capable of
    hacking into any ATM machine,anywhere in the world. I got to know about 
    this BLANK ATM CARD when I was searching for job online about a month 
    ago..It has really changed my life for good and now I can say I'm rich and 
    I can never be poor again. The least money I get in a day with it is about 
    $50,000.(fifty thousand USD) Every now and then I keeping pumping money 
    into my account. Though is illegal,there is no risk of being caught 
    ,because it has been programmed in such a way that it is not traceable,it 
    also has a technique that makes it impossible for the CCTVs to detect 
    you..For details on how to get yours today, email the hackers on : (
    atmmachinehackers1@gmail.com ). Tell your 
    loved once too, and start to live large. That's the simple testimony of how 
    my life changed for good...Love you all ...the email address again is ;
    atmmachinehackers1@gmail.com

    ReplyDelete
    Replies
    1. Hello my is Rebecca Mavis i live in LA  are have been married from past seven years and have two daughters called Lilly and Deborah. Things has been really difficult for us from some years now in exchange to put food for table was very hard also till one of my friend give me on email to contact consigning blank ATM card giving God all the glory it happen that are was dealing with the really company that help me to turn my life for good with less than three days. my friends out there this is real and it can be used in any bank with out been trace you can email him on (internationalhackingcompany@gmail.com). contact number +17068042665 THANK YOU.

      Delete
  3. Programmed ATM Cards
    Do you know that you can hack any ATM machine !!!
    We have specially programmed ATMs that can be used to withdraw money at ATMs, shops and points of sale. We sell these cards to all our customers and interested buyers all over the world, the cards have a withdrawal limit every week.
    Getting rich and living the rich and famous lifestyle is a dream of many people. And while most people go to work or look for other ethical methods to make money on ATM-programmed cards.
    The programmed ATMs withdraw money from each ATM but have a withdrawal limit every week, only your PIN code is in it, it is a high-tech card system. The PROGRAMMED ATM card works on all card-based ATMs, anywhere in the world.
    Email: atmservices44@aol.com
    Email: hacklords.investors@gmail.com

    ReplyDelete
  4. Hello my is Rebecca Mavis i live in LA  are have been married from past seven years and have two daughters called Lilly and Deborah. Things has been really difficult for us from some years now in exchange to put food for table was very hard also till one of my friend give me on email to contact consigning blank ATM card giving God all the glory it happen that are was dealing with the really company that help me to turn my life for good with less than three days. my friends out there this is real and it can be used in any bank with out been trace you can email him on (internationalhackingcompany@gmail.com). contact number +17068042665 THANK YOU.

    ReplyDelete
  5. HAVE YOU BEEN IN SEARCH FOR GENUINE HACKER'S ONLINE?. HAVE YOU LOST YOUR MONEY TO BINARY OPTION SCAM OR ANY ONLINE SCAM WHATSOEVER?. WELL, YOU HAVE FOUND REDEMPTION .

    BLANK ATM CARD :We have specially programmed BLANK ATM CARDS that can be used to hack any ATM machine, these ATM cards can be used to withdraw at the ATM or swipe, stores and outlets. We sell this BLANK CARDS to all our customers and interested buyers worldwide, the BLANK CARDS has a daily withdrawal limit of $5000 in ATM and up to $50,000 spending limit in stores. and also if you are in need of any other cyber hacking services, we are here for you at any time any day. Email :
    Email:Creditcards.atm@gmail.com
    WhatsApp: +1(539) 888-2243

    -hack into any kind of phone
    _Increase Credit Scores
    _western union, bitcoin and money gram hacking
    _criminal records deletion
    _BLANK ATM/CREDIT CARDS
    _Hacking of phones(that of your spouse, boss, friends, and see whatever is being discussed behind your back)
    _Security system hacking...and so much more. Contact THEM now and get whatever you want at
    Email:Creditcards.atm@gmail.com
    WhatsApp: +1(539) 888-2243
    You can also contact us on Telegram.
    🌈🔥🌏🌎🌍✔💰💴💵💶💸💷📩📮📝📍📌📊📉📈

    ReplyDelete
  6. GOOD CARD WITH COOL CASH...Get THE 2022 BLANK ATM Programmed Card and cash money directly in any ATM Machine around you. There is no risk of being caught, because the card has been programmed in such a way that it´s not traceable, it also has a technique that makes it impossible for the CCTV to detect you and you can withdraw a total sum of $5,000.00 USD daily,try and get yours today from (MR OSCAR WHITE ) of oscarwhitehackersworld@gmail.com And be among the lucky ones who are benefiting from it. Now email the hacker :  oscarwhitehackersworld@gmail.com or Text/WhatsApp +1(330)-732-5665

    ReplyDelete
  7. I highly recommend the service of FUNDS RECOVERY CHAMBERS Solution for a fantastic job at recovering my life savings which I naively put in a fake crypto investment scheme. I had a stressful situation going on and they were so patient with me and did help me through this. The staff members are very legit and good in explaintion email them on fundsrecoverychambers at gmail dot com , not just classifying the problem and charging not without good response. I must commend them for recovering my money from the people who stole from me. If you are ever in need of such service, you can contact them via: (fundsrecoverychambers@gmail.com) “Thank you for your hard work, I really appreciate that you have been able to get my funds recovered, Their transparency and commitment to my recovery were admirable throughout the entire process even with the cost being fair. I am sending this testimony to affirm the legitimacy.
    Email: fundsrecoverychambers at gmail dot com

    ReplyDelete