Sales

This form is used to manage sales data.

SALES (Daftar)

SALES (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.
• Rental Transaction
  The rental transaction input can be used as a filter on the main list form..
• Rental Duration
• Rental Unit
  The rental unit input can be used as a filter on the main list form..
  • Select one of the available options.
  • Available options:
    • Hour
    • Day
    • Month
    • Year
• Rental Expired
  The rental expired input can be used as a filter on the main list form..
  • This field captures both date and time. It defaults to the current timestamp and can be adjusted via the picker or typed manually.
• Rental Completed
  This input is read-only and only displays data from system.. The rental completed input can be used as a filter on the main list form..
• 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

• Sales Representative Code
  The sales representative 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.
• Sales Representative Name
  This input is read-only and only displays data from system.. The sales representative name input can be used as a filter on the main list form..
  • This field displays sales representative name and is populated automatically.

Fill Data from Sales Order

• Sales Order
  • This field searches table salesorder (form Sales Order). Open the dropdown, type a keyword, and pick the desired record.
• Sales Details
  • Add Sales Details 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..
• Discount (%)
  • Enter numeric values into discount (%).
• Payment Term
  The payment term input is required.. The payment term input can be used as a filter on the main list form..
• Billed To
  The billed to input is required.. The billed to 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..
  • This field displays customer name 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.
• Discount (%)
  • Enter numeric values into discount (%).
• Discount
  • Enter numeric values into discount.
• Total Sales
  This input is read-only and only displays data from system.. The total sales input can be used as a filter on the main list form..
  • This field displays total sales and is populated automatically.
• Payment
  • Add Sales Payment 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 salesexpensesdetail 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.
• Check Rewards & Points
  This input is read-only and only displays data from system..
• Product Gift
  • Add Product Gift 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 salesextratax 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.
• Product Received
  The product 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.

Sales Details

This form is used to manage sales details data.

SALES DETAILS (Daftar)

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.
• SN from List
• 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.
• Quantity
  • Enter numeric values into 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
  This input is read-only and only displays data from system..
  • This field displays tax amount and is populated automatically.
• 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..

Sales Payment

This form is used to manage payment data.

PAYMENT (Daftar)

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..
• Check Customer Points
  This input is read-only and only displays data from system..
• Total Points
  The total points input can be used as a filter on the main list form..
  • Enter numeric values into total points.
• Payment Value per 1 Point
  This input is read-only and only displays data from system.. The payment value per 1 point input can be used as a filter on the main list form..
  • This field displays payment value per 1 point and is populated automatically.
• 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.
• Payment Fees (%)
  • Enter numeric values into payment fees (%).
• Payment Fees
  • Enter numeric values into payment fees.
• onlinepaymentspaynow

salesexpensesdetail

This form is used to manage expense data.

EXPENSE (Daftar)

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

Product Gift

This form is used to manage product gift data.

PRODUCT GIFT (Daftar)

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.
• Quantity
  • Enter numeric values into 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
  This input is read-only and only displays data from system..
  • This field displays tax amount and is populated automatically.
• 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..

salesextratax

This form is used to manage additional tax data.

ADDITIONAL TAX (Daftar)

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.
• Quantity
  • Enter numeric values into 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
  This input is read-only and only displays data from system..
  • This field displays tax amount and is populated automatically.