Microsoft Dynamics Partners providing comparisons and opinions to professionals in the ERP/Accounting software selection process since 2009

 
 

Crestwood Associates

Dynamics GP SmartList Builder: PO Shipment Receipt & Matching Line Number


    Email | Print

    SmartList Builder for Purchase Order in Dynamics GP

    Recently I aided a Microsoft Dynamics GP client in generating a SmartList to pull in purchase order numbers for shipments and match receiving lines.  In addition, they wanted to see the number of the receiving line. To accomplish this, I generated a SmartList Builder Report from the SmartList “Receiving Transactions.”

    Here’s how:

    SmartList Builder for Purchase Order in Dynamics GP

    The trick is we had to link the Purchasing Lines to the Receiving Lines.  To achieve this, I linked on two fields:  PO Number > PO Number and Ord > Receipt Line Number

    SmartList Builder for Purchase Order in Dynamics GP

    We also needed the Receipt Line Number to mirror the Line Number on the Purchase Order.  Dynamics GP holds the Receipt Line 1 as 16384 and increments by that amount each line number. I created a calculation in Smartlist Builder called PO Receipt Line.  The calculation divides the Receipt Line Number by 16384 to have the PO Receipt Line show as 1, 2, 3, etc.  This correlates to the line number on the Blanket Order or Purchase Order.

    Here is my calculation:

    {Receivings Line Items:Receipt Line Number} /16384

    SmartList Builder for Purchase Order in Dynamics GP

    Here is what the final report looked like.  Matching all our data.

    SmartList Builder for Purchase Order in Dynamics GP

    For more helpful Dynamics GP tricks and tips, subscribe to our blog.

    Ask This Expert a Question / Leave a Comment