My Products
Help
kashyap
PARTNER

Visma.net getting error on journal create

by kashyap

We are getting below error while posting journal data.  Subaccount is exists PFA.

Error:
VismaId: f344fe39-2a35-4da2-8013-0dbda23f3c7d. Error creating journal transaction. Error: Prosjekt, Kampanje, Ansatt of SubCD do not exist.

 

 

Request Data:
{"createVatTransaction":{"value":true},"hold":{"value":false},"transactionDate":{"value":"2022-04-04T00:00:00"},"postPeriod":{"value":"042022"},"financialPeriod":{"value":"202204"},"ledger":{"value":1},"description":{"value":"Z-rapport-13-1001"},"journalTransactionLines":[{"operation":"Insert","subaccount":[{"segmentId":1,"segmentValue":"140"},{"segmentId":2,"segmentValue":"1"},{"segmentId":3,"segmentValue":"000"},{"segmentId":4,"segmentValue":"0000"}],"accountNumber":{"value":"3000"},"referenceNumber":{"value":1001},"debitAmountInCurrency":{"value":0},"creditAmountInCurrency":{"value":7995.04},"transactionDescription":{"value":"Z-rapport 1001 Salg Varer 25.00% MVA(04.04.2022)"},"vatCodeId":{"value":"3"}},{"operation":"Insert","subaccount":[{"segmentId":1,"segmentValue":"140"},{"segmentId":2,"segmentValue":"1"},{"segmentId":3,"segmentValue":"000"},{"segmentId":4,"segmentValue":"0000"}],"accountNumber":{"value":"2701"},"referenceNumber":{"value":1001},"debitAmountInCurrency":{"value":0},"creditAmountInCurrency":{"value":1998.76},"transactionDescription":{"value":"Z-rapport 1001 Salg Varer 25.00% MVA(04.04.2022)"},"vatId":{"value":"3"}},{"operation":"Insert","subaccount":[{"segmentId":1,"segmentValue":"140"},{"segmentId":2,"segmentValue":"1"},{"segmentId":3,"segmentValue":"000"},{"segmentId":4,"segmentValue":"0000"}],"accountNumber":{"value":"3000"},"referenceNumber":{"value":1001},"debitAmountInCurrency":{"value":0},"creditAmountInCurrency":{"value":577.4},"transactionDescription":{"value":"Z-rapport 1001 Salg Varer 15.00% MVA(04.04.2022)"},"vatCodeId":{"value":"31"}},{"operation":"Insert","subaccount":[{"segmentId":1,"segmentValue":"140"},{"segmentId":2,"segmentValue":"1"},{"segmentId":3,"segmentValue":"000"},{"segmentId":4,"segmentValue":"0000"}],"accountNumber":{"value":"2701"},"referenceNumber":{"value":1001},"debitAmountInCurrency":{"value":0},"creditAmountInCurrency":{"value":86.6},"transactionDescription":{"value":"Z-rapport 1001 Salg Varer 15.00% MVA(04.04.2022)"},"vatId":{"value":"31"}},{"operation":"Insert","subaccount":[{"segmentId":1,"segmentValue":"140"},{"segmentId":2,"segmentValue":"1"},{"segmentId":3,"segmentValue":"000"},{"segmentId":4,"segmentValue":"0000"}],"accountNumber":{"value":"3005"},"referenceNumber":{"value":1001},"debitAmountInCurrency":{"value":0},"creditAmountInCurrency":{"value":213.6},"transactionDescription":{"value":"Z-rapport 1001 Salg Varer 25.00% MVA(04.04.2022)"},"vatCodeId":{"value":"3"}},{"operation":"Insert","accountNumber":{"value":"1920"},"referenceNumber":{"value":1001},"debitAmountInCurrency":{"value":"2592.20"},"creditAmountInCurrency":{"value":0},"transactionDescription":{"value":"Z-rapport 1001 BankAxept(04.04.2022)"}},{"operation":"Insert","accountNumber":{"value":"1510"},"referenceNumber":{"value":1001},"debitAmountInCurrency":{"value":"5163.60"},"creditAmountInCurrency":{"value":0},"transactionDescription":{"value":"Z-rapport 1001 Visa(04.04.2022)"}},{"operation":"Insert","accountNumber":{"value":"1511"},"referenceNumber":{"value":1001},"debitAmountInCurrency":{"value":"1750.00"},"creditAmountInCurrency":{"value":0},"transactionDescription":{"value":"Z-rapport 1001 MasterCard(04.04.2022)"}},{"operation":"Insert","accountNumber":{"value":"1512"},"referenceNumber":{"value":1001},"debitAmountInCurrency":{"value":"653.00"},"creditAmountInCurrency":{"value":0},"transactionDescription":{"value":"Z-rapport 1001 Maestro(04.04.2022)"}},{"operation":"Insert","accountNumber":{"value":"1516"},"referenceNumber":{"value":1001},"debitAmountInCurrency":{"value":"766.00"},"creditAmountInCurrency":{"value":0},"transactionDescription":{"value":"Z-rapport 1001 Til nattsafe(04.04.2022)"}},{"operation":"Insert","accountNumber":{"value":"1901"},"referenceNumber":{"value":1001},"debitAmountInCurrency":{"value":0},"creditAmountInCurrency":{"value":2500},"transactionDescription":{"value":"Z-rapport 1001 Kontantinnskudd(04.04.2022)"}}],"branchNumber":{"value":"1"}}

1 REPLY 1

by Magnus Johnsen

Hi,

Please make sure that each value of each segment is set up in the segmentkey/value screens(ScreenId=CS203000&DimensionID=SUBACCOUNT):

2022-04-29 10_31_46-Segment keys - Brave.png2022-04-29 10_32_04-Segment values - Brave.png

 

As well as the combination in the subAccounts screen(ScreenId=GL203000):

2022-04-29 10_29_37-Subaccounts - Brave.png

 

Please also make sure that the values and combinations are active.

If they are all active, please try to enter the transaction via the UI, this should point you to the issue.