Field 'VATNum' in table 'CompanyInfo' has not been explicitly selected.

Field 'VATNum' in table 'CompanyInfo' has not been explicitly selected.

This is caused because of Field 'VatNum' in CompanyInfo Tables showing "Unretrieved values".

You can do like this to solve the issue:

 Update CompanyInfo directly in the table inside AOT
                                        - or -
Open SQL Server and use a script to update the DirPartyTable Table.
CompanyInfo table is on SQL level stored in the DirPartyTable table.

SQL Script:

UPDATE DIRPARTYTABLE 
SET VATNUM = ''
WHERE VATNUM IS NULL 
AND INSTANCERELATIONTYPE = 41 -- 41 is CompanyInfo TableID

Comments

Post a Comment

Popular posts from this blog

AX 2012 R3: Cannot edit a record in Purchase order - update table (PurchParmTable).

Image
AX 2012 R3: Cannot edit a record in Purchase order - update table (PurchParmTable). Error: Cannot edit a record in Purchase order - update table (PurchParmTable). An update conflict occurred due to another user process deleting the record or changing one or more fields in the record. Scenarios: This happen when, I try to cancel Purchase Order Confirmation or GRN in AX 2012 R3. Anyone encounter this before? Appreciated can share some solutions. All the best. Ariston J.
Read more

AX 2012: The AOS server name or instance name is not correctly configured

Image
Scenario: When installing Reporting Extension in Reporting Server using Microsoft Dynamics AX 2012 R3 Installation wizard, then I got the below error. Error Details: Performing a service status check for prerequisite 'Application Object Server (AOS) Services WSDL URI accessible Error fetching services status. Reason: The AOS server name or instance name is not correctly configured Check succeeded. services check failed Solution Details 1. In "Microsoft Dynamics AX Configuration Utility". 2. Check if Connection Details in Connection Tab are valid and in correct setups. 3. Refresh Configuration to regenerate WCF configuration 4. Try to install again
Read more

AX 2012 Get Financial Dimension Value by Worker RecID

public Name mscGetOriginatorFinancialDimension(RefRecId _workerRecId) {     RecId       defaultDimension;     DimensionAttributeValueSet      dimAttrValueSet;     DimensionAttributeValue         dimAttrValue;     DimensionAttribute              dimAttr;     Common                          dimensionValueEntity;     defaultDimension        = HcmEmployment::findByWorkerLegalEntity(_workerRecId, CompanyInfo::current()).DefaultDimension;     dimAttrValueSet         = DimensionAttributeValueSet::find(defaultDimension);   ...
Read more