Does anyone know what field you are supposed to populate with qty for PO detail records in DMT. I thin I have tried about every field that has a qty associated with it and nothing sticks.
Should be something simple like OrderQty, (What its called in V6),xorderQty.
Any help would be greatly appreciated.
10.1.400.12
DMT 4.0.15.0
the error msg DMT is throwing for every line is;
31445 1 Table: PODetail Msg: A valid Quantity is required.
Chris,
Try CalcOurQty (or CalcVendQty if using Supplier quantity/UOM).
Have you tried turning on TRACING, then creating a dummy line on a PO with some quantity that’s easy to search for, like “5555”. Then, open the trace and search for “5555”. That should give you all the fields you need to set.
Hope that helps.
Kevin Simon
SimsTrak Consulting, LLC
Agree with Ernie, my template builder says CalcVendQty could be the one
you’re looking for. If not, try ContractQty
Kevin,
Thanks. The issue turned out to be multiple
For those that see this in the future.
PO Detail Qty field = CalcOurQty
Once the qty was entered into that field and DMT was rerun a new error came up “Transaction type PO Release was not found”.
Turns out when I was testing some other imports earlier in the week and had turned off the Inventory interface in company config and not turned it back on. 3 hrs of trying everything under the sun and it turned out to be user error.
Yes,
I was able to get ahold of Arthur Cole at Epicor who gave me the qty field but that was only part of the problem. The final solution was the inventory interface under Company config needing to be checked in order to import PO lines and releases.
Glad to hear it’s resolved.