DocMart Inventory integration with Midnight MIS Follow
This article reviews what the inventory integration with Midnight does and how to set it up with price requests or without them.
MIS ItemID and how to use it with Midnight
The MIS ItemID is expecting a specific format depending on what you are trying to accomplish. There are three numbers to be interested in and they are used in specific formats and combinations.
Format: InventoryItemID-ServiceID-ProjectTypeID
- InventoryItemID
- This is used when you are not going to be doing any price requests/If you are not using ProjectTypeID. If you do plan on MyOrderDesk requesting Price from Midnight leave this number blank. However, if you are not doing price requests but still want Midnight inventory to be adjusted by ordering them this allows Midnight to make inventory adjustments when orders are submitted from MyOrderDesk. If you use BOTH InventoryItemID and ProjectTypeID together you can end up in a situation where you take double the intended amount of inventory, so only use one. NOTE: The inventory Item needs to either belong to the correct customer or needs to be a global item. In Midnight, associated inventory items will be Reserved on the Order. You will still need to follow Midnight inventory deduction logic to reduce the on hand balance and actually pull the quantity used.
- ServiceID
- Allows override of default ServiceID for order submission. You will only use this ID if your ServiceID for the global setting can not be used.
- ProjectTypeID
- Allows pricing requests from Midnight to MyOrderDesk. You will only be using this number if you want Midnight to calculate a cost based on a Print Template. NOTE: Prefix wide format project type ids with "
WF" (e.g.,WF22).
- Allows pricing requests from Midnight to MyOrderDesk. You will only be using this number if you want Midnight to calculate a cost based on a Print Template. NOTE: Prefix wide format project type ids with "
Below are some examples of MIS ItemIDs and why they might be used.
- 91254--
- This only has InventoryItemID. Both ServiceID and ProjectTypeID are left blank. The result is this item will adjust Inventory levels in midnight and the default pricing from MyOrderDesk will be used. Also, the default ServiceID will be used.
- 91254-1236-
- This has InventoryItemID and ServiceID. The result is this item will adjust Inventory levels in midnight and the default pricing from MyOrderDesk will be used. Also, the default ServiceID will be overridden and set to 1236.
- -1236-WF32154
- This has ServiceID and ProjectTypeID. The result is this item will adjust Inventory levels in midnight and the pricing from midnight can be requested. Also, the default ServiceID will be overridden and set to 1236.
- 91254-1236-3215
- This has InventoryItemID, ServiceID, and ProjectTypeID. The result is this item will adjust Inventory levels in midnight twice. Once for the Print Template 3215 and another for the inventory item 91254. In most cases, this would not be the desired result and something to keep in mind. Also, the pricing from midnight can be requested and the default ServiceID will be overridden and set to 1236.
Configuring your Order Form to use the ProjectTypeID
Now that you have some items and you would like to start requesting the price from midnight for the order you need to set up your Order Form. In the Cart setting, you will want to Select your DocMart field for the ProjectTypeID setting, see the screenshot for an example. IF you set this field and your items do not have a ProjectTypeID inside your MIS ItemID, it can cause issues, so do not use this field if you are not intending on requesting a price. If you are not planning on using price requests just setting your item up with an InventoryItemID is enough, you do not need to further configure that.
