Been struggling all weekend trying to upload PO Receipts that happened when we were in V8, into E10, so that AP can match up the AP Invoices, but have had zero luck.
I’ve got all the RcvHead entries in, but RcvDtl entries give errors at every turn.
Most common error is “Table: RcvDtl Msg: Record not available.”
Can anyone give me the cliff notes on how to do this successfully. Particularly the states of any of the fields of POHead, PODtl, PORel, RcvHead, and RcvDtl that need to be a certain value.
I tried running the Trace in DMT but that provides very little info.
You cannot import PO Receipts as historical data. DMT is coming out with a feature that allows “historical mode” for imports, but this is not released yet (as far as I know). What you are doing is actually creating new receipts, which will trigger new PartTran records. I doubt that’s what you are intending to do. The same can be said about creating ShipHead and ShipDtl records. Those will trigger inventory transactions. If you want to import purely historical data, either wait for the DMT feature to be released or import into a UDxx table like UD01 or create your own user-defined table and add fields that mimic the existing schema. DMT can import into UDxx tables. Then create a BAQ and Dashboard that query the UDxx or user-defined table to see history. My team has created a BPM that pulls data from UDxx, populates Purchase Advisor tabs, and makes the data appear as if it was truly created from history.
I knew the processing of PO Receipts and Shipments would generate the part transactions. I was prepared to do all the adjustments to “back them out” (Qty Adj’s to get QOH correct, and GL trans to undo the variances created).
I need to do this so that we can match Supplier invoices to PO Receipts. The PO receipts happened in V8, but the supplier invoice is now being entered into E10,
I’m open suggestions for how to handle entering an AP Invoice with no PO receipt on record.
But I’d also like to know what I was doing wrong during the PO Receipt import in DMT.
Your approach will essentially recreate the entire part transaction history for PO receipts.
Then, you need to make sure those receipts are not appearing as payables unless you are also importing the matching AP invoices. Lastly, you’ll likely need to mark them as paid or import matching AP checks as well. Very ambitious!
AP Invoices can be imported using Open Invoice Load, either with DMT or using the function in the Accounts Payable > Setup menu.
I was only importing the receipts that we knew were not yet invoiced.
And I do these types of things on weekends, so any transactions can easily be identified.
And these are done in the Test DB (just after copying the Live Company to it) first.
Are you importing PO lines with part numbers that do not exist (like a miscellaneous line)? When in doubt, use the Receipt Entry function to add the same line item manually and see if you get the same error message. I believe you might be missing the Weight UOM Class because PO Receipts require it to be populated. I also recommend including RcvDtl#IUM and RcvDtl#PUM in your import file.
I struggled with the same issue for half a day, found out that these are the field required to overcome the Record Not Available. Hope this will help someone else who is doing DMT.
I have done extensive work on DMT on PO Receipts recently and I found out there is a bug where the RcvDtl#Received flag needs to be “TRUE” rather than 1.
My DMT template contains the following data to import and it works perfectly.
