Inistate Documentation
  • Welcome
  • Workspace
  • Module
  • User
    • Role
    • Profile
    • Management
  • Configuration
    • Builder
    • Studio
  • Features
    • Basic
    • Information
    • Listing
    • Activity
    • Form
    • State
    • Flow
  • Advanced
    • Formula
    • Authorization
    • Automation
      • Automation Block
      • Scripting
    • Notification
    • Template
      • Code
    • Logic
    • Integration
      • Accounting 1
        • Invoice
        • Cash Sale
        • Delivery Order
        • Stock Transfer
        • Sales Order
        • Creditor
        • Credit Note
        • Debit Note
        • A/P Invoice
        • A/P Credit Note
        • A/P Debit Note
        • Customer
      • Accounting 2
        • Debtor
        • Purchase Order
        • Good Receive
        • Payment Voucher
        • Customer Invoice
        • Customer Payment
Powered by GitBook
On this page
  1. Advanced
  2. Integration
  3. Accounting 1

Customer

PreviousA/P Debit NoteNextAccounting 2

Last updated 17 days ago

SQL ACCOUNTING integration - customer

example script
purpose

to let the system know you integration with Customer

change ["COMPANYNAME"]. You can refer below table

UI
mapping field
type
remarks

Company

COMPANYNAME

text

Code

CODE

text

Currency

CURRENCYCODE

text

map to Currency (need to make sure the Currency code exist in SQL)

Address line 1

ADDRESS1

text

Address line 2

ADDRESS2

text

Address line 3

ADDRESS3

text

Address line 4

ADDRESS4

text

Attention

ATTENTION

text

Phone

PHONE1

text

Email

EMAIL

text

payloadData["type"] = "AR_CUSTOMER"
payloadData["payload"]["COMPANYNAME"] = data["Name"]