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

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.