Jovix to Smart Materials - Intergraph Smart Materials - 10.5 - Administration & Configuration - Hexagon

The following information flow happens from Jovix to Smart Materials:

• Receipt (MRR header in Smart Materials).

• Receipt items (MRR line items in Smart Materials).

• The following MRR types are supported:

  • MRR by PO.

  • MRR by RN.

  • Direct MRR.

  • MRR by Packages (Receipts created in Jovix that are based on Traffic Shipments are integrated as MRR by Packages in Smart Materials).

• MRR is posted in Smart Materials.

MRR functionality is supported only on the Jovix mobile app.

Data Mapping

The following table lists the data integration between Smart Materials and Jovix.

Triggering points

• Receipt status in Jovix is set to Complete.

  You cannot edit a Receipt once the status of the Receipt is set to Complete.

Prerequisites

Before beginning the integration ensure the following:

1. The status used in Jovix must have a same name mapping in Smart Materials Site Materials Status screen.

   Smart Materials restricts the status name to a maximum limit of 10 characters. In case of MRRs, if the exact status name match is not found in Smart Materials, status value will be picked from project default ZC_STATUS.

2. For Direct MRRs, configure the CIP MI_JVX_PCK_CUSTOM.create_ident to define the logic for new ident creation in Smart Materials during MRR integration from Jovix.

3. Set ZB_UNIT to fetch the unit of quantity of a direct receipt item. If unit id is null, the application tries to fetch the unit id from M_PCK_REQ_CUSTOM.qty_unit function based on the ident value. If no value is set by this function then application checks for the project default ZB_UNIT_ID. If a value is not set in the project default ZB_UNIT_ID then the application throws an error.

4. To create MRR by PO in Jovix, Purchase Order must be integrated from Smart Materials to Jovix and the PO ownership must be transferred to Jovix.

5. Similarly to create an MRR by RN in Jovix, RN must be integrated from Smart Materials to Jovix and RN ownership must be transferred to Jovix.

6. To receive traffic shipments in Jovix, Traffic Shipments must be integrated from Smart Materials to Jovix.

7. The project default ZC_BIN_LOC must be set to WHTU.

8. Over Short Damage (OSD) in Smart Materials are created based on the project default ZC_CR_OSD. OSD rule must be defined in Smart Materials to create valid OSDs.

9. In Smart Materials, assign the USID to the project default ZI_JX_MRRU to create a MRR in the discipline that is derived from the USID.

   Alternatively, the USID logic can be configured using the CIP MI_JVX_PCK_CUSTOM.get_us_id. By default, this CIP fetches value from the project default ZI_JX_MRRU.

   

   • get_us_id function returns Smart Materials us_id for a given Smart Materials project and Jovix entity-type. us_id is required for MRR (Receipt) creation in Smart Materials while integrating data from Jovix.

   • get_mrr_recv_qty function decides whether the received quantity should be based on either Jovix packingList quantity, Jovix received quantity, Smart Materials expected quantity, or jovix status.

10. Configure CIP MI_JVX_PCK_CUSTOM.get_mrr_recv_qty to define the logic for received quantity for integration to Smart Materials.

11. During the integration of a Receipt Item, if the Jovix location does not exist in Smart Materials, then a new warehouse/location with the same name is created in Smart Materials.

    • Only two levels of Jovix location heirarchy is supported for integration. In Smart Materials the root node is considered as a warehouse and the child node is considered as a location.

    • In case there is no heirarchy for a Jovix location, then the warehouse and location are created in Smart Materials using the same Jovix location value.

    • After a new warehouse is created in Smart Materials, the warehouse is assigned to the same user who created the MRR (ZI_JX_MRRU).

    • The Use for issue field for the newly created warehouse is marked Yes.

    The warehouse/location name can not exceed 30 characters.

Receipt integration

1. If the Receipt is created against an SRN in Jovix, MRR by Release Notes is created in Smart Materials.

2. If the Receipt is created against a Purchase Order in Jovix, MRR by Purchase Order is created in Smart Materials.

3. If the Receipt is created against traffic shipment in Jovix then, MRR by Package(s) is created in Smart Materials.

   Once you start receiving traffic shipments in Jovix then, you cannot edit/revert the traffic shipments in Smart Materials.

4. If a direct receipt is created in Jovix then a Direct MRR is created in Smart Materials. You can create Direct MRRs using existing/new Smart Material idents and tag numbers.

   If unit id is null, the application tries to fetch the unit id from M_PCK_REQ_CUSTOM.qty_unit function based on the ident value. If no value is set by this function then application checks for the project default ZB_UNIT_ID. If a value is not set in the project default ZB_UNIT_ID then the application throws an error.

   If catalog item used for Direct MRR in Jovix does not exist, a new ident is created in Smart Materials. Creation of the ident is done based on the logic present in the function create_ident of the custom package mi_jvx_pck_custom. You can customize the function as per your requirement. The default logic of the custom function is as follows:

   • If a catalog item has a tag number, a new ident is created using the following:

     • Item type Tag with Milestone (TWM).

     • Commodity Part from the project default ZB_TAGPART.

     The ident code in Jovix Catalog Item is replaced by the ident code that this function returns.

   • If a catalog item does not have a tag number and if the:

     • Commodity code defined under catalog item exists in Smart Materials, a new ident is created under this commodity code, else a new commodity code is created using the Part defined in the project default ZI_JX_PART.

     • Commodity code is empty, a new ident is created under the Commodity Code defined in the project default ZI_JX_CC.

   • The catalog item details in Jovix are updated once the ident is updated in Smart Materials.

   Only receipts of projects that have the project default ZI_JX_PROJ defined are integrated with the corresponding SMAT project.

5. Receipts (MRRs) that are integrated from Jovix are created and posted in Smart Materials using the Jovix receipt name.

   From versions 10.4 SP1 and 10.5, when a receipt is integrated from Jovix to Smart Materials then, the receipt numbering in Smart Materials is based on the project default ZI_JX_NUMR, This project default takes the following values:

   • No - (Default) MRR is integrated to Smart Materials with the Jovix Receipt Id.

   • Yes - MRR is integrated to Smart Materials with the Smart Materials numbering rule and the Jovix receipt Id is updated with the newly created MRR number.

6. If the project default ZC_CR_OSD value is set to Y, OSDs of type Shortage/Overage are created using MRR by PO and MRR by RN.

7. By default, receipt items with zero quantity or with status Damaged are not integrated. You can define the logic in the CIP MI_JVX_PCK_CUSTOM.get_mrr_recv_qty.

8. In case of an failure to integrate then, the data is rolled back and the receipt status is set to Open in Jovix. You can fix the errors listed in the log file and set the receipt to Complete to complete the integration.

Log files

You can check the integration status and logs in the Jovix Integration Report in Smart Materials and Smart Materials Web. The log files are saved in the path defined under the project default ZI_JX_LOG (from versions 10.3 and higher) or in the DBA setting LOG_FILE_DEST. The naming format of the log files for Jovix Receipts/MRR is as follows:

JOVIX_MRR_<Jovix receipt ID>_<Date in dd-mm-yyyy_Time in hhmmss>.log