Expose Unit_Price in "Edit in Excel" in regard to the Items table.
"Edit in Excel" is a wonderful tool. Unfortunately, it sometimes seems like a developer used the dart board approach when deciding which fields to make editable.
Aside from "Item no." and "Description", "Unit_Price" is probably the most crucial field to have available for update i...
GTIN, NW, GW and Volume in Item Unit of Measure
Having the following information per Item Unit of Measure would be best as many items can be sold/shipped using different packaging level; GTIN, Net Weight, Gross Weight and Dimension (Volume). Dynamics NAV has the most of the above already in the table Item Unit of Measure. The only only that...
Automatic Cost Posting
It would be great for Automatic Cost Posting to be included in D365. I cannot see this as something that can turned on within the Inventory Setup at present.
Update the actual cost in the Posted assembly order lines( after posting Assemble Order)
Auditor always ask what the actual cost of the Assembled Items, there is no straight forward report or there is no actual cost updated in the posted assembly lines for Consumed Items actual cost or the Posted assemble order header as a cumulative cost of Assembled items. It's all giving the expec...
Best regards,
Business Central Team
Application entries in Item Ledger entries
It's very hard to re apply the Item ledger entries with the correct Lot if user wants to reapply the Stock with the correct lot no to get the correct cost related to that Lot. if it is partial qty case then there is no chance to correct from the Item application work sheet except to do the correc...
Best regards,
Business Central Team
Option of having Site or Location on Purchase prices
vendor can supply same item cost on 2 different location or sites. the option to input the purchase price per vendor ,item, location. option on the purchase price.
Best regards,
Business Central Team
Line level and Lot/serial card attachments
Companies need line level attachments and attachments to Lots/serial numbers (information card), especially on the purchase receipt side. When items are received many times there is an inspection report from the vendor or a certificate of conformance that needs to be attached to the line on the ...
Best regards,
Business Central Team
Inventory Valuation Reporting
I want to run an inventory valuation report by location - this filter does not seem to exist. As a work around, I run a physical inventory journal for the required location, send to excel so I can amend it to get the information required.
Best regards,
Business Central Team
Item Availability by Location - Bring back send to Excel
In Business Central 15.0, we could send the Item Availability by Location to Excel. This was great way to see all item quantity on hand by location. There isn't a report like it in Business Central. Since upgrading to BC 15.4, this feature is no longer available. Selecting all rows and using...
Best regards,
Business Central Team
Dampener % to use Original Quantity and not Lot Size
On the manufacturing setup the Dampener % says - Specifies a percentage of an item's lot size by which an existing supply must change before a planning suggestion is made. This is not how most people view the Dampener % or would like it to work. Unless you are a standard cost company you don;t ...
Best regards,
Business Central Team
Administrator
Hi David,
Thanks for the feedback. There is currently the ability from within the Excel add-in to modify the fields that display in the Excel spreadsheet. In the add-in, click the Design action. This brings up the list of data sources for the workbook. From here to can edit the data source, including adding or removing fields from the table. Unit_Price is one of the fields you are able to add for the Item_Card data source.
However, the Unit_Price property is not an editable field through the Excel add-in. It will display the value pulled from the database, but won't allow you to publish changes to the field. This is due to how the code handles calculations and relationships among the Unit Cost, Unit Price, Profit %, and Price/Profit Calculation fields.
But I'll add a feature to our backlog for us to look into handling editing for fields of this type so we can allow publishing changes for the Unit Price and similar fields.
Thanks!
Jared Hall
Microsoft