Manual Price, Screen AR301000

[Florian Haase]

Hi,

we have some trouble with this manual price switch and don't know exactly what the problem is:

Today we import UnitPriceInCurrency and Quantity. The manual price switch is not set on the invoice. 

This behavior makes that a change of the invoice-date triggers a recalculation of the prices. But here the third-party system is master for the prices and we dont have pricing information in Visma.

We tried on the first line of the invoice under to set the manual amount field (manualAmountInCurrency). But still the Manual Price checkbox is not set and the price still changes if we change the invoice-Date.

We also have checked some older invoices and there the "Manual price" checkbox is set, but we didn't do any code change. At the same time we are not able to find out if the change is on the API-level or the application level.

Here is the json:

{"externalReference":{"value":""},"invoiceLines":[{"operation":"Insert","inventoryNumber":{"value":"943"},"description":{"value":"INNG., Diverse uspesifiserte produkter (inkl. stykkgods),"},"quantity":{"value":1.00000},"unitPriceInCurrency":{"value":15.0000},"manualAmountInCurrency":{"value":15.000000000},"subaccount":[{"segmentId":"1","segmentValue":"20"},{"segmentId":"2","segmentValue":"032"},{"segmentId":"3","segmentValue":"30"},{"segmentId":"4","segmentValue":"21351"}],"note":{"value":"\"Flatholmen 6\", 27.03.2020 14:41, Refnr.: 82704 Sveafjord, IMO: 7503594"}},{"operation":"Insert","inventoryNumber":{"value":"908"},"description":{"value":"UTG., Nytelsesmidler og krydder, \"Flatholmen 6\", 27.03.2020"},"quantity":{"value":14.80000},"unitPriceInCurrency":{"value":13.5000},"subaccount":[{"segmentId":"1","segmentValue":"20"},{"segmentId":"2","segmentValue":"032"},{"segmentId":"3","segmentValue":"30"},{"segmentId":"4","segmentValue":"21351"}],"note":{"value":"14:41, Refnr.: 82704 Sveafjord, IMO: 7503594"}},{"operation":"Insert","inventoryNumber":{"value":"941"},"description":{"value":"Emballasje, møbler og andre bearbeidde varer."},"quantity":{"value":14.00000},"unitPriceInCurrency":{"value":13.5000},"subaccount":[{"segmentId":"1","segmentValue":"20"},{"segmentId":"2","segmentValue":"032"},{"segmentId":"3","segmentValue":"30"},{"segmentId":"4","segmentValue":"21351"}]},{"operation":"Insert","inventoryNumber":{"value":"942"},"description":{"value":"Diverse varer spesifisert"},"quantity":{"value":28.30000},"unitPriceInCurrency":{"value":13.5000},"subaccount":[{"segmentId":"1","segmentValue":"20"},{"segmentId":"2","segmentValue":"032"},{"segmentId":"3","segmentValue":"30"},{"segmentId":"4","segmentValue":"21351"}]},{"operation":"Insert","inventoryNumber":{"value":"943"},"description":{"value":"Diverse uspesifiserte produkter (inkl. stykkgods)"},"quantity":{"value":46.80000},"unitPriceInCurrency":{"value":15.0000},"subaccount":[{"segmentId":"1","segmentValue":"20"},{"segmentId":"2","segmentValue":"032"},{"segmentId":"3","segmentValue":"30"},{"segmentId":"4","segmentValue":"21351"}]}],"referenceNumber":{"value":"2003006"},"customerNumber":{"value":"14919"},"documentDate":{"value":"2020-08-31T00:00:00"},"invoiceText":{"value":"Ordre: 2003006"},"branchNumber":{"value":"1"}}

Any ideas?

Regards,

Florian

[Magnus Johnsen]

Hi,

According the the ERP documentation:
Manual Price:

"A check box that indicates (if selected) that the unit price in this line has been corrected or specified manually.

The system automatically selects this check box for the line when you change the price in the Unit price column.
If the check box is selected, when you change the unit of measure or quantity in the line, the unit price is not automatically refreshed with the price from the price list.

If you clear this check box, the system updates the unit price in the document line with the current price (if one is specified)."

In our local test we are not able to reproduce this:

{
    "customerNumber": {
        "value": 10000
    },
    "invoiceLines": [{
            "operation": "Insert",
            "lineNumber": {
                "value": 1
            },
            "inventoryNumber": {
        "value": "nonstocktest"
      },
            "quantity": {
                "value": 1.00
            },
            "unitPriceInCurrency": {
                "value": 2.00
            }
        }
    ]
}

Results in the "Manual Price" being ticked:

Whereas sending the same JSON without the price on the item results in it not being ticked:

Does the price on the created invoice differ from your JSON from the start? Or only if you change the date?

When the date is updated, what are the prices set to? 0, since you don't have any data?

[Anonymous]

Hi!

I am having trouble with this box and found this post. I have tried to use your JSON against the endpoint POST api/v2/customerinvoice but I don't get the box ticket. It stays unticked. I have tried multiple times and set the unitPriceInCurrency to different values but I never get the manual price ticked. Is there a specific setting that needs to be on the article?

/Frida 

[Magnus Johnsen]

Hi,

We'll have a look at this and get back to you.

[Florian Haase]

We have to investigate this further. In our environment the check-box is not set - neither when we import quantity and price nor when we set the manual amount. So the prices always will be recalculated. But why the checkbox is not set we don't know exactly. But I can check once again if our imported price is the same as the suggested price from the inventory setup. Maybe if they are the same the checkbox is not set?

Florian