Well, this was a hard one. The client is using Scribe, which uses eConnect, to populate the Project Accounting budget in the project, and the Inventory Transfer work files. The primary files for the Inventory Transfer are PA10900 and PA10901. There are two secondary files EEAPAIVRQ and eePAIVLN.
The Scribe integration was creating the inventory transfer records, and the return records in PA10900 and PA10901. However, in the case of a return no cost was being posted to the budget detail in the job. Therefore the job customer was being charged for job material but on a return they were not receiving create in the job, and the PA Prebilling report would be incorrect.
When the PA Inventory Transfer batch with the return in it was posted the cost would show up as zero on the report indicating a problem in the work files PA10900 and PA10901.
In the PA10901 file Scribe was not populating the fields PAEXTCOST and UOMSCHOL. Properly populating these fields solves the problem.