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...

Tuesday, February 2, 2016

Rule of Thumb | Maintain Requisition History


There is an important piece of setup when using the requisition management that is supposed to be checked after every single deployment of the module, it is simply the "Maintain History" option for requisitions. When upgrading from previous versions, this option might not be checked by default. 
  • Go to Microsoft Dynamics GP > Tools > Setup > Purchasing > Purchase Order Processing.
  • Under Maintain History section, check the option for "Requisitions" as illustrated below in the screen shot.
    Purchase Order Processing Setup

Requisition Tables Structure

The following are the primary requisition tables:
  • POP10200  -- Open Purchase Requisition Header
  • POP10210  -- Open Purchase Requisition Details
  • POP30200  -- History Purchase Requisition Header
  • POP30210  -- History Purchase Requisition Details 
  • sop60100   -- Requisition and Purchase Order Link

Primary Requisition Tables









Purchasing requisition/ multiple requisition and Maintain History 
 
In case the "Maintain History" is checked for requisitions, the data is archived in the history tables once a requisition is purchased. Otherwise, the data will be completely removed from the open tables, leaving only a record/records in the SOP60100 table (Requisition and Purchase Order Link)






Important Note !

When "maintain history" is not checked, the system allows you to re-use the same requisition number after being purchased. Although, once you purchase the requisition, the convert to PO window will retrieve no data, since there is an existing record in the SOP60100 indicating that the requisition number has already been purchased.


Best Regards,
Mahmoud M. AlSaadi

1 comment:

  1. 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