Archive for the ‘Purchase Order Processing’ Category
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 [...]
September 28, 2011 · 
veeyeskay · 
3 Comments
Tags: add item option, default additem pop/sop, non-inventoried item, non-inventory item · Posted in: Dynamics, Great Plains, Professional Services Tools, Purchase Order Processing, Sales Order Processing Total Views: 161
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 [...]
August 3, 2011 · veeyeskay · One Comment
Tags: cost selection, include allocations, include back orders, include requisitions, item resource planning, mass update, order method, po generator, po generator setup, replenishment level, vendor selection · Posted in: Dynamics, Great Plains, Inventory, Purchase Order Processing Total Views: 93
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 [...]
August 2, 2011 · veeyeskay · 2 Comments
Tags: item cost selection, item resource planning, order policy, po generator · Posted in: Dynamics, Great Plains, Inventory, Purchase Order Processing Total Views: 96
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 [...]
August 1, 2011 · veeyeskay · 6 Comments
Tags: edit lot number attributes, expiry date, lot number attributes, lot numbers, manufacturing date · Posted in: Dynamics, Great Plains, Inventory, Purchase Order Processing Total Views: 203
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 [...]
June 26, 2011 · veeyeskay · One Comment
Tags: Audit Features, Deletion Prevention, Journal Entry Void, purchase-order, Sales Documents, Voiding · Posted in: Dynamics, General Ledger, Great Plains, Purchase Order Processing, Sales Order Processing Total Views: 167
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 [...]
June 23, 2011 · veeyeskay · 4 Comments
Tags: Items Not Received, Line Item Remaining, purchase-order, Qty Canceled, Qty Ordered, Qty Shipped · Posted in: Dynamics, Great Plains, Purchase Order Processing, SQL Server, SQL Server 2005, SQL Server 2008 Total Views: 388
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 [...]
June 2, 2011 · veeyeskay · One Comment
Tags: assigned percentage, purchase-order, receipt, Transaction Dimensions · Posted in: Analytical Accounting, Dynamics, Great Plains, Purchase Order Processing Total Views: 310
SQL Script for POP Receiving Transactions with AA Information
Hi all My last post had a script for Purchase Orders with AA information. Today, I am posting a script for the following POP transactions with AA information. Shipments Shipment/Invoice Invoice IF EXISTS ( SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N’[dbo].[vw_POPRcptInformation]‘) ) DROP VIEW [dbo].[vw_POPRcptInformation] GO S Read the rest of this entry
May 20, 2011 · veeyeskay · 3 Comments
Tags: Dimension Codes, Receiving Transaction Entry, shipment/invoice · Posted in: Analytical Accounting, Dynamics, Great Plains, Purchase Order Processing, SQL Server, SQL Server 2005, SQL Server 2008 Total Views: 237
SQL View for Purchase Order Details with AA Information
Hi all Based on a request from a community user on my blog, I have decided to post these SQL Views for fetching the purchase order information with analytical accounting information. IF EXISTS ( SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N’[dbo].[vw_POInformation]‘) ) DROP VIEW [dbo].[vw_POInformation] GO SET ANSI_NULLS ON GO SET QU Read [...]
May 9, 2011 · veeyeskay · One Comment
Tags: Dimension Codes, Purchase Order Processing, purchase-order, Transaction Dimensions · Posted in: Analytical Accounting, Dynamics, Great Plains, Purchase Order Processing, SQL Server, SQL Server 2005, SQL Server 2008 Total Views: 301
Defaulting Unit Of Measurements
Hi all In this article, I am planning to give a quick insight into the defaulting of unit of measurements in the sales transactions and the purchase transactions. Sales Order Processing If you wish to default the unit of measurement of items in sales transactions, you need to define the same at the Price List [...]
November 9, 2010 · veeyeskay · No Comments
Tags: Default Unit of Measurement, Item Purchasing Options, Item Vendors Maintenance, Price List Maintenance, Purchase Order Processing, Sales Order Processing · Posted in: Dynamics, Great Plains, Purchase Order Processing Total Views: 507