Share
ReportHi,
We have updated the localization from one of our entity from Brazil to Canada.(by running SQL script)
In one environment, the testing were successful but in another environment. No transaction can be created. I'm receiving the below info log..
I checked and found out in this vm, the sales tax codes are not set (Tax group and items tax group are set)
- T1.TAXCODE,T1.BUSINESSTYPE_LV,T1.CUSTOMCALCMETHOD_RU,T1.CUSTOMCHARGETYPE_RU,T1.CUSTOMCOMBINEDRATE_RU,T1.CUSTOMSPRACTICE_FI,T1.CUSTOMUNITID_RU,T1.DIOTADDINFO_MX,T1.DOMESTICMARKETTAXCODE_RU,T1.EXCLUDEFROMINVOICE,T1.INCLUDEDTAX_BR,T1.NEGATIVETAX,T1.NOTEUSALESLIST,T1.PAYMENTTAXCODE,T1.PRINTCODE,T1.REPFIELDBASEINCOMING,T1.REPFIELDBASEINCOMINGCREDITNOTE,T1.REPFIELDBASEINCOMINGDEBITNOTE_MY,T1.REPFIELDBASEOUTGOING,T1.REPFIELDBASEOUTGOINGCREDITNOTE,T1.REPFIELDBASEOUTGOINGDEBITNOTE_MY,T1.REPFIELDBASEUSETAX,T1.REPFIELDBASEUSETAXCREDITNOTE,T1.REPFIELDBASEUSETAXOFFSET,T1.REPFIELDBASEUSETAXOFFSETCREDITNOTE,T1.REPFIELDTAXFREEBUY,T1.REPFIELDTAXFREEBUYCREDITNOTE,T1.REPFIELDTAXFREEBUYDEBITNOTE_MY,T1.REPFIELDTAXFREESALES,T1.REPFIELDTAXFREESALESCREDITNOTE,T1.REPFIELDTAXFREESALESDEBITNOTE_MY,T1.REPFIELDTAXINCOMING,T1.REPFIELDTAXINCOMINGCREDITNOTE,T1.REPFIELDTAXINCOMINGDEBITNOTE_MY,T1.REPFIELDTAXOUTGOING,T1.REPFIELDTAXOUTGOINGCREDITNOTE,T1.REPFIELDTAXOUTGOINGDEBITNOTE_MY,T1.REPFIELDUSETAX,T1.REPFIELDUSETAXCREDITNOTE,T1.REPFIELDUSETAXOFFSET,T1.REPFIELDUSETAXOFFSETCREDITNOTE,T1.RETAINEDTAX_BR,T1.TAXACCOUNTGROUP,T1.TAXATIONCODETABLE_BR,T1.TAXBASE,T1.TAXBORDERNUMREQ_FI,T1.TAXCALCMETHOD,T1.TAXCOMPONENTTABLE_IN,T1.TAXCOUNTRYREGIONTYPE,T1.TAXCURRENCYCODE,T1.TAXINCLUDEINTAX,T1.TAXJURISDICTIONCODE,T1.TAXLEDGERACCOUNTGROUP_IN,T1.TAXLIMITBASE,T1.TAXNAME,T1.TAXONTAX,T1.TAXPACKAGINGSORT,T1.TAXPACKAGINGTAX,T1.TAXPERIOD,T1.TAXPURCHASETAX,T1.TAXROUNDOFF,T1.TAXROUNDOFFTYPE,T1.TAXSUBSTITUTION_BR,T1.TAXTYPE_BR,T1.TAXTYPE_JP,T1.TAXTYPE_IN,T1.TAXTYPE_IT,T1.TAXTYPE_MX,T1.TAXTYPE_SG,T1.TAXTYPE_TH,T1.TAXTYPE_W,T1.TAXUNIT,T1.TAXVALUEQTY_RU,T1.TAXVATREPORTCATEGORY_MX,T1.TAXWRITESELECTION,T1.UNREALIZEDTAX,T1.VATCHARGESOURCE_RU,T1.VATOPERATIONCODE_RU,T1.TAXSUBSTITUTIONBASEREDCALCMODE_BR,T1.ISGST_MY,T1.REPFIELDBASEUSETAXDEBITNOTE_MY,T1.REPFIELDBASEUSETAXOFFSETDEBITNOTE_MY,T1.REPFIELDUSETAXDEBITNOTE_MY,T1.REPFIELDUSETAXOFFSETDEBITNOTE_MY,T1.RETAILSAFTSTANDARDVATCODE,T1.RETAILPRINTCODE,T1.REVENUECODE_BR,T1.AFFECTPLAFOND_IT,T1.DESCRIPTIONQRBILL_CH,T1.GENVATLOCALCURRENCY,T1.GENOFFSETLEDGERDIMENSION,T1.GENLEDGERDIMENSION,T1.GENACCOUNTTYPE,T1.GENOFFSETACCOUNTTYPE,T1.GENJOURNALNAME,T1.MODIFIEDDATETIME,T1.RECVERSION,T1.PARTITION,T1.RECID FROM TAXTABLE T1 WHERE (((PARTITION=5637144576) AND (DATAAREAID=N'eur')) AND (TAXCODE=?))
- [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Invalid column name 'GENVATLOCALCURRENCY'.
- Object Server Azure:
- Cannot select a record in Sales tax codes (TaxTable). Sales tax code: A_TVA20. The SQL database has issued an error.
The system isn't lettings me setting the sales tax code, displaying always the same error message.
Any though about this. What do you think the fix should be.
Thank you
Kamel.
All responses (
Answers (
99
