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, January 25, 2016

Purchase Order Processing - Prepayment Report



The purchase order processing prepayment has been introduced recently with the release of Dynamics GP 2013, it allows prepayments to be issued and handled while processing the purchase order. The purpose of this article is not to provide a detailed tutorial on "how to setup and use" the prepayment functionality in Dynamics GP, rather it provides a prepayment report. 

The report sample is provided below:

Prepayment Report Sample

The script can be downloaded from this link >  Download Link 


/*--------------------------------------------------------------------
Creation Date: 25 January, 2016
Created by: Mahmoud M. AlSaadi

The script provides a detailed report of the purchase order prepayment

Revision History:
Revision No.            Revision Date     Description
1                       25/01/2016        Original Version
----------------------------------------------------------------------*/
SELECT  PONUMBER PuchaseOrderNumber ,
        PMNTNMBR PaymentNumber ,
        CASE PrepaymentSource
          WHEN 0 THEN 'Edit Checks'
          WHEN 1 THEN 'Manual Payment'
          ELSE ''
        END AS PaymentType ,
        CASE PYENTTYP
          WHEN 0 THEN 'Check'
          WHEN 1 THEN 'Credit Card'
          ELSE ''
        END AS PaymentType ,
        CASE PSTGSTUS
          WHEN 0 THEN 'Unposted'
          WHEN 20 THEN 'CheckAssigned to Batch'
          WHEN 80 THEN 'Posted'
          ELSE ''
        END AS PostingStatus ,
        PSTGSTUS ,
        PrepaymentAmount ,
        OriginatingPrepaymentAmt ,
        APPLDAMT AppliedAmount ,
        ORAPPAMT OriginatingAppliedAmount ,
        CURTRXAM CurrentTransactionAmount ,
        ORCTRXAM Or_CurrentTransactionAmount ,
        CHEKBKID CheckBookID ,
        CHEKNMBR CheckNumber ,
        GLPOSTDT GLPostingDate ,
        BACHNUMB BachNumber ,
        CURNCYID
           FROM    [POP10170];

 


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