sales orders

 

Sales orders can be manually created or, depending on the transaction type, the sales order can be automatically created.

 

Feed Deliveries – Sales orders are generated automatically from feed orders based on the following scenarios:

 

Processing Transactions - Sales orders are generated automatically from processing transactions based on the following scenarios:

 

Placement Transactions - Sales orders are generated automatically from processing transactions based on the following scenarios:

 

Transfer Transactions - Sales orders are generated automatically from processing transactions based on the following scenarios:

 

Prior to creating a Sales Order, the following items should be created:

 

The following procedures are outlined in the Sales Order document:

Create a Sales Order

  1. In General>Sales, select Orders.

  2. In the Sales Orders index, click to create a new sales order.

  3. Click on the Bill-To tab.

Sales Order Header

The sales order header contains the base data to outline the sales order. The header is divided into three sections to group the data.

 

Bill-To

The Bill-To tab contains the base data for the bill-to customer.

 

  1. In the Customer (Bill to) field, enter the code that is used to identify the customer (alphanumeric, max 20 characters). If the ship-to customer is selected first, the bill-to will automatically be assigned based on the ship-to customer.
  2. Customer Name (Bill To) will default from the selected Bill-to Customer and displays the name of the customer.
  3. Bill To Address 1-3 fields will default from the selected customer and display the address details of the customer. Once the order is posted, the address will be fixed with the order and will not update with any changes to the customer.
  4. Bill To City will default and displays the city in which the selected customer is located.
  5. Bill To State will default and displays the state in which the selected customer is located.
  6. Bill To Country will default and displays the country in which the selected customer is located.
  7. Bill To Zip will default and displays the zip or postal code of thee selected customer.
  8. Currency defaults to the currency defined on the Bill-To customer with an option to modify
  9. Bill To Contact defaults from the primary contact defined on the Bill-To customer.
  10. Bill To Contact Tel defaults from the Bill-To customer.
  11. Employee No Identifies the person responsible for the order (usually a sales representative). Employees must first be defined in: Admin>Business>General>Definitions>Employees.
  12. Employee Name defaults from Employee No and displays the name of the employee responsible for the order.
Ship-To

The Ship-To tab contains the base data for the ship-to customer, and can only be selected based on the relationships defined on the Business Usages tab on the Bill-To Customer.

 

  1. In the Customer (Ship to) field, enter the code that is used to identify the customer (alphanumeric, max 20 characters). If the bill-to customer is selected first, the ship-to will only display ship-to customers that have been assigned to the bill-to customer.
  2. Customer Name (Ship To) will default from the selected Ship-to Customer and displays the name of the customer.
  3. Ship To Address 1-3 fields will default from the selected customer and display the address details of the customer. Once the order is posted, the address will be fixed with the order and will not update with any changes to the customer.
  4. Ship To City will default and displays the city in which the selected customer is located.
  5. Ship To State will default and displays the state in which the selected customer is located.
  6. Ship To Country will default and displays the country in which the selected customer is located.
  7. Ship To Zip will default and displays the zip or postal code of thee selected customer.
  8. The Customer No (Deliver To) field is optional if there is an additional delivery location assigned to the ship-to customer. The delivery location must be assigned to the ship-to customer on the Business Usages tab of the bill-to customer.
  9. The Delivery Location Name will default based on the selected delivery Customer No.
  10. Ship To Contact defaults from the primary contact defined on the Ship-To customer.
  11. Ship To Contact Tel defaults from the Ship-To customer and displays the main contact telephone number, if applicable.
  12. Salesperson No is an optional field to select the salesperson.
  13. Salesperson Name will default in.
  14. Tech Service No is an optional field to select the technical service number.
  15. Tech Service Name will default in.
General

The General grid contains the base data for the sales order.

 

  1. Order No is an auto-assigned unique number that identifies the order. This number can be manually overridden if required, however must be unique to the process.
  2. Select the Order Date from the drop-down calendar to identify the date the order was initiated.

  3. From Cost Center No, select the cost center where the product will be shipped, and where revenue will be recorded. In the Line Items grid, there is an option to select if the order needs to be shipped from a different cost center.

  4. In the Shipped Date field, enter the date that the product will be shipped to the customer. The ship date field will be used to select the required pricing for sales contracts, price master and tax rates.

  5. Ship Week is an optional field to enter the calendar week that the order is to be shipped.

  6. In the Delivery Date field, enter the date that the product will be delivered to the customer.

  7. In the Delivery Time field, enter the requested time for the product to be delivered to the customer.

  8. PO No is an optional field to enter the purchase order number that the customer provides for the order.

  9. Order Status determines the status of the order and is set to Confirmed by default. Options are: Tentative or Confirmed. The planning module allows the user to view only confirmed orders or a combination of confirmed and tentative orders so they can see their net position.

    1. Tentative - the order is planned for the date, but dates, quantities and prices possibly need to be verified.

    2. Confirmed - dates and quantities are confirmed with the customer.

  10. Once the order has been entered, the Pre Post Status flag can be selected. Selecting this flag will lock the quantity on the order so it cannot be modified, and the make the order available for shipment. Once the product has shipped, the flag cannot be de-selected.

  11. Selecting the Approved flag will lock the pricing and make the order available for invoice after the product has been shipped. Once a shipped order has been invoiced, the Approved flag cannot be unchecked. Security can be assigned to this field so that only the required users can approve orders.

  12. Approved UserID indicates the user that approved the order.

  13. Approved Date indicates the date that the order was approved.

  14. The Prepaid flag will be selected if the payment term for the order is a prepaid term. The purpose of this flag is to notify the user that a prepayment is required. The flag will also prevent the order from being shipped until the Pre Payment Received flag is selected.

  15. The Pre Payment Received flag must be selected before a prepaid order can be shipped. Security can be added to this field so that only the required users have access to the flag. Generally, only the finance department only has access to modify this flag.

  16. Payment Term No indicates the default payment term that is assigned to the ship-to customer in the Business Usages tab of the Bill-To customer. Permissions can be set so that this field will always be entered by default, or users can have the option to modify.

  17. Ship Method No will default from the selected Ship-To customer. The method is defined on the Business Usages tab of the Ship-To/Bill-To relationship.

  18. Freight Terms will default from the selected Ship-To customer and identifies the freight terms for the sales order based on a company-defined list. These terms are defined on the Business Usages tab of the Ship-To/Bill-To relationship.. Examples are FOB, CIF.

  19. Selecting the Void flag will cancel the order, but will leave the order in the system for audit purposes.

  20. In the Text field,  enter any additional comments related to the order.

  21. Handling Instructions defaults from the Ship-to customer with any details related to processing the order. Optionally, details that are specific to the order can also be added.

  22. Process Sequence determines where in the planning process that the order will be addressed.

  23. In the Attachment field, any type of file can be attached (Example: Word document, picture, music or video clip).

  24. Creation Date indicates the date the transaction was created.

  25. Last Mod Date indicates the date the transaction was last modified.

Sales Order Details

After completing the header of the order, there are several tabs in the Line Items grid that also must be completed in the creation process.

Details

  1. Click on the Line Details grid.
  2. Click to create a new purchase order detail line.

 

 

  1. Line Item No identifies the line number of the order. This will be used in the complex sales order no.
  2. Select the Sales SKU No for the product that is being sold. The sales SKU must be defined on the product before the sales order can be created. Selecting the sales will then determine the price mode.
  3. Sales SKU Name defaults from Sales SKU No and displays a description of the product being sold.
  4. Contract No is based on the selected sales SKU and bill-to customer. The system will search to see if there is an existing sales contract for the product. If a contract exists, the assigned contract number will be associated to the order for pricing.
  5. Based on the selected sales SKU, the Price Mode will default. The system first searches contracts, and then price master. If there is not an existing relationship, the price mode defaults to 'Order' mode where the user will manually enter price details.
  6. Unit Description indicates the unit of measure in which the product is being shipped (Example: Each, Box, Ton, etc.). The Unit Description will default from the selected sales sku.

  7. Units Per represents the number of inventory units per each sales unit being sold. The value defaults from the selected sales sku.

  8. Product No derives the product number that is associated with the sales SKU. Product Name defaults from Product No and displays a description of the product.

  9. Product Type displays a description of the type of product being purchased (Example: Medication, Chicks, Eggs, etc).

  10. The Cull Sales flag will default from the selected sales sku and determines if the head will be deducted from entity inventory for animal sales.

  11. The Cull Inventory Deduction flag will be selected if any inventory have been deducted due to culling.

  12. In the Order Units field, enter the number of sales units being sold. Quantity is based on the unit type. For example, if the product is being sold in boxes, enter the number of boxes.

  13. Unit Price indicates the defaulted unit price from the contract or price master. If Price Mode defaults to Order, the price can be modified. Otherwise, the price is read-only. The Override Price flag can be used if the price is incorrect.

  14. Order Free Units indicates the number of units that are to be shipped free of charge. This field is calculated based on a premium add-on where the user enters the percentage of free units. Free units are only used for shipping chicks and poults.

  15. Order Total Units is a calculated field indicating the total quantity order. Total Units = Order Units + Order Free Units.

  16. Amount is a calculated field representing the selling amount of the product before add-ons and taxes. Amount = Order Units x Unit Price.

  17. Total Premium is a calculated field based on the order units and the premium add-ons assigned to the sales SKU in the order.

  18. Total Tax indicates the tax amount for the product and any associated add-ons. If the product and/or add-ons are taxable, taxes will be calculated based on the tax rates that are assigned to the order. The Taxable flag must be selected on each taxable item, and the tax codes added to the Taxes tab.

 

 

  1. Total Discount indicates the total discount add-on amount calculated from the child grid Discount AddOns tab.
  2. Total Price is a calculated field representing the total price of the line item. Total Price = Amount + Premiums – Discounts + Taxes.
  3. Cost Center No indicates the cost center where the product is being shipped from. The Cost Center No from the General tab in the Header will default to the line item. If the product is to be shipped from a different cost center, select the required cost center code.

  4. Cost Center Name defaults from Cost Center No and displays the name of the cost center.

  5. In the Notes field, enter any additional comments related to the order.

  6. Taxable defaults from the selected sales SKU if the product is taxable. If the flag is selected, a tax code must be added to the child grid before the order can be approved.

  7. Once the sales order as been Shipped, the process will mark the line item as 'Shipped'. An order is assumed shipped when the order shipment has the Complete flag marked and there are no outstanding back orders.

  8. The Closed flag can be selected after posting, if the sales order has been closed.

  9. Reason Code Change No is an optional field to select the reason for closing.

  10. Farm No is only used when selling field products from the farm. Farm No identifies the farm that will receive credit for selling the product.

  11. By selecting the Override Zero Price flag, the order can be approved for invoice at a zero price.  If the Unit Price is set to '0', the order cannot be approved for invoicing unless the flag is selected. Permissions are usually assigned to this field so that all users do not have access.

  12. By selecting the Override Price flag, the unit price can be changed from the default if the Price Mode is Contract or Price Master. Permissions are usually assigned to this field so that all users do not have access.

  13. Shipped Units indicates the number of shipped units excluding free units.

  14. Shipped Free Units displays the number of units that have been shipped free of charge. This amount is based on the free percentage quantity defined in Premium Add-Ons.

  15. Shipped Total Units is a calculated field that indicates the total amount of units shipped to the customer. Shipped Total Units = Shipped Units + Shipped Free Units.

  16. Contract Price Mode defaults if the sales order is priced by contract, and displays the price mode of the contract - where in the sales process the price can be modified.

  17. Contract Sales SKU No defaults if the sales order is priced by contract, and indicates the product being sold.

  18. Contract Sales SKU Name defaults if the sales order is priced by contract, and displays a description of the product being sold.

 

  1. Contract Unit Description defaults if the sales order is priced by contract, and displays a description of the contract unit.

  2. Contract Units Per defaults if the sales order is priced by contract, and indicates the number of units per order (Example: Per box or carton).

  3. Contract Product No defaults if the sales order is priced by contract, and indicates the contract product.

  4. Contract Product Name defaults if the sales order is priced by contract, and displays a description of the contract product.

  5. 2nd Unit Measurement No can be used to selected an alternative unit of measurement for the product.

  6. 2nd Unit Description will default in.

  7. Product Info indicates that details have been entered for the product.

Additional Details

Within the Line Item No tab, there is a child grid with additional tabs that must be created. The details in the child grid will default from the contract or price master if the order is priced from either of those two options. If the order is manually priced, they will default from the sales sku and prices can be entered where required. All add-ons must be defined on the sales sku and cannot be manually added to the sales order.

 

 

Taxes

If the product and/or add-ons are taxable, the tax code must be assigned on the Taxes tab. The tax amount will then be calculated based on the taxable order amounts.

  1. Click  to display the child grid for the Line Item No.

  2. Select the Taxes tab.

  3. Tax codes will default from the contract, price master, or sales sku as defined. If not previously defined, click to add tax codes.

 

  1. Tax No identifies the tax code to be applied to the product and add-ons for the selected line item. The Taxable flag must be selected in the product and add-ons for taxes to calculate.

  2. Tax Name describes the selected tax code.

  3. The Rate will display the tax rate percentage that is in effect on the date that the purchase order is created. The receiving transaction will be recorded based on the tax rate that is in effect on the receiving date. The calculated amounts will be displayed on the product detail line to display a total value of the product being purchased.

Commissions

The Commissions tab allows the user to define a commission rate that is payable to an employee or other party. Commissions must be defined on the sales contract, price master or sales sku prior to the sales order being created. The commission will be accrued at invoice. The commission must be assigned to the sales sku for the product prior to being defined on a price master list.

 

 

  1. Product No displays the code of the selected add-on that transfers from the selected sales sku, contract, or price list.
  2. Product Name will default from Product No and displays a description of the add-on.

  3. Transaction Basis is a read-only field that defaults from the selected add-on and determines how the add-on is calculated on orders. Options are: Per Unit, Percentage, Flat Rate, or Free Percentage.

  4. Payment Type is a read-only field that derives from the sales sku and determines when the add-on payment is made.

  5. The Payee Type field is optional. If the add-on is to be processed by an alternative source, select the source type for the add-on. Options are: Customer, Vendor, Employee, or Cost Center. If the field is left blank, it assumes the sales sku for the payment of the add-ons.

  6. Transaction Entity ID is a required field if a different Payee Type is selected. Select the appropriate customer or cost center.

  7. Taxable identifies if the item is taxable or non-taxable when the item is purchased. Tax codes must be assigned to the purchase order for the taxes to be calculated. Select the flag if the item is taxable.

  8. The Rate will default as defined on the sales sku. Modify the rate as required. The calculated amounts will be displayed on the product detail line to display a total value of the product being purchased.

Premium/Discount Add-Ons

In the child grid, there is the option to define the add-ons related to the product. The add-ons must be pre-defined in General>Products>AddOns prior to adding to the sales sku. Add-ons must be defined on the sales SKU and then the corresponding contracts and price masters before defaulting to the order.

 

 

  1. Product No displays the code of the selected add-on that transfers from the selected sales sku, contract, or price list.
  2. Product Name will default from Product No and displays a description of the add-on.

  3. Transaction Basis is a read-only field that defaults from the selected add-on and determines how the add-on is calculated on orders. Options are: Per Unit, Percentage, Flat Rate, or Free Percentage.

  4. Payment Type is a read-only field that derives from the sales sku and determines when the add-on payment is made.

  5. The Payee Type field is optional. If the add-on is to be processed by an alternative source, select the source type for the add-on. Options are: Customer, Vendor, Employee, or Cost Center. If the field is left blank, it assumes the sales sku for the payment of the add-ons.

  6. Transaction Entity ID is a required field if a different Payee Type is selected. Select the appropriate customer or cost center.

  7. Taxable identifies if the item is taxable or non-taxable when the item is purchased. Tax codes must be assigned to the purchase order for the taxes to be calculated. Select the flag if the item is taxable.

  8. The Rate will default as defined on the sales sku. Modify the rate as required. The calculated amounts will be displayed on the product detail line to display a total value of the product being purchased.

  9. Select the Print on Invoice flag if the add-on is to be printed on the default system invoice. If the add-on is not to be printed on the invoice, the option should not be selected. This option can be further defined in price lists.

Shipped

The Shipped tab contains details relating to the shipped product.

 

 

  1. Ref No is a system-generated reference number that identifies the order shipment
  2. Ship Date indicates the date the product was shipped.
  3. Quantity Shipped indicates the amount of products shipped.
  4. Complex Entity No is only used for egg and chick shipments to determine where the product was sourced from.
Instructions

The Instructions tab contains instructions relating to the add-on (s).

 

 

  1. From Instruction No, select an instruction code.
  2. Instruction Name defaults from Instruction No and displays a description of the instruction.
  3. Select the Print on Invoice flag if the add-on is to be printed on the default system invoice. If the add-on is not to be printed on the invoice, the option should not be selected. This option can be further defined in price lists.

 

Bill of Materials

The Bill of Materials tab is used to determine the products that must be used to ship the order.

 

 

  1. Product Type displays a description of the type of product being.
  2. Product No identifies the product.
  3. Quantity indicates the number of product units.
  4. Inventory Units indicates the number of units in inventory.
  5. Order Units indicates the number of units ordered.
  6. Shipped Units indicates the number of shipped units.
  7. The Override flag should be selected if the product will be over-rode.

Call Notes

The Call Notes tab is used to enter information relating to calls or discussions held with contacts.

 

 

  1. In the Contact Name field, enter the name of the contact with whom correspondence took place.
  2. From Priority, select the level of priority for the call. Available options are: Low, Medium, and High.
  3. In the Notes field, enter any comments relating to the discussion.
  4. In the Subject field, enter a brief description of the reason for the call.

History

The History tab is used to indicate any changes that have been made to the order based on a pre-defined list of reason codes.  

 

 

  1. From Change Date, enter the date the change took place
  2. In the Change Details field, enter additional notes relating to the change.
  3. From Reason Code, enter the code for the reason for the change.
  4. Reason Code Name will default from Reason Code and displays a description of the reason.
  5. In the Revision No field, enter the number of times this particular item has been revised.

Invoice Info

The Invoice tab identifies the details for all invoices created for the order.

 

 

  1. Invoice Date indicates the date of the sales invoice.
  2. Invoice No indicates the document number from the sales invoice.
  3. Invoice Amount represents the total amount of the invoice.
  4. Currency No defines the currency assigned to the sales order and invoice.
  5. Exchange Rate automatically sets to the current exchange rate based on the rate that is in effect on the invoice date. If the rate is different than the exchange rate incurred at receiving, the difference in the converted amount payable will be coded to the foreign exchange gain/loss account.
  6. Exchange Amount displays the calculated exchange on sales order based on the exchange rate used in the invoice.

Transportation Details

The Transportation tab outlines the details related to the transportation of the product.

 

  1. Click the button to add a new line.

 

 

  1. Sequence defines the order of the transportation series of events.
  2. In the Carrier No field, select the carrier who will be transporting the product. Carriers must be predefined in: Admin>Business>General>Definitions>Carriers.
  3. Carrier Name defaults from Carrier No and displays the name of the carrier.
  4. Transport Type defaults from the selected carrier. Options are: Air, Ground Delivery, Pick Up, Rail, or Water.
  5. In the Ref No field, enter the carrier reference number (usually a bill of lading or transportation document).
  6. From Departure Date, select the date the product will depart.
  7. From Departure Time, select the estimated time the product will depart.
  8. From Arrival Date, select the date the product will arrive.
  9. From Arrival Time, select the estimated time the product will arrive.
  10. In the Comments field, enter any additional information related to the transportation details of the product.
  11. Carrier Vendor No defaults from the assigned Carrier No, if applicable. For example, internal haulage will not have a vendor, but other external carriers can optionally be assigned in Carriers.
  12. Carrier Vendor Name defaults from Carrier Vendor No and displays the name of the carrier vendor.
  13. From Airport No, select the arrival airport.
  14. Airport Name will default in.

Sales Order Approval Options

There are three levels of approval within the sales order.

  1. Pre-Post - the Pre-Post flag must be selected before the order can be shipped. Once the Pre-Post flag is selected, the quantity cannot be modified. The Pre-Post flag can be unchecked as required until the first order is shipped. Once the first order is shipped, the Pre-Post flag cannot be unchecked. The Pre-Post flag is located in the sale order header on the General grid.
  2. Approved - the Approved flag must be selected before the order shipment can be invoices. Once the Approved flag is selected, the pricing cannot be modified. The Approved flag can be unchecked as required until the first order is invoiced Once the first order shipment is invoiced, the Approved flag cannot be unchecked. The Approved flag is located in the sale order header on the General grid.
  3. Post - the Post option locks the entire order from edit. The Pre-Post and Approved options must be completed prior to the order being approved and the order must be shipped. Posting of the sales order is optional and completed by selecting the required order from the sales order index and selecting Options>Post or right-click on sales order and select Post.