Action results: Error running action query

Errors are specific to screens. Select the error for the screen on which the error was received.

• Create Bill - Code 8114
• Import - Apply orders: Code: 2627
• Import - Apply orders: Code: 15281
• Import - Apply UPS/Fedex Files: Code: 242
• Billing - Invoicing - Create Bill (3PL Version Only): Code: 8152
• Search - Products - Delete (Feature Assemblies Only): Code 547
• Shipments - Ship Orders - Create Order BOL (Feature Delivery Contract Only): Code 515
• Shipments - Order Entry / Edit - Code: 8152

Create Bill - Code 8114 (back to top)

This will occur if the Account Preference: Invoice: Bill Type Minimum $ Amount is not set to a number for the Bill Type being generated.

Screen Import - Apply orders: Code: 2627 (back to top)

This is due to a header field in the import file that has different data for the same order. Review your import file for header fields that are not identical for all records of the order. Then re import the corrected file and apply it again.

An indication that this is the issue is if you see the same order appearing more than once on the apply screen. If you scroll to the right on the Import - Apply Orders screen, you should be able to see the two header fields for the same order that differ. You can also look in the csv file used to import the orders

This can also be caused if an order is imported twice due to an error in an External System Import. If this happens with an External Interface (such as the Magento Interface), contact customer support. *Note* that if you click remove on either record for the order, both records will be removed and the order would have to be reimported.

Screen Import - Apply orders: Code: 15281 (back to top)

This is due to a command not being run on the SQL Server instance that allows assess. Contact Coreflex Customer Service so they can run a script on your database that will give permission to your SQL Server to run the procedure.

Screen Billing - Invoicing - Create Bill (3PL Version Only): Code: 8152 (back top top)

This is due to the data getting inserted into the Bill item Refno or Shipmethods fields being longer than 20 characters. As of Update 22 Init 19, this was updated to 40 characters. The Source of the information placed in the refno and shipmethod fields is determined by System settings as follows:

• Item Receiving
  • Refno Source - Ref on the Item Receiving Screen
    • System Setting - Public Warehousing:Billing Reference Inv Hist Field
  • Shipping Method Source
    • System Setting - Public Warehousing:Billing ShipMethod Inv Hist Field
• ASN Receiving
  • Refno Source - Ref on the Item Receiving Screen
    • System Setting - Public Warehousing:Billing Reference ASN Field
  • Shipping Method Source
    • System Setting - Public Warehousing:Billing ShipMethod ASN Field

Screen Search - Products - Delete (Feature Assemblies Only): Code 547 (back to top)

This message indicates the product exists in another table and must be removed.

If the text in the error message after table "dbo. is KITDTL:

This happens when deleting a productid that exists as a component in an Assemembly. Use the Setup Assemblies screen to search for the component and either remove it from the Assembly or remove the Assembly.

If the text in the error message after table "dbo. is INVENTORY:

This happens when deleting a productid exists in inventory. Adjust out the existing Inventory and/or Unslot the product from Inventory.

Screen Shipments - Ship Orders - Create Order BOL (Feature DeliveryContract Only): Code 515 (back to top)

Note: This message is the result of a bug that is fixed in Update 23.

This bug occurs when clicking the Ship button with a Trucking Contract open which has one or more Refused shipments on it.

Shipments - Order Entry / Edit - Update Customer - Code: 8152

• Update Customer Button - The ship method may be too long. It must be 20 characters or less for the customer in the Setup - Customers table. Shorten the ship method and click Save. Then try to update the customer again.

Screen Import Apply UPS/Fedex Files - Code: 242 (back top top)

• The Date formats exported from UPS or Fedex Exports must be in the format yyyymmdd. Only the first 8 characters are considered.