The external vendor catalog can contain millions of potential items which could be converted. Some customers may also have more than one provider they use to access these items, including items added by using custom price sheet imports. This potential volume can lead to issues with the catalog if some vendor lines or items are duplicated.
When using providers such as trade service, the standard way to get your stock pricing into the catalog is to submit those price sheets to trade service so they show up in the catalog_custom_price1 field in the updates.
Catalog provided data can also run into the issue where UOM values provided by the manufacturer may be problematic for a distributor. One example is the manufacturer provides trade service with item information with a minimum qty of per case, but the distributor regularly sends purchase orders with a quantity less than the requirements provided by the pricing service.
To help resolve these sorts of issues related to stocking items, we have added a catalog cost (i.e., CatCost) table. The way the CatCost table works is that all stock items can be added to this table, and then on convert or update the system will check this table to see if a stored cost exists. If a stored cost does exist, the system will use these values for stock items with known costs. Populating this table can be used in lieu of sending your costing information to a 3rd party (i.e., the service provider), and it also will help protect your converted items from being updated for both TS and custom price sheets with different costs. It also has the side benefit of using a wholesale price as a basis for commissions, while still maintaining a separate value for PO costing.
The CatCost table is optional, the functions are configured to check the CatCost table first, but if the data does not exist then the normal external vendor catalog settings and data would be used instead.
The xWDCatCost table can be populated before the item is converted or after and maintained in one table that will be used to manage costing across the application when process controls dictate that multiple costs have to be maintained to reflect true cost of items sold and purchased.
Table 1.1. xWD CatCost Table
Source Field | Target Field | Default use | Description |
---|---|---|---|
catcost_item_id | Item_id | Item_id from the item table | For reference only to the item after conversion. |
catcost_item_number | item_number | Item number of the converted item that should be updated. | Item number is one of the fields that is checked when an update is run to make sure the item should be updated. |
catcost_wholesale_price | Item_listcost | If you currently have or want to use the setting: Use wholesale price for unit cost for markups then this field should be populated. | The setting for WholeSale Price can be found under / / tab. You can use this field to maintain a separate cost for sales commissions basis and PO cost, this would be used as the sales order unit cost for commissions with the setting enabled. |
catcost_price_uom | item_price_uom_id | This can be used to replace the UOM provided by the vendor with a custom UOM. | If a custom UOM is used, then the wholesale price and the list price should both reflect this UOM value. |
catcost_po_cost | itemsrcp_price | This will be used as the PO cost for the item. | This can be used to maintain a separate cost for commissions and vendor purchasing. |
catcost_po_uom | itemsrc_vend_uom | This will be used as the PO UOM for the item. | This can be used to maintain a separate UOM for the purchasing side. |
catcost_itemsrc_qtybreak | itemsrcp_qtybreak | 1 if no QTY break exists. | Sets the QTY break if applicable for your item. |
catcost_vendor_number | itemsrc_vend_id | Sets which vendor the PO record should apply to. | You can find this value on the vendor record in the field vendor number. |
catcost_cost_invvendoruomratio | itemsrc_invvendoruomratio | Ratio between the inventory UOM and vendor PO UOM. | If your purchasing UOM is not the same as your inventory UOM, then populate the value the PO UOM should be divided by to the proper inventory to vendor UOM value. |
catcost_warehous_id | itemsrcp_warehous_id | Sets the warehouse ID for the PO cost and UOM. | Use this field to set per warehouse costs for items if you have different costs per warehouse. If blank the data will apply to all warehouses. |