Variable Pricing Error Message
There may have been times that a Contract has been changed from a Purchase to a Sales when there are already line items present. This scenario can cause knock on affects.
One such instance is when creating a variable price on the Contract.
Error message:
The field Vendor/Customer No. of table Contract Line contains a value (C07900) that cannot be found in the related table (Vendor).
Internal session ID:
d0fe2952-6caa-42fa-99d2-7ebf165e3c50
Application Insights session ID:
3ddb5f86-d1f3-4b4e-92db-d4fe396e7292
Client activity id:
075ebef2-ad6b-4684-aa2c-5b1c61ac1e2a
Time stamp on error:
2024-07-30T14:45:29.1398348Z
User telemetry id:
ccca80e8-074f-4c85-84cf-7d7afb3355f1
AL call stack:
"CUK Contract Header"(Table 50101).UpdateValueOnLines line 15 - MBP Contracts and References by Columbus UK
"CUK Contract Header"(Table 50101)."Vendor/Customer No. - OnValidate"(Trigger) line 25 - MBP Contracts and References by Columbus UK
"CUK Contract Header"(Table 50101).LookupVendorCustomer line 7 - MBP Contracts and References by Columbus UK
"CUK Contract Header"(Table 50101)."Vendor/Customer Name - OnLookup"(Trigger) line 2 - MBP Contracts and References by Columbus UK
The field Vendor/Customer No. of table Contract Line contains a value (C07900) that cannot be found in the related table (Vendor).
Internal session ID:
d0fe2952-6caa-42fa-99d2-7ebf165e3c50
Application Insights session ID:
3ddb5f86-d1f3-4b4e-92db-d4fe396e7292
Client activity id:
075ebef2-ad6b-4684-aa2c-5b1c61ac1e2a
Time stamp on error:
2024-07-30T14:45:29.1398348Z
User telemetry id:
ccca80e8-074f-4c85-84cf-7d7afb3355f1
AL call stack:
"CUK Contract Header"(Table 50101).UpdateValueOnLines line 15 - MBP Contracts and References by Columbus UK
"CUK Contract Header"(Table 50101)."Vendor/Customer No. - OnValidate"(Trigger) line 25 - MBP Contracts and References by Columbus UK
"CUK Contract Header"(Table 50101).LookupVendorCustomer line 7 - MBP Contracts and References by Columbus UK
"CUK Contract Header"(Table 50101)."Vendor/Customer Name - OnLookup"(Trigger) line 2 - MBP Contracts and References by Columbus UK
In the above case the line item still thinks it is a purchase contract due to the value 'Contract Type' = Purchase.
Refreshing the line item by removing the Contract Item No and re-adding resolves this.
Be aware you will need to add the quantity again.
Be aware you will need to add the quantity again.
Related Articles
Error: - Finance - Message - You have one or more documents that must be posted before you post document no. XXXX
Error message whilst trying to post a general journal. Issue A general journal has been fully prepared with all lines ready but not immediately posted. Later, the journal posting is revisited to complete it but it will not post stating the following ...How to copy error messages from Business Central
When submitting a support ticket you will be asked for the error message you receive. This is critical for resolution of the issue. Microsoft have made some improvements so you don't have to take a screen shot. This helps the Support Desks as it ...Contract: Message - NAV Contract No. must have a value in Contract Header
Issue The system is prompting for a Nav. Contract No. when you make a new contract in Business Central. Resolution Working in Business Central 'Live' or 'Prod.' (e.g. 200) The Production companies e.g. Solutions may be configured to require data in ...Contract: - Message - You may not enter numbers manually. Contract list error.
No contracts are displaying when opening the contract list from the Contract form (with F5). Issue Contract listing is filtered to one entry only but the full list can be seen in module Contract List. The system presents the following warning ...Ref.: - Message - There is no KPA Item within the filter
Trying to receive a purchase order on an OMBP ref errors. Issue Trying to receive a purchase order on an OMBP ref fails with error message "There is no KPA Item within the filter". Resolution Select the Purchase tab & check if the field Supplier ...