User Profile
Quan Pham
39
Posts
3
Kudos
1
Solution
04-03-2025
10:27
Hi, I'm encountering an error when trying to create a journal transaction with the JSON below. The same JSON works in another company but fails in this one. If I remove the "exchangeRate" field, it works, but it should be possible to send a value of 0 since it works for another company. Could you help me understand why this is happening and how to fix it? Thank you! { "ledger": { "Value": "1" }, "transactionCode": { "Value": "GLNE" }, "journalTransactionLines": [{ "accountNumber": { "Value": "9001" }, "transactionDescription": { "Value": "Datum: 2025-01-07" }, "quantity": { "Value": -8.5 }, "debitAmountInCurrency": { "Value": -3910.0 }, "subaccount": [{ "segmentId": 1, "segmentValue": "120230001" }, { "segmentId": 2, "segmentValue": "00" }, { "segmentId": 3, "segmentValue": "4300" } ], "creditAmountInCurrency": { "Value": 0.0 }, "lineNumber": { "Value": 0 }, "operation": "Insert" }, { "accountNumber": { "Value": "9009" }, "transactionDescription": { "Value": "Datum: 2025-01-07" }, "quantity": { "Value": -8.5 }, "creditAmountInCurrency": { "Value": -3910.0 }, "subaccount": [{ "segmentId": 1, "segmentValue": "110120001" }, { "segmentId": 2, "segmentValue": "00" }, { "segmentId": 3, "segmentValue": "0000" } ], "debitAmountInCurrency": { "Value": 0.0 }, "lineNumber": { "Value": 0 }, "operation": "Insert" }, { "accountNumber": { "Value": "9001" }, "transactionDescription": { "Value": "Datum: 2025-01-07" }, "quantity": { "Value": -8.5 }, "debitAmountInCurrency": { "Value": -3910.0 }, "subaccount": [{ "segmentId": 1, "segmentValue": "120230001" }, { "segmentId": 2, "segmentValue": "00" }, { "segmentId": 3, "segmentValue": "4300" } ], "creditAmountInCurrency": { "Value": 0.0 }, "lineNumber": { "Value": 0 }, "operation": "Insert" }, { "accountNumber": { "Value": "9009" }, "transactionDescription": { "Value": "Datum: 2025-01-07" }, "quantity": { "Value": -8.5 }, "creditAmountInCurrency": { "Value": -3910.0 }, "subaccount": [{ "segmentId": 1, "segmentValue": "110120001" }, { "segmentId": 2, "segmentValue": "00" }, { "segmentId": 3, "segmentValue": "0000" } ], "debitAmountInCurrency": { "Value": 0.0 }, "lineNumber": { "Value": 0 }, "operation": "Insert" }, { "accountNumber": { "Value": "9001" }, "transactionDescription": { "Value": "Datum: 2025-01-07" }, "quantity": { "Value": 8.5 }, "debitAmountInCurrency": { "Value": 5355.0 }, "subaccount": [{ "segmentId": 1, "segmentValue": "110120001" }, { "segmentId": 2, "segmentValue": "00" }, { "segmentId": 3, "segmentValue": "4100" } ], "creditAmountInCurrency": { "Value": 0.0 }, "lineNumber": { "Value": 0 }, "operation": "Insert" }, { "accountNumber": { "Value": "9009" }, "transactionDescription": { "Value": "Datum: 2025-01-07" }, "quantity": { "Value": 8.5 }, "creditAmountInCurrency": { "Value": 5355.0 }, "subaccount": [{ "segmentId": 1, "segmentValue": "110140001" }, { "segmentId": 2, "segmentValue": "00" }, { "segmentId": 3, "segmentValue": "0000" } ], "debitAmountInCurrency": { "Value": 0.0 }, "lineNumber": { "Value": 0 }, "operation": "Insert" } ], "transactionDate": { "Value": "2025-02-01T00:00:00.000Z" }, "description": { "Value": "Text." }, "financialPeriod": { "Value": "202502" }, "postPeriod": { "Value": "022025" }, "controlTotalInCurrency": { "Value": 0.0 }, "exchangeRate": { "Value": 0.0 } }
... View more
12-02-2025
13:39
Hi, It is disabled because we don't want to post to closed periods. Is it possible to post to an open period but with a transaction date from a closed one? I tried to use overrideNumberSeries=true but I receive the same error message.
... View more
12-02-2025
10:52
Hi, I'm getting this error when trying to create a journal transaction. 01-2025 is closed, but we're trying to create it in period 02-2025 with a transaction date of 2025-01-07. It is possible in the UI but not via the API. { "message": "VismaId: 5e12fdec-614e-4a20-9044-cf93b204a928. Error creating journal transaction. Error: An error in processing of field Post period value 01-2025 General ledger error: The financial period '01-2025' is closed."
} This is the json: { "ledger": { "Value": "1" }, "description": { "Value": "avseende registrerade tider" }, "transactionCode": { "Value": "GLNE" }, "journalTransactionLines": [{ "accountNumber": { "Value": "9001" }, "transactionDescription": { "Value": "Datum: 2025-01-07" }, "quantity": { "Value": -8.5 }, "debitAmountInCurrency": { "Value": -3910.0 }, "subaccount": [{ "segmentId": 1, "segmentValue": "120230001" }, { "segmentId": 2, "segmentValue": "00" }, { "segmentId": 3, "segmentValue": "4300" } ], "creditAmountInCurrency": { "Value": 0.0 }, "lineNumber": { "Value": 0 }, "operation": "Insert" }, { "accountNumber": { "Value": "9009" }, "transactionDescription": { "Value": "Datum: 2025-01-07" }, "quantity": { "Value": -8.5 }, "creditAmountInCurrency": { "Value": -3910.0 }, "subaccount": [{ "segmentId": 1, "segmentValue": "110120001" }, { "segmentId": 2, "segmentValue": "00" }, { "segmentId": 3, "segmentValue": "0000" } ], "debitAmountInCurrency": { "Value": 0.0 }, "lineNumber": { "Value": 0 }, "operation": "Insert" }, { "accountNumber": { "Value": "9001" }, "transactionDescription": { "Value": "Datum: 2025-01-07" }, "quantity": { "Value": -8.5 }, "debitAmountInCurrency": { "Value": -3910.0 }, "subaccount": [{ "segmentId": 1, "segmentValue": "120230001" }, { "segmentId": 2, "segmentValue": "00" }, { "segmentId": 3, "segmentValue": "4300" } ], "creditAmountInCurrency": { "Value": 0.0 }, "lineNumber": { "Value": 0 }, "operation": "Insert" }, { "accountNumber": { "Value": "9009" }, "transactionDescription": { "Value": "Datum: 2025-01-07" }, "quantity": { "Value": -8.5 }, "creditAmountInCurrency": { "Value": -3910.0 }, "subaccount": [{ "segmentId": 1, "segmentValue": "110120001" }, { "segmentId": 2, "segmentValue": "00" }, { "segmentId": 3, "segmentValue": "0000" } ], "debitAmountInCurrency": { "Value": 0.0 }, "lineNumber": { "Value": 0 }, "operation": "Insert" } ], "transactionDate": { "Value": "2025-01-07T03:00:00.000Z" }, "financialPeriod": { "Value": "202502" }, "postPeriod": { "Value": "022025" }, "controlTotalInCurrency": { "Value": 0.0 }, "exchangeRate": { "Value": 0.0 } }
... View more
19-06-2024
14:47
Hi, I'm experiencing the same issue when trying to create a inventory with type ComponentPartItem. It works if i use FinishedGoodItem. Json: { "inventoryNumber": { "Value": "test5" }, "status": { "Value": "NoRequest" }, "description": { "Value": "TEST5" }, "itemClass": { "Value": "410" }, "type": { "Value": "ComponentPartItem" }, "kitItem": { "Value": false }, "vatCode": { "Value": "02" }, "postingClass": { "Value": "P4100" }, "packaging": { "baseItemWeight": { "Value": 0.0 }, "baseItemVolume": { "Value": 0.0 } } } Response: { "message": "Error creating inventory. Error: Inserting 'Item' record raised at least one error. Please review the errors.\r\nThe class you have selected cannot be assigned to a non-stock item, because the Stock item check box is selected for this class in the Item classes window. Select another item class which is designated to group non-stock items.\r\nError: VAT category '02' cannot be found in the system.\r\nError: 'Base unit' cannot be empty.\r\nError: 'Sales unit' cannot be empty.\r\nError: 'Purchase unit' cannot be empty.\r\n" }
... View more
08-04-2024
09:06
1 Kudo
This is now solved. I removed "segments".
... View more
03-04-2024
15:06
Hi, I'm trying to update the salesSubaccount but i doesn't work. What am i doing wrong?
... View more
21-03-2024
09:53
Hi, I'm trying to create a inventory in a company that has many system languages active. I can't set the item description with the json below. The item is created with a empty description for all languages. Is there any way to make it work via the API? { "inventoryNumber": { "value": "TEST1Q" }, "status": { "value": "Active" }, "type": { "value": "FinishedGoodItem" }, "descriptionnb": { "value": "stetete" }, "itemclass": { "value": "100" }, "postingclass": { "value": "P1000" } }
... View more
15-02-2024
15:02
Hi, We're getting different values for "averageCost" when fetching costPriceStatistics from the inventory endpoint. Could you please check why? https://integration.visma.net/API/controller/api/v1/inventory?addCostPriceStatistics=true&availabilityLastModifiedDateTime=2024-02-14&availabilityLastModifiedDateTimeCondition= > https://integration.visma.net/API/controller/api/v1/inventory/150070
... View more
11-01-2024
10:46
Hi, It works now after following your instructions. Thank you. But we experienced the same error in all companies that we tried so it would be great if you could check if the issue is fixed.
... View more
29-12-2023
14:33
Please see below.
... View more
28-12-2023
14:01
This is possible to do with the v2 salesorder api. Same company, that's why i assumed it has something to do with v3.
... View more
28-12-2023
09:02
Hi, It is not possible to create a salesorder without specifying the subaccount. Would you like to take a look?
... View more
22-11-2023
11:13
Hi, we would also like this. Is it possible for you to add notes to the lines aswell?
... View more
07-11-2023
08:27
Hi, Is it possible to add the fields below to the SupplierInvoice endpoint?
... View more
01-11-2023
11:22
Typo. Deferral Schedule
... View more
01-11-2023
10:40
2 Kudos
Hi, Would it be possible for you to add an endpoint where we can GET "Deferal Schedule".
... View more
17-10-2023
09:40
Hi, I'm getting the same error with this body and i can't see anything wrong with the customer number sequence. It is possible to create the payment in the UI. "message": "VismaId: 7e72a23f-5cb7-4853-895c-51c08010bc2b. Error creating payment Error: Inserting 'Customer payment' record raised at least one error. Please review the errors.\r\nLast reference number customers\r\n" { "branch": { "Value": "1" }, "currency": { "Value": "SEK" }, "customer": { "Value": "10089" }, "type": { "Value": "Payment" }, "paymentRef": { "Value": "Reglering" }, "cashAccount": { "Value": "1973" }, "paymentMethod": { "Value": "03" }, "applicationDate": { "Value": "2023-10-13T00:00:00.000Z" }, "paymentAmount": { "Value": 87603.75 }, "paymentLines": [{ "refNbr": { "Value": "1902396" }, "documentType": { "Value": "Invoice" }, "amountPaid": { "Value": 87603.75 }, "crossRate": { "Value": 1.000000 }, "operation": "Insert" } ] }
... View more
20-09-2023
16:09
Hi, I'm getting this error when trying to create a CustomerInvoice with the bearer token that is generated via tenantid, clientid and clientsecret. If i try to post the exact same json with the old bearer token and the company-id in the header it works. Please see below for the json body: { "customerNumber": { "Value": "30122" }, "customerRefNumber": { "Value": "AO23310.1" }, "hold": { "Value": false }, "billingAddress": { "Value": { "overrideAddress": { "Value": true }, "addressLine1": { "Value": "Gatan 3" }, "addressLine2": { "Value": "" }, "addressLine3": { "Value": "" }, "postalCode": { "Value": "56113" }, "city": { "Value": "HUSKVARNA" }, "countryId": { "Value": "SE" }, "county": { "Value": "" } } }, "invoiceContact": { "Value": { "overrideContact": { "Value": true }, "attention": { "Value": "xxxx.xxxxx@zzzzz.se" }, "email": { "Value": "faktura@zzzzz.se" }, "name": { "Value": "zzzzz" } } }, "domesticServicesDeductibleDocument": { "Value": false }, "invoiceLines": [ { "description": { "Value": "REST API" }, "discountPercent": { "Value": 30.00 }, "domesticServicesDeductible": { "Value": false }, "lineNumber": { "Value": 0 }, "manualDiscount": { "Value": false }, "quantity": { "Value": 1.0 }, "unitPriceInCurrency": { "Value": 6250.0 }, "operation": "Insert" } ] }
... View more
30-06-2023
08:50
Hi, Sorry, my screenshot was wrong. I'm trying to patch the order as you described but the quantity doesn't update. Am I missing something?
... View more
29-06-2023
10:23
Hi, we also have a customer that is in need for POST and PUT pending cost. Will this be available anytime soon?
... View more
26-06-2023
14:38
Hi, I've tried with and without operation and it failed for both calls. The invoice is now closed so i can't try with the same invoice again. I tried with another company and it works, so I guess it was something wrong in that specific company. I'll have to wait and i'll get back to you when i have a new invoice to test.
... View more
26-06-2023
08:57
I tried to save it and it was fine. Please see below for the lateset JSON. {
"supplier": {
"Value": "50072"
},
"type": {
"Value": "Payment"
},
"paymentRef": {
"Value": "Nettan reglering"
},
"cashAccount": {
"Value": "1963 "
},
"paymentMethod": {
"Value": "4"
},
"paymentAmount": {
"Value": 32030.27
},
"applicationDate": {
"Value": "2023-06-15T00:00:00.000Z"
},
"paymentLines": [{
"refNbr": {
"Value": "201945"
},
"documentType": {
"Value": "Invoice"
},
"amountPaid": {
"Value": 32030.27
},
"crossRate": {
"Value": 7.45446484
}
}
]
}
... View more
22-06-2023
15:08
Hi, I've already tried both the suggestions unfortunately. Please see my screenshot above.
... View more
22-06-2023
15:03
Hi, I'm trying to update a salesorder line with the new API. The response seems to be okay but nothing happens in Visma.
... View more
19-06-2023
09:51
Hi, I'm trying to create a supplierpayment with crossrate. Please see my json below. I can create the payment in Visma without any problems. When trying to create via the API im getting this error message: Do you have any suggestions to fix this? { "message": "Error creating payment. Error: Inserting 'Payment' record raised at least one error. Please review the errors.\r\nThe document is out of the balance.\r\n" } {
"branch": {
"Value": "1"
},
"supplier": {
"Value": "50072"
},
"type": {
"Value": "Payment"
},
"paymentRef": {
"Value": "Nettan reglering"
},
"cashAccount": {
"Value": "1963 "
},
"paymentMethod": {
"Value": "4"
},
"paymentAmount": {
"Value": 32030.27
},
"applicationDate": {
"Value": "2023-06-15T00:00:00.000Z"
},
"paymentLines": [{
"refNbr": {
"Value": "201945"
},
"documentType": {
"Value": "Invoice"
},
"amountPaid": {
"Value": 32030.27
},
"crossRate": {
"Value": 7.45446484
},
"operation": "Insert",
"cashDiscountTaken": {
"Value": 0.0
},
"withholdingTax": {
"Value": 0.0
},
"applicationDate": {
"Value": "0001-01-01T00:00:00.000Z"
},
"date": {
"Value": "0001-01-01T00:00:00.000Z"
},
"dueDate": {
"Value": "0001-01-01T00:00:00.000Z"
},
"cashDiscountDate": {
"Value": "0001-01-01T00:00:00.000Z"
}
}
],
"appliedAmount": {
"Value": 0.0
},
"financeCharges": {
"Value": 0.0
},
"hold": {
"Value": false
},
"released": {
"Value": false
},
"unappliedBalance": {
"Value": 0.0
}
}
... View more
10-03-2023
14:45
Hi, Please see below, the cash account is allowed for the branch.
... View more
21-02-2023
13:23
Hi, We're having trouble creating supplier payments with branch. It only works if we set default cash account on the supplier. It has to be the same cash account as the supplier payment or else it won't work. We're getting a error message that says: "Cash account cannot be empty". Would you like to see if it would be possible to make it work even if we don't set default cash account? Please see our json below. { "type": { "value": "Payment" }, "applicationDate": { "value": "2023-02-21T12:10:06.244Z" }, "paymentRef": { "value": "Nettan reglering" }, "supplier": { "value": "SupplierInvoice.Supplier" }, "paymentMethod": { "value": "SupplierInvoice.PaymentMethod" }, "cashAccount": { "value": "SupplierInvoice.CashAccount" }, "currency": { "value": "EUR" }, "paymentAmount": { "value": 1000 }, "branch": { "value": "22" }, "paymentLines": [{ "operation": "Insert", "documentType": { "value": "Invoice" }, "refNbr": { "value": "SupplierInvoice.ReferenceNumber" }, "amountPaid": { "value": 1000 }, "crossRate": { "value": 10 } } ] }
... View more
10-01-2023
08:51
Activity Feed for Quan Pham
- Posted Error creating journal transaction. Customer currency and Base currency are Identical on Forum in Developers Visma.net. 04-03-2025 10:27
- Posted Re: Error creating journal transaction on Forum in Developers Visma.net. 12-02-2025 13:39
- Posted Error creating journal transaction on Forum in Developers Visma.net. 12-02-2025 10:52
- Got a Kudo for Expose Deferal Schedule in the API. 04-09-2024 09:36
- Got a Kudo for Expose Deferal Schedule in the API. 04-09-2024 09:31
- Posted Svar: The class you have selected cannot be assigned to a non-stock item - when creating shipping it on Forum in Developers Visma.net. 19-06-2024 14:47
- Got a Kudo for Svar: Problem updating salesSubaccount on Customer. 08-04-2024 13:34
- Posted Svar: Problem updating salesSubaccount on Customer on Forum in Developers Visma.net. 08-04-2024 09:06
- Posted Problem updating salesSubaccount on Customer on Forum in Developers Visma.net. 03-04-2024 15:06
- Posted Sv: Inventory - Description on Forum in Developers Visma.net. 21-03-2024 10:08
- Posted Inventory - Description on Forum in Developers Visma.net. 21-03-2024 09:53
- Kudoed Re: Inventory averageCost for Suzdar Ibrahim . 16-02-2024 08:30
- Posted Inventory averageCost on Forum in Developers Visma.net. 15-02-2024 15:02
- Kudoed Re: Salesorder API v3 creating orderLines without subaccount for Joni Wolff. 08-02-2024 08:44
- Kudoed Re: Salesorder API v3 creating orderLines without subaccount for Joni Wolff. 11-01-2024 11:28
- Posted Re: Salesorder API v3 creating orderLines without subaccount on Forum in Developers Visma.net. 11-01-2024 10:46
- Posted Re: Salesorder API v3 creating orderLines without subaccount on Forum in Developers Visma.net. 29-12-2023 14:33
- Posted Re: Salesorder API v3 creating orderLines without subaccount on Forum in Developers Visma.net. 28-12-2023 14:01
- Posted Salesorder API v3 creating orderLines without subaccount on Forum in Developers Visma.net. 28-12-2023 09:02
- Posted Svar: Note is missing on PurchaseReceipt on Ideas in Developers Visma.net. 22-11-2023 11:13