Welcome

Welcome to HandsonERP.com

This site provides video based training of Oracle Financials.
Learn concepts and functionality in a step by step manner.

Login

HandsonERP - Oracle E-Business Suite Training
Welcome, Guest
Please Login or Register.    Lost Password?
Re:AP Invoice - Create Accounting Warning (1 viewing) (1) Guest
Please post inquiries related to lessons content here. All questions and inquiries related to the website should be submitted directly using Contact form in the top menu.
Go to bottom Post Reply Favoured: 0
TOPIC: Re:AP Invoice - Create Accounting Warning
#3492
Charlie (User)
Gold Boarder
Posts: 284
graphgraph
User Offline Click here to see the profile of this user
AP Invoice - Create Accounting Warning 11 Years, 9 Months ago  
Hello Hasan,

Can you take a look at the attached file.

I'm getting a warning when I try to Create Accounting for a Validated Invoice.

Any ideas as to why ?
Could there be a bug again with Oracle ?

Thank-you
Charlie
File Attachment:
File Name: WARNING___Create_Accounting.doc
File Size: 451072
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#3494
Charlie (User)
Gold Boarder
Posts: 284
graphgraph
User Offline Click here to see the profile of this user
Re:AP Invoice - Create Accounting Warning 11 Years, 9 Months ago  
Sorry... wrong file was attached...in previous posting.
.
This is the correct file.

Thank-you
File Attachment:
File Name: Create_Accounting_DOESNT_work.doc
File Size: 452096
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#3497
handsonerp (Admin)
Admin
Posts: 1989
graph
User Offline Click here to see the profile of this user
Re:AP Invoice - Create Accounting Warning 11 Years, 9 Months ago  
There are two problems. You should treat them separately.
1) Account is not creating
2) Create Accounting in ending at warning.

In order to fix issue 1, you need to take a look at the Create Accounting output. See if you can view the output. If you are seeing XML output then run the Publisher program to view the output as I have done in the videos. The output will tell you what the problem is (with accounting). Most likely cause is GL period is not opened.

Keep in mind that validation does not mean that accounting will be created. Create accounting could have its own issues and only the Create Accounting program display errors in detail.

Alternative you can go to Tool->View Accounting for that transaction, and look at the error message there.

Why create accounting is ending at warning? You need to take a look at the full log file for that. There could be an XML publisher related bug that prevents publisher to launch automatically.
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#3498
Charlie (User)
Gold Boarder
Posts: 284
graphgraph
User Offline Click here to see the profile of this user
Re:AP Invoice - Create Accounting Warning 11 Years, 9 Months ago  
Can you acknowledge that this is the correct solution...
I've also attached the OUTPUT file for the Create Accounting program
.
My Ledger is composed of BSV (01,02)
My LE is assigned to my Ledger
My OU is assigned to my Ledger
Financial Options setting for Payables Liabilty = 01.2000.00

When I create an invoice my Expense distr = 02.5870.00
Hence, when I try to Create Accounting... I get a warning
Warning states that my journal is unbalanced, and that I need to enable the option...
Balancing Cross-Entity journals.
.

I enabled Intracompany for my Ledger
I defined a default rule to use to handle situation, where my Liability account references BSV 01 and my Expense account references BSV 02
.
Now when I enter an Invoice and the distrn is "02.5870.00"
and run Create Accounting... the program completes successfully

I have generated Accounting...

Example :

DR 02.5870.00 ...$200
CR 01.2000.00 ...$200

CR 02.IC.10 ....$200
DR 01.IC.20 ....$200


This seemed to have worked....
Do you agree as to the solution is ?

Thanks
Charlie
File Attachment:
File Name: Contents_of_the_Create_Accounting_OUTPUT_file.doc
File Size: 317440
 
Report to moderator   Logged Logged  
 
Last Edit: 2012/08/09 19:00 By Charlie. Reason: Attaching OUTPUT file
  The administrator has disabled public write access.
#3503
handsonerp (Admin)
Admin
Posts: 1989
graph
User Offline Click here to see the profile of this user
Re:AP Invoice - Create Accounting Warning 11 Years, 8 Months ago  
Technically the solution is sound but I am not sure if it is meeting the business needs or not.
When you enter an invoice for company 02 you would normally would the liability account for company 02 to be credited (not 01). You can control that using balancing segment offset settings in Payables Options. In that case you will not get cross entity error.
Otherwise if this is what business wants that company 01 will assume the liability no matter which company is generating expenses, then your solution is fine.
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#3506
Charlie (User)
Gold Boarder
Posts: 284
graphgraph
User Offline Click here to see the profile of this user
Re:AP Invoice - Create Accounting Warning 11 Years, 8 Months ago  
Thank-you

That's exactly what I was looking for.
This solved my issue.
There are SO MANY options that it sometimes becomes overwhelming.

Thank-you
Charlie :)
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#3518
handsonerp (Admin)
Admin
Posts: 1989
graph
User Offline Click here to see the profile of this user
Re:AP Invoice - Create Accounting Warning 11 Years, 8 Months ago  
Good to know that your problem is solved.
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
Go to top Post Reply
Powered by FireBoardget the latest posts directly to your desktop