What Is The Purpose of Field CPORDHDR_FRT_ENT_MTHD in COP Order Header?

What Is The Purpose of Field CPORDHDR_FRT_ENT_MTHD in COP Order Header?

Release Date: 2/23/2021
Version: 7.5 & Up

Q - Can you explain the purpose/functionality of the ORDER_FRT_ENT_MTHD field in the CPORDHDR table?

A - The purpose is to record how the order header freight amount is determined. 

The possible values can be:
  • "A" = Automatically Calculate in Billing Screen
  • "B" = Manual Enter Through Billing Screen
  • "S" = Manual Enter Through Shipping Data Update
  • "D" = Automatically Calculate in Shipping Data Update
  • "V" = Calculated By Shipping Verification
  • "X" = Calculated By Shipping Confirmation
  • "C" = Manual Enter By Shipping Confirmation
  • "R" = Calculated By Mass Billing By Range
  • "M" = Calculated By Mass Billing By Shipping Verification
  • "L" = Through VICS BOL
  • “Spaces” = No Value
As you know, in Elliott users can optionally access the billing screen in Order Entry. The freight amount could be determined at the time of order entry. But what if the order is changed later on -- should the freight amount be changed later? We have an issue here because we don’t know if the freight amount should stay fixed or should be recalculated if the order is changed.

The main purpose is to determine if the freight should be recalculated in the billing screen. There is a related flag in Global Setup -> Cop-Func -> Order Billing Screen -> 1. Initialize Freight Amount in Order Billing. If this Global Setup flag is “N,” then the existing freight amount in the billing screen will be preserved in the billing screen. If it is “Y,” then the system tries to determine if the freight was previously entered manually based on the value in CPORDHDR ORDER_FRT_ENT_MTHD. If it was previously entered manually (Value “B” or “S”), then even if the Global Setup flag is = “Y,” the previous manually entered freight amount will be preserved. If it was calculated automatically, then it will wiped out and possibly recalculated.

EMK

    • Related Articles

    • Definition of the Order Header Freight Pay Codes

      Q - What are the definitions of the order header freight pay codes? In the past, there were only two types of freight pay codes: P=Prepaid C=Collect The codes have been expanded recently, and we are struggling with their meaning. For example, we ...

    • Feature - PO Header EDI Flag

      Release Date: 2/3/22 Updated: 2/15/22 Version: 8.5 & Up PO Header EDI Flag A purchase order header EDI flag has been added. See following sample screen. The purpose of this flag is to add finite control to determine which PO should be exported for ...

    • Feature - Gross Requirements Report COP Order Import

      Date Released - 5/24/16 The feature will allow the user to import COP line items to the BOMP Requirements Work File. When running the Bill of Material Processor-> Reports-> Gross Requirements Report, a new option is available from the item number ...

    • CP0300 Customer Order Processing Order Billing

      Order Billing Application Overview Order Billing is an application that will be used routinely. Regardless of which billing procedure you implement you will at least print invoices. The two billing procedures and other related concepts are explained ...

    • Feature - Erase Order Header Job Number When Convert Quote to Order

      Release Date: 1/17/19 The feature allows the user to choose whether or not job numbers specified on quote orders will be used when the quote is converted to a regular order. Users may not want to use this functionality if using the multi-bin ...