Sales Return

This form is used to manage sales return data.

Application menu
Sales → Sales Return
Database table
sales
Primary Key
salesid (Invoice).
User permissions
Access for this form (create, update, delete, duplicate) can be configured from the General → User Role List menu.
Initial focus when creating data
Field Division will receive focus first.
Sorting order
Records are sorted by Sales Date then salestime.
Print template
Update the print template for this form via General → Print Layout using Design Group = salesreturnform.
List print template
Adjust the list print layout via General → Print Layout using Design Group = salesreturnlist.
sales return
SALES RETURN (Daftar)
sales return
SALES RETURN (Form)

General

The general section contains several inputs that end users can populate:

  • Division
    The division input is required.. The division input can be used as a filter on the main list form..
    • Options are loaded from table division (form Division List). The default value follows the Role User form, but you can choose another item.
  • Invoice
    The invoice input is required.. The invoice input can be used as a filter on the main list form..
  • Date
    The date input is required.. The date input can be used as a filter on the main list form..
    • This field captures a date. It defaults to today, and you can select another date from the picker or type it manually.
  • Time
    The time input is required.. The time input can be used as a filter on the main list form..
    • This field captures a time value. It defaults to the current time but you can adjust it via the picker or by typing.
  • Currency
    The currency input is required.. The currency input can be used as a filter on the main list form..
    • Options are loaded from table currencies (form Currency List). The default value follows the Role User form, but you can choose another item.
  • Default Exchange Rate
    • Enter numeric values into default exchange rate.
  • Applied Exchange Rate
    • Enter numeric values into applied exchange rate.

Customer

  • Customer Code
    The customer code input is required.. The customer code input can be used as a filter on the main list form..
    • This field searches table customer (form Customer). Open the dropdown, type a keyword, and pick the desired record.
  • Customer Name
    This input is read-only and only displays data from system.. The customer name input can be used as a filter on the main list form..
    • This field displays customer name and is populated automatically.
  • Address
    This input is read-only and only displays data from system..
    • This field displays address and is populated automatically.
  • Taxpayer ID
    This input is read-only and only displays data from system..
    • This field displays taxpayer id and is populated automatically.
  • Credit Limit
    This input is read-only and only displays data from system..
    • This field displays credit limit and is populated automatically.
  • Credit Limit Type
    The credit limit type input can be used as a filter on the main list form..
    • Select one of the available options.
    • Available options:
      • Invoice Amount Limit
      • Invoice Quantity Limit
  • Accounts Receivable
    This input is read-only and only displays data from system..
    • This field displays accounts receivable and is populated automatically.

Sales Representative

  • Code
    The code input can be used as a filter on the main list form..
    • This field searches table salesman (form Sales Representative). Open the dropdown, type a keyword, and pick the desired record.
  • Name
    This input is read-only and only displays data from system.. The name input can be used as a filter on the main list form..
    • This field displays name and is populated automatically.
  • Sales Details
    • Add Returned Product entries via the [+ New] action (or [+] icon on mobile). The dialog that appears contains the fields described in Sales Details.
  • Payment Term
    The payment term input is required..
    • Select one of the available options.
    • Available options:
      • Cash
      • Cash on Delivery
      • Credit
  • Discount Days Limit
    The discount days limit input is required.. The discount days limit input can be used as a filter on the main list form..
  • Payment Term
    The payment term input is required.. The payment term input can be used as a filter on the main list form..
  • Discount
    • Enter numeric values into discount.
  • Total Sales Return
    This input is read-only and only displays data from system.. The total sales return input can be used as a filter on the main list form..
    • This field displays total sales return and is populated automatically.
  • Payment
    • Add Payment Returned entries via the [+ New] action (or [+] icon on mobile). The dialog that appears contains the fields described in Payment.

Expense

The expense section contains several inputs that end users can populate:

  • Expense
    • Add salesreturnexpensesdetail entries via the [+ New] action (or [+] icon on mobile). The dialog that appears contains the fields described in Expense.

Rewards and Points

The rewards and points section contains several inputs that end users can populate:

  • Points Balance
    This input is read-only and only displays data from system.. The points balance input can be used as a filter on the main list form..
    • This field displays points balance and is populated automatically.
  • Points
    The points input can be used as a filter on the main list form..
    • Enter numeric values into points.
  • Total Points
    This input is read-only and only displays data from system.. The total points input can be used as a filter on the main list form..
    • This field displays total points and is populated automatically.
  • Product Gift
    • Add Returned Reward entries via the [+ New] action (or [+] icon on mobile). The dialog that appears contains the fields described in Product Gift.

Additional Tax

The additional tax section contains several inputs that end users can populate:

  • Additional Tax
    • Add salesreturnextratax entries via the [+ New] action (or [+] icon on mobile). The dialog that appears contains the fields described in Additional Tax.

Others

The others section contains several inputs that end users can populate:

  • Notes
    The notes input can be used as a filter on the main list form..
  • Change Log
    The change log input can be used as a filter on the main list form..
  • Printed
    The printed input can be used as a filter on the main list form..
  • Shipment
    The shipment input is required.. The shipment input can be used as a filter on the main list form..
    • Options are loaded from table shipments (form Shipment List). The default value follows the Role User form, but you can choose another item.
  • Received Date
    This input is read-only and only displays data from system.. The received date input can be used as a filter on the main list form..
    • This field displays a timestamp that is populated automatically.
  • Received
    The received input can be used as a filter on the main list form..
  • Settled
    The settled input can be used as a filter on the main list form..
  • Settlement Date
    This input is read-only and only displays data from system.. The settlement date input can be used as a filter on the main list form..
    • This field captures a date. It defaults to today, and you can select another date from the picker or type it manually.
  • Settlement Ref.
    This input is read-only and only displays data from system.. The settlement ref. input can be used as a filter on the main list form..
  • Created By
    This input is read-only and only displays data from system.. The created by input can be used as a filter on the main list form..
    • This field shows the user code that created the record and is filled automatically.
  • Modified By
    This input is read-only and only displays data from system.. The modified by input can be used as a filter on the main list form..
    • This field shows the user code that last modified the record and is filled automatically.
  • Last Modified
    This input is read-only and only displays data from system.. The last modified input can be used as a filter on the main list form..
    • This field displays a timestamp that is populated automatically.

Returned Product

This form is used to manage sales details data.

Database table
salesdetail
Primary Key
transid (Code).
User permissions
Access for this form (create, update, delete, duplicate) can be configured from the General → User Role List menu.
Initial focus when creating data
Field Product will receive focus first.
Sorting order
Records are sorted by Invoice.
List print template
Adjust the list print layout via General → Print Layout using Design Group = .
sales details
SALES DETAILS (Daftar)
sales details
SALES DETAILS (Form)

Additional Fields

The additional fields section contains several inputs that end users can populate:

  • Department
    The department input is required.. The department input can be used as a filter on the main list form..
    • This field searches table departement (form Department). Open the dropdown, type a keyword, and pick the desired record.
  • Product
    The product input is required.. The product input can be used as a filter on the main list form..
    • This field searches table product (form Product). Open the dropdown, type a keyword, and pick the desired record.
  • Name
    This input is read-only and only displays data from system.. The name input can be used as a filter on the main list form..
    • This field displays name and is populated automatically.
  • Serial Number
    The serial number input can be used as a filter on the main list form..
    • This field searches inventory. Open the dropdown, type a keyword, and pick the desired record.
  • Expiration Date
    This input is read-only and only displays data from system.. The expiration date input can be used as a filter on the main list form..
    • This field captures a date. It defaults to today, and you can select another date from the picker or type it manually.
  • Unit
    The unit input is required.. The unit input can be used as a filter on the main list form..
    • This field searches units. Open the dropdown, type a keyword, and pick the desired record.
  • Return Quantity
    The return quantity input is required.. The return quantity input can be used as a filter on the main list form..
    • Enter numeric values into return quantity.
  • Price
    • Enter numeric values into price.
  • Gross
    This input is read-only and only displays data from system..
    • This field displays gross and is populated automatically.
  • Discount (%)
    • Enter numeric values into discount (%).
  • Discount Value
    • Enter numeric values into discount value.
  • Tax
    The tax input can be used as a filter on the main list form..
    • Options are loaded from table taxes (form Tax List). The default value follows the Role User form, but you can choose another item.
  • Tax Amount
    The tax amount input can be used as a filter on the main list form..
    • Enter numeric values into tax amount.
  • Subtotal
    This input is read-only and only displays data from system..
    • This field displays subtotal and is populated automatically.
  • Service Staff
    The service staff input is required.. The service staff input can be used as a filter on the main list form..
    • This field searches table servicedoer (form Service Staff). Open the dropdown, type a keyword, and pick the desired record.
  • Service Staff Name
    This input is read-only and only displays data from system.. The service staff name input can be used as a filter on the main list form..
    • This field displays service staff name and is populated automatically.
  • Notes
    The notes input can be used as a filter on the main list form..

Payment Returned

This form is used to manage payment data.

Database table
salespayments
Primary Key
transid (Code).
User permissions
Access for this form (create, update, delete, duplicate) can be configured from the General → User Role List menu.
Initial focus when creating data
Field Payment Type will receive focus first.
Sorting order
Records are sorted by Invoice.
List print template
Adjust the list print layout via General → Print Layout using Design Group = .
payment
PAYMENT (Daftar)
payment
PAYMENT (Form)

Additional Fields

The additional fields section contains several inputs that end users can populate:

  • Payment Type
    The payment type input is required.. The payment type input can be used as a filter on the main list form..
    • Options are loaded from table paymenttype (form Payment Method List). The default value follows the Role User form, but you can choose another item.
  • QR Code
    This input is read-only and only displays data from system..
  • Payment
    • Enter numeric values into payment.
  • Discount (%)
    • Enter numeric values into discount (%).
  • Discount
    • Enter numeric values into discount.
  • Due Date
    • This field captures a date. It defaults to today, and you can select another date from the picker or type it manually.
  • Received
  • Payment Ref.

salesreturnexpensesdetail

This form is used to manage expense data.

Database table
salesexpensesdetail
Primary Key
transid (Code).
User permissions
Access for this form (create, update, delete, duplicate) can be configured from the General → User Role List menu.
Initial focus when creating data
Field Expense will receive focus first.
Sorting order
Records are sorted by Invoice.
List print template
Adjust the list print layout via General → Print Layout using Design Group = .
expense
EXPENSE (Daftar)
expense
EXPENSE (Form)

Additional Fields

The additional fields section contains several inputs that end users can populate:

  • Expense
    The expense input is required.. The expense input can be used as a filter on the main list form..
    • This field searches table salesexpenses (form Selling Expenses). Open the dropdown, type a keyword, and pick the desired record.
  • Expense Value
    • Enter numeric values into expense value.
  • Notes

Returned Reward

This form is used to manage product gift data.

Database table
salesrewarddetail
Primary Key
transid (Code).
User permissions
Access for this form (create, update, delete, duplicate) can be configured from the General → User Role List menu.
Initial focus when creating data
Field Product will receive focus first.
Sorting order
Records are sorted by Invoice.
List print template
Adjust the list print layout via General → Print Layout using Design Group = .
product gift
PRODUCT GIFT (Daftar)
product gift
PRODUCT GIFT (Form)

Additional Fields

The additional fields section contains several inputs that end users can populate:

  • Department
    The department input is required.. The department input can be used as a filter on the main list form..
    • This field searches table departement (form Department). Open the dropdown, type a keyword, and pick the desired record.
  • Product
    The product input is required.. The product input can be used as a filter on the main list form..
    • This field searches table product (form Product). Open the dropdown, type a keyword, and pick the desired record.
  • Name
    This input is read-only and only displays data from system.. The name input can be used as a filter on the main list form..
    • This field displays name and is populated automatically.
  • Serial Number
    The serial number input can be used as a filter on the main list form..
    • This field searches inventory. Open the dropdown, type a keyword, and pick the desired record.
  • Expiration Date
    This input is read-only and only displays data from system.. The expiration date input can be used as a filter on the main list form..
    • This field captures a date. It defaults to today, and you can select another date from the picker or type it manually.
  • Unit
    The unit input is required.. The unit input can be used as a filter on the main list form..
    • This field searches units. Open the dropdown, type a keyword, and pick the desired record.
  • Return Quantity
    • Enter numeric values into return quantity.
  • Price
    • Enter numeric values into price.
  • Gross
    This input is read-only and only displays data from system..
    • This field displays gross and is populated automatically.
  • Tax
    The tax input can be used as a filter on the main list form..
    • Options are loaded from table taxes (form Tax List). The default value follows the Role User form, but you can choose another item.
  • Tax Amount
    • Enter numeric values into tax amount.
  • Subtotal
    This input is read-only and only displays data from system..
    • This field displays subtotal and is populated automatically.
  • Notes
    The notes input can be used as a filter on the main list form..

salesreturnextratax

This form is used to manage additional tax data.

Database table
salesextratax
Primary Key
transid (Code).
User permissions
Access for this form (create, update, delete, duplicate) can be configured from the General → User Role List menu.
Initial focus when creating data
Field Product will receive focus first.
Sorting order
Records are sorted by Invoice.
List print template
Adjust the list print layout via General → Print Layout using Design Group = .
additional tax
ADDITIONAL TAX (Daftar)
additional tax
ADDITIONAL TAX (Form)

Additional Fields

The additional fields section contains several inputs that end users can populate:

  • Product
    The product input is required.. The product input can be used as a filter on the main list form..
    • This field searches salesdetail. Open the dropdown, type a keyword, and pick the desired record.
  • Name
    This input is read-only and only displays data from system.. The name input can be used as a filter on the main list form..
    • This field displays name and is populated automatically.
  • Return Quantity
    • Enter numeric values into return quantity.
  • Unit
    The unit input is required.. The unit input can be used as a filter on the main list form..
    • This field displays unit and is populated automatically.
  • Gross
    This input is read-only and only displays data from system..
    • This field displays gross and is populated automatically.
  • Tax
    The tax input can be used as a filter on the main list form..
    • Options are loaded from table taxes (form Tax List). The default value follows the Role User form, but you can choose another item.
  • Tax Amount
    • Enter numeric values into tax amount.

English Documentation Administrator 08 Nov 2025 05:19pm