Bill of Materials EZ Import

Inventory EZ Import

Purchase Order EZ Import

Sales Order EZ Import

EZ Import Reject Maintenance.

Rejected Import Maintenance - Fields.

Rejected Import Record - Distribution Edit

Rejected Import Record - Distribution Edit - Fields.

Rejected Import Record - Header Edit

Rejected Import Record - Header Edit - Fields.

Rejected Import Record - Line Edit

Rejected Import Record - Line Edit - Fields.

Rejected Import Selection.

Rejected Import Selection - Fields.

Correct Rejected Transactions.

Mobility Module Options.

Mobility Module Options - Fields.

Supported Transaction Codes.

  

Bill of Materials EZ Import

Navigation: Select Mobility Module Main menu > Bill of Materials EZ Import.

 

Overview: Use Bill of Materials EZ Import to import production records. Production entries are imported directly into Bill of Materials Production Entry.

After the import process is run, the results are displayed in the Bill of Materials EZ Import window. The Processed column show the total number if records imported. The Imported column shows the total number of successfully imported records. The Rejected column show the total number of records that failed to import properly, if there are records that were not imported they can be edited or deleted in EZ Import Reject Maintenance.

  

Inventory EZ Import

Navigation: Select Mobility Module Main menu > Inventory EZ Import.


Overview: Use Inventory EZ Import to import Receipts, Issues, Adjustments and Physical Count records. Inventory entries are imported directly into Inventory Transaction Entry and\or Physical Count Entry.

After the import process is run, the results are displayed in the Inventory EZ Import window. The Processed column show the total number if records imported. The Imported column shows the total number of successfully imported records. The Rejected column show the total number of records that failed to import properly, if there are records that were not imported they can be edited or deleted in EZ Import Reject Maintenance.

Purchase Order EZ Import

Navigation: Select Mobility Module Main menu > Purchase Order EZ Import.

 Overview: Use Purchase Order EZ Import to import Receipt of goods records. Purchase Order entries are imported directly into Receipt of goods Entry.

After the import process is run, the results are displayed in the Inventory EZ Import window. The Processed column show the total number if records imported. The Imported column shows the total number of successfully imported records. The Rejected column show the total number of records that failed to import properly, if there are records that were not imported they can be edited or deleted in EZ Import Reject Maintenance. 

Sales Order EZ Import

Navigation: Select Mobility Module Main menu > Sales Order EZ Import.

Overview: Use Sales Order EZ Import to import Invoicing and Shipping records. Sales Order entries are imported directly into Sales Order Invoice Data Entry and\or Shipping Data Entry.

After the import process is run, the results are displayed in the Inventory EZ Import window. The Processed column show the total number if records imported. The Imported column shows the total number of successfully imported records. The Rejected column show the total number of records that failed to import properly, if there are records that were not imported they can be edited or deleted in EZ Import Reject Maintenance.  

EZ Import Reject Maintenance

Navigation: Select Mobility Module Main menu > Rejected Import Maintenance. In the Rejected Import Selection window, select the transaction, and then click Edit.

Overview: Use Rejected Import Maintenance to select the rejected record to modify. This task displays the rejected records based on the transaction type selected in the Rejected Import Selection window. The Rejected Import Maintenance task filters the error codes to the appropriate tables and the selected records can be deleted or modified.

If a transaction is not imported into the transaction tables, a record is sent to the rejection tables. The Mobility Module Rejection tables consist of Header Rejection, Detail Rejection, and Distribution Rejection tables. Various import errors can occur in each table, and these errors are sent to their corresponding rejection tables.

  • If an error occurs at the lot and serial distribution level, the distribution import record is flagged with the line lot and serial distribution's rejection code.
  • If an error occurs at the item detail import record level is flagged with the detail line rejection code.

You can import, delete, and edit a single transaction or all of the transactions listed.

 

Rejected Import Maintenance - Fields

Rejected Import Maintenance

Item Transaction / Physical Count / P/O Number / S/O Number / RMA Number / Bill Number

This field displays information based on the transaction type selected in the Rejected Import Selection window, and can only be viewed.

Click Edit to open the rejected transaction to be modified. Click Delete to delete the transaction. Click Import to re-import the selected transaction. You can also click Import All to re-import all the transactions, click Delete All to delete all the transactions, or click Edit All to edit all transactions.

 

Transaction No.

This field displays the transaction number, and can only be viewed.

 

Record Type

This field displays the level where the error occurred. There are three levels available: Header, Detail, and Distribution. This field can only be viewed.

 

Transaction Type

This field displays the field where the error occurred, and can only be viewed.

Item Transaction / Physical Count / Reference / Bill Number / P/O Number

This field changes based on the module and task the transaction was rejected from at the time of import, and can only be viewed.

 

Rejection Description

This field displays the description of the rejected record, and can only be viewed.

 

Transaction Date

This field displays the date that the record was collected, not when it was rejected.


 

Rejected Import Record - Distribution Edit

Navigation

  • Select Mobility Module Main menu > Rejected Import Maintenance. In the Rejected Import Selection window, select the transaction, and then click Fix Entry. In the Rejected Import Maintenance window, select the distribution line detail transaction, and then click Edit. In the Rejected Import Record - Line Edit window, click Distributions.
  • Select Mobility Module Main menu > Rejected Import Maintenance. In the Rejected Import Selection window, select the transaction, and then click Edit. In the Rejected Import Maintenance window, select the transaction, and then click Edit. In the Rejected Import Record - Header Edit window, click Lines. In the Rejected Import Record – Line Edit window, browse to the correct line, click Distribution, then browse to the correct distribution transaction.

Overview: Use Rejected Import Record - Distribution Edit to modify the line item lot or serial number for the transaction that was rejected during the import process.

Note Only the fields that pertain to the transaction type selected can be modified.  

 Fields

Transaction No.

Record Type

Transaction Type

Item Transaction / Physical Count / Reference / Bill Number / P/O Number

Reject Description

Transaction Date

Detail Line No.

Warehouse

Item Code

Item Quantity

Item Description

 Lot/Serial Distribution

 Bin Location

 Alt Bin Location

Distribution No.

 Lot Number / Serial Number

Distribution Qty  
   
   

 

Rejected Import Record - Distribution Edit - Fields

Rejected Import Record - Distribution Edit

Transaction No.

This field displays the transaction number, and can only be viewed.

 

Record Type

This field displays the level where the error occurred. There are three levels available: Header, Detail, and Distribution. This field can only be viewed.

 

Transaction Type

This field displays the field where the error occurred, and can only be viewed.

Item Transaction / Physical Count / Reference / Bill Number / P/O Number

This field changes based on the module and task the transaction was rejected from at the time of import, and can only be viewed.

 

Rejection Description

This field displays the description of the rejected record, and can only be viewed.

 

Transaction Date

This field displays the date that the record was collected, not when it was rejected.

 

Detail Line No.

This field displays the transaction detail line number, and can only be viewed.

 

Item Code

This field displays the item code for this line detail, and can only be viewed.

 

Item Description

This field displays the item description, and can only be viewed.

 

Warehouse

This field displays the item warehouse, and can only be viewed.

 

Item Quantity

This field displays the item quantity, and can only be viewed.

Lot/Serial Distribution

 

Distribution No.

Enter the line number for this transaction, or click the Lookup button to list all lines.

Click the Next button to go to the next distribution in the selected line number. Click Lines to return to the Rejected Import Record - Line Edit window to select a different line item.

 

Lot Number / Serial Number

Type the lot or serial number for the selected item. If Invalid appears in red next to the field, a valid lot or serial number must be entered.

 

Distribution Qty

Type the quantity to be distributed for the selected item. If Invalid appears in red next to the field, a valid distribution quantity must be entered.

 

Bin Location

Type the bin location for the selected item. If Invalid appears in red next to the field, a valid bin location must be entered.

 

Alt Bin Location

Type the alternate bin location for the selected item. If Invalid appears in red next to the field, a valid alternate bin location must be entered.

 

Rejected Import Record - Header Edit

Navigation: Select Mobility Module Main menu > Rejected Import Maintenance. In the Rejected Import Selection window, select the transaction, and then click Edit. In Rejected Import Maintenance, select the header transaction, and then click Edit.

Note In Rejected Import Maintenance, if you click Fix Entry and there is an error in the header transaction, this window automatically appears.

Use Rejected Import Record - Header Edit to modify the transaction that was rejected during the import process. An Invalid label in red appears next to the field that needs to be modified.

Note Only the fields that pertain to the transaction type selected can be modified.

 

Fields

Transaction No.

Record Type

Transaction Type

Item Transaction / Physical Count / Reference / Bill Number / P/O Number

Reject Description

Transaction Date

 

 

Transaction Header

 

Warehouse

Revision

To Warehouse

Option Codes

Batch Number

Invoice No.

RMA No.

Customer No.

Sales Order No.

Lot/Start Serial

Purchase Order No.

Production Qty

A/P Invoice No.

Check No.

Shipper ID

Amt Received

Ship Via

Vendor No.

Bill Number

 

 

Rejected Import Record - Header Edit - Fields

Rejected Import Record - Header Edit

Transaction No.

This field displays the transaction number for the rejected import transaction, and can only be viewed.

Click the Next Transaction Header button to go to the next header transaction. Click Lines to open the transaction line detail window for the rejected transaction. Click Distributions in the Line Edit window to open the transaction lot/serial distribution window for the rejected transaction.

 

Record Type

This field displays the transaction type for the rejected import transaction, and can only be viewed.

  

Transaction Type

This field displays the transaction record type, and can only be viewed. The three record types are: Header, Line Detail, and Distribution.

 

Item Transaction / Physical Count / Reference / Bill Number / P/O Number

This field changes based on the module and task the transaction was rejected from at the time of import, and can only be viewed.

 

Transaction Date

Type the transaction date if different from the date displayed in this field.

 

Reject Description

This field displays a description for the rejected transaction, and can only be viewed.

  

Transaction Header

 

Warehouse

Enter the warehouse code representing the correct default warehouse for this transaction, or click the Lookup button to list all warehouse codes. If Invalid appears in red next to the field, a valid warehouse code must be entered.

 

To Warehouse

Enter the warehouse code representing the correct destination warehouse for this transaction, or click the Lookup button to list all warehouse codes. If Invalid appears in red next to the field, a valid destination warehouse code must be entered.

 

Batch Number

Type the batch number for this transaction. If Invalid appears in red next to the field, a valid batch number must be entered.

 

RMA No.

Type the RMA number for this transaction. If Invalid appears in red next to the field, a valid RMA number must be entered.

 

Sales Order No.

Type the sales order number for this transaction. If Invalid appears in red next to the field, a valid sales order number must be entered.

 

Purchase Order No.

Type the purchase order number for this transaction. If Invalid appears in red next to the field, a valid purchase order number must be entered.

 

A/P Invoice No.

Type the Accounts Payable invoice number for this transaction. If Invalid appears in red next to the field, a valid invoice number must be entered.

 

Shipper ID

Type the shipper ID for this transaction. If Invalid appears in red next to the field, a valid shipper ID must be entered.

 

Ship Via

Enter the shipping code for this transaction, or click the Lookup button to list all shipping codes. If Invalid appears next to the field, a valid shipping code must be entered.

 

Bill Number

Enter the Bill of Materials bill number for this transaction, or click the Lookup button to list all bill numbers. If Invalid appears next to the field, a valid bill number must be entered.

 

Revision

Enter the Bill of Materials revision code for this transaction, or click the Lookup button to list all revision codes. If Invalid appears next to the field, a valid revision code must be entered.

 

Option Codes

Enter the Bill of Materials option codes for this transaction, or click the Lookup button to list all option codes. If Invalid appears next to the field, a valid option code must be entered.

 

Invoice No.

Type the Sales Order invoice number for this transaction. If Invalid appears next to the field, a valid invoice number must be entered.

 

Customer No.

Enter the customer number for this transaction, or click the Lookup button to list all customer numbers.

Alternately, start typing a customer name to locate a record. As you type, a list of records matching your entry appears. You can then select a record from the list, and the customer number will appear in the field.

If Invalid appears next to the field, a valid customer number must be entered.

 

Lot/Start Serial

Type the lot or starting serial number for this transaction. If Invalid appears next to the field, a valid lot or starting serial number must be entered.

 

Production Qty

Type the Bill of Materials production quantity for this transaction. If Invalid appears next to the field, a valid production quantity must be entered.

 

Check No.

Type the check number for this transaction. If Invalid appears next to the field, a valid check number must be entered.

 

Amt Received

Type the amount received for this transaction. If Invalid appears next to the field, a valid received amount must be entered.

 

Vendor No.

Type the primary vendor number for this transaction.

Alternately, start typing a vendor name to locate a record. As you type, a list of records matching your entry appears. You can then select a record from the list, and the vendor number will appear in the field.

If Invalid appears next to the field, a valid primary vendor number must be entered.

Rejected Import Record - Line Edit

 

Navigation

 
  • Select Mobility Module Main menu > Rejected Import Maintenance. In the Rejected Import Selection window, select the transaction, and then click Edit. In the Rejected Import Maintenance window, select the line detail transaction, and then click Fix Entry.
  • Select Mobility Module Main menu > Rejected Import Maintenance. In the Rejected Import Selection window, select the transaction, and then click Edit. In the Rejected Import Maintenance window, select the line detail transaction, and then click Edit. In the Rejected Import Record - Header Edit window, click Lines.

Overview

 

Use Rejected Import Record - Line Edit to modify the line detail for the transaction that was rejected during the import process. An Invalid label in red appears next to the field that needs to be modified.

Note Only the fields that pertain to the selected transaction type can be modified.

Fields

 

 

Transaction No.

Record Type

Transaction Type

Item Transaction / Physical Count / Reference / Bill Number / P/O Number

Reject Description

Transaction Date

 

 

Item Detail

 

Detail Line No.

Item Action

Item Code

Replacement Item

Item Description

Job No.

Alternate Whse

Cost Code

Quantity

Unit Cost

Unit of Measure

Unit Price

G/L Account

Weight

B/M Misc G/L Acct

Package No.

Invoice No.

Alias Item No.

Return Reason

Alias Item Desc

Customer Action

 

 

Rejected Import Record - Line Edit - Fields

 

Rejected Import Record - Line Edit

 

Transaction No.

This field displays the transaction number for the rejected import transaction, and can only be viewed.

Click the Next button to go to the next Header transaction.

Record Type

This field displays the transaction record type, and can only be viewed. The three record types are: Header, Line Detail, and Distribution.

 

Transaction Type

This field displays the transaction type for the rejected import transaction, and can only be viewed.

 

Item Transaction / Physical Count / Reference / Bill Number / P/O Number

This field changes based on the module and task the transaction was rejected from at the time of import, and can only be viewed.

 

Transaction Date

This field displays the transaction date, and can only be viewed.

 

Reject Description

This field displays a description for the rejected transaction, and can only be viewed.

 

  

Item Detail

 

Detail Line No.

Enter the line number for this transaction, or click the Lookup button to list all lines.

Click the Next button to go to the next line item in the selected transaction. Click Distributions to open the transaction lot/serial distribution window for the rejected line item.

 

Item Code

Enter the item code for this transaction, or click the Lookup button to list all items codes.

Alternately, start typing an item description to locate an item. As you type, a list of records matching your entry appears. You can then select an item from the list, and the item code will appear in the field.

If Invalid appears in red next to the field, a valid item code must be entered.

 

Item Description

This field displays the item description, and can only be viewed.

 

Alternate Whse

Enter the alternate warehouse code for the item selected, or click the Lookup button to list all warehouses. If Invalid appears in red next to the field, a valid warehouse code must be entered.

 

Quantity

Type the quantity for the item selected. If Invalid appears in red next to the field, a valid quantity must be entered.

 

Unit of Measure

Enter the alternate warehouse code for the item selected, or click the Lookup button to list all warehouses. If Invalid appears in red next to the field, a valid unit of measure must be entered.

 

G/L Account

Enter the general ledger account for the item selected, or click the Lookup button to list all general ledger accounts. If Invalid appears in red next to the field, a valid general ledger account must be entered.

 

B/M Misc G/L Acct

Enter the Bill of Materials miscellaneous account for the item selected, or click the Lookup button to list all miscellaneous accounts. If Invalid appears in red next to the field, a valid miscellaneous account must be entered.

 

Invoice No.

Enter the invoice number for the selected item. If Invalid appears in red next to the field, a valid invoice number must be entered.

 

Return Reason

Enter the return reason for the selected item, or click the Lookup button to list all return reasons. If Invalid appears in red next to the field, a valid return reason must be entered.

 

Customer Action

Select the customer action for the selected item. If Invalid appears in red next to the field, a valid customer action must be selected.

 

Item Action

Select the item action for the selected item. If Invalid appears in red next to the field, a valid item action must be selected.

 

Replacement Item

Enter the replacement item for the selected item, or click the Lookup button to list all replacement items. If Invalid appears in red next to the field, a valid replacement item must be entered.

 

Job No.

Enter the job number for the item selected, or click the Lookup button to list all job numbers. If Invalid appears in red next to the field, a valid job number must be entered.

 

Cost Code

Enter the cost code for the item selected, or click the Lookup button to list all cost codes. If Invalid appears in red next to the field, a valid cost code must be entered.

 

Unit Cost

Type the unit cost for the item selected. If Invalid appears in red next to the field, a valid unit cost must be entered.

 

Unit Price

Type the unit price for the item selected. If Invalid appears in red next to the field, a valid unit price must be entered.

 

Weight

Type the weight for the item selected. If Invalid appears in red next to the field, a valid weight must be entered.

 

Package No.

Enter the package number for the item selected, or click the Lookup button to list all package numbers. If Invalid appears in red next to the field, a valid package number must be entered.

 

Alias Item No.

Type the alias item number. If Invalid appears in red next to the field, a valid alias item number must be entered.

 

Alias Item Desc

Type the description for the alias item. If Invalid appears in red next to the field, a valid alias item description must be entered.

 

Rejected Import Selection

  

Navigation

 

Select Mobility Module Main menu > Rejected Import Maintenance. The Rejected Import Selection window appears.

Note This window appears only if the transactions have been rejected in Bill of Materials EZ Import, Inventory EZ Import, Purchase Order EZ Import, Sales Order EZ Import.

Overview

 

Use Rejected Import Selection to select transaction types that were rejected during the import process.

 

Rejected Import Selection - Fields

 

Rejected Import Selection

Activity

This column displays a list of rejected import transaction types. Click Edit to open the maintenance window for the selected transaction type, or double-click the transaction type.

Rejected

This column displays the number of rejected transactions for the transaction type selected at the Activity column. The number displayed is the number of Header records found in any header, detail, and distribution import errors.

Correct Rejected Transactions

           

 Overview

 

Use this procedure to correct the rejected transactions that were created during the import process. This procedure corrects rejected transactions from the Import Bill of Material Transactions, Inventory EZ Import, Purchase Order EZ Import, Sales Order EZ Import, and EZ Import tasks.

  

To correct rejected transactions

1.  Select Mobility Module Main menu > Rejected Import Maintenance. The Rejected Import Selection window appears.  

 2.  Select the rejected import, and click Edit. For more information, see Rejected Import Selection - Fields.

 3.  In Rejected Import Maintenance, select the transaction to correct. For more information, see Rejected Import Maintenance - Fields.

 4.  Click Fix Entry.

    •   If the error exists in the header record, the Rejected Import Record - Header Tab appears. 
    •  If the error exists in the lines, the Rejected Import Record - Lines Tab appears.
    •  If the error exists in the lot or serial information, the Rejected Import Record will be edited on the Lines Tab by toggling the radio button from Detail Only to Detail and Dist. or Distribution Only.

 5.  Enter the correct information for any invalid fields. For more information, see Rejected Import Record - Header Edit - Fields, Rejected Import Record - Line Edit - Fields, or Rejected Import Record - Distribution Edit - Fields.

6.  After clicking Accept to return to the Rejected Import Maintenance window, click Import to import the corrected transaction.

 

The rejected transaction has been corrected and imported.

 

Mobility Module Options

  

Navigation

 

Select Mobility Module Setup menu > Mobility Module Options.

 

Overview

 

Use Mobility Module Options to define a series of options allowing you to maintain features most appropriate for your business.

 

Main Tab

 

Number of Days to Retain Import History

P/O Prompt for Mobility Module Receipt Labels

I/M Prompt for Mobility Module Receipt Labels

Prompt for Standard P/O Receipt Labels

Prompt for Standard I/M Receipt Labels

 

   
   
   

 

Mobility Module Options - Fields

Mobility Module Options

Main Tab

 

Number of Days to Retain Import History

Type the number of days to retain import history. The minimum days to retain history is 90 days. Import history retained on or before the number of days specified is purged automatically during period-end processing, or it can be purged using the Purge Imported Transaction History Data check box in the Purge Mobility Module Import History window.

 

I/M Prompt for Mobility Module Receipt Labels

Select this check box to be prompted to print Mobility Module inventory receipt labels after printing the Inventory Management Transaction Register, and before the update. Clear this check box if you do not want to print the Mobility Module receipt labels.

 

Prompt for Standard I/M Receipt Labels

Select this check box to be prompted for standard inventory receipt labels after printing the Inventory Management Transaction Register, and before the update. Clear this check box if you do not want to print the standard inventory receipt labels.

 

P/O Prompt for Mobility Module Receipt Labels

Select this check box to be prompted to print Mobility Module purchase order receipt labels after printing the Purchase Order Daily Receipts Register, and before the update. Clear this check box if you do not want to print the Mobility Module purchase order receipt labels.

 

Prompt for Standard P/O Receipt Labels

Select this check box to be prompted for standard purchase order receipt labels after printing the Purchase Order Daily Receipts Register, and before the update. Clear this check box if you do not want to print the standard purchase order receipt labels.

 

All records in the Mobility Module tables are imported through the various EZ Import programs. All data imported is validated and valid records are written as transactions while invalid records are written as rejections.

Imported records can be accessed using one of the following:

  • Bill of Materials Production Entry
  • Inventory Management Physical Count Entry
  • Inventory Management Transaction Entry
  • Purchase Order Receipt of Goods Entry
  • Sales Order Invoice Data Entry
  • RMA Receipts Entry

For more information, see:

 Mobility Module Options

 EZ Import Reject Maintenance

 Bill of Materials EZ Import

 Inventory EZ Import

 Purchase Order EZ Import

 Sales Order EZ Import

 

 

Supported Transaction Codes

Home | FAQs & Troubleshooting

                 

The following transaction codes are supported:

Physical Count

15

Inventory Transfer

11

Inventory Receipt

14

Inventory Issues

12

Inventory Sales

13

Inventory Alias Items

16

Count Card

18

Purchase Order Receipt

31

Sales Order Invoice Data Entry

21

Sales Order Shipping Data Entry

22

Remote Sales Order

23

Bill of Materials Production Entry

41

Sales (Creates invoice)

51

Delivery (Invoicing sales order)

52

Request Order (Creates sales order)

53

Request Quote (Creates quote)

54

Payment (Creates cash receipt)

55

RMA Receipt

61