1. Home
  2. /
  3. Panel Help
  4. /
  5. Distribution
  6. /
  7. Sales order enquiry, Order...

Sales order enquiry, Order Settlements or Service order enquiry, Order settlements (OSMD12001)

Related topics

This panel displays the credit card/cheque payments made by your customer for this transaction as well as a summary of all amounts and fees for a sales order.

Note: If this panel has been accessed via the Service order enquiry, the title of this panel will read Service order enquiry, Order settlements. In this mode, the panel indicates the amount that the customer has to pay for the service after deduction of internal charges.

Function keys

M-pay Access the Work with order settlements, Open payments panel.
M-card Click if multiple credit cards are used by, or defined for, this customer. This accesses the Work with order settlements, All credit cards panel. Note: This function key is only displayed if the Sales order type, used to enter the sales order with, has the Update A/R parameter set to YES.
Details Access the summary details for the order settlements.

Payment type

In order to distinguish between how much has been received in the form of cash, and how much has been received in the form of cheques, a value is displayed in this field to identify the method of payment used in this transaction.

Permitted values:

  • CHK (Cheque)
  • CSH (Cash)

Note: These values are panel values and represent the type of payment that has been received. Reports can be generated via the Print daily order settlement report routine. This printout will detail the amounts that have been received in the form of cash or cheques.

Cash register

Displays a code from the Cash register codes table, indicating the sales that have been settled in the form of cheque or cash payments. This is to indicate that the payment has been received.

Amount

Displays the amount that is being paid by either cash or cheque.

Cheque no

Displays the number of the Cheque that the customer issued to make the payment with.

Card

Displays a code from the Credit card table indicating the type of card used in this transaction.

Payment status

Displays a value indicating the status of the Cash or Cheque payment. These statuses control the release of the order, accounts receivable payment creation and determine if the payment will be printed on the invoice document.

Displays one of the following values:

Value Description
1 Payment is expected. The order will be held until the payment is received, i.e. status upgraded to 2 or 3.
2 Payment has been received. This payment will be printed on the invoice but will not be subtracted from the amount due until it has been posted to Account Receivable in DC1 Financials, i.e. upgraded to status 3.
3 Payment has been posted to Account Receivable in DC1 Financials. This payment will be printed on the invoice and subtracted from the amount due.

Card number

Displays a credit card that has been defined for this customer in the Business partner maintenance, Credit card file (GDMD01601) panel.

Note: If the user does not have permission for credit card maintenance and credit card authorization, only the last four digits of the credit card number are displayed while rest of the number is masked with asterisks.

Card amount

Displays the amount that will be paid for by credit card.

CCV number
Displays the credit card verification number of the credit card. Note: If the user does not have permission for credit card maintenance and credit card authorization, the credit card verification number is masked with asterisks.
Valid from/Exp date

Displays the valid from date and the expiry date of the credit card.

Holder/Addr

Displays the name of the credit card holder. This is the name of the person that the credit card is issued to.

Postal code

Displays the postal code pertaining to the credit card holder.

Auth/Exp date

Displays the expiry date of the credit card authorisation.

Note: All amounts displayed in this panel are of the same transaction currency.

Order lines tot
Displays the total net value of the sales order, including discounts; but excluding taxes, surcharges or any additional charges.
Fee total
Displays the total fees that have been calculated for this order. If they are preliminary, (which pertain to administration, invoice and freight fees), an asterisk (*) will be displayed to the right of this fee total if the following is true. This gives you the possibility to more accurately estimate the total order value already at order entry. See View preliminary sales order related fees for more information.

For Administration/Invoice fees:

  • A fee was not manually entered on the order header
  • The order header status is below 30
  • The invoice total for the order is lower than any order value limit defined in the Adm fee limit field and/or Invoice fee limit field in the Customer file or Currency table
  • The fee has not been applied on any invoice for the order.

For Freight fees:

  • The user did not manually enter a freight fee in the Freight field (or change an automatically retrieved preliminary freight fee) on the order header
  • The order header status is below 40.

To view the fee amounts, click the Details function key.

Estimated surcharges
Displays the estimated value of the surcharges that will be added to the sales order. Note: This is an estimate since the goods have not been shipped. It is, therefore, not possible to determine the exact cost of the packaging used.
Estimated tax/VAT
Displays the estimated tax/VAT. This does not include the amount of tax/VAT that will be calculated for the packaging used for shipping the goods. Note: This is an estimate since the goods have not been shipped. It is, therefore, not possible to determine the exact cost of the packaging used.

Note: For service orders: The value in this field may change when the service order is closed if time transactions are added on or if debit codes are changed. This would affect both the internal charges and what the customer will pay. A debit code on a service order line indicates that the value of the line will be charged internally and not invoiced to the customer.

Time transactions
This field is only displayed on the Work with service orders, Order settlements panel. All time transactions that do not have a debit code and have not been transferred to service order lines are added (summarised) to the value in this field.

Note: For service orders: The value in this field may change when the service order is closed if time transactions are added on or if debit codes are changed. This would affect both the internal charges and what the customer will pay. A debit code on a service order line indicates that the value of the line will be charged internally and not invoiced to the customer.

Note: Time transactions and Deductions can only appear for service orders. Time transactions represent the value of reported working time for the service order that has not yet been booked for the order. This occurs at Service order close. Deductions represent the value of all order lines on the order that have been marked with a debit code, which will be booked as internal costs at Service order close.

Deductions
This field, which is only displayed on the Work with service orders, Order settlements panel, displays the value of all the service order lines that have been marked with a debit code, (i.e. internally charged). All time transactions that have a debit code and have not been transferred to service order lines are also added to the value in this field.

Note: A debit code on a service order line indicates that the value of the line will be charged internally and not invoiced to the customer.

Note: For service orders: The value in this field may change when the service order is closed if time transactions are added on or if debit codes are changed. This would affect both the internal charges and what the customer will pay.

Coin adjustment
Displays the sum of the Coin adjustment and Cash discount fields, specified on the Order settlements, Details panel.

Note: Coin adjustments is a part of the currency handling function. This allows you to round off the invoice amount for certain currencies. For example if the invoice amount is 12,97 SEK (Swedish Crowns) and the SEK currency in the Currency table indicates rounding to the nearest Crown, then the invoice will be rounded to 13 SEK.

Invoice total
Displays the invoice total for open order lines for this order. To this amount, any previously invoiced amount is added and carried over to the Tot invoice this ord field.

This is the difference between the amount that is paid and the open order lines total that is printed on the invoice before any deduction of payments specified in the right column on this panel.

The value of this field is calculated as follows:

+ Order line total
+ Fee total
+ Estimated surcharges
+ Estimated Tax/VAT
+ Time transactions (only for service orders)
+ Deductions (only for service orders)
+/- Coin adjustment
= Invoice total.

Note: Time transactions and Deductions can only appear for service orders. Time transactions represent the value of reported working time for the service order that has not yet been booked for the order. This occurs at Service order close. Deductions represent the value of all order lines on the order that have been marked with a debit code, which will be booked as internal costs at Service order close.

Note: The value of Invoice total is adjusted according to the currency rounding rules for the invoice amount i.e. the Adjust inv amount parameter in the Currency table.

Note: For service orders: The value in this field may change when the service order is closed if time transactions are added on or if debit codes are changed. This would affect both the internal charges and what the customer will pay.

Tot invoice this ord
The balance from Invoice total in the bottom left hand column is carried over to this field. Displays the invoice total for this order including any previously invoiced amount which has been added.
Expected payments
Displays the total payment that is due to be received. The order will be held until the payment is received. For example, if a cheque has been sent as payment by mail.
Received payments
Displays the amount that has been received. This payment will be printed on the invoice. For example, if the order has been paid in cash at counter sale.
Posted paym/credits
Displays the total amount for payments that have been posted to Accounts Receivable in DC1 Financials. This payment will be printed on the invoice and subtracted from the amount due. For example, if a credit note for the debtor in Accounts Receivable in DC1 Financials has been settled as partial or full payment for the order. It could also be a pre-paid amount or advanced payment.

Note: If an asterisk (*) is displayed in this field then this indicates that the A/R payment has been entered but has not yet been posted to the General Ledger in DC1 Financials.

Credit card
Displays the amount that has been paid for by credit card.
Invoice amount due
Displays the net invoice amount due that will be printed on the invoice. The value of this field is calculated as follows:

+ Invoice total
– Expected payments
– Received payments
– Posted payments/Credits
– Credit card
= Invoice amount due

Sales order enquiry, Order settlements, Summary details or Service order enquiry, Order settlements, Summary details (OSMD12002)

From this panel additional charges that were added to the sales/service order can be viewed.

Function keys

Time trans/Surcharges/Deductions Toggle time transactions, surcharge information and deductions. Note: This function key is only available for service orders.
Surcharges/Time trans/Deductions Toggle surcharge information, time transactions and deductions. This function key is only available for service orders.

Freight
If the FREICALC (Freight fee calculation) function is activated in the Function control file, a freight fee could be automatically calculated by the system depending on how the system was set up, (i.e. based on the weight of the goods or a fee per package regardless of the weight), and retrieved to this field.

Automatically calculated/retrieved:
During sales order line entry, any automatically calculated freight fee will be retrieved and is considered a preliminary freight fee. This is denoted with an asterisk (*) to the right of the fee amount and is based on the current order value. The preliminary freight fee will be displayed in this field as well as in the Sales order enquiry if the following is true:

  • The user did not manually enter a freight fee in the equivalent field in the maintenance program (or change an automatically retrieved preliminary freight fee)
  • The order header status is below 40.

Freight fee calculation for the real fee is performed at pick list confirmation.

Manually entered or changed:
If the user manually entered a freight fee in the equivalent field in the maintenance program or changed an automatically retrieved preliminary freight fee, this will be denoted in the Man frei fee field on the Order header. That field will be set to YES. No freight fee calculation for the real fee will be performed at pick list confirmation. This fee can also be defined when confirming the pick list.

For back order lines:
If the FREICALC (Freight fee calculation) function is activated in the Function control file, and the order generates back orders in the system, the value in the Fee limit back order field (in the DIS control file, or overridden in the Customer file) determines if an additional freight fee calculation will take place for back order lines. The system could have been set up to prevent an additional freight fee calculation for back order lines during pick list confirmation.

When a pick list is confirmed and the order includes previously invoiced order lines (i.e. any other line on the order has status 60), the total weight for confirmed lines is compared to the value in the Fee limit back order field. The result is as follows:

  • If the Fee limit back order field does not contain any value in any of the above-mentioned locations a freight fee calculation will be performed for all back order lines.
  • If a value is defined in the Fee limit back order field in any of the above-mentioned locations the freight fee calculation will only take place if the total weight of the remaining order lines is greater than this value.

During any freight fee calculation, the system will search for a freight fee that could be based on a freight fee per package or weight limit. If found, that freight fee will be added to any additional invoice containing the back order lines.

Insurance
Displays the fee for insurance. If the order generates back orders in the system, the insurance fee will only be charged on the first invoice sent to the customer. Note: This fee can also be defined when confirming the pick list.
Insurance %
If the Calculate insurance field on this panel is set to YES, a percentage can automatically be retrieved from the Insurance table and displayed here. The field can be changed as long as the Calculate insurance field on this panel is set to YES.

Note: This fee can also be defined when confirming the pick list.

Since the insurance percentage can depend on the Manner of transport code and the Terms of delivery code, which is determined in the Insurance table, the percentage can be changed if you change these codes on this panel.

The insurance value is calculated on the invoices as:

Insurance % * total of the order lines
_______________________________________
100

If the Calculate insurance field on this panel is set to NO, this field must be blank. In addition, if the Insurance field on this panel is completed, this field must also be blank.

Calculate insurance
Indicates if insurance is to be calculated when invoices are printed. The value is retrieved from the Customer file. If there is a record in the Insurance table that matches the Manner of transport and/or the Terms of delivery and/or the Customer number on this sales order, a percentage will be retrieved from the Insurance table and displayed in the Insurance % field on this panel.

The insurance value is calculated on the invoices as:

Insurance % * total of the order lines
_______________________________________
100
Postage
Displays the postage fee. If the order generates back orders in the system, the postage fee will only be invoiced on the first invoice sent to the customer. Note: This fee can also be defined when confirming the pick list.
Administration fee
Displays the administration fee. If the order generates a back order in the system, the administration fee will only be invoiced on the first invoice sent to the customer. Note: This fee can also be defined when confirming the pick list.
Invoice fee
Displays the fee for the invoicing. If the order generates back orders in the system, the fee will only be invoiced on the first invoice sent to the customer. Note: This fee can also be defined when confirming the pick list.
Estimated surcharges
Displays the estimated value of the surcharges that will be added to the sales order. Note: This is an estimate, since the goods have not been shipped. It is, therefore, not possible to determine the exact cost of the packaging used.
Estimated tax/VAT
Displays the estimated tax/VAT. This does not include the amount of tax/VAT that will be calculated for the packaging used for shipping the goods.
Expected payments
Displays the total payment that is due to be received. The order will be held until the payment is received. For example, if a cheque has been sent as payment by mail.
Received payments
Displays the amount that has been received. This payment will be printed on the invoice. For example, if the order has been paid in cash at counter sale.
Posted paym/credits
Displays the total amount for payments that have been posted to Accounts Receivable in DC1 Financials. This payment will be printed on the invoice and subtracted from the amount due. For example, if a credit note for the debtor in Accounts Receivable in DC1 Financials has been settled as partial or full payment for the order. It could also be a pre-paid amount or advanced payment.

Note: If an asterisk (*) is displayed in this field then this indicates that the A/R payment has been entered but has not yet been posted to the General Ledger in DC1 Financials.

Credit card
Displays the amount that has been paid for by credit card.
Cash discount 1 days
Displays the number of days within which payment must be made if the cash discount percentage for Cash discount 1 shall be valid. Extra cash days can be defined for each debtor or supplier in the Business partner file, which will allow payment to be made later, but the cash discount conditions will still apply.

Note: This value is controlled by the Terms of payment parameter in the Business partner file maintenance, A/R basic data panel. The Term of payment that is attributed to the customer must specify a Cash discount 1 days. Note: The terms of payment are defined in the Terms of payment table.

Cash discount 1 %
Displays the percentage applicable for Cash discount 1.

Note: This value is controlled by the Terms of payment parameter in the Business partner file maintenance, A/R basic data panel. The Term of payment that is attributed to the customer must specify a Cash discount 1 %. Note: The terms of payment are defined in the Terms of payment table.

Cash discount 2 days
Displays the number of days within which payment must be made if the cash discount percentage for Cash discount 2 % shall be valid. Extra cash days can be defined for each debtor or supplier in the Business partner file, which will allow payment to be made later, but the cash discount conditions will still apply.

Note: This value is controlled by the Terms of payment parameter in the Business partner file maintenance, A/R basic data panel. The Term of payment that is attributed to the customer must specify a Cash discount 2 days. Note: The terms of payment are defined in the Terms of payment table.

Cash discount 2 %
Displays the percentage applicable for Cash discount 2.

Note: This value is controlled by the Terms of payment parameter in the Business partner file maintenance, A/R basic data panel. The Term of payment that is attributed to the customer must specify a Cash discount 2 %. Note: The terms of payment are defined in the Terms of payment table.

Coin adjustment
Displays the sum of the Coin adjustment and Cash discount fields, specified on the Order settlements, Details panel. Note: Coin adjustments is a part of the currency handling function. This allows you to round off the invoice amount for certain currencies. For example if the invoice amount is 12,97 SEK (Swedish Crowns) and the SEK currency in the Currency table indicates rounding to the nearest Crown, then the invoice will be rounded to 13 SEK.

Surch

Below this heading the various types of surcharges that have been calculated for the order are displayed. Note: Values are only displayed if surcharge handling has been specified for the item(s) via the Item file maintenance, Units panel and the order type has been defined for Surcharge handling in Sales order type maintenance on the Order header, main info panel.

Price/percent

Below this heading the price/percent surcharge applicable to the item are displayed.

Per

Below this heading the surcharges that are applicable per item are displayed.

Amount

Below this heading the total surcharge amounts are displayed.