| 11.5.9 - problem in Account posting - Very Urgent - Please help [message #161196] |
Thu, 02 March 2006 09:12 |
financeguy
Messages: 6
Registered: March 2006
Location: Queens
|
Junior Member |
|
|
Hello all,
WE recently migrated to 11.5.9 from 11.5.3
We had a custom download iterface process which used to work fine in 11.5.3 which we used to bring checks from the city into acconts payable tables and after the checks were inserted into the AP tables the posting process used to run and the status of the checks used to say ACCOUNTED and the posting process would balance the books at the end of the month.
The download interface program is inserting the check records into
INSERT INTO AP_INVOICE_PAYMENTS_ALL
INSERT INTO AP_CHECKS_ALL
UPDATE AP_INVOICES_ALL
SET PAYMENT_STATUS_FLAG = x_invoice_paid_flag,
AMOUNT_PAID = x_invoice_amount_paid ,
DISCOUNT_AMOUNT_TAKEN = 0,
LAST_UPDATE_DATE = SYSDATE,
LAST_UPDATED_BY = x_user_id,
ATTRIBUTE15 = '2'
WHERE INVOICE_ID = invoice_id_rec.INVOICE_ID;
UPDATE AP_PAYMENT_SCHEDULES_ALL
SET AMOUNT_REMAINING = x_invoice_amt_due,
DISCOUNT_AMOUNT_REMAINING = 0,
PAYMENT_STATUS_FLAG = x_invoice_paid_flag,
LAST_UPDATE_DATE = SYSDATE,
LAST_UPDATED_BY = x_user_id
WHERE INVOICE_ID = invoice_id_rec.INVOICE_ID;
UPDATE AP_CHECK_STOCKS_ALL
SET LAST_DOCUMENT_NUM = x_check_num,
LAST_UPDATE_DATE = SYSDATE,
LAST_UPDATED_BY = x_user_id
WHERE CHECK_STOCK_ID = x_check_stock_id
AND LAST_DOCUMENT_NUM < x_check_num;
With 11.5.9, the download interface is working and inserting/updating the checks into the AP tables but when we run the Posting process, the status of the check payments is not changing to ACCOUNTED, which means that the payments are not getting accounted / posted in the financial tables.
Has anyone had this problem with 11.5.9 and can someone please help to resolve this issue.
We are looking for a solution ASAP.
Thanks,
Samir.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
