ERP Software Logo1

Microsoft Dynamics vendors provide comparisons and opinions to professionals in the ERP/Accounting software selection process

 
 

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