Category: Inventory
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. [...]
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. [...]
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 [...]
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 [...]
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 [...]