DMT "new" function for PORelease Update (where's the DMT Manual?)

[LarsonSolutions (Bruce Larson)]

I have been working through a problem with PO releases.
Through DMT many releases were closed in error.
When you close an open release, (set PORel.OpenRelease to FALSE), the status of the release is set to “V”
When setting the value of PORel.OpenRelease to TRUE, the Status was not update to “O”.
This causes an issue with Mass Receipt not working.

After going around and around with Epicor Support - they asked if I had tried, ReOpenRelease to update the table? Didn’t know it existed.

So, if you need to Reopen a release that was closed and voided, use ReOpenRelease as your column set to True.

Now, if there only a place to find the Manual on all of the DMT loads that one could use.
Maybe a help button??

[JasonMcD (Jason McDermott)]

Here are two of my favorites (in one post):

Job Closing DMT and Backflushing

You have the “QuantityContinue” column in the DMT, too? I know that was an obscure thing I had to find. I think “Schedule Job” is the screwiest DMT I know of. There’s a magical column you have to know about called “OverRideHistDateSetting” and set it to 1 for every row. And “StartTime” is a text field, so in Excel I have it as '6:00 (with the apostrophe). There are some interesting DMTs out there.

[JasonMcD (Jason McDermott)]

Oh, and this is my favorite Easter egg. For when you want to Print As Fred in a DMT.

[Edge (Stephen Edginton)]

Ok that is not in DMT but our metadata for fields - directed to team to correct.

[JasonMcD (Jason McDermott)]

Noooo! I love Fred!

[LarsonSolutions (Bruce Larson)]

There should be a post to capture all the “oops” in Epicor fields and errors.
The best ones are the Blank error codes that pop up.

Still looking for that manual or extended help.
I guess it is just the templated that you need to read through to know what is there.
And tribal knowledge to know when a CSV file works and an XLS or XLSX won’t work,