Warehouse Management#
The following features expand standard Microsoft Dynamics 365 Business Central1 functionality to provide additional options to those working in your organization’s logistics department.
Make copies of shipping notes#
By using standard app functionality, you can specify a set number of invoice copies that are printed when you post an invoice sent to a customer.
A new feature lets you do the same for shipping notes so that, for example, as a wholesaler, you can respond to forwarders’ requests for a certain number of copies that they need to supply to international clients.
Each copy is printed automatically when a shipping note is posted. To specify the number of copies:
- Choose the Search icon, enter Customers, and then choose the related link.
- Open a customer card.
- On the General FastTab, fill in the No. of Shpt. Copies field.
Show quantities in item statistics#
The statistics page you can open from item cards in Microsoft Dynamics 365 Business Central1 provides multiple ways in which to list currency amounts for a specific item. None of these views, however, contain item-related quantities. Therefore, a Quantity option has been added to the page.
To see quantities in statistics:
- Choose the Search icon, enter Items, and then choose the related link.
- Open an item card.
- Choose Related > Statistics > Item Statistics.
- Select Quantity in the Show as Lines field and fill in the other fields as necessary.
- Choose Show Matrix on the ribbon.
You can then see the following quantity totals for each item ledger entry type:
- Positive Adjmt. (Qty.)
- Purchases (Qty.)
- Output (Qty.)
- Assembly Output (Qty.)
- Quantity Increase
- Sales (Qty.)
- Consumption (Qty.)
- Assembly Consumption (Qty.)
- Quantity Decrease
- Transfer (Qty.)
All quantities except those related to item ledger entries of the Transfer type are shown as positive values. You can drill down on a field to see all the item ledger entries totaled for a certain type.
Identify receipts by supplier#
When retrieving source document lines for warehouse receipts, you can now see the external reference numbers stored on the document lines in addition to item numbers. This way, you can filter for a supplier’s item reference when creating documents for warehouse receipts.
Manage negative inventory by location#
By using standard system functionality, you can prevent negative inventory at every location of your company. However, some locations might need to make use of the option of posting into the negative.
A field has been added to the location card so that you can decide individually for each location how posting negative adjustments should be handled.
- Choose the Search icon, enter Locations, and then choose the related link.
- Select a location card.
- On the General FastTab, fill in the Prevent Negative Inventory field.
If you didn’t turn on the Prevent Negative Inventory toggle in Inventory Setup, the field on location cards shows the following options:
- Default (No)
- No
- Yes
However, if you turned on the toggle in Inventory Setup, the options are:
- Default (Yes)
- No
- Yes
In other words, the default setting at a location depends on whether you’ve turned the toggle in Inventory Setup on or off.
Note
What default option is set in item masters, that is, a Default (Yes) or a Default (No), always depends on whether you turned on the Prevent Negative Inventory toggle in Inventory Setup.
When you’re trying to post a negative adjustment, the system goes through the following sequence to decide whether to perform or prevent the posting:
- What option is set on the item card?
- What option is set for the location?
- Has the toggle been turned on in Inventory Setup?
Supply certificates of conformity#
You can now also store conformance certificates for lots and provide them to customers if necessary.
Setup#
Extended Manufacturing Setup#
To be able to use this feature, you need to specify a number series for certificates. To set up a series:
- Choose the Search icon, enter Extended Manufacturing Setup, and then choose the related link.
- On the General FastTab, select a series in the Conformance Certificate Nos. field. Alternatively, to create a new series, select the button next to the field and then choose New.
Manage a certificate#
To manage certificates:
- Choose the Search icon, enter Conformance Certificate List, and then choose the related link.
- On the ribbon, choose New to create a certificate or choose Manage > View or Edit after selecting an existing one.
- If you choose New, the No. field will be filled in with a number from the series that you set up for this purpose. You can also assign a number manually.
- Optionally, fill in the Description and Certificate No. fields based on what you see written on the certificate. The other fields on the General FastTab will be filled in by the system after you’ve run the Import function.
- Choose Import on the ribbon to select the file that contains the certificate.
You can then choose Get Lots from Purch. Receipts, Get Lots from Lot No. Info, or Get Lots from ILEs on the ribbon to assign the certificate to a lot.
The other actions available on the ribbon are described in the following table.
Function | Description |
---|---|
Export | Saves the image file displayed on the header. |
Open | Shows the image file displayed on the header. |
Delete | Deletes the image file displayed on the header. |
Lot No. Information card#
This card shows in the Conformance Certificate No. field the number of a certificate of conformity. You can use the Assist button next to the field to open the card of the certificate itself.
Post transfers automatically#
Another new feature is that you can have the receipt of transfer orders posted at the same time as their shipment. This can be useful, for example, when you have no staff member who could confirm receipt at the destination.
You can use standard or KUMAVISION functionality for direct transfer orders, the difference being that when you choose the default option, you cannot ship or receive only part of an order.
With the KUMAVISION option, on the other hand, the system also posts partial receipts and shipments. To set up the feature:
- Choose the Search icon, enter Inventory Setup, and then choose the related link.
- On the Numbering FastTab, in the Direct Transfer Setup field, select the option you want to use (Microsoft Direct Transfer or KUMAVISION base Direct Transfer).
- In the Direct Transfer Posting field, select Direct Transfer for standard functionality. For the KUMAVISION base extension, select Receipt and Shipment.
However, for the KUMAVISION base function to work, you must also turn on the feature for a location:
- Open a location card.
- On the General FastTab, turn on the Auto Post Transfers toggle.
The toggle is then set automatically on transfer orders to which this location is assigned.
Get source document lines#
In Microsoft Dynamics 365 Business Central1, you can use the Get Source Documents function to retrieve source data for the following inventory and warehouse documents:
- Inventory Put-Away
- Inventory Pick
- Whse. Receipt
- Whse. Ship
All lines that still need to be received or shipped are then copied there. Lines that aren’t required must be deleted manually. The new Get Source Document Lines function extends standard functionality to include filter options for the lines of source documents. Grouped by type of document, the lines can then be filtered, for example, by item numbers so that only part of a document is retrieved.
Post during inventory counts#
Standard functionality allows you to post to locations even during physical inventory counts. To prevent this, you can now specify that items can only be posted to other locations or not all during stocktaking.
- Choose the Tell Me function, enter Inventory Setup, and then choose the related link.
- Turn the Allow Posting of Items in Physical Inventory on or off.
Deactivating the toggle means you cannot post any item that is currently stored in a physical inventory journal or on an inventory order. Items that aren’t can be used for posting, however.
Activate the toggle if you want to allow items to be posted to other locations. As an example, you might need to take stock in Warehouse 1 but want to continue working in Warehouse 2.
Get blocked items or variants#
Typically, blocked items or item variants cannot be used in physical inventory journals.
This means that they aren’t copied to a journal, for example, when you run the Calculate Inventory action from it, and you cannot enter them manually on the lines either. You also aren’t notified whether some are still in inventory despite being blocked.
In KUMAVISION base (Booster), you can use a ribbon function to specify items that would typically be unavailable but must be included in a count temporarily:
- Open a physical inventory journal.
- On the ribbon, choose Get Blocked Items/Variants.
- On the page that opens, you can select the items you want to unblock, and then choose Unblock Items/Variants to include them in a count.
Afterward, the items or variants remain unblocked on the page until you select them again and choose Block Items/Variants.
Note
Rerunning the function clears the current page, however. This means that any items that you didn’t re-block before exiting the page will remain available in the system.
The lines on the page contain the fields described in the following table. You cannot change any of them manually.
Field | Description |
---|---|
Journal Template Name | Specifies the name of the journal template that the line is associated with. This field is relevant only to users working with multiple physical inventory journals at once. |
Journal Batch Name | Specifies the name of the journal that the line is associated with. This field is relevant only to users working with multiple physical inventory journals at once. |
Line No. | Specifies the number of the line, in steps of 100. |
Item No. | Specifies the number of the blocked item. |
Variant Code | If available, specifies the item variant that is blocked. |
Blocked By | Specifies if the item or variant was blocked because of a failed field check or because a user did so manually. |
Blocked (User) | If the item or variant was blocked by a user, specifies the ID of the person who blocked it. |
Item Jnl. Variant Block | Specifies if the item variant is blocked in an item journal. |
Unblocked (Temp.) | Specifies if the line was unblocked by using the Unblock Items/Variants function. With the field selected, the item or variant shown on the line can be manually entered in a physical inventory journal or be filled in by running the Calculate Inventory action. |
Unblocked (Temp.) At/On | Specifies when the Unblock Items/Variants function was run. |
Unblocked (Temp.) By | Specifies who ran the Unblock Items/Variants function. |
Created On | Specifies when the Get Blocked Items/Variants function was run. |
Created By | Specifies who ran the Get Blocked Items/Variants function. |
We recommend that you first use the Get Blocked Items/Variants action to fill in the page, then select the lines that you want to unblock and run the Unblock Items/Variants function from the ribbon.
Afterward, you can add the lines to the relevant journal manually (or choose Calculate Inventory on the ribbon) before completing the count and running the Block Items/Variants function to block the items again.
Note
To be able to use unblocked items or variants on sales or purchase documents, the Sales or Purchasing Blocked toggle must also be turned off on the associated item or variant cards.
Inventory#
Overview#
The Inventory Summary page provides you with a comprehensive overview of what inventories you have and what tracking information is available for them.
This means that the summary includes all items and item variants, as well as their tracking codes in the form of lot, serial, and package numbers, sorted by location, zone, and bin. Quantities are shown in the relevant item’s base unit of measure and, if you’re using advanced warehouse functionality, put-away unit.
Note
For locations that don’t need bins, the quantity is shown per serial number if the SN Specific Tracking toggle is turned on for the tracking code assigned to the item. For locations where bins are mandatory, inventory is shown by serial numbers if the SN Warehouse Tracking toggle is activated instead.
The same applies to lot and package numbers and their toggles.
Setup#
To turn on the feature:
- Choose the Search icon, enter Inventory Setup, and then choose the related link.
- Fill in the fields on the Inventory Summary FastTab as described in the following table.
Field | Description |
---|---|
Auto Create Inventory Summary | Turn on this toggle if you want the overview to be kept up to date by the system. When the toggle is turned on, an initial summary is created based on all inventory movements that have already been posted. You can turn the toggle off again if you notice that the real-time updates are slowing down the app. You can then still update the overview, albeit manually, by using the Refresh Summary action. |
Include Adjustment Bins in Summary | Turn on this toggle if you want the summary to also display all quantities entered in adjustment bins (see the Adjustment Bin Code field on the relevant location card). |
Include Negative Inventory in Summary | Turn on this option if you want the summary to also show any negative inventory quantity that might exist. |
Inventory summary#
To see the items your business currently has in stock, choose the Search icon, enter Inventory Summary, and then choose the related link. The values you see on the page are described in the following table.
Note
You might need to use the Personalize function to unhide some of the fields that will be described in this table.
Field | Description |
---|---|
Entry No. | Shows the unique number of the entry, assigned from a number series when the entry was created. |
Location Code | Specifies the location that inventory is shown for. |
Zone Code | Specifies the zone that inventory is shown for. |
Bin Code | Specifies the bin that inventory is shown for. |
Item No. | Shows the number of the item specified on the line. |
Variant Code | Shows the code of the item variant specified on the line. |
Lot No. | Shows a lot number if one is specified for the posted item. |
Serial No. | Shows a serial number if one is specified for the posted item. |
Package No. | Shows a package number if one is specified for the posted item. |
Description | Specifies the description of the item. |
Description 2 | If available, specifies the additional description of the item. |
Quantity | In advanced warehousing configurations, specifies the item quantity in the put-away unit of measure. In all other configurations, specifies the quantity in the item’s base unit of measure. |
Unit of Measure Code | In advanced warehousing configurations, shows the put-away unit of measure assigned to the item. In all other configurations, specifies the item’s base unit of measure. |
Qty. per Unit of Measure | Specifies the inventory quantity in the item’s base unit of measure in relation to its put-away unit. |
Quantity (Base) | Specifies the item quantity in the base unit of measure. |
Item Blocked | If selected, specifies that transactions with the item cannot be posted, for example, because it is in quarantine. |
Mvmt. Blocked (Bin) | Specifies if the associated bin does not allow outbound or inbound transfers, or both. |
Mvmt. Blocked (Bin Content) | Indicates if the associated bin content cannot be used in inbound or outbound transfers, or both. |
Inventory Blocked | Specifies whether transactions with this inventory can be posted. The field is only selected if: • Item Blocked is selected. • Bin Blocked is set to Outbound or All. • Mvmt. Blocked (Bin) is set to Outbound or All. • Iten Trkg. Blocked is selected. |
Item Trkg. Blocked | If selected, at least one of the tracking information cards associated with the inventory (that is, the Lot No. Information Card, Package No. Information Card, or Serial No. Information Card) is blocked. |
Dedicated | If selected, specifies that the inventory in the associated bin cannot be picked to meet demand from orders elsewhere. |
Bin Ranking | Shows the priority of the associated bin. |
Bin Mandatory | Indicates if the Bin Mandatory toggle is turned on for the location at which the item is stored. |
Lot Specific Tracking | Indicates if the Lot Specific Tracking toggle is turned on for the item on the associated Item Tracking Code Card. |
Lot Warehouse Tracking | Indicates if the Lot Warehouse Tracking toggle is turned on for the item on the associated Item Tracking Code Card. |
SN Specific Tracking | Indicates if the SN Specific Tracking toggle is turned on for the item on the associated Item Tracking Code Card. |
SN Warehouse Tracking | Indicates if the SN Warehouse Tracking toggle is turned on for the item on the associated Item Tracking Code Card. |
Package Specific Tracking | Indicates if the Package Specific Tracking toggle is turned on for the item on the associated Item Tracking Code Card. |
Package Warehouse Tracking | Indicates if the Package Warehouse Tracking toggle is turned on for the item on the associated Item Tracking Code Card. |
Ribbon functions#
Function | Description |
---|---|
Item Card | Opens the item card associated with the selected record. |
Variant Card | Opens the variant summary, filtered to the item number and variant code that is entered on the selected record. Note This ribbon action is only shown if a variant code is assigned to the record. |
Lot Information Card | Opens the lot number information card that is linked to the selected record. Note This ribbon action is only available if a lot number is assigned to the record. You see an empty page if no card exists. |
Serial No. Info Card | Opens the serial number information card linked to the selected record. Note This ribbon action is only available if a serial number is assigned to the record. You see an empty page if no card exists. |
Package No. Info Card | Opens the package number information card linked to the selected record. Note This ribbon action is only available if a serial number is assigned to the record. You see an empty page if no card exists. |
Bin | Opens the bin summary, filtered to the location and bin code that is entered on the selected record. Note This ribbon action is only shown if a bin is assigned to the record. |
Note
None of these actions can be run if you select multiple records at once.
For base data and on documents#
You can also see a filtered summary of available inventory by running the Inventory Summary action from the following pages:
Run from | Summary filtered to |
---|---|
Items | Item number |
Item Card | Item number |
Item Variants | Item variant |
Item Variant Card | Item variant |
Stockkeeping Units | Item number, variant code, and location |
Stockkeeping Unit Card | Item number, variant code, and location |
Lot No. Information List | Item number, variant code, and lot number |
Lot No. Information Card | Item number, variant code, and lot number |
Serial No. Information List | Item number, variant code, and serial number |
Serial No. Information Card | Item number, variant code, and serial number |
Package No. Information List | Item number, variant code, and package number |
Package No. Information Card | Item number, variant code, and package number |
Bins | Location code, zone code, and bin code |
Bin Content/Bin Contents | Location code, zone code, bin code, item number, variant code, and unit of measure code (the exact filters depend on the page that the action is run from) |
Purchase Order (Lines FastTab) | Location code, item number, and variant code (as entered on the line) Note Here, the action can only be run for lines of type Item. |
Sales Order (Lines FastTab) | Location code, item number, and variant code (as entered on the line) Note Here, the action can only be run for lines of type Item. |
Transfer Order (Lines FastTab) | Outbound location (Transfer-from Code), item number, and variant code (as entered on the line) |
Released Production Order (Lines FastTab) | Item number, variant code, location code, and bin code (as entered on the line) |
Production Order Components | Item number, variant code, location code, and bin code (as entered on the line) |
Assembly Order (Lines FastTab) | Item number, variant code, location code, and bin code (as entered on the line) |
Warehouse Receipt (Lines FastTab) | Item number, variant code, location code, and bin code (as entered on the line) |
Warehouse Shipment (Lines FastTab) | Item number, variant code, location code, and bin code (as entered on the line) |
Internal Movement (Lines FastTab) | Item number, variant code, location code, and From Bin Code (as entered on the line). |
Warehouse Put-away (Lines FastTab) | Item number, variant code, location code, and bin code (as entered on the line) |
Warehouse Pick (Lines FastTab) | Item number, variant code, location code, and bin code (as entered on the line) |
Inventory Movements (Lines FastTab) | Item number, variant code, location code, and bin code (as entered on the line) |
Warehouse Movements (Lines FastTab) | Item number, variant code, location code, and bin code (as entered on the line) |
Item Journals | Item number, variant code, location code, and bin code |
Item Reclassification Journals | Item number, variant code, location code, and bin code |
Physical Inventory Journals | Item number, variant code, location code, and bin code |
Warehouse Item Journal | Item number, variant code, location code, and bin code |
Warehouse Reclassification Journals | Item number, variant code, and location code |
Warehouse Physical Inventory Journal | Item number, variant code, and location code |
Warehouse Internal Put-away (Lines FastTab) | Item number, variant code, location code, and From Bin Code (as entered on the line). |
Warehouse Internal Pick (Lines FastTab) | Item number, variant code, and location code (as entered on the line). |
Movement Worksheets | Item number, variant code, location code, From Zone Code, and From Bin Code (as entered on the line) |