Feature of the Day: Shipping - Inside Microsoft Dynamics GP - Site Home - MSDN Blogs

Microsoft is showing off a new Feature of the Day: Shipping. The funny thing is that when I first saw this I was reminded of Robert Scoble's quote "Shipping is a feature". He was talking about the ability to actually complete the work and produce a product. The irony of course is that Dynamics GP 2013 is shipping in a week.

Weekly Review: POP Invoice Match Extended Price

 

Here’s the scenario: in POP you go to match an invoice but you can’t quite get quantity and unit price to equal the extended price you need to match too. Usually this is because there aren’t enough decimal places defined for quantity or unity price.

The fix for this is easy. Set the quantity and force the extended price field to be what you want. GP will automatically adjust the Unit Price. This works even if there aren’t enough decimal places defined, GP still forces the unit price and deals with the decimal places behind the scenes.
This also works for P.O.’s, Receivings and SOP transactions. It’s also a great way to make sure integrations are right. Integrate the quantity and extended price and let GP figure out the unit price.

Weekly Dynamic: Next P.O. Number

If you end up with gaps in P.O. numbering it’s possible for a user to key a P.O. number in the gap and effectively reset the next P.O. number lower. When this happens, you get P.O. errors. It’s relatively easy to reset the number but it becomes a pain to do it over and over again.

The Professional Service Tools Library (PSTL) offers a Minimum PO/Receipt Number Tool. This sets a number threshold that that users can’t create a P.O. Number below.

Once active, Purchase Order Processing Setup gets an Additional menu to set the minimum threshold.

Why does the JE description say “Receivings Transaction Entry”? - Blog - Kuntz Consulting

Kuntz Consulting wonders Why does the JE description say “Receivings Transaction Entry”?

Streamlined Purchase Processing GP: Copying from Existing P.O.’s

Sheldon from Etelligent offers suggestions for Streamlined Purchase Processing in GP by Copying from Existing P.O.’s

Weekly Dynamic: POP Cost Defaulter

By default Microsoft Dynamics GP gets the Last Invoice Cost on a Purchase Order from Inventory setup in Cards | Inventory | Vendors.

If you would like the Last Invoice Cost to default from the Inventory Current Cost or Standard Cost you can do that with the free POP Cost Defaulter utility that is part of the Professional Services Tools Library (PSTL).

POP Cost Default is easy to use. Simply check the box next to the tool to activate it. Mark the radio button and hit next to set it up.

Setup is ridiculously easy. Pick where you want the cost to default from and click Ok.

That’s all there is to it to changing the source of your Last Invoice Cost on P.O.’s

Weekly Review: Proper P.O. Closing

 

An awful lot of folks close Purchase Orders the wrong way. The scenario is this: A P.O. remains partially open due to a vendor's inability to deliver goods in a timely manner. The firm finds an alternate supplier and cancels the P.O. with the vendor. To cancel the P.O. out of GP, they change the quantity on the P.O. line to match the quantity delivered and close the P.O. The problem with this scenario is that it removes visibility into the vendor's performance.

A better way to accomplish this is to put the remaining amounts in the Quantity Cancelled line. This will enable closing the P.O. and provide a history that the vendor didn't deliver. Now Smartlists or other reporting can be used to compare the delivery performance of various vendors and allow businesses to make intelligent sourcing decisions.

Originally Posted by Mark at 10/12/2009 09:00:00 AM

Add Item option in POP and SOP | | Interesting Findings & Knowledge Sharing

Sivakumar looks at the Add Item option in POP and SOP in his latest post.

SQL Scripts–Vendor Invoice Pricing Discrepancy « Real Life Dynamics User

Real Life Dynamics User is back with a SQL Script looking at Vendor Invoice Pricing Discrepancy

“…all Payables invoices that have been entered into your system where the price your vendor is charging does not match the price of your purchase order. “

SQL Scripts–SOP to POP Freight Analysis « Real Life Dynamics User

Ron at Real Life Dynamics User is back with SQL code for SOP to POP Freight Analysis.

“…analyze the freight you charged to a customer versus the freight you were billed from you vendor provided there is a SOP to POP link between the sales order and purchase order.”

Sweet

Weekly Dynamic: POP Reference

In the POP windows with distributions (Shipment, Ship/Invoice, Enter/Match Invoice) there is a Reference field. This defaults to the transaction type but it can be changed. This reference passes through to be the reference field in the GL Transaction and can help provide additional information for folks starting with the GL.

According to the help documentation, this is also supposed to flow down to the distribution reference field in the GL if the distribution reference is blank, but it doesn’t. From the help:
Purchasing Invoice Distribution Entry window: Fields
Reference
Displays the reference that will post to General Ledger as the reference for the receipt. Purchasing Invoice Entry is the default reference for this field. If the Distribution Reference field for an account is left blank, the reference entered in the Reference field will post as the distribution reference. If you change the reference in the Reference field, that change will only affect those accounts that don't have distribution reference entered for them when the invoice is posted.
What actually happens is that the account category rolls down as the reference. I’ve submitted a request via Microsoft Connect to have GP work as documented. You can vote for this request to move it up the priority chain and put it on Microsoft’s radar at: http://bit.ly/rnVYwM.
[Big Hat Tip to Chaz Vann of I.B.I.S. for this.]

Mohammad R. Daoud: PO Receiving Hangs During Posting

Mohammad Daoud is back with a look at PO Receiving Hangs During Posting

SQL Script – Orders Needing Purchase « Real Life Dynamics User

Real Life Dynamics User gives us a new SQL Script with details on Orders Needing Purchase « Real Life Dynamics User.

Errors seen in Purchase Order Processing when Encumbrance Management and Requisition Management are installed - Dynamics GP Support and Services Blog

From the Dynamics GP Support and Services Blog we’ve now got information on Errors seen in Purchase Order Processing when Encumbrance Management and Requisition Management are installed.

Unit Cost of an Item using PO Generator | Interesting Findings & Knowledge Sharing

Sivakumar digs into the Unit Cost of an Item using PO Generator in a new post.

Centralize or Decentralize Distribution Management? | I.B.I.S. Inc.

Distribution expert Brent Grover has a new guest post up at the I.B.I.S. blog with answering the question Centralize or Decentralize Distribution Management? .

Dynamics Confessor Blogspot: SOP order and POP document in the same order

From a Convergence reminder, Leslie Vail looks at how to get the SOP order and POP document in the same order.

Available to Promise. Helps you keep your promises! - Dynamics GP Blog

Dynamics GP Blog has a new look at how Available to Promise. Helps you keep your promises.

Default SOP and POP dates | DynamicsCare

Amy Walsh is back with a look at Default SOP and POP dates over at DynamicsCare.

Mohammad R. Daoud: Add Purchase Order Line Account Number to PO Workflow

Mohammad Daoud shows us how to Add Purchase Order Line Account Number to PO Workflow.