Category: Purchase Order Processing
Add Item option in POP and SOP
There are many little options in Dynamics GP which goes unnoticed most of the time. One such option is the Add Item option which is available under Options menu in the Sales Transaction Entry window. So when the user enters a line item number which does not exist in the system, if this option [...]
Mass Update Purchase Order Generator Options for Items
As a follow-up to my previous article on Unit Cost of an Item using PO Generator, which I had posted yesterday, this article explains an option to mass update the PO Generator options for many items at once. This can be achieved using the Purchase Order Item Mass Update window which opens from Microsoft Dynamics [...]
Unit Cost of an Item using PO Generator
Yesterday, I was responding to a support ticket where the unit cost was coming as $0 for an item-site combination when using PO Generator. Ideally there are quite a few options available for cost selection for an item-site combination when using the Purchase Order Generator module. It can be found from the Purchase Order Generator [...]
Editing Lot Number Attributes After Posting
Recently, I had seen a request from one of our clients who had asked us if the lot number attributes can be edited after the receiving transactions have been posted. This could be needed when there was an issue with the expiry date (or) the manufacturing date (or) any of the other attributes which are [...]
Nice Features for Auditing Information in GP
Hi all I read the recent article posted by Vaidy titled Sales Quote Line Item Cancellation, where he explains the use of the Qty Canceled field and how it helps the companies to track the actual quote and details of the canceled item, rather than deleting the line item completely. As a follow-up article for [...]
SQL Script for Purchase Order Line Items Not Yet Received
Hi all Today, I am posting a script which provides the details of the Purchase Order Line Items which are yet to be received. /****************************************************************** Created June 23, 2011 by Sivakumar Venkataraman – Interdyn AKA This view returns a returns the details of the PO Line which has not been received fully. It provides the [...]
Analytical Accounting Information Flow from Purchase Order to Receipts
Hi all This article is to explain how Analytical Accounting (AA) information is transferred from Purchase Orders to Receiving Transaction Entry. The scenario explained below is on an environment where there is one transaction dimension configured in Analytical Accounting. Create a Purchase Order with 2 line items as explained below. PO Number Line Seq. No [...]