Writing data

Implementation of the latest Diamant webservice to access and modify data in your accounting software. Here is an explanation of writing data.

PostCustomer

Creates a new customer record.

Example

let result = app.businessFunction({
    functionName: "Diamant",
    methodName: "PostCustomer", 
    companyId: 999,
    designation: "Muster GmbH",
    designation2: "Abteilung Einkauf",
    matchCode: "MUSTGMBH",
    accountId: "10050",
    dunningType: "STD",
    vatIdentNumber: "DE123456789",
    taxNumber: "31/432/70358",
    summaryAccount: "1200",
    bankId: 98765,
    bankAccountNumber: "1234567890",
    iban: "DE89370400440532013000",
    isVariousAccount: false,
    paymentCondition: "14T2%30T",
    paymentMethod: "U",
    paymentsExclusion: "2025-03-07T10:52:16.775Z",
    bankAccountHolder: "Muster GmbH",
    paymentsExclusionReason: "Dispute",
    alternativeBankDetailsTab: [
        {
            bankId: 87654,
            bankAccountNumber: "0987654321",
            iban: "DE27100777770209299700",
            bankAccountHolder: "Muster GmbH Zweitkonto"
        }
    ]
});

PostVendor

Creates a new vendor record.

Example

let result = app.businessFunction({
    functionName: "Diamant",
    methodName: "PostVendor",
    companyId: 999,
    designation: "Technik Supplies GmbH",
    designation2: "Büroausstattung",
    matchCode: "TECHSUPP",
    vatIdentNumber: "DE987654321",
    taxNumber: "76/543/21098",
    summaryAccount: "7000",
    bankId: 12345,
    bankAccountNumber: "9876543210",
    iban: "DE45500105174529223988",
    isVariousAccount: false,
    paymentCondition: "30T",
    paymentMethod: "T",
    paymentsExclusion: "2025-03-07T10:56:28.722Z",
    bankAccountHolder: "Technik Supplies GmbH",
    paymentsExclusionReason: "Reorg",
    accountId: "70050",
    customerIdAtVendor: "CU-78901",
    alternativeBankDetailsTab: [
        {
            bankId: 54321,
            bankAccountNumber: "1122334455",
            iban: "DE91100000000123456789",
            bankAccountHolder: "Technik Supplies International"
        }
    ]
});

PostContactPerson

Creates a contact person record.

Example

let result = app.businessFunction({
    functionName: "Diamant",
    methodName: "PostContactPerson", 
    companyId: 999, 
    contactPersonId: 12345,
    addressId: 5678,
    salutationId: 2, // Assuming this is an ID for Mr/Ms etc.
    title: "Dr.",
    firstName: "Anna",
    name: "Schmidt",
    function: "Purchasing Manager",
    extension: "4302",
    email: "[e-mail]",
    fax: "[phone]",
    mobileNumber: "[phone]",
    letterSelection: "BS",
    changeDate: "2025-03-07T10:58:11.107Z",
    changedBy: "SYSTEM"
});

PostOpenStack

Opens a transaction stack.

Example

let result = app.businessFunction({
    functionName: "Diamant",
    methodName: "PostOpenStack", 
    companyId: 999
});

PostTransactionBatch

Posts a batch of transactions.

Example

let result = app.businessFunction({
    functionName: "Diamant",
    methodName: "PostTransactionBatch", 
    companyId: 999,
    stackNumber: 447711,
    transactionTab: [
        {
            transactionId: 12345,
            transactionType: "INVP",
            transactionDate: "2025-03-07T11:06:54.038Z",
            transactionNumber: "INV-2025-0567",
            internalTransactionNumber: "202503-1234",
            currency: "EUR",
            rate: 1.0,
            archiveKey: "AP/2025/03/0567",
            barcode: "20250300567",
            allowDuplicateBarcode: false,
            ledgerEntryNumber: 5678,
            origin: "AP",
            accountAssignmentTab: [
                {
                    accountAssignmentId: 78901,
                    accountId: "7000",
                    taxCode: 19,
                    debit: 2380.00,
                    credit: 0,
                    turnover: 2380.00,
                    text: "Office supplies purchase",
                    fcDebit: 2380.00,
                    fcCredit: 0,
                    fcTurnover: 2380.00,
                    movementTypeId: "PURCH",
                    associatedCompanyId: "SUP123",
                    costAccountingDataTab: [
                        {
                            costAccountingDataId: 23456,
                            costCenterId: "4000",
                            costObjectId: "ADMIN",
                            projectId: "OPS2025",
                            amount: 2000.00,
                            fcAmount: 2000.00,
                            quantity: 1,
                            costElementId: "OFFICE"
                        }
                    ],
                    openItemDataTab: [
                        {
                            openItemDataId: 34567,
                            amount: 2380.00,
                            fcAmount: 2380.00,
                            valueDate: "2025-03-07T11:06:54.038Z",
                            dueDate: "2025-04-06T11:06:54.038Z",
                            cashDiscount1To: "2025-03-17T11:06:54.038Z",
                            cashDiscount1Percent: 2.0,
                            cashDiscount2To: "2025-03-27T11:06:54.038Z",
                            cashDiscount2Percent: 1.0,
                            text: "Office supplies invoice",
                            openItemInvoiceType: "I",
                            additionalField1: "PO-2025-123",
                            additionalField2: "Admin Department",
                            additionalField3: "Regular Supplier",
                            additionalField4: "",
                            additionalField5: "",
                            additionalField6: "",
                            additionalField7: "",
                            additionalField8: "",
                            additionalField9: "",
                            additionalField10: "",
                            note: "Monthly office supplies",
                            name: "Office Supply Co.",
                            name2: "Munich Branch",
                            contactPerson: "Max Mustermann",
                            street: "Hauptstrasse 123",
                            town: "Munich",
                            faxNumber: "[phone]",
                            email: "[e-mail]",
                            bankId: 98765,
                            bankAccountNumber: "1234567890",
                            iban: "DE89370400440532013000",
                            bankAccountHolder: "Office Supply Co."
                        }
                    ]
                },
                {
                    accountAssignmentId: 78902,
                    accountId: "1903",
                    taxCode: 19,
                    debit: 0,
                    credit: 380.00,
                    turnover: 380.00,
                    text: "VAT on office supplies",
                    fcDebit: 0,
                    fcCredit: 380.00,
                    fcTurnover: 380.00,
                    movementTypeId: "VAT",
                    associatedCompanyId: ""
                },
                {
                    accountAssignmentId: 78903,
                    accountId: "70050",
                    taxCode: 0,
                    debit: 0,
                    credit: 2000.00,
                    turnover: 2000.00,
                    text: "Office supplies vendor",
                    fcDebit: 0,
                    fcCredit: 2000.00,
                    fcTurnover: 2000.00,
                    movementTypeId: "VEND",
                    associatedCompanyId: "SUP123"
                }
            ],
            postingPeriod: {
                year: 2025,
                month: 3,
                periodType: "Normal"
            }
        }
    ]
});

PostCloseStack

Closes a transaction stack.

Example

let result = app.businessFunction({
    functionName: "Diamant",
    methodName: "PostCloseStack", 
    companyId: 999,
    stackNumber: 447711
});

PostReverseTransaction

Reverses a transaction.

Example

let result = app.businessFunction({
    functionName: "Diamant",
    methodName: "PostReverseTransaction", 
    companyId: 999,
    transactionId: 78901,
    reversingTransactionData: {
        transactionNumber: "INV-2025-0342",
        internalTransactionNumber: "202503-0789",
        transactionDate: "2025-03-07T11:00:49.972Z",
        postingText: "Reversal of incorrect invoice posting",
        postingPeriod: {
            year: 2025,
            month: 3,
            periodType: "Normal" 
        }
    }
});

PostGenLedgerAccount

Creates a general ledger account.

Example

let result = app.businessFunction({
    functionName: "Diamant",
    methodName: "PostGenLedgerAccount",
    designation: "Marketing Department",
    designation2: "Digital Campaigns",
    matchCode: "MKTDIG",
    companyId: 999, 
    accountId: "4500",
    type: "PR", 
    discountAccount: "8100",
    costElement: "MKT01"
});

PostSettleOpenItems

Settles open items.

Example

let result = app.businessFunction({
    functionName: "Diamant",
    methodName: "PostSettleOpenItems", 
    companyId: 999, 
    openItems: [
        {
            openItemId: 123456,
            transactionId: 78901,
            transactionPostingPeriod: {
                year: 2025,
                month: 3,
                periodType: "Normal"
            },
            transactionDate: "2025-03-07T11:02:57.446Z",
            transactionNumber: "INV-2025-0456",
            transactionInternalNumber: "202503-0892",
            transactionType: "SALE",
            transactionReversingTransactionId: 0,
            transactionCurrency: "EUR",
            transactionOrigin: "AP",
            transactionPostingTime: "2025-03-07T11:02:57.446Z",
            transactionPostingBy: "USER",
            accountId: "10050",
            accountClass: "KR",
            postingAmount: 1250.00,
            postingFcAmount: 1250.00,
            postingText: "Invoice payment",
            postingCode: "P",
            openItemAmount: 1250.00,
            openItemFcAmount: 1250.00,
            openItemDueDate: "2025-04-07T11:02:57.446Z",
            openItemValueDate: "2025-03-10T11:02:57.446Z",
            openItemInvoiceType: "I",
            openItemCashDiscount1To: "2025-03-21T11:02:57.446Z",
            openItemCashDiscount1Percent: 2.0,
            openItemCashDiscount2To: "2025-03-31T11:02:57.446Z",
            openItemCashDiscount2Percent: 1.0,
            openItemPayedOn: "2025-03-20T11:02:57.446Z",
            openItemDunningLevel: "00",
            openItemLastDunningLetter: "2025-03-07T11:02:57.446Z",
            openItemTaxCode1DiscountableAmount: 1050.00,
            openItemTaxCode1FcDiscountableAmount: 1050.00,
            openItemTaxCode2DiscountableAmount: 0,
            openItemTaxCode2FcDiscountableAmount: 0,
            openItemLastChange: "2025-03-07T11:02:57.446Z",
            openItemAddressIban: "DE89370400440532013000",
            openItemAdditionalField1: "Project A",
            openItemAdditionalField2: "Department 3",
            openItemAdditionalField3: "Contract 2025-034",
            openItemAdditionalField4: "",
            openItemAdditionalField5: "",
            openItemAdditionalField6: "",
            openItemAdditionalField7: "",
            openItemAdditionalField8: "",
            openItemAdditionalField9: "",
            openItemAdditionalField10: "",
            settlementRowId: 5678,
            settlementAmount: 1250.00,
            settlementFcAmount: 1250.00,
            settlementWithOpenItemId: 78654,
            settlementWithTransactionInternalNumber: "202503-0675",
            settlementWithTransactionType: "PAYM",
            settlementWithTransactionDate: "2025-03-20T10:15:00.000Z",
            settlementNumber: 20250301,
            settlementYear: 2025,
            settlementWriteOffScenarioId: 0
        }
    ]
});

PostBank

Creates a new bank record.

Example

let result = app.businessFunction({
    functionName: "Diamant",
    methodName: "PostBank",
    companyId: 999,
    bankId: 98765,
    bankSortingCode: 70050000,
    designation: "Sparkasse München",
    bic: "BYLADEM1KMS",
    name1: "Stadtsparkasse München",
    name2: "Hauptfiliale",
    street: "Sendlinger Str. 28",
    town: "80331 München",
    countryByNorm: "DE",
    norm4Country: "ISOa2",
    countryID: "DE",
    bankType: 2,
    branch: "0001",
    changedBy: "TEST"
})

PostCostCenter

Creates a cost center record.

Example

let result = app.businessFunction({
    functionName: "Diamant",
    methodName: "PostCostCenter"
    designation: "Production Department",
    designation2: "Assembly Line 3",
    matchCode: "PRODASL3",
    deleteRegistered: false,
    postBlocked: true,
    companyId: 999, 
    costCenterId: "6000",
    costCenterType: "P"
});

PostCostObject

Creates a cost object record.

Example

let result = app.businessFunction({
    functionName: "Diamant",
    methodName: "PostCostObject",
    designation: "Project Alpha",
    designation2: "Phase 2 Implementation",
    matchCode: "PROJALPHA2",
    deleteRegistered: false,
    postBlocked: true,
    companyId: 999,
    costObjectId: "PR2023-005",
    costObjectType: 3
});

SaveIIBTransaction

Posts a single transactions using the old SOAP api.

Example

let result = app.businessFunction({
    functionName: "Diamant",
    methodName: "SaveIIBTransaction",
    company: 999,
    iibStatus: 1,
    transactionType: "ERA",
    transDate: "2025-04-23T00:00:00",
    postingPeriod: "042025",
    transNumber: "CK-0423-99",
    internalTransNo: "799",
    currency: "EUR",
    rate: 1.0,
    barcode: "799",
    generalStatus: 2,
    // SOAP Flags
    flags: 0,
    allowDuplicateBarcode: true,
    postWithoutArchive: false,
    
    accountAssignments: [
        {
            key: null,
            accountNo: "70002",
            taxCode: null,
            debit: 119.0,
            credit: null,
            turnover: null,
            text: "Bueromaterial",
            fcDebit: null,
            fcCredit: null,
            fcTurnover: null,
            summaryAccount: null,
            balance: null,
            cAccData: [
                {
                    costCenter: "320",
                    costObject: null,
                    amount: 119.0,
                    fcAmount: null,
                    quantity: null,
                    unit: null
                }
            ]
        },
        {
            key: null,
            accountNo: "4930",
            taxCode: null,
            debit: null,
            credit: 119.0,
            turnover: null,
            text: "Lieferant XYZ",
            fcDebit: null,
            fcCredit: null,
            fcTurnover: null,
            summaryAccount: null,
            balance: null
        }
    ]

};