Performing consistency checks and repairs – Logistics tab

All

Select this to perform the diagnostic check for all transactions in open and close periods.

Only in open periods

Select this to perform the diagnostic check for all transactions in open periods only.

Note:If you have selected this option, the Financial year and Period fields will be disabled.

Financial year

Select the financial year range to perform the diagnostic check. Select the All check box to perform the diagnostic check for both open and closed transactions for all the financial years.

Note: If you select the All check box, the Financial year and Period fields will be disabled.

Period

Select the period range to perform the diagnostic check. Select the All check box to perform the diagnostic check for both open and closed transactions for all periods.

Note: This field is enabled only if one single year has been selected at the Financial year field, for example, from 2003 to 2003) and the All check box is cleared.

Financial check box

Select this check box to perform the diagnostic check on financial transactions only.

Logistics check box

Select this check box to perform the diagnostic check on logistics transactions only.

Project check box

Select this check box to perform the diagnostic check on project transactions only.

1. Incorrect item definition

Check:
Checks for the definition of the item including:

• the ItemType field of item
• the Serial and Batch attributes of the item
• the Explode-Fulfillment attribute of the item
• the description of the missing item
• the description of the missing item group
• the internal uses without the company number
• all existing make items that do not have a main version for the existing bill of materials (BOM) version(s) defined in the item

Repair:
If inconsistencies are found, the following repairs will be performed: 

• the ItemType field is updated to value “N” when “Condition” = “D”; “T” when “Condition” = text item; “V” when it is a sales item
• the structure of the Serial and/or Batch attributes of items will be repaired 
• the Explode - Fulfillment check box is cleared if no structure is linked to the item
• the blank item description field will be filled with the item code
• the blank item group description field will be filled with the item group code 
• internal uses without the company number will be updated with the company number
• the first BOM version will become the main version for the make item

2. Incorrect master data

Check:
Checks for wrong master data including:

• the missing unknown creditor code (000000) in the administration
• the missing phantom item code created for delivery methods and payment conditions, phantom item with incorrect type in the Items table
• the missing MRP budget scenario
• identifying project that self-references itself as the parent project in the Project table
• the recipe item missing from item
• the missing item in item account
• account code of the ItemAccounts table that does not match with the cmp.wwn of the cicmpy table
• the missing supplier in the cicmpy table but found in the ItemAccounts table
• the missing notes from bacodiscussion in the recipe table

Repair:
If inconsistencies are found, the following repairs will be performed:

• create the unknown creditor code (000000) if this is found missing in the administration
• create the item code for payment conditions and delivery methods, update item type to phantom item
• create the MRP budget scenario
• remove parent project from project
• create the missing item
• update account code from the ItemAccounts table with cmp.wwn from the cicmpy table
• create the missing supplier
• remove link from the recipe table

3. Incorrect attribute in payment condition master data

Check:
Checks for all payment conditions which have the Print on order and Explode - Fulfillment check box is selected.

Repair:
The wrong attribute of the payment condition is repaired through which the Print on order check box is now cleared. The wrong attribute of Explode -  Fulfillment is repaired by clearing the Explode - Fulfillment check box.

4. Missing general ledger accounts for item master data

Check:
Checks for the item master data which are not linked to the Revenue, Stock, and Cost of goods sold general ledger accounts.

Repair:
The missing general ledger accounts will be filled based on the general ledger accounts of the item group associated to the item master data concerned.

5. Orders with MRP lines without order header and order lines

Check:
Checks for all the existing orders that include purchase orders, sales orders, quotations, Return Material Authorization (RMA) orders, Return to Vendor (RTV) orders, and blanket purchase orders which have the MRP lines but do not have the order header and order lines.

Repair:
For the MRP line that is not invoiced and fulfilled, the orders will be deleted. However, for the MRP line that is invoiced or fulfilled, the order header and order lines will be created through the validation server.

6. Orders with order and MRP lines without order header

Check:
Checks for all the existing orders that include purchase orders, sales orders, quotations, Return Material Authorization (RMA) orders, Return to Vendor (RTV) orders, and blanket purchase orders which have the order and MRP lines but do not have the order header.

Repair:
For the MRP line that is not invoiced and fulfilled, the order and MRP lines will be deleted. However, for the MRP line that is invoiced or fulfilled, the order header will be created through the validation server.

7. Orders with order header and MRP lines without order lines

Check:
Checks forall the existing orders that include purchase orders, sales orders, quotations, Return Material Authorization (RMA) orders, Return to Vendor (RTV) orders, and blanket purchase orders which have the order header and MRP lines but do not have the order lines.

Repair:
For the MRP line that is not invoiced and fulfilled, the order header and MRP lines will be deleted. However, for the MRP line that is invoiced or fulfilled, the order lines will be created through the validation server.

8. Orders with order lines without order header and MRP lines

Check:
Checks for all the existing orders that include purchase orders, sales orders, quotations, Return Material Authorization (RMA) orders, Return to Vendor (RTV) orders, and blanket purchase orders which have the order lines but do not have the order header and MRP lines.

Repair:
The order lines will be deleted.

9. Orders without MRP lines

Check:
Checks for all the existing orders that include purchase orders, sales orders, quotations, Return Material Authorization (RMA) orders, Return to Vendor (RTV) orders, and blanket purchase orders which have the order header and order lines but do not have the MRP lines.

Repair:
The missing MRP lines will be created.

10. Orders with order header without order and MRP lines

Check:
Checks for all the existing orders that include purchase orders, sales orders, quotations, Return Material Authorization (RMA) orders, Return to Vendor(RTV) orders, and blanket purchase orders which have the order header but do not have the order and MRP lines.

Repair:
The order header will be deleted.

11. All sales order lines are completed but the order is not set to be completed

Check:
Checks for sales orders which have all the order lines completed but the orders are not set to completed status.

Repair:
The status of the orders are set to completed.

12. Not all sales order lines are completed but the order is set to be completed

Check:
Checks for sales orders which the order status is set to completed although not all the order lines are completed.

Repair:
The status of the orders are set to incomplete. However, there is an exception for sales orders with zero total amount. Order lines of such orders will be updated to completed, and the status of the orders will remain as completed.

13. Comparison of order lines against MRP lines

Check:
Checks for consistency of data between the order and MRP lines on the following fields:

• Ordered quantities
• Delivered quantities
• Invoiced quantities
• Amount
• Fulfillment date
• Order status
• Invoice status

Repair:
If the data is found to be different, the data in the MRP lines will be recalculated and updated to reflect the data in the order lines.

14. Open orders with missing terms

Check:
Checks for open orders which include purchase orders, sales orders, quotations, Return Material Authorization (RMA) orders, and Return to Vendor (RTV)  
orders which do not have payment terms.

Repair:
The payment terms will be created.

15. Allocated stock: planned fulfillments versus fulfillments

Check:
Checks for imbalance of allocated stock between planned and actual fulfillments. The diagnostic tool will compare the following criteria to detect
inconsistencies between the planned and actual fulfillments:

• item code
• order number
• our ref.
• GL accounts
• allocation number
• quantities
• warehouse

Repair:
If inconsistencies are detected, the allocation link between the planned and actual fulfillments is then deleted.

16. Allocated stock: planned receipts versus receipts

Check:
Checks for imbalance of allocated stock between planned and actual receipts. The diagnostic tool will compare the following criteria to detect inconsistencies between the planned and actual receipts:

• item code
• warehouse
• order number
• our ref.
• GL accounts
• allocation number
• quantities
• warehouse

Repair:
If inconsistencies are detected, the allocation link between the planned and actual receipts is then deleted.

17. Allocated stock: receipts versus (planned) fulfillments

Check:
Checks for imbalance of allocated stock between actual receipts and actual and/or planned fulfillments. Allocation is considered imbalanced if:

• the allocated fulfillment has a link which cannot be found in the receipt
• the allocated receipt has a link that cannot be found in the fulfillment
• the allocated fulfillment has a link but the receipt does not link back to the fulfillment
• the allocated receipt has a link but the fulfillment does not link back to the receipt
• the allocated quantities of the fulfillment do not match the quantities of the receipt
• the allocated quantities of the receipt do not match the quantities of the fulfillment

Repair:
Allocation of transactions related to the receipt is deleted.

18. Allocated stock: fulfillments versus receipts

Check:
Checks for imbalance of allocated stock between the actual fulfillments and actual receipts. Allocation is considered imbalanced if:

• the allocated fulfillment has a link which cannot be found in the receipt
• the allocated receipt has a link which cannot be found in the fulfillment
• the allocated fulfillment has a link but the receipt does not link back to the fulfillment
• the allocated receipt has a link but the fulfillment does not link back to the receipt
• the allocated quantities of the fulfillment do not match the quantities of the receipt
• the allocated quantities of the receipt do not match the quantities of the fulfillment

Repair:
Allocation of transactions related to the fulfillment is deleted.

19. Allocated stock: planned fulfillments versus (planned) receipts

Check:
Checks for imbalance of allocated stock between planned fulfillments and actual and/or planned receipts. Allocation is considered imbalanced if:

• the allocated fulfillment has a link which cannot be found in the receipt
• the allocated receipt has a link which cannot be found in the fulfillment
• the allocated fulfillment has a link but the receipt does not link back to the fulfillment
• the allocated receipt has a link but the fulfillment does not link back to the receipt
• the allocated quantities of the fulfillment do not match the quantities of the receipt
• the allocated quantities of the receipt do not match the quantities of the fulfillment

Repair:
Allocation of transactions related to the planned fulfillment is deleted.

20. Allocated stock: planned receipts versus (planned) fulfillment

Check:
Checks for imbalance of allocated stock betwwen planned receipts and actual and/or planned fulfillments. Allocation is considered imbalanced if:

• the allocated fulfillment has a link which cannot be found in the receipt
• the allocated receipt has a link which cannot be found in the fulfillment
• the allocated fulfillment has a link but the receipt does not link back to the fulfillment
• the allocated receipt has a link but the fulfillment does not link back to the receipt
• the allocated quantities of the fullfillment do not match the quantities of the receipt
• the allocated quantities of the receipt do not match the quantities of the fullfillment

Repair:
Allocation of transactions related to the planned receipt is deleted.

21. Update warehouse locations, sales units and projects on item transactions

Check:
Checks for item transaction on warehouse location, sales units, and projects including:

• item transactions which do not have warehouse location if the Warehouse locations functionality is enabled under the Fulfillment section at System à General à Settings à Inventory settings
• related data from assets(ItemNumbers) for which the assest is linked to and item and the indication of the batch item is equal to 1, as well as the assests is a batch asset (ItemNumbers - classification = "B").
• invoices, invoice lines, invoice history, invoice history lines, sales orders, sales order lines, delivery notes, and general ledger transactions that are linked to an invalid project
• items are filled with sales unit or if an item is filled with a valid sales unit
• the incorrect budget type for transactions classified as labor hour and the transactions are originated from the E-Job cost or E-Stock and Purchase modules
• assets which are not linked to debtors, asset classification which is sales or contract, and asset type filled

Repair:

• If inconsistencies are found, the following repairs will be performed:
• updating of the warehouse location in the general ledger transactions
• updating of the asset quantity to be based on the summation quantity received for which the asset ID (ItemNumbers - HID) is equal to the asset ID if the asset's quantity (ItemNumbers - quantity) is different with the summation quantity received (QtyReceived) based on the data retrieved while running the check
• updating of the project number for invoices, invoice lines, invoice history, invoice history lines, sales orders, sales order lines, delivery notes, and general ledger transactions which are found to be linked to an invalid project number
• entering the default sales unit for the missing sales unit while the invalid sales unit will be updated to “-“ (Other)
• updating the general ledger transaction on transaction subtype to fulfillment
• removal of the incorrect assets

22. Status update of internal use entries

Check:
Checks for incorrect status of internal use entries which have zero quantity of item and the internal use entries have not been fulfilled for non-hour item only.

Repair:
The incorrect status will be corrected to fulfilled.

23. Wrong production orders status

Check:
Checks for incomplete production orders in which none of the lines have a completed status although some actual quantities are found to have already been issued/received. This inconsistency is found in production orders created in Exact Globe batch 325 where the incorrect quantity and status are recorded for the partial issuance and receipt of production orders.

Repair:
Production order lines will be updated with their status set to completed based on the actuals found and the lines will be split in case of partial realization.

24. Purchase price lists conversion

Check:
Checks for outdated purchase price list codes in administrations that were converted from batch 327 or older to Exact Globe. To be able to work with Exact Globe, the outdated price list codes, for example PURCHASE_EUR, must be converted to the latest price list codes like P_EUR.

Repair:
All purchase price lists which have the outdated code of PURCHASE_XXX will be updated to P_XXX.

25. Incorrect invoiced quantity in sales order lines

Check:
Checks for sales orders which have incorrect invoiced quantity in the sales order lines when you delete a partial invoice for a sales order. This inconsistency occurs in the previous versions of Exact Globe up to batch 342. As a result of this inconsistency, when deleting a partial invoice, all the  sales order invoiced quantities are reset. This creates a situation that when you do a new partial fulfillment, all the sales order lines will be invoiced  again. Starting from batch 350, when you delete a partial invoice in a sales order, the system will use the linked line functionality to find the original sales order lines and only in the corresponding sales order lines the invoiced quantity are reset.

Repair:
For each order item selected, the tool will find the corresponding order lines and refill each line with the actual invoiced quantity. The invoiced quantity  will be distributed over the sales order lines based and sorted on the delivery date of each sales order line. If after the repair all the order lines are fully  fulfilled and invoiced, the order can be set to Completed.

26. Comparison of external numbers against financial transactions

Check:
Checks for inconsistencies of the links between the general ledger transactions and the external number details table when external numbering is used.
The setting for external numbering can be defined in System à General à Settings à Numbers settings under the General section.

Repair:
The system will repair all the incorrect links in the external number details table based on the general ledger transaction table which the external number has been assigned to actual transactions.

Advanced/Simple

Click Simple to disable the Project check box. Click Advance to enable the Project check box. The amount of areas where the diagnostic check will be performed on will also differ based on the selection.

Log

Click this to view all the information of the diagnostic check. The information includes the person who ran the check, the date the check was performed, the start time and end time of the check, duration of the check, and remarks.

Note: This button will be displayed after clicking the Start button.

E-mail

Click this to send an e-mail on the details and results of the diagnostic check. On clicking the E-mail button, you will see the New Mail Message screen in Microsoft Office Outlook. By default, the subject and content of the e-mail which consists of the details and results of the diagnostic check will be displayed in the body of the email. Type in the recipient’s e-mail address. Click Send to send the e-mail.

Start

Click this to start running the checking process.

Repair

Click this to repair the transactions with errors.

Close

Click this to exit.