Page 1 of 1

Invoice Distribution Line is Reversed and Manually

Posted: Mon Dec 14, 2009 11:37 am
by nadh.oracleapps@yahoo.com
Version R12/11i? = R12
Instance PROD/TEST/VIS? = Vision
Module? = AP
OS? = Any

Dear Members,

I Created Invoice and Run Create Accounting. Later, I reversed Invoice distribution Line and manually Changed Invoice Header Amount. I Run Create Accounting. Reversed Distribution Line is Transfered to GL but Liability account is not balancing because i manually Changed.

Is there any way

Thanks

Posted: Tue Dec 15, 2009 12:26 pm
by tgs100
Have you validated the invoice? If invoice is validated, then invoice header total should match with the line and distribution total.

Check invoice status, invoice header amount, line total and distribution total for each line.

Cheers,
Saravanan

Posted: Wed Dec 16, 2009 4:23 am
by stalinvstalin@gmail.com
hI,

WHEN EVER U MAKE ANY CHANGES IF DISTRIBUTION AMOUNT IS NOT EQUAL TO HEADER IT WILL PUT IN HOLD.

IF U MAKE ANY CHANGES IT WILL ASK FOR "NEEDS REVALIDATION"ONLY AFTER VALIDATION U CAN CREATE ACCOUNTING AND T/F THEM TO GL. IF I AM RONG PLEASE MAKE THE QUESTION MORE CLEAR .


STALIN

Posted: Wed Dec 23, 2009 10:16 am
by nadh.oracleapps@yahoo.com
Hi Sravan,

Invoice is Validated, Accounted, Transfered to GL and Posted also.

Invoice Status in not Paid. I checked Invoice Header Amount and Line Amount is Correct

Thanks

Posted: Wed Dec 23, 2009 1:35 pm
by tgs100
Can you give the accounting entries with amounts?

There were some issues in create accounting in R12 till 12.0.6 and we applied some patches. This could be due to bug also.

Cheers,
Saravanan

Posted: Sat Dec 26, 2009 7:57 pm
by nadh.oracleapps@yahoo.com
Hi Sravan,

When Invoice is Created
Expense A/c Dr. 100
To Liability A/c 100

When Reversed
Liability A/c Dr. 0
To Expense A/c Dr. 100

Actually System has to Hold this Inovice. But It was imported to GL and Posted in GL.

If you have any Bug reference number for this Please update me.

Thanks

Posted: Mon Dec 28, 2009 8:05 pm
by tgs100
1. Is it a one-off case or you are able to reproduce the issue?
2. What is the SLA used in the ledger?

Cheers,
Saravanan