Supplier Advances

This form is used to manage supplier advances data.

Application menu
Purchases → Supplier Advances
Database table
supplierdp
Primary Key
transid (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 updatetimestamp.
Print template
Update the print template for this form via General → Print Layout using Design Group = supplierdpform.
List print template
Adjust the list print layout via General → Print Layout using Design Group = supplierdplist.
supplier advances
SUPPLIER ADVANCES (Daftar)
supplier advances
SUPPLIER ADVANCES (Form)

Additional Fields

The additional fields 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 both date and time. It defaults to the current timestamp and can be adjusted via the picker or typed manually.
  • 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.

Supplier

  • Code
    The code input is required.. The code input can be used as a filter on the main list form..
    • This field searches table supplier (form Supplier). 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.
  • Address
    This input is read-only and only displays data from system..
    • This field displays address and is populated automatically.
  • Payment Type
    The payment type input is required..
    • 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..
  • Advance Payment Type
    The advance payment type input is required..
    • Options are loaded from table paymenttype (form Payment Method List). The default value follows the Role User form, but you can choose another item.
  • Advance Payment
    The advance payment input is required.. The advance payment input can be used as a filter on the main list form..
    • Enter numeric values into advance payment.
  • Notes
    The notes 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..
  • 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.

English Documentation Administrator 08 Nov 2025 05:19pm