Finance and Operations

thomas shelby 0 Reputation points
2025-08-07T10:51:18.6366667+00:00

Iam facing an error while making the product receipt automic code in D365 F&O these is the error An error occurred: Cannot select a record in Transit document tax information relation (TransitDocumentTransTaxInfoRelation_IN). The SQL database has issued an error. Object Server Azure: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Invalid column name 'MODIFIEDDA and Posting. Cannot select a record in Transit document tax information relation (TransitDocumentTransTaxInfoRelation_IN). The SQL database has issued an error.Object Server Azure: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Invalid column name 'MODIFIEDDATETIME'.SELECT T1.TRANSTAXINFORMATIONRECID,T1.RECID,T2.COMPANYLOCATION,T2.TAXINFORMATION,T2.VATTIN,T2.VATGOODSTYPE,T2.VATNONRECOVERABLEPERCENT,T2.SALESTAXREGISTRATIONNUMBER,T2.SALESTAXFORMTYPES,T2.TAXWITHHOLDTAN,T2.TAXWITHHOLDSOFTWAREDECLRECEIVED,T2.TAXWITHHOLDNATUREOFREMITTANCE,T2.TAXWITHHOLDACKNOWLEDGEMENTNUMBER,T2.TAXWITHHOLDCOUNTRYREGIONTOREMITTANCE,T2.EXCISETYPE,T2.EXCISEECCREGISTRATIONNUMBER,T2.EXCISETARIFFCODES,T2.EXCISEDIRECTSETTLEMENT,T2.EXCISECONSIGNMENT,T2.EXCISEDSA,T2.EXCISECENVATCREDITAVAILED,T2.CUSTOMSIECREGISTRATIONNUMBER,T2.CUSTOMSTARIFFCODE,T2.SERVICETAXREGISTRATIONNUMBER,T2.SERVICECODE,T2.SERVICETAXGTASERVICECATEGORY,T2.SERVICETAXISRECOVERABLE,T2.VATCOMMODITYCODE,T2.EXCISEISSCRAP,T2.EXCISERECORDTYPE,T2.TAXWITHHOLDNATUREOFASSESSEE,T2.CUSTOMSTARIFFDIRECTION,T2.SERVICETAXCONSIGNMENTNOTENUM,T2.EXCISEDISPOSALTYPE,T2.VATSCHEDULE,T2.CSTSCHEDULE,T2.TYPE,T2.CUSTOMERLOCATION,T2.CUSTOMERTAXINFORMATION,T2.EXEMPT,T2.EXIM,T2.HSNCODETABLE,T2.ITCCATEGORY,T2.NONBUSINESSUSAGEPERCENTAGE,T2.SERVICEACCOUNTINGCODETABLE,T2.SERVICECATEGORY,T2.VENDORLOCATION,T2.VENDORTAXINFORMATION,T2.GSTIN,T2.INCLTAX,T2.HEADINGTABLEID,T2.HEADINGRECID,T2.TAXID,T2.BANKLOCATION,T2.BANKTAXINFORMATION,T2.APPLYGSTTDS,T2.APPLYGSTTCS,T2.NONGST,T2.TAXRATETYPE,T2.CUSTOMSEXPORTORDER,T2.MODIFIEDDATETIME,T2.CREATEDDATETIME,T2.RECVERSION,T2.PARTITION,T2.SYSROWVERSION,T2.RECID FROM TRANSITDOCUMENTTRANSTAXINFORELATION_IN T1 CROSS JOIN TRANSTAXINFORMATION T2 WHERE (((T1.PARTITION=5637144576) AND (T1.DATAAREAID=N'ihir')) AND (((T1.TRANSACTIONRECID=?) AND (T1.TRANSACTIONTABLEID=?)) AND (T1.TRANSITDOCUMENTTYPE=?))) AND (((T2.PARTITION=5637144576) AND (T2.DATAAREAID=N'ihir')) AND (T2.RECID=T1.TRANSTAXINFORMATIONRECID))session 362563 (stella)

purchFormLetter = PurchFormLetter::construct(DocumentStatus::PackingSlip);

    purchFormLetter.transDate(systemDateGet());

    purchFormLetter.proforma(false);

    purchFormLetter.specQty(PurchUpdate::All);

    purchFormLetter.purchTable(purchTable);

    purchFormLetter.parmParmTableNum(purchParmTable.ParmId);

    purchFormLetter.parmId(purchParmTable.ParmId);

    purchFormLetter.purchParmUpdate(purchFormLetterParmData.parmParmUpdate());

    purchFormLetter.run(); where its gets into purchformletter.run(); and went to cache and throwing this error
Developer technologies | C#
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Surya Amrutha Vaishnavi Lanka (INFOSYS LIMITED) 335 Reputation points Microsoft External Staff
    2025-08-15T12:12:08.7+00:00

    Follow the bellow steps to get resolved

    1.Verify Table Schema : In SQL Server Management Studio (SSMS), run as below

    SELECT * 

    FROM INFORMATION_SCHEMA.COLUMNS

    WHERE TABLE_NAME = 'TransitDocumentTransTaxInfoRelation_IN'

    Check if MODIFIEDDATETIME exists, If not, that’s the problem.

    2.Sync DB with Application Metadata ,in D365 F&O development environment:

    a. Open Visual Studio with D365 extensions.

    b. Do a Full Build of your model.

    c. Perform Database Synchronization.

    3.Check for Missing ExtensionsIf MODIFIEDDATETIME should exist (for auditing purposes), verify, any table extension for TransitDocumentTransTaxInfoRelation_IN or TransTaxInformation hasn’t been deleted or skipped during deployment.

    Apply pending customizations or deploy missing extensions.

    4.Deploy & Test

    After fixing schema or code, redeploy the package and run as Full build


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.