INTERNET APPLICATION DEVELOPMENT
MID MARKET ERP DEVELOPMENT
by Kristi Feng
Last week a coworker asked me, “Do you know which object stored the amount paid detail for AP bills in Intacct?”
I thought it was in AP Payment and AP Payment Detail, but payment and payment detail do not have references to AP Bill. Then, I looked in Objects in Platform Services trying to see which object name seems to have both bill and payment information. From the name, “AP Bill Payment” seems to be my answer. I tried to use this object in a report, but because of the date filters, the report did not give me every detail. I decided to write a C# project to see if using the Web Services API will return every detail, and it did.
Here is the data from “View Detail” from Intacct and data returned from my C# project.
For Credit Memo:
During this exercise, I also learned that the “View Detail” form credit memo in Intacct does not include the paid to invoice detail, if the invoice is paid fully by the credit memo.
I hope you find this helpful.