AP Push to AM in PeopleSoft Version 9.1

The weekly AP push to AM was done and two items were pushed erroneously without keeping them on hold. Out of two items, one item got asset created and another did not. Not sure where the second item has gone and the value is $10. Can any one help in researching this second item ??

Use Query Manager and select these records (individually) and in all the fields in them, perhaps using anything about the transactions you are looking for as criteria to limit the data returned.. Run the Query

1) In the Interface Pre AM TAbles enter the Voucher Number of the missing item. This will have the Financial/Physical Interface # if it was processed thru the Payables/Purchasing Process. If it does not have the Interface # it was not processed.

If you do have an Interface Financial/Physical Interface #, enter that number along with the BU Number in the Financial Interface Panels - it should pull up and give you the status of the item. You will also need to check the Physical Interface Panels to verify that it is entered there and check the status there. The Financial Interface panels will have the Asset # if it was processed thru to Asset Management. If yes, check the Asset Cost Adjust/Transfer Panels to verify the asset is there, you must also check the Asset Basic information Panels to verify that it has been entered there. This is how you look for it via the Panels. You can also run queries to verify. (Inteface PreAm - Interface Financial - Interface Physical A)

If you will let me know the outcome, of your research I can help you trouble shoot your issue. In order to do this I have to know the last process that was completed.

There are several possible issues if it did not process thru to AM, but it depends on if it processed thru the PreAm (Payable/Purchasing Process) or not.

So we have established that it processed from the Pre-AM tables to the Interface tables. (Interface Status of "DON")

In the Interface Financial Panel at the bottom of the Panel it will give you a reason it is in ERR.

It appears that the issue is the Accounting Date. It will only process transactions with an Accounting Date in the Current AM Period. ( not the GL Open Periods but the AM Open Periods)
The normal options are:
1) Via an SQL Change the Accounting Date to a Current Period.
2) Or open AM for the period related to the Accounting Date listed for the Asset.

Either way you go, before you can process it through the interface tables you must change BOTH THE INTF FINANCIAL AND INTF PHYSICAL A to a Status of "PENDING". They must be changed prior to running the Transaction Loader to avoid further issues.

Another reason a transaction from AP won't process thru the transaction loader is the CAP is not open or has reached it's limit.