Archive for the ‘Inventory’ Category
Price Level Defaulting in SOP Entry
Recently, I was handling a support case, where the user raised an issue in the way the Price Level was defaulting in the Sales Transaction Entry window line. The issue is explained below. “I have a client whose standard pricing doesn’t seem to be working as expected, or at least as I thought it should. [...]
November 20, 2011 · 
veeyeskay · 
3 Comments
Tags: default, default price level, item price list, Line Item, price level, price list, receivables, sales invoice, sales quote, sales transaction entry, sales-order, sop line item, standard pricing · Posted in: Dynamics, Great Plains, Inventory, Sales Order Processing Total Views: 116
Selling Options in Item Price List Maintenance
I was recently assisting a customer who was getting the following error when trying to enter a quantity in the Sales Transaction Entry window for a specific item. This message is because of an Selling Option setup which is defined for the specific item and unit of measurement in the Item Price List Maintenance window. [...]
August 12, 2011 · veeyeskay · 2 Comments
Tags: not available, price list, Price List Maintenance, round amount, round option, round policy, selling option, whole, whole and fractional · Posted in: Dynamics, Great Plains, Inventory, Sales Order Processing Total Views: 122
Support Debugging Tool Customization #4 – U Of M Long Description on SOP Invoice
A recent support request was to add the U Of M Long Description on the SOP Blank Invoice Report. The situation explained was that the U Of M was just an abbreviation and the client was using the U Of M long Description to capture a meaningful description in the Unit Of Measure Schedule Setup [...]
August 8, 2011 · veeyeskay · 4 Comments
Tags: component-sequence, line item sequence, runtime execute, sop blank invoice, sop number, sop type, support debugging tool, u of m, u of m long description, u of m schedule · Posted in: Customizations, Dynamics, Great Plains, Inventory, Sales Order Processing, Support Debugging Tool Total Views: 114
Calculating Quantity on Hand in Inventory
Recently, I was assisting a community member on the forum, who was trying to reconcile the Quantity on Hand in the Item Inquiry window. Ideally, the simplest check to validate the Quantity on Hand for a particular item would be to get the transaction details from the Inventory Transaction Amounts History (IV30300) table, manipulate the [...]
August 4, 2011 · veeyeskay · One Comment
Tags: inventory reconcile, inventory transaction history, quantity on hand · Posted in: Dynamics, Great Plains, Inventory Total Views: 184
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
Maintaining Data Integrity between Sub Ledgers and General Ledger
Hi all I have been involved in the process of reconciliation between the sub ledgers and the general ledger at various clients and there has been various scenarios in which there has been a break between the sub ledgers and the general ledger balances. A few key scenarios are quoted below A transaction posted in [...]
May 16, 2010 · veeyeskay · No Comments
Tags: Accounts Payables, Accounts Receivables, General Ledger, Inventory, Reconciliation · Posted in: Accounts Payables, Accounts Receivables, Dynamics, General Ledger, Great Plains, Inventory Total Views: 2,017
SQL View for Inventory Aging
Guys I have come across many requests from various friends and clients of mine, who have a need to print a stock aging report in GP. There is no out-of-the-box report for stock aging report in GP. So I decided to write out a simple view to achieve the same. CREATE VIEW vw_IVStockAgeing AS [...]
May 2, 2009 · veeyeskay · 6 Comments
Posted in: Dynamics, Great Plains, Inventory Total Views: 1,422