We are having an issue with DMT and were told by support that we should upgrade to the latest, I said well that’s silly DMT Updates itself. However
EpicWeb says otherwise
We are having an issue with DMT and were told by support that we should upgrade to the latest, I said well that’s silly DMT Updates itself. However
EpicWeb says otherwise
I can’t DMT to update with the auto update. It has been failing for a couple weeks now. I ended up just downloading the new version from EpicWeb.
My version for 10.2.200 auto updated to 4.0.50.1 automatically earlier this week.
Maybe they hit their bandwidth limit for the month already
I have 4.0.50.0 (for 10.2.300) installed and checking for updates did find the new version
Someone cough @amurdock cough pointed out that my version 39 is over a year old and so maybe it’s my fault…
#ICallBS
but probably
Epicor is ageist
Also… Was there ever a thread started to store the Change Log info of DMT versions?
DMT 4.0.50.1
Enhancements:
Fixes:
Financials > Payment > PayMethod - DMT Issue: Cannot import payment method (Jira # DMT-1490)
Inventory > Quantity Adjustment - Quantity Adjustment Template broken: Unable to Process Quantity Adjustment (Jira # DMT-1491)
DMT 4.0.50.0
Enhancements:
Purchasing > RequisitionCombined - Implement Requisition DMT import in Epicor 10 (Jira # DMT-454)
All Imports > DMT Core- Pascal case searching in DMT menu should match both Abbreviations and import names(Jira # DMT-1461)
Fixes:
Financials > GL Journal Combined - GL Journal not entering the default Expense account for Multicompany records.(Jira # DMT-429)
Purchasing > PO Combined - PO Release Import: DMT allows to add PORelease for Contract PO (Jira # DMT-461)
Payment > Payment Group - Payment Group: Not able to access PaymentGroups by other users (Jira # DMT-366)
Sales > Quote Head - Unable to create quote header with a specified number on DMT(Jira # DMT-423)
Financials > Asset Revaluation - Type cast error on AssetNum import (Jira # DMT-507)
DMT crashes without showing any exception message on Startup (Jira # DMT-1467)
Sales > Sales Order Combined - Create Multiple lines under a Sales Order header record (Jira # DMT-371)
DMT 4.0.49.0
Enhancements:
Add an option in Preferences to choose if Exception stack trace should be logged in error log file. (Jira # DMT-484)
Fixes:
All Imports - DMT is matching Company name with case sensitivity and showing error. (Jira # DMT-1425)
Management > Production > Job > Job Oper Attachment - Job Operation Import - DMT is not updating OverrideRate column. (Jira # DMT-367)
Management > Engineering > Engineering Workbench Group - Add "Description" field to Required/Mandatory columns list. (Jira # DMT-1369)
Management > Engineering > Package Control > Package Control ID Configuration - DMT does not accept User Defined column. (Jira # DMT-1427)
Management > Inventory > Part > Part > Part Revision - ECO value is being ignored when Approved column is set to True. (Jira # DMT-388)
Management > Inventory > Part > Part - HTS field doesn't accept more than 10 characters. (Jira # DMT-476)
Management > Inventory > Part > Part Plant - DMT allows the creation of PartPlant records with invalid combination of "sourcetype=T" and "PhantomBOM=True". (Jira # DMT-1424)
Management > Sales > Quote > Quote Contact - Quote Contact - DMT creates duplicate contacts for quotes with same CustId. (Jira # DMT-384)
Management > Sales > Quote > Quote Header - DMT shows error: 'Record not found'. (Jira # DMT-368)
Management > Financials > OpenLoad > AR Open Load - Unable to set Credit Memo to Yes. (Jira # DMT-370)
Management > Financials > AP Invoice > AP Invoice Combined - Error creating record when Line Type is "Receipt Line / R". (Jira # DMT-485)
Management > Financials > AP Invoice > AP Invoice Combined - DMT is adding a Variance when using a Foreign Currency Code. (Jira # DMT-436)
Management > Financials > AP Invoice > AP Invoice Combined - Error: Object reference was not set to instance, while importing AP invoice Receipt lines. (Jira # DMT-450)
Management > Financials > AP Invoice > AP Invoice Combined - Error: "Input array longer than the number of columns". (Jira # DMT-427)
Management > Financials > General Ledger > Journals > GL Journal Combined - GL Journal Combined | update alone creates new records If we given non-existing Journal Number. (Jira # DMT-1365)
DMT 4.0.48.1
Enhancements: None
Fixes:
Management > Financials > AP Invoice > AP Invoice Combined - Error: "Input array longer than the number of columns". (Jira # DMT-427)
DMT 4.0.48.0
Enhancements: None
Fixes:
Mangement > Inventory > Part > Part Combined - While trying to create a duplicate part, DMT throws error "Configurator mode is not valid" (Jira # DMT-377)
Management > Production > Time and Expense > TE Labor Combined - DMT needs JobNum and Job details to complete the Indirect Labor upload, while these fields are not mandatory. (Jira # DMT-385)
Management > Financials > AP Invoice > AP Invoice Combined Import - Cannot create one line with more than one expense (Jira # DMT-433)
Management > Production > Time and Expense > TE Weekly - When the Date format of a system in Regional settings is dd/MM/yyyy, DMT throws exception: Error accessing the database: Conversion failed when converting date and/or time from character string. (Jira DMT-448)
Management > Inventory > Part - Importing multiline part language descriptions via DMT leads to extra empty lines in Reporting (Jira # DMT-1383)
DMT license validation - Fallback to .lic file validation if E10 license validation fails (Jira # DMT-1386)
Management > Financials > General Ledger > Journals > GL Journal Combined - DMT is creating multiple Journals with one line, instead of one Journal with multiple lines. (Jira # DMT-1404)
DMT 4.0.47.2
Enhancements: None
Fixes:
GL Journal Entry creating multuple Journals with one line, instead of one Journal with multiple lines.(Jira # DMT-1400)
DMT 4.0.47.1
Enhancements:
Fixes:
Fallback to DMT license validation if E10 license validation fails (Jira # DMT-1386)
AP Invoice Combined Import > DMT - Not able to create 1 line with more than 1 expense. (Jira # DMT-433)
DMT 4.0.47.0
Enhancements:
Management > Production > Project > Project Combined - Added the ability to import ProjectCst table's fields (Jira # DMT-369)
Fixes:
DMT Home Page - Fix for the Bandwidth Error on the DMT Home Page that loads on DMT startup (Jira # DMT-453)
Management > Purchasing > PO Combined - Fix for bug in PORelTGLC#GLAccount field not getting updated (Jira # DMT-349)
Management > Engineering > Bill of Operations - Fix to import Crew Size filed in Bill of Operations (Jira # DMT-499)
DMT 4.0.46.1
Enhancements: None
Fixes:
Fix for the Bandwidth Error on the DMT Home Page that loads on DMT startup.(Jira # DMT-453)
DMT 4.0.46.0
Enhancements: None
Fixes:
Management > Suppliers> Supplier Price List - Fir for error message: Multiple Part Match Found Import (JIRA # DMT-346)
Management > Financials > General Ledger > Journals > GL Journal Combined - Fix to support Update operation (Jira # DMT-416). However, DMT still doesn't validate GLAccount field.
Management > Production > Job > Job Assembly - Fix for error message: string was not recognized as a valid Boolean (JIRA # DMT-475)
Management > Engineering > Bill of Operations - Fix for error message: Column doesn't belong to table (JIRA # DMT-487)
Management > Financials > AP Invoice > AP Invoice Combined - Fix to delete the default record created in TranGLC table when MultiCompany is True(JIRA # DMT-457, DMT-493)
Management > Inventory > ABC Code - Fix to make CountFreq column as a mandatory field (JIRA # DMT-501)
DMT 4.0.45.0
Enhancements
All Imports - Added full exception stack trace in error logging(JIRA # DMT-460)
Fixes
AP Invoice Combined Import - When APInvExp#MultiCompany is true, DMT does not delete the default GLAccount record(JIRA # DMT-457)
DMT Command line - NoUi option does not work(JIRA # DMT-424)
PO Combined Import - On error in importing a line, successive records stop working with error(JIRA # DMT-456)
Quote Detail Import - Input string is not in a correct format when importing Unit Price with decimals in fields QuoteQty#WQunitPrice and QuoteQty#UnitPrice(JIRA # DMT-357)
DMT 4.0.44.0
Enhancements: None
Fixes
Part Revision Import - Error : AltMethod Cannot be updated as it's primary key(JIRA # DMT-342)
AR Invoice Combined: Object reference not set to instance of an object.(JIRA # DMT-432)
Bill of materials : Not updating MtlPartNum(JIRA # DMT-422)
APInvoiceCombined :GLAccount not being updated(JIRA # DMT-414)
APInvoiceCombined : Update given VendorID in LateCost entries(JIRA # DMT-425)
JOB PROD : not updating existing Records when trying to change Warehouse(JIRA # DMT-406)
Part Revision :DMT will not upload DrawNum(JIRA # DMT-407)
Quote Detail : DMT not updating QuoteQty.SellingQty (JIRA # DMT-324)
AP Invoice Combined import : not creating APInvHed (JIRA # DMT-372)
DMT not able to login with SSL Connection. (JIRA # DMT-420)
DMT 4.0.43.0
Enhancements
Master Pack Shipment - Implement Master Pack Shipment import for DMT(JIRA # DMT-393)
PCID Build/Split/Merge - Implement PCID Build/Split/Merge functionality(JIRA # DMT-391)
Fixes
Fix to accept Endpoint binding HttpsOffloadBinaryAzureChannel in Azure AD login(JIRA # DMT-331)
Job Closing/Complete - Fix for QuantityContinue to accept 1 or yes or true as input(JIRA # DMT-387)
PO Detail - Fix for error Receipt amount is greater than purchase order amount(JIRA # DMT-343)
PlayBooks - Fix to remove the import from tracker once it is completed(JIRA # DMT-347)
Inventory > Part - Fix to add SearchWord if given in Excel while AddNew(JIRA # DMT-401)
TE Labor Combined - Fix for inserting Indirect and Project record through TE Labor Combined(JIRA # DMT-386)
Account Segments Value - Fix the bug of fields GainAccount and LossAccount not getting updated(JIRA # DMT-404)
Financial > APInvoice > APInvoiceCombined - Pick default terms code for the Supplier ID(JIRA # DMT-400)
DMT 4.0.42.0
Enhancements
Code changes to support Upward Compatibility with ERP10.2.400.0(JIRA # DMT-353)
Integrate DMT licensing with E10
Fixes
��� PO receipt combined - Add TranDocTypeId field in the madatory fields list(JIRA # DMT-316)
Supplier Price List > Remove manually handled exception for Cross Part Reference(JIRA # DMT-346)
Engineering > BOM - Validate Part when EcoMtlPart has changed(JIRA # DMT-360)
Financial > APInvoice > APInvoiceCombined - AP Invoice Combined not processing GL Account information(JIRA # DMT-302)
Inventory > Part > Part - Fix to ignore Part Audit when Approved is false or blank(JIRA # DMT-380)
COA import - Fix to update split values of GainSegVal and LossSegVal to split columns(JIRA # DMT-383)
DMT 4.0.41.2
Enhancements
Fixes
��� PlayBook - Prioritized execution of entries Playbook and Playlist(JIRA # DMT-270)(PlayList was not working)
Financial > APInvoice > APInvoice - AP Invoice Import - A valid Invoice Number is required on AP invoice entry and APInvoice Combined.(JIRA # DMT-309)(Reopened issue)
PO receipt combined - Error: Valid legal number is required(JIRA # DMT-316)
Job Closing/Complete - DMT not closing Jobs(JIRA # DMT-330)
Inventory > Part - Populate approved field with TRUE/FALSE, YES/NO, or 1/0 in Part Revision(JIRA # DMT-336)
Financials > GLControl > RecurringJournal - GL Recurring Journal crashing on opening template builder(JIRA # DMT-338)
DMT 4.0.41.0
Enhancements
��� PlayBook - Prioritized execution of entries Playbook and Playlist(JIRA # DMT-270)
Fixes
��� Production > �Time and Expense > TE weekly import (CS0001071166)(JIRA # DMT-254)
Production > ProjectEntities > ProjectMeasuredWork �- Project measured works-Table: PBWrkMeasuredDtl Msg: Invalid Customer Quantity Surveyor.(JIRA # DMT-395)
Financial > APInvoice > APInvoice - AP Invoice Import - CS0001370621(JIRA # DMT-329)
Inventory > Part > Part Attachment Import(JIRA # DMT-41)
Inventory > Part > Part Revision - The AltMethod is unnecessarily required by the Part Revision import(JIRA # DMT-132)
Sales > QuoteDtl - CS0001283389 - Saleskit in Opportunity/Quote Detail not updating.(JIRA # DMT-307)
Financial > APInvoice > APInvoiceCombined - A valid Invoice Number is required on AP invoice entry and�APInvoice Combined.(JIRA # DMT-309)
Supplier > SupplierCombined - Supplier Part Import - csv with multiple companies is not being processed(JIRA # DMT-312)
Inventory > Part > Part Combined not updating the Supplier ID(JIRA # DMT-322)
Sales > QuoteHead - Not able to Update Quote Header(JIRA # DMT-319)
DMT 4.0.40.0
Enhancements:
�� �Sales > PriceGroup - Implement Price Product group and PriceGrpValBrk table(JIRA # DMT-283)
Fixes:
�� �Financials > ARInvoiceCombined - DMT ARInvoiceCombinedImporter reports errors incorrectly(JIRA # DMT-306)
�� �System > Memo >Memo - Invalid column name BOName in Memo import(JIRA # DMT-305)
�� �Engineering > BOM - BOM issue: EcoMtl has not been changed(JIRA # DMT-303)�
�� �Purchasing > POCombined > PO Combined (CS0001218258)(JIRA # DMT-304)(The fields BookID,FiscalCalendarID and COACode has been made mandatory for GL account entry)
�� �Financials > GLControl > GLCOAReferenceAcct - GL COA Reference Acct: Throws error on dynamically referenced segments(JIRA # DMT-301)
�� �Financial > ARInvoice > AROpenLoad - Amount Doubled on AR Open Load(JIRA # DMT-300)
�� �Engineering > BOO -Resource ID in BOO is not being updated(JIRA # DMT-289)
�� �Financial > APInvoice > APInvoiceCombined - DMT ONLY gets the APUninvoicedRcptLines of the first packslip (then the line they want to invoice is never found)(JIRA # DMT-276)
DMT 4.0.39.0
Enhancements
Playlist > PlayList - Add wait option for PLayBook to prioritize PlayLists(JIRA # DMT-270)
Inventory > PartAudit - Implementation of Part Audit Log creation(JIRA # DMT-274)
Sales > Loaction Management > Implement new import for Location Inventory Transfer(JIRA # DMT-280)
Fixes
Inventory > Part - Changes to handle Dealer Network Management(JIRA # DMT-281)
Financial > APInvoice > APInvHead > Fix for Add new record for AP Invoice Head is failing(JIRA # DMT-286)
Inventory > Part - Fix for the error invalid base number(JIRA # DMT-287)
DMT 4.0.38.0
Enhancements
Financial > APInvoice > APInvoiceCombined-Add 3rd Party Late Cost handling through AP Invoice Combined import form (JIRA # DMT-273)
PlayList -Enhancement feature to copy rows in DMT Playlist(JIRA # DMT-222)
Financials > GLControl > RecurringJournal-GL Recurring Journal Import implementation(JIRA # DMT-261)
Engineering > Planning Contract and Package Control -Check Planning Contract and Package Control imports code(JIRA # DMT-266)
Fixes
Engineering > BOM -Record Not Available- Bill of Materials(JIRA # DMT-272)
Engineering > BOM -ECORev Msg: Revision Approved, Creation not allowed(JIRA # DMT-263)
Production > Transfer Order -Cannot find column when importing transfer orders(JIRA # DMT-264)
Financials > ARInvoiceCombined -Change AR Invoice Combined description of InvoiceNum(JIRA # DMT-267)
Inventory > Inventory Transfer -Inventory Transfer Error: "here is no row on position -1"(JIRA # DMT-268)
DMT 4.0.37.0
Enhancements
Financials > GLControl > Account Entry Restricted Functions - Implement Account Entry Restricted Functions import form(JIRA # DMT-251)
Financials > Implement Asset Attachment import form(JIRA # DMT-256)
Fixes
System > Memo > Memo Import- Key1ColumnName not listed in Template Builder(JIRA # DMT-252)
Management > Inventory > Part > CS0001199028 - Serial Number (10.2.300.2)(JIRA # DMT-259)
Management > Inventory > Part > Part Combined > CS0001139720 - Part Combined DMT - Additional Required Fields(JIRA # DMT-253)
Sales > DrpShipDtl > Drop Shipment Detail Update(JIRA # DMT-211)
Engineering > BOM > Allowing Inactive Parts in BOM (CS0001034903)(JIRA # DMT-210)
Financials > GLControl > Bug in DMT AP Invoice Combined-multiple Gl Accounts against single line doesn't work for GL Allocation 1(JIRA # DMT-243)
production > Time and Expense > TE weekly import (CS0001071166)(JIRA # DMT-254)
Financials > TaxType > Update mtlDescription field on Tax Type Maintenance.(JIRA # DMT-255)
Production > TO shipment - Requirement list is not accurate(JIRA # DMT-257)
Inventory > Inventory Transfer Import - getting error: A transfer record not found(JIRA # DMT-260)
DMT 4.0.36.0
Enhancements
System > Document > Document Type Maintenance > -Implement Document Type Maintenance form Import(JIRA # DMT-224)
Financials > Implementation of Amortization Codes import form(JIRA # DMT-244)
Fixes
Sales > CustShipCombined > CustomerMiscCharge > Implementation of Shipment Misc Charges import form(JIRA # DMT-238)
Sales > CustShipCombined > CustomerMiscCharge > CS0001105103 - DMT Customer Shipment Combined(JIRA # DMT-237)
System > Memo > Unable to create entries in Memo Table(JIRA # DMT-239)
System > Memo > Mismatch of BO name and table name for SalesOrder(JIRA # DMT-240)
Customer > Customer Part Cross Reference Import - PartNum value not validated(JIRA # DMT-187)
Financials > Automatically fetch AccountDesc field GLAccount import form(JIRA # DMT-247)
Financial > AP Invoice > AP Invoice Combined > APInvoiceCombined.cs - Bug in DMT AP Invoice Combined-DocScrUnitCost field(JIRA # DMT-242)
DMT 4.0.35.0 is not being recognized on DMT 4.0.32.0(JIRA # DMT-245)
Inventory > Serial Number - Convert SNStatus value from proper case to upper case on serial number update(JIRA # DMT-250)
DMT 4.0.35.0
Enhancements
System > Document > Document Type Control > -Implement Document Type Control form Import(JIRA # DMT-218)
System > Document > Document Type Metadata > -Implement Document Type Metadata form Import(JIRA # DMT-232)
Fixes
Upgrade DMT's compatibility to E 10.2.300.0(JIRA # DMT-225)
Replace .Net cryptography classes usage with Epicor to be FIPS Compliant(JIRA # DMT-226)
Engineering > Bill of operations - DMT not loading attachments to the Bill Of Operations(JIRA # DMT-220)
Engineering > Bill of operations - Bill of Operations Import-Fields not being updated(JIRA # DMT-219)
DMT 4.0.34.0
Enhancements
Financials > GLControl > StatisticalUOM > -Added support to import Statistical GL UOM (Jira # DMT-217)
Financials > GLControl > JournalCode > -Added support to import Journal Code (Jira # DMT-221)
Azure AD based login in DMT command line and GUI mode(JIRA # DMT-189)
Fixes
Management > Inventory > Part > Part Combined > -Not able to update - Part Revision Field (JIRA # DMT-223)
System > Menu > Menu Security - Fix error Invalid GroupId despite of supplying valid GroupId(JIRA # DMT-213)
System > Menu > Menu Security - Correction in the description of allow and disallow access(JIRA # DMT-204)
System > Memo - Remove the field RelatedToSysRowID from required fields list(JIRA # DMT-202)
DMT 4.0.33.0
Enhancements
Sales > Configurator Lookup Table Combined > - Added support to import Configurator Lookup Table (Jira # DMT-195)
Fixes
System > Menu > Menu Security - Fixed an error "Object reference not set to an instance of an object" when csv has a combination of UserId and GroupId in columns AllowAccess and DisAllow Access (Jira # DMT-180)
UI - Fixed broken issue on DMT.exe's missing file icon - DMT.exe file was not loading standard Epicor icon (Jira # DMT-206)
Management > Purchasing > PO Receipts > PO Receipt Combined - fixed the error "Cannot determine UOM Class of UOM" (Jira # DMT-205)
DMT 4.0.32.0
Enhancements
Financials > AP Invoice > APInvoice Combined - Added support for R, U, and Asset line types
System > Menu > Menu Security - Blank values in AllowAccess and DisAllowAccess fields now reset previous values
System > Menu > Menu Security - Added support for allowing and disallowing access based on GroupIDs
UI - Added appropriate icons to message boxes
Fixes
Sales > Sales Order - Improved the template builder's description of the OrderNum field in the Sales Order imports
DMT 4.0.31.0
Enhancements
Menu - Added abbreviation based search feature for menu items
Fixes
Asset Addition - Fixed an issue where InterGroup field was not being updated by DMT. Issue was specific to 10.2.100 version
Customer Contact - Fixed a "Column 'Name' does not belong to the table" error
Part Combined - Fixed an issue that could lead to the Part table not being updated
DMT 4.0.30.0
Enhancements
10.2.200.0 Compatible - DMT is now compatible with Epicor version 10.2.200.0
Fixes
Asset Addition - Fixed an issue where InterGroup field was not being updated by DMT. Issue was specific to 10.2.100 version
GL COA Reference Account - Fixed an issue of exception message "Segment value not found"
Menu Security - DMT will accept AllowAccess and DisallowAccess fields as ~ (tilde) separated UserId rather than UserName
PO Schedule - Fixed the exception message: "Error accessing the database: Incorrect syntax near '?'"
DMT 4.0.29.0
Enhancements
All Import windows - "Update" and "Add New" check boxes will now be automatically unchecked on selecting/checking "Delete"
Fixes
Payroll Employees - fixed an issue of implicitly setting false value to fields of Employee Maintenance when not mentioned in import source csv/spreadsheets
PO Combined - fixed errors where import source has multiple rows with PONum assigned (non-zero), and user chooses "Add New" only, DMT processes first row correctly, but fails to process 2nd row that has same PONum as 1st row.
AP Invoice Combined Adv Billing - Fixed issue of DMT rejecting invoice for InvcDtl#LineType != "J" or "M"
DMT Playlist and Playbooks - fixed the issue to now let DMT to continue processing next item in the playlist/playbook on exception without stopping whole import job.
Part - Fixed issue of Foreign Language description not being shown on Quote/Order Entry, even though DMT successfully imports description in Part import.
DMT 4.0.28.0
Enhancements
License Checks - company ID validation is now case-insensitive
Fixes
Cash Receipt Combined - fixed an issue preventing the GL account from being set when a legal number was specified
PlayLists - Source selection now allows all valid import files to be selected instead of just CSVs
GL Journal Combined - TotCurrDebit and TotCurrCredit are now correctly converted to the base currency
DMT 4.0.27.0
Enhancements
Service Job Header - records can now be added instead of just updated and deleted
Fixes
Asset Addition - fixed an issue causing a "ttFAAddReg has not changed" error to be returned incorrectly
Purchase Order Header - approval now works correctly in 10.1.500 and above
Cash Receipt Combined - fixed an issue preventing legal numbers from being generated in 10.1.500
Cash Receipt Combined - fixed an issue that could cause legal numbers to not be generated when importing multiple records in the same group
Security Managers can see all imports again
Container Landed Cost - made Container Landed Cost imports visible
DMT 4.0.26.0
Enhancements
AP Invoice Job Misc Charge - fixed "Failed to enable constraints" error
New Imports - Sales > Customer Shipment > Container Landed Cost Header, Detail, Duty and Indirect Costs
New Imports - Sales > Customer Shipment > Container Landed Cost Header, Detail, Duty and Indirect Costs
Tracing - include full dataset when verbose logging is enabled
New Imports - Sales > Miscellaneous Shipment > Miscellaneous Shipment Header, Detail, Origin and UPS
New Imports - Sales > Miscellaneous Shipment > Miscellaneous Shipment Header, Detail, Origin and UPS
Fixes
CC BMSyst - import now points to the correct table
Cash Receipt Combined - added legal number generation
Cash Receipt Combined - changed the import so that a HeadNum is always generated for new records (prevents issues occurring due to using a specified HeadNum)
Cash Receipt Combined - fixed an issue preventing CashHeadTGLC records from being created in 10.1.600 environments
DMT 4.0.25.0
Enhancements
Template Builder - added the ability to filter the list of fields by table
Template Builder - Excel format - Required fields are now in bold
New Imports - Financials > General Ledger > GL COA Reference Type and GL COA Reference Account
New Imports - Financials > Tax > Cents Override and Cents Override Detail
New Imports - Financials > Tax > Custom Tax Algorithm and Custom Tax Algorithm Detail
New imports - Financials > Legal Text and Legal Text Detail
Login screen - added Caps Lock warning message
Demand Contract Header and Demand Contract Detail - set OverridePartXRef = TRUE to default to the Part Master record when multiple matching Parts are found.
Multiple Imports - allow omission of the Company field - defaults to Session Company
Fixes
Menu Security - fixed an issue that could allow access to an Import that the user does not have permission for
Asset Addition - fixed a "The remaining amount is greater than zero" error
Asset Addition - fixed Part UOM error for Transfer Addition type
Part Revision - fixed an 'Invalid Base Revision' issue when AltMethod is specified
Part Combined - fixed an 'Invalid Base Revision' issue
Purchase Order Imports - fixed "Input Array is longer..." error that can occur if multiple Purchase Order imports are active in DMT
Quote Detail - fixed an issue with Unit Price not populating
TE Labor Detail and TE Labor Detail No Header - added method call to populate ExpenseCode from IndirectCode
DMT 4.0.24.0
Enhancements
Template Builder - added facility to create import file in Excel format. Field descriptions are included as cell comments.
Template Builder - if an import file is open then set the selected fields to the fields in the import file
Management menu items are now sorted alphabetically
New Import - Financials > Transaction Document Type
New Import - Financials > General Ledger > Journals > Journal Code
New Import - Financials > AP Invoice > Purchase Type
New Import - Sales > Call Type
New Imports - System > Service Security and Service Security Method
Tracing - added a checkbox to the Tracing Options dialog to enable full dataset logging
Fixes
Part Revision - fixed an 'Invalid Base Revision' issue
BAQ Export - fixed memory issue for large BAQ exports. Added a -PageSize parameter to fine tune speed / memory.
Depreciation Method - fixed Charge Types formulae
Customer Combined - added CustBillTo# and ShipToMFBill# fields to Template Builder
PlayBooks - fixed file not found error message
Asset - fixed error when trying to set DocResidualValue
DMT 4.0.23.0
Enhancements
New Import - System > Company > Company Maintenance - support for the Epicor Company Maintenance screen
PlayLists and PlayBooks - relative file paths are now relative to the PlayList / PlayBook rather than the Epicor client folder
UI - Added button click effect
Fixes
BAQExport - fixed "Unable to cast..." issue and now releases session correctly
GL Journal Detail - fixed issue when updating multiple lines on the same header updating the wrong line
DMR Action - fixed Unrecognized Guid format error that can occur with Serial Numbers
PO Receipt Detail and PO Receipt Combined - fixed column error when importing SerialNo field
Bill Of Materials - only calls update on the ECOMtl record if changes have been made - prevents deletion of RoHS records
Misc Detail - fixed Object Reference error that can occur in 10.1.500+ when changing the APTranTGLC record
Supplier - fixed 1099 Code references invalid value error
DMT 4.0.22.0
Enhancements
Added PlayBooks and PlayLists to main menu. See Home Page and new Lab for details.
New Import - Inventory > Count Tag > Count Tag
Sales Order Combined and Sales Order Header - fixed issue with TaxRegionCode failing to default to correct value
Bill Of Materials - allow deletion of a RoHS record by setting ECOMtlRestrictSubst#RowMod = D
AP Invoice Job Misc Charge & APInvoice Combined - set MtlQuestion to Yes/No to answer the 'Material not found...' dialog
Account Segment Values - Added COASegOpt#SubSegmentNbrName to Template Builder
Fixes
Sales Order Imports - fixed "Input Array is longer..." error that can occur if multiple Sales Order imports are active in DMT
Sales Order Detail & Sales Order Combined - use default RevisionNum for Sales Kit Components if not present in import file
Fixed error message on exiting Check For Updates window
DMT 4.0.21.0
Enhancements
New Imports - Service > Field Service > Service Contract Renewal Header and Detail
Fixes
Session management - imports now release the session on exit
Purchase Order Release - added OpenRelease field to Template Builder (10.1.600 only)
Job Receipt To Inventory - fixed issue with co-parts updating main Part received qty instead of co-part received qty
DMT 4.0.20.0
Enhancements
New Imports - Financials > AP Invoice > Payment Instrument > AP Payment Instrument Group and Head
New Imports - Financials > Asset > Asset Register, Asset Revaluation and Asset Revaluation Register
Posted AP Invoice Update - added ability to change the 1099 Code (10.1.400+ US Only)
Fixes
Import File load - disabled Reload button while import file is loading to prevent error if Reload is clicked again
Multiple Quote Imports - fixed "Input Array is longer..." error when importing multiple different Quote Imports in the same DMT instance.
Multiple Customer Imports - fixed "Input array is longer.." error when importing multiple different Customer imports in the same DMT instance.
Part Alternative - fixed duplicate record error that could occur when changing the first SubPart of many
Sales Order Release, Sales Order Combined - set default values on change of release ShipToNum
Sales Order Detail, Sales Order Combined - fixed issue with Sales Kits not populating Kit Components from the correct Part Revision
Migration menu > Phase 1 > Assets - 1st import is now Asset Register, not Asset Register Detail
DMT 4.0.19.0
Enhancements
Added Favourites menu. Right-click an Import to add it to the Favourites menu.
New Import - Financials > AP Invoice > Aging Report Format
New Import - Financials > AP Invoice > 1099 Box Number
New Imports - Financials > General Ledger > Allocation Batch, Allocation Batch Schedule
New Imports - Inventory > Warehouse > Warehouse Bin Attribute, Warehouse Bin Size Group
New Import - Production > Project > Project CheckList Types
New Import - Sales > Marketing > Marketing Activity Type
New Import - Sales > Attribute
Project Combined and WBS Phase - added CreateWBSPhaseJob field to emulate pressing the Create WBS Phase Job button
Command Line - Environment now only defaults to default.sysconfig if the environment is not specified in the command line or the DMT config file.
Warehouse - added support for GL Control
Purchase Order Header - OpenOrder field now accepts 1/0 for true/false.
PO Combined & Purchase Order Header - Approve field now accepts 1/0 for true/false.
AP Invoice Group - removed Post field from required list and added description to Template Builder
Fixes
Main Menu - fixed the issue of double-click not expanding a menu folder
Sales Order Combined & Sales Order Detail - fixed error message when using RegenerateKit
Multiple Imports - Added UD fields to Template Builder and field validation
User Import - Improved error message for SaaS
TE Labor Detail - fixed 'JobHead is not available' error that can occur with Project entries
Sales Territory - fixed issue where DMT fails to find records marked as inactive
DMT 4.0.18.0
Enhancements
New Imports - Financials > Rebates > Rebate Header, Detail, Customer, Schedule and Break
New Imports - Production > QA > Employee Training Course, Corrective Action
New Import - Production > Transfer Order Shipment
New Imports - Sales > Salesperson Quota Head, Salesperson Quota Detail
New Import - Suppliers > Supplier Periodicity
All Imports - added Company field capitalisation check
Company Creation - allow import when no companies exist
APInvoice Combined, AP Invoice Head - now support Debit Memos - include DebitMemo = true for Debit Memos
Job Operation - added the ability to delete a Scheduling Resource. Set JobOpDtl#RowMod = D and run import in update mode.
Fixes
Command Line Arguments - fixed case sensitivity of ConfigValue and allow it to contain the extension
Command Line Arguments - fixed file access error that could occur when running multiple versions of DMT
Fixed a BackgroundWorker error message that can occur when trying to start too many imports at the same time
Global Part Link - fixed error that can occur when fields on the source part are not valid in the target company
Chart of Accounts - allow COASegment#RefEntity to be blank when COASegment#UseRefEntity is false
Chart of Accounts - fixed COASegment#RefEntity error message when COASegment#EntryControl field is used
Maintenance Job Operation - now only calls the Epicor change method if the field's value has changed. Fixes the issue of the Comments field being blanked out.
Check Head - now supports Legal Numbers
AP Invoice Detail - fixed "Input Array is longer..." error that can occur if multiple AP imports are active in DMT
DMT 4.0.17.0
Enhancements
New Import - Production > Transfer Order Receipt
New Import - Sales > Serial Number Customer Transfer
Tabs - middle-click a tab header to close the import
PO Receipt Combined, PO Receipt Detail - added Serial Number support
Fixes
RMA Receipt - fixed "Legal Number is Required" error that can occur when not required
Removed Apply Debit Memo and Debit Note Invoice Imports - these imports did not apply the transaction, so were not useful
Removed Apply Credit Memo, Credit Memo Payment and Credit Memo Invoice Imports - these imports did not apply the transaction, so were not useful
Job Material - fixed issue with BuyIt field not changing value and dspBuyIt not calling Epicor change method.
Multiple Imports - fixed issue of User Defined fields not validating and not appearing in Template Builder
Part - fixed "Unable to change IUM" error that can occur when creating a Part with non-default IUM
Serial Number Assignment - fixed error that can occur with Masked Serial Numbers of format <A9>
Supplier Combined - fixed Missing operand error that can occur with Contacts with apostrophes
DMT 4.0.16.0
Enhancements
New Import - Production > QA > Nonconformance
New Import - Financials > AP Invoice > AP Invoice Tax
Sales Order Combined - Allow multiple releases to be created on the same Line for a new Order
Customer Shipment Combined - ReadyToInvoice field (Shipped) is now processed after processing lines
Part Import - now populates the SearchWord from the PartDescription for new records
Multiple imports - validate Plant field capitalisation
Operation Text - moved import to Engineering menu
File Split screen - added drag and drop functionality to file name box.
Fixes
Sales Order Combined - fixed an order quantity issue with multiple releases when both OrderDtl#SellingQuantity and OrderRel#SellingReqQty are specified
Customer Document Types, Customer Documents & Customer ShipTo Documents - fixed object reference error that could occur in Add Only mode.
Credit Memo Payment, Credit Memo Invoice - fixed SQL error that could occur when inserting a new record
Multiple Imports - made column names case-insensitive
Purchase Order Detail, PO Combined (10.1.500 only) - added support for ScrUnitCost & DocScrUnitCost fields
Sales Order Combined - fixed issue with Sales Kits not being created correctly
TE Labor Combined - fixed Submit for newly created records
Bill Of Operations - fixed validation of UD Fields
Cash Head - added call to ChangeReceiptAmt to populate DocTranAmt
Supplier - Allow apostrophes in VendorID
DMT 4.0.15.0
Enhancements
New Import - Sales > Customer Shipment > Customer Shipment Combined - combined version of Ship Head & Ship Detail
New Imports (10.1 only) - Engineering > Package Control > Control ID, Control ID Extract, Control ID Segment, Package Control Label Type, Resource Printer, Resource Printer Resource, Station Resource, Station Resource Resource, Transaction Routing, Transaction Routing Printer
Quote Header - added BTCustNumCustID field to allow population of BTCustNum field
Fixes
Drop Shipment Detail - fixed a "This serial number does not conform to the specified mask" error that can occur when importing masked serial numbers
Country Port - allow the CountryDescription field to be used to specify the Country
Equipment Plan - fixed issue with auto-number routine for creating new records
Customer Contact - now automatically splits Name into FirstName, MiddleName and LastName
TE Labor Combined - fixed "Failed to find Labor Row after Update" error that can occur when submitting a new record.
PO Receipt Detail - fixed "Unit of measure conversion not found" error that can occur if EA UOM is not defined for Part.
Package Control ID Configuration - made Segment optional
Sales Order Combined - fixed object reference error that could occur when importing Sales Kits
DMT 4.0.14.0
Enhancements
51 new Imports:
Engineering > Resource Collection, Resource Type, Stage Number
Engineering > Package Control > Package Control ID Configuration (Epicor 10.1.500+ only)
Financials > Asset > Depreciation Method, Spread Code, Asset Condition
Financials > Legal Number > Legal Number, Legal Number Sequence and Legal Number Document Type
Financials > General Ledger > GL Control Type, GL Control Type Account Context, GL Control Type Entity, GL Control Type Journal Context
Inventory > ABC Code, Supplier Shipment Class
Inventory > Warehouse Team > Warehouse Team, Warehouse Team Bin, Warehouse Team Zone, Warehouse Team Item, Warehouse Team Employee, Warehouse Team Transaction, Warehouse Team Attribute, Warehouse Team Warehouse
Inventory > Package Code, Packaging Classification, Delivery Type
Production > Move Inventory Request, Production Team
Production > Project > Time Type
Production > Project Entities > Burden Actual Percentage, Burden Code
Production > Job > Setup Group
Purchasing > Import Tariff & Import Tariff Commodity, Lifecycle
Sales > Carrier
Sales > RMA > RMA Head Attachment and RMA Detail Attachment
Service > Field Service > Renewal Code, Warranty Code
Service > Field Service > Service Call Center > Service Call Center Header, Service Call Center Line, Service Call Center Technician & Service Call Center Combined
Service > Maintenance > Equipment Type, Equipment Status
Service > Service Job > Service Job Header, Service Job Material and Service Job Operation
System > Plant > Site Cost
All Imports - excluded Plant field from field validation
Migration Mode menu - reordered for Migration map 4.1
Cash Head, Cash Receipt Combined, Payment - now supports GL Account in display order as well as default order
Menu Structure - Created Financials|General Ledger folder and moved COA and Journals folders into it
Task List - added facility to look up TaskConNum from CustomerContactName - uses first matching record for customer
Fixes
Supplier Price List - added facility to create Supplier Price List record using Customer Part Cross Reference PartNum
Fixed SLS version of Imports whose Business Objects differ to the standard Epicor Business Objects
Multiple Imports - fixed issue of User Defined fields not validating and not appearing in Template Builder
Drop Shipment Detail - fixed "Unrecognized GUID Format" error that can occur when importing serial numbers
Supplier GLControl - fixed error when changing same Vendor record for multiple companies
Asset Register Detail - fixed "row has been removed" error that can occur when adding records
DMT 4.0.13.0
Enhancements
New Imports - System > Workstation and Workstation Device.
New Import - Sales > RMA > RMA Combined. Combined RMA Head and RMA Detail - allows RMA creation without RMANum knowledge.
BAQ Export - added a new flag: -UseFieldNames. Including this flag tells the BAQ Export to ignore the Field Labels in the BAQ and use the original field names instead.
UOM - added Foreign Language Descriptions support.
Fixes
Import load - the duplicate field check is now case-insensitive
Cash Receipt Combined - added functionality to allow the creation of a CashHead record and CashDtl record for the newly created CashHead record without knowledge of the auto-created HeadNum field.
Supplier Contact - fixed extra record created in Person Contact table when supplier contact added.
Task List - fixed issue with Task List import when RelatedToFile = Customer
PO Receipt Combined - fixed UOM Class error
Account Segment Values - UD Fields now appear in Template Builder and validate correctly
Apply Credit Memo - fixed currency error that occurs when DocumentNum is specified instead of InvoiceNum
AR Invoice Combined - fixed error displayed when creating 2 lines with the same OrderNum
Bill Of Operations - Including the OpStdID field no longer triggers Op-Standard functionality, unless the field has a value.
Quote Header - added support for change of Primary Salesperson
Account Budget - fixed "Record not found" error that can occur when creating a record for a different Budget Code (Epicor 10.1 only)
DMT 4.0.12.4 Hotfix
Enhancements
New Import - Engineering > Engineering WorkBench Group
BAQ Export - added a new flag: -UseFieldNames. Including this flag tells the BAQ Export to ignore the Field Labels in the BAQ and use the original field names instead.
Account Budget - Budget Periods can now be created automatically by Epicor rather than created explicitly. Exclude GLBudgetDtl# fields to use new functionality.
Import File Split is now available via command line arguments. Use DMT /? for details.
Fixes
Login screen - fixed issue of Connection URL field not updating when Environment field is changed.
Fixed issue of not all errors appearing in Reprocess file when errors occur faster than the disk can write to the log file.
Account Budget - fixed "Record not found" error that can occur when creating a record for a different Budget Code (Epicor 10.1 only)
Migration Menu - Reordered UOM to come before UOM Class
Cash Group - Unlock Group after creation
DMT 4.0.12.0
Enhancements
CSV File Split - Added a screen to the settings menu which allows a large CSV file to be split into multiple smaller CSV files for concurrent processing. File is split by line number, so may not be suitable for all imports.
New Imports - Production > QA > Training Course and Training Course Revision
New Imports - System > Report Style > Report Style Header & Report Style Detail
Job Operation - Performance improvement
Warehouse Bin Attachment - Optimised code to improve performance
Account Segment Values - Added support for Multi-Currency accounts
PO Receipt Detail - Added new field: AllowGreaterReceiptQty. Set to TRUE to ignore the 'Receipt Quantity is greater than the Purchased Quantity.' warning.
Migration Mode menu - added existing Imports to Migration Mode menu
Part Attachments - now allows change of filename when DrawingSeq is included in import file
AP Invoice Detail, AP Invoice Combined Changed - Added LineType validation to identify unsupported types
Fixes
PO Receipt Detail & PO Receipt Combined - fixed issue with imports when Unit of Measure is not set to the default value
GL Journal Combined - fixed an issue with Multi-Company GL Account codes that could cause an Object Reference error during Multi-Company processing.
Quick Job Entry - Added standard Epicor functionality when Released field is included
AP Invoice Head, APInvoice Combined - fixed error that can occur when setting REFPONum
Payment > Misc Detail - Fixed an error "The Account may not be blank" when creating record and no default GL Account is set up in Epicor
Approved Supplier - fixed PartNum value in error message when Vendor is not found
TE Labor Combined - fixed issue with changing ResourceID to a Resource in another Resource Group
DMT 4.0.10.0
Enhancements
Migration Mode menu - added existing Imports to Migration Mode menu
Part Attachments - now allows change of filename when DrawingSeq is included in import file
New Imports: Production > QA > Training Course and Training Course Revision
New Imports - System > Report Style > Report Style Header & Report Style Detail
Warehouse Bin Attachment - Optimised code to improve performance
Fixes
Approved Supplier - fixed PartNum value in error message when Vendor is not found
TE Labor Combined - fixed issue with changing ResourceID to a Resource in another Resource Group
DMT 4.0.9.0
Enhancements
Customer / Customer Combined - (10.1.400+) now supports Sales Order Credit Override when setting Credit Hold
Fixes
Multiple imports - fixed issue with importing data into a different plant using the Plant field.
Transfer Order - Corrected required fields to include TFOrdNum. Fixed "Order has been shipped" error that can occur when creating a header and detail record on one line.
Data Load - Blank lines in Excel spreadsheets are no longer loaded
DMT 4.0.8.0
Enhancements
New Import - Financials > Asset > Asset Impairment
New Import - System > Memo > Memo Category
New Import - Service > Maintenance > Equipment Attachment
New Import - Production > Reference Category
New Import - Inventory > Warehouse > Warehouse Zone
New Import - Financials > Cash Receipts > Cash Receipt Combined
Job Prod Import - added a new import field, NewWarehouseCode, to allow the change of WarehouseCode
Quantity Adjustment - Added check for Sales Kits
Fixes
Fixed DNS connection issue that can cause DMT login issue.
Install - improved error handling when DMT is run from a folder that is not the Epicor Client folder
Job Entry imports - fixed "Input Array is longer..." error that can occur if multiple Job imports are active in DMT
Company imports - Extended UD Fields now validate and display in Template Builder
AR Invoice Imports - Extended UD Fields now appear in the Template Builder and validate correctly
Cash Head / Cash Receipt Combined - Fixed "Invoice number cannot be updated" issue
GL Journal Detail - fixed an issue with Multi-Company GL Account codes that could cause an Object reference error during Multi-Company processing.
Task Set Milestone - allow creation of non-standard interval TaskSetSeq values
Purchase Order Header - allow change of Vendor
TE Expense - Fixed error where DMT would try to set project on indirect expense even if project is empty
Company Creation - Removed CountryGroupCode as a required column
Transfer Order - no longer requires TROrdDtl#TROrdLine column when creating new detail records
Transfer Order - Added TFOrdLine (optional) to required columns
DMT 4.0.7.0
Enhancements
New Imports - System > Plant > Plant Configuration, Plant Config ABC, Plant Config Attachment, Plant Config MFBill, Plant Config CtrlEGLC, Plant Config GL, Plant Config Shared, Plant Config TranDef & Plant Config UPS Email.
New Imports - System > External System > External Company & External Company Configuration
New Imports - Financials > Payroll > Payroll Tax Head & Payroll Tax Detail
New import - Production > Alert Group
Job Receipt To Inventory - Added flag to allow processing of records where the quantity exceeds the quantity completed for the job
Fixes
Cash Receipt imports - fixed "Exception has been thrown by the target of an invocation" error that can occur when running multiple Cash Receipt imports in the same DMT session.
Cash Head and Payment imports - now looks up and completes customer details
Supplier Imports - fixed "Input Array is longer..." error that can occur if multiple supplier imports are active in DMT
Cash Receipt imports - Extended UD Fields now appear in the Template Builder
TE Weekly - fixed error that can occur when changing an existing Weekly Time entry
AP Invoice Receipt - fixed 'Invalid Uninvoiced Receipt' error that can occur
Employee Calendar - fixed DBNull error message that could occur when importing new records
Auto-updater - allow update from up-to-date DMT version for old Epicor version to newer Epicor version
Account Budget - fixed "BalanceAcct not found" error that can occur when importing records with optional segments in the GL Account
DMT 4.0.6.0
Enhancements
New import - Inventory > Warehouse > Warehouse Bin Attachment
New Imports - Sales > Marketing > Marketing Campaign and Marketing Event
New Import - Production > Job > Job Receipt To Inventory
New imports - Financials > Tax > Tax Authority, Tax Box, Tax Jurisdiction, Product Tax Category and Tax Report Category
Moved Tax Type and Tax Liability imports to Financials > Tax menu
APInvoice Combined - now supports change of GL Control Code
Part Attachments - now supports saving files to the Backing Store when Document Storage Type is set to File System Document
Schedule Job - Added Template Builder Descriptions
Job Material - Added JobMtlRefDes fields to Template Builder and added ability to delete a Reference Designator by setting RowMod = D
Spreadsheet import files which have a blank first cell will now load correctly.
Fixes
APInvoice Combined, AP Invoice Head - fixed "A legal number is required" issue that can occur when importing records with auto-legal numbers enabled
Purchase Order Header - fixed error on unapprove.
APInvoice Combined - fixed "A valid Bank Account is required" error when BankID field is included, but blank, for a Vendor without a Bank record.
Ship Detail - fixed the selected serial number issue for import files with SerialNo
Supplier Contact - Name now populates the FirstName, MiddleName and LastName fields and vice-versa
Fixed "Country Not Found" error when importing Countries in Chinese.
DMT 4.0.5.0
Enhancements
BAQ export. This allows the export of data from a BAQ to a CSV file for later import via DMT. Command Line argument only. New arguments: Export, BAQ and Target.
New Imports - Production > QA > DMR > DMR Header, DMR Action & DMR Attachment
New import - Sales > Demand > Demand Schedule
New Imports - Financials > Credit Memo > Apply Credit Memo, Credit Memo Payment & Credit Memo Invoice
New Imports - Financials > Debit Memo > Apply Debit Memo & Debit Note Invoice
New Import - Inventory > Issue And Return > Return Misc Material
Preferences - Enabled "Load spreadsheets using ODBC" option for loading Excel spreadsheets. Useful for macro-enabled spreadsheets.
Added ability to select and copy values from the Import grid
Added ability to drag and drop an import file into an import's Source textbox to load the file.
Demand Detail - added support for multiple lines for the same Contract Line
Bill of Materials - Allow deletion of a ECOMtlRefDes line by setting the RowMod to "D"
Part - PartDescription now formats mutli-line descriptions correctly in the search results
Added advice to NoUI functionality when ConfigValue parameter is required
Fixes
Supplier imports - Fixed "Input array is longer than the number of columns in this table" error that can occur if another Supplier import has already been run in this session
TE Weekly - fixed issue with changing the ResourceGrpID for Project Setup
APInvoice Combined - Multi-Company GL Account - fixed "GL Account may not be blank" error that can occur when changing the default record
Disabled date-based Check for updates when -DisableUpdateService is specified
Job Parts - fixed "object not found..." error that can occur on import
Command Line import of large files will now process the import after the data has loaded rather than wait for user input
Licensing - fixed License Expiry Date on License Information screen. Fixed the "License about to Expire" message.
Auto-updater now copes with updating to different major and minor versions.
Issue Miscellaneous Material - expanded Required Column list
Employee GL Account - Fixed search for existing record
APInvoice Combined - fixed issue with Multi-Company GL Analysis for Epicor 10.1
Account Segment Values - Allow SubSegment identification using the SubSegmentNbrName field
Quantity Adjustment - now respects the Negative Inventory Test setting for the Part Class
Handle error that can occur when the Reprocess file is locked by another process.
CD Tax Detail - fixed record creation for Epicor 10.1.400 general release
APInvoice Combined - fixed issue that can occur when attempting to create two invoices in the same Group for different Suppliers, but the same Invoice Number.
Supplier Contact - fixed error that can occur when importing a contact with an apostrophe in the name.
AR Open Load - Fixed "DocDispInvoiceBal or DisInvoiceBal cannot be < 0" error message that can occur for Credit Memos in Epicor 10.1
DMT 4.0.4.0
Enhancements
Added Sales > Drop Shipment > Drop Shipment Head and Drop Shipment Detail imports
Added Service > Maintenance Request > Maintenance Request and Maintenance Request Attachment imports
Login - now allows use of stored encrypted passwords (Epicor 10.1)
Template Builder - added field descriptions to System imports.
Template Builder - moved Valid Values information into the Valid Values column
Menu Security import - Added descriptions to Template Builder
Menu structure - Sales Order imports are now in the Sales > Sales Order sub-menu.
Menu structure - Quote imports are now in the Sales > Quote sub-menu.
Menu structure - PO Receipt Head Attachment, PO Receipt Detail, PO Receipt Detail Attachment menu items moved to Purchasing > PO Receipts menu folder
APInvoice Combined - now supports Multi-Company GL Analysis lines
Job Complete/Closing - Added description to QuantityContinue field in Template Builder. Import now aborts correctly if this is not set.
Ship Detail - the error message displayed when the Ship Head record does not exist is now much clearer
AR Invoice Combined - Added support for changing the GL Account
Added support for Excel .xlsm files
Fixes
License Information - fixed Licensed Companies list
Error Reprocess file is now created with the default encoding. This fixes the merged columns problem when reloading the Reprocess file.
Menu Structure - Restricted Migration Mode to Security Manager users. Security Manager users now see all imports.
Payroll Check Hours - fixed BaseHours column
Quote Operation - description now updates when CapabilityID changes
Customer ShipTo, Sales Order Misc Charge, Sales Order Line Misc Charge - fixed "Input array is longer than the number of columns in this table" error that can occur in 10.1 if other imports are also open in DMT
AP Invoice Head, APInvoice Combined - fixed default Tax Liability from Vendor. Note this requires VendorID to appear before InvoiceNum in the import file, as per Epicor.
APInvoice Combined - added Extended UD Fields to Template Builder and valid field list.
Customer Contact, ShipTo Contact, Supplier Contact - fixed error that can occur when importing a contact with an apostrophe in the name.
Supplier Part - Added MfgNumMfgID to required field list
Display an error when the import file contains duplicate columns
Ship Detail Attachment - fixed new attachment routine
Ship Head, Ship Detail, Ship Head Attachment, Ship Detail Attachment - fixed issue with importing data for a different Plant
TE Labor Combined - fixed an issue that can cause the Actual ClockIn/ClockOut Time to be blank
APInvoice Combined - fixed an issue with GL Analysis record attached to the Invoice Line when the GL Account is formatted with dashes
Project Billing Schedule - renamed to Project Schedule Of Works
Project Bill Schedule - renamed to Project Billing Schedule
DMT 4.0.3.0
Enhancements
Added Epicor Version number to CompleteLog file.
Fixed Installation Error message
Added error handling when Template Builder attempts to save to a locked file.
The Error reprocessing file, Errors.Reprocess.csv, now copes with non-ansi characters (umlauts, Chinese characters, etc.)
Menu import now supports 'All' company menus (blank Company field)
Added support for Counter Sale to SalesOrderCombined
Migration Mode - Included Job Header and Job Assembly in Phase 4 > Engineering
Added Sales > Demand > Demand Head and Demand Detail imports
Fixes
AP Invoice Head, AP Invoice Detail, GL Account, Data Tag, Menu, User Codes, Ext File Ref, Memo, Menu Security and User imports now display UD Fields in Template Builder and Field Validation
AP Invoice Group, APInvoice Combined - Unlock Group after import
WBS Phase Operation: Fixed "Error accessing the database: Invalid column name 'PhaseID'" error that could occur when adding new WBS Phase Operations in 10.1.301 and later
PO Combined - fixed an issue that displays a "Column 'OpenPO' does not belong to table" error when the OpenOrder column is included in the import file.
TE Labor Detail, TE Labor Detail No Header, TE Labor Combined imports - fixed issue that could result in the BurdenRate to be set to zero causing a zero Burden Cost value
Menu Import - removed MenuDataSet from Required Fields
Purchase Order Detail: Fixed "Input array is longer than the number of columns in this table" error that can occur in 10.1 if the PO header import is also open in DMT
Fixed Menu Security for menu item disabled at the top level. The user will now only have access to DMT imports that their user has access to use.
Fixed compatibility issue with DMT v4 and older extensions
DMT 4.0.2.0
Enhancements
Enabled DMT Home page
DMT Version change. DMT now ignores the revision when checking to see if it has the correct version installed. So DMT for 10.0.700.0 works on an Epicor 10.0.700.4 client.
Enabled Cut & Paste from Template Builder
DMT Version Updater - display message if no updates are available
Command Line Arguments - Allow Auto-login for SSO users
Added Single Sign On option to Preferences screen to allow the user to change SingleSignOn setting. DMT now remembers this setting and uses it by default on next start-up.
Command Line Arguments - Now properly looks up enviornment from command line argument whether or not .sysconfig is specified in ConvigValue parameter
Fixes
Customer Contact - Added key fields to error log
Command Line Arguments are case-insensitive again
Handle corrupt config file more gracefully
Exit DMT after Command Line Argument initiated import finishes
Quantity Adjustment import - fixed blank serial number that could result from importing multiple records with Masked Serial Numbers
Fixed the Migration Mode menu order of Bill Of Materials and Bill Of Operations
Fixed Column header display of import field names that include underscores to prevent the removal of the underscore - does not affect import functionality
Account Budget - Fixed Fiscal Period Not Found error that could occur when running in Add and Update mode
Account Segment Values - fixed an issue relating to adding or updating Segment Options
Bill Of Operations - Populate Operation description when Operation Code changes
Bill of Operations - changed the way Company / Plant is set when different to logged in user.
AP Invoice Combined - Added VendorID to Template Builder
Fixed Null Reference Error that could occur when loading an empty import file
Part Plant - Fixed error message that occurs if the Plant case does not match
Specification Attribute - now correctly displays UD Fields in the Template Builder
DMT 4.0.1.0
Enhancements
Added Management / Purchasing / PO Schedule import
Added Management / Purchasing / Part Schedule import
Fixes
Allow columns to be ordered by Selected column in template builder
Disabled DMT Home page due to issues encountered by Windows 10 users
DMT 4.0.0.0
Enhancements
New User Interface
AP Invoice Head - Added support for manual Legal Numbers
AP Invoice Combined - Added support for manual Legal Numbers on header
Quantity Adjustment - Added Legal Number support
Added Purchasing / PO Receipts / PO Receipt Head and PO Receipt Combined imports
Added Service / Maintenance Job / Maintenance Operation import
Fixes
Command Line Argument - fixed logon issue caused if Server argument is specified
Purchase Order Detail and Purchase Order Combined - Do not set BTOOrderNum and BTOOrderLine if value is blank
Part Combined - fixed "Input array is longer.." error that could occur when setting the Warehouse Code
AP Invoice Detail - fixed "Invalid Line Type" error that occurs when creating a new Line when LineType is not J or blank
DMT 3.0.8.0
Enhancements
Added Customers / Customer Document Types import
Added Production / QA / Skip Lot Control Code import
RMA Disposition: Added serial number support
Added AP Invoice Job Misc Charge import
AP Invoice Detail: Added ability to create Job Misc lines
AP Invoice Combined: Added Job Misc Charge and added functionality to allow creation of job lines through APInvDtl by setting LineType to J
Quick Job Entry: Added support for Legal Numbers
Fixes
Purchase Order Detail: PODetail# fields are now case-insensitive
Purchase Order Release: Added Business Object method calls that should be called on change of BTOOrderNum, BTOOrderLine and BTOOrderRelNum fields
Bill of Operations: Fixed "Validate Columns" for ECOOprAttch, ECOOprRestriction and ECOOprRestrictSubst sub-tables.
Sales Order Release: Added ReOpenRelease to Template Builder
Sales Order Release: Fixed issue when changing from Make Direct to Buy To Order
Case Import: Template now includes Extended UD fields
AP Invoice Combined: Fixed error on creating multiple invoices with only 1 Invoice Line
User Codes import: Allow for deletion of individual User Codes
GL Journal Combined: fix an issue caused by multiple header rows with the same description
Issue Material: Fixed "A valid Job material is required" error that could occur for Assembly Sequence > 0
Return Material: Fixed "A valid Job material is required" error that could occur for Assembly Sequence > 0
Handle error that occurs when attempting to save a template to a locked file
DMT 3.0.7.0
Enhancements
Added Service / Service Call Type and Service Contract Code imports
Added Customers / Customer Tax Exemptions import
AP Invoice Misc Charge import renamed to AP Invoice Detail Misc Charge
Fixes
Ship Via Import: Added Foreign Language Description support.
Update Service: Removed dependency on access to Google for internet connectivity test
Terms Import: Added Foreign Language Description support.
Menu Import: Fixed import routine for imports with both Arguments and ReadOnly fields
Extended UD Fields import: Allow changes to migrated UD Fields
Account Budget import: fixed Account Budget creation for Epicor versions 10.1.200.0 and above. Also fixes creation for multiple rows.
Purchase Order Detail import: fixed UD fields not appearing in Template Builder
Handle crash that can occur when DMT cannot create log files.
Sales Order Release: Added PlantRelease column for Plant in Release
Part Combined: Added functionality for part duplication
DMT 3.0.6.24
Enhancements
Added Site Maintenance (Plant) import
Moved Miscellaneous Charge to Sales
Moved Miscellaneous Charge Credit to Purchasing
Added Transfer Order import
Added Company Configuration BMSystem import
Added Global Lot Sequence import
Fixes
RMA Detail and RMA Receipts: Fixed imports that include Serial Numbers
Multi-session: Fixed an error that sometimes occurs when a large import is split into many files which are all processed by DMT concurrently
Quote Material: Fixed unique constraint error on updating multiple rows
Data Tag: Fixed for imports that do not include the ForeignSysRowID
Ship Detail: Fixed import where Pack currency does not match Sales Order currency.
Part: Changed delete function to fix issue of orphan PartRev records
GL Journal Combined: Fixed duplicate Journal header created when Journal entry is added for a Journal Header that already exists in the database
DMT 3.0.6.23
Enhancements
Added Person Import
Added Supplier Group import
Added Workflow Stage import
Added Indirect Labor Code import
Added Miscellaneous Charge import
Fixes
CashReceipts - Now automatically fills information in Deposit based on Sales Order as it does in UI
Project - Fixed an issue where you couldn't engineer and release new project jobs in a single DMT run
Project - Fixed an issue where project jobs couldn't be created on new projects
Purchasing - Fixed an issue where DMT wasn't using BTOOrderNum/BTOOrderLine to populate PartNum/Desc
Inventory - Fixed issue that meant import wouldn't run properly if FromJobSeq wasn't before TranQty in the columns
Project - Added functionality for Create Project Job
CashReceipts - Fixed issue with Invoice Payment import that was causing a "Check amount cannot be 0" error when trying to import a CC payment.
Sales - Fixed Customer Shipment Line creation for Serial Number tracked parts
Service - Fixed EquipmentPlan functionality for Update Only
Customer - Corrected menu security for Customer Part Cross Reference
ARInvoice - fixed issues where CurrencyCode was not being updated
Customer - fixed CustNumCustID not showing in Template Builder
DMT 3.0.6.22
Enhancements
Added Payment Method import
Added Company imports
Fixes
Sales Order Header: Now correctly updates other values when ShipToNum column included in import
Workflow Group Member: Members now correctly imported
DMT 3.0.6.21
Enhancements
Added Role Code import
Added Task import
Added TaskStatus import
Added TaskType import
Added PriceGroup import
Added Sales Category import
Added Inspector import
Added Security Group import
Added Fiscal Calendar import
Added FOB import
Added Supplier Search Cross Reference import
Added AP Invoice Receipt import
Fixes
Part & Part Combined: Do not allow IUM or UOM Class to be changed if it would not be allowed through the Epicor UI
PO Combined: Now accepts a PONum of 0 and will then continue attaching lines to the same new PO while POLine increases. A POLine lower than the previous row indicates that a new PO should be created.
Memo: Delete and Update now able to find the required Memo
Quote Header: Delete no longer errors
Project Bill Schedule: Template Builder no longer errors
AP Invoice Combined: Can now add GL Analysis
Sales Order Release: Now allows yes/no and 0/1 as well as true/false for OpenRelease
DMT 3.0.6.20
Enhancements
Added Customer Shipment import
Added Issue Miscellaneous Material import
Added Industry Class Type and Industry Class Code imports
Added EntityGLC to Asset Class and Asset Group imports
Added Task Set, Task Set Milestone and Task Set Milestone Next Task imports
Added Workflow Group and Workflow Group Member import
Fixes
Global Part Link: Fixed 'Row has been modified by another user' error
Quote Detail Attachment: Template Builder now shows correct table
Employee Role: No longer shows 'Duplicate Role Code' error when updating a record
Employee GL Account: Fixed error in setting RelatedToFile
Sales Boundary: Allow blank country
DMT 3.0.6.19
Enhancements
Added Issue/Return Material
Added Issue/Return Assembly
Added Update option for Configurator Control Data
Fixes
Part Class: Will now error if OwnerPlant column missed, instead of silently failing
AR Invoice Combined: No longer errors when ARInvcDtl#InvoiceNum is included and set to 0 for a newly created invoice with autogenerated invoice num
AR Invoice Combined: No longer errors if group already exists but with no invoices
Demand Contract Detail: DemandContract now shown as a field in Template Builder
ShipTo Contact: UD fields now appear in Template Builder
Supplier/Supplier Bank: Validation no longer fails when PayMethodName included in import
Job Assembly: Assembly created using DMT is now copied across when job is used as a template
CoPart: Fixed ForeignKeyConstraing error when CoPart added for AltMethod
Purchase Order Detail: No longer get error when using DMT to close PO line relating to closed job
DMT 3.0.6.18
Fixes
Schedule Job: Fixed error where not importing if WhatIf column not included in import
DMT 3.0.6.17
Enhancements
Added AP Invoice Header Misc Charge
Added ability to delete UserComp row without deleting User (set RowMod to D and run Update mode)
Added Extended UD Maintenance
Fixes
Asset Addition and Asset Disposal: Now show Extended UD fields in Template Builder
AP Invoice Combined: Now handles multiple line GL analysis
Supplier Combined: Now includes Purchase Points and GL Controls
Job Serial Number Assignment: Now handles Mask type serial numbers
BOO: No longer see 'ECOOpr has not changed error when OpCode is the only changed field
DMT 3.0.6.15
Enhancements
Added Posted AP Invoice Update
Added Posted AR Invoice Update
Added Asset Class
Added Asset Group
Fixes
BOO: Operation description updated when op code is changed
AP Invoice: Correctly assigns LegalNum where configured
User: Delete no longer errors
Schedule Job: Handles WhatIf scheduling
UOM Class: ConvFactor now set
Tax Type: Tax Box details now importing
Employee: Removed Plant from required columns list
DMT 3.0.6.14
Enhancements
Added Payroll Employee GL Account
Added Customer Documents and Customer ShipTo Documents
Added Cash Receipts
Added Payments
Added Payroll Check and Hours
Added AP Invoice Combined
BOO: Added ability to delete ECOOprInsp rows
RMA Header: Added BTCustNumCustID and ShipToCustNumCustID
Fixes
Payroll Employee Rate: Can now update/delete PREmpRate
PO Detail: No longer errors when importing line with more than 2 releases
Minor fixes to importing of Excel data when Infragistics component cannot be used
Employee Expense: Clarified description of PMUID column
Users: Now applies Epicor menu security
Viewing Required columns no longer impacts on Validation
Part Combined: Column Validation recognizes extended UD columns
Sales Order Combined: No longer errors when changing RevisionNum
DMT 3.0.6.13
Enhancements
Added Customer Search Cross-Reference
Added Job Material Reference Designators
Added Time & Expense
Fixes
Maintenance Job Header: no longer shows invalid job error when JobEngineered or JobReleased included in template
Job Serial Number Assignment: no longer shows unrecognized Guid format error
Login form no longer resizes when SSO is ticked as this caused display issues in some circumstances
DMT 3.0.6.12
Enhancements
Added Quote Contact
Added Quote Salesperson
Added Configurator Control Data
Added Operation Attachment
Fixes
UOMClass: No longer shows record not found error on adding new UOM Class
UOMClass: No longer shows row modified by another user on adding new UOM Class
DMT 3.0.6.11
Fixes
General: Improved handling of various exceptions
BOO: No longer errors when OpStdID included
BOO: Correctly updates Op Std hours
OrderHed: ReOpenLine column now visible in Template Builder
UD tables: UD columns now visible in Template Builder
Maintenance Job Operation: No longer throws null reference exception
Enhancements
AP and AR Invoice imports added
Clarified error message when downloaded update file is corrupted
DMT 3.0.6.10
Fixes
BOO: SubContract column now recognises 0/1, No/Yes and True/False
Command line version NoUI version no longer fails to run
Employee GL Account: No longer errors when trying to open this import
Case: Added CloseCase/ReopenCase functionality
DMT 3.0.6.9
Enhancements
Changed location of application settings file so users will not need to run DMT with elevated privileges
Added COA Account and Segment Mapping import
Fixes
Journal Header: no longer fails when a posted group already exists with the same GroupID
Schedule Job: performance issue fixed, RPM no longer drops during import
DMT 3.0.6.8
Enhancements
Full UD tables imports
Fixes
Global Customer Link: Links all ShipTos
DMT 3.0.6.7
Fixes
Ship Via: no longer shows error "Column 'col.ColumnName' does not belong to table"
Various: no longer errors when handling validation mask Serial Numbers
Resource Group: no longer errors on deletion
DMT 3.0.6.6
Fixes
Various: no longer errors when handling Serial Numbers
Various: no longer errors when switching between plants during an import
DMT 3.0.6.5
Enhancements
Command line help updated for new E10 options
Fixes
Global Customer Link: allows for linking of Contacts and ShipTos
Part: no longer shows error on change of plant
Sales Order Detail: allows sales kit with revision but no components
Supplier Combined: import no longer errors when PP not provided
CRMCall: defaults RelatedToFile to 'customer' if CallCustNumCustID is provided
GL Journal Group: no longer shows error when book mode is M and BookID is blank
Did you try running DMT as admin? (right click run as admin)
Elevated rights sometimes is needed to do the auto update.
He was using an older version. Which probably pointed to a now defunct URL for updates.
I get this from BitDefender
Just documenting the change logs for
Just documenting the last two change logs for 10.2.300
DMT 4.0.52.0
Fixes:
DMT 4.0.51.0
Fixes:
DMT 4.0.59.0
DMT 4.0.59.0
Enhancements:
Fixes:
DMT 4.0.58.0
Enhancements:
Fixes:
DMT 4.0.57.0
Enhancements:
Fixes:
DMT 4.0.56.0
Enhancements:
Fixes:
DMT 4.0.55.0
Enhancements:
Fixes:
DMT 4.0.54.0
Enhancements:
Fixes:
DMT 4.0.53.0
Enhancements:
Fixes:
DMT 4.0.52.1
Enhancements:
Fixes:
Deleted older entries - they can be found in prior lists