Archive for the ‘Dynamics’ Category
Post Through GL for Computer Checks – with Analytical Accounting
When you have Analytical Accounting module installed and configured in a GP company, the Post Through GL for Computer Checks gets automatically disabled in the specific company (even if it was turned on). If we try to activate the same manually (with Analytical Accounting activated), we get the following error message and the system prevents [...]
August 4, 2011 · 
veeyeskay · 
No Comments
Tags: analytical accounting activation, computer checks, post through general ledger files, post through gl, Posting Setup · Posted in: Analytical Accounting, Dynamics, Great Plains, SQL Server, SQL Server 2005, SQL Server 2008 Total Views: 131
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
Support Debugging Tool Customization #1 – Notes Disabler
Hi all I am planning to start a new series of posting code for simple customizations, which have been requested on the forum by communities. This is the first of that category. I would be using the Support Debugging Tool for this purpose, and this is means to promote the tool. There are many on [...]
July 30, 2011 · veeyeskay · 10 Comments
Tags: Customization Code, Notes Disabler, Record Notes, support debugging tool, Window Notes · Posted in: Customizations, Dynamics, Great Plains, Support Debugging Tool Total Views: 210
Additional Purchases Accounts for Vendors
Hi all Sometimes, when we book invoices against vendors, we might have to post the expense into multiple GL accounts based for the purpose of financial reporting. Mostly I have seen a specific purchases account defaulted at the vendor level and the users manually add additional expense lines at the distribution window at the time [...]
July 29, 2011 · veeyeskay · One Comment
Tags: Additional Purchase Accounts, expense accounts, purchasing, Vendor Account Maintenance, vendor-maintenance · Posted in: Accounts Payables, Dynamics, Great Plains Total Views: 63
Upgrade Details for Dynamics GP
Hi all Today I have decided to write up an article which gives links to the update paths for Dynamics GP and its web applications. Microsoft Dynamics GP 10.0 Updating to Dynamics GP 10 Upgrade Information for Microsoft Dynamics GP 10.0 Upgrade Guides for Microsoft Dynamics GP 10.0 Service Pack, Hotfix, and Compliance Update Patch [...]
July 27, 2011 · veeyeskay · One Comment
Tags: dynamics gp 10, dynamics gp 2010, Service Pack Information, Update Information, Upgrade Guides · Posted in: Dynamics, Great Plains, Upgrade Total Views: 254
Payables HATB With Aging By Payment Terms (using Document Date)
As a follow up to my script for generating the Payables HATB With Aging By Due Date (using Document Date), I have decided to post a script for the same with aging buckets based on the document date (with the logic of payment terms). This will provide the aging buckets for each transaction based on [...]
July 25, 2011 · veeyeskay · 2 Comments
Tags: HATB, Payables Aging, Payables HATB, Payables Transactions, payment-terms, Trial Balance · Posted in: Accounts Payables, Dynamics, Great Plains, SQL Server, SQL Server 2005 Total Views: 108
Payables HATB With Aging By Payment Terms (using GL Posting Date)
As a follow up to my script for generating the Payables HATB With Aging By Due Date (using GL Posting Date), I have decided to post a script for the same with aging buckets based on the document date (with the logic of payment terms). This will provide the aging buckets for each transaction based [...]
July 25, 2011 · veeyeskay · One Comment
Tags: HATB, Payables Aging, Payables HATB, Payables Transactions, payment-terms, Trial Balance · Posted in: Accounts Payables, Dynamics, Great Plains, SQL Server, SQL Server 2005 Total Views: 89