AutoInvoice first looks at the transaction type setup (Menu: Setup>Transactions>Transaction Types) and the TAX_EXEMPT_FLAG column in RA_INTERFACE_LINES_ALL. If the 'Calculate Tax' box is checked on the transaction type OR the TAX_EXEMPT_FLAG column is 'R'(for Required), it tries to derive the Tax code.
To get the tax code, AutoInvoice looks at the following places in the following order, stopping at the first place where it finds a tax code:
- Ship-to site
- Bill-to site
- Customer
- Item
Thursday, February 26, 2009
Steps to be considered when we get 'Please Correct Revenue (or Receivable or Freight or Tax) Account Assignment'?
Autoaccounting is used to determine the accounts when the distribution table is not populated. When AutoInvoice gives this error, it generally gives the account with the missing segment(s).
Menu: Setup>Transactions>Autoaccounting
Query the account mentioned in the above error and note the setup for that missing segment.
If it is based on:
Transaction Type - Menu: Setup>Transaction>Transaction Types, and verify that all accounts are populated.
Salesperson - Menu: Setup>Transactions>Salespersons, and verify that all accounts are populated.
Standard Lines - For an Inventory Item navigate to Menu: Setup>Transactions>Items>Inventory items, and verify that the 'Sales Account' is populated in the 'Invoicing' alternate region. For a Memo Line, navigate to Setup =>Transactions =>Memo Lines, and make sure that 'Revenue Account' is populated.
Taxes - Menu: Setup>Tax>Codes and verify that account is populated in 'Tax' column under the 'Accounting' alternate region.
Additionally the following can be checked: Setup of Cross Validation Rules. Run Cross validation Listing Report in GL to identify the cross validation rule stopping the import of this line.
Menu: Setup>Transactions>Autoaccounting
Query the account mentioned in the above error and note the setup for that missing segment.
If it is based on:
Transaction Type - Menu: Setup>Transaction>Transaction Types, and verify that all accounts are populated.
Salesperson - Menu: Setup>Transactions>Salespersons, and verify that all accounts are populated.
Standard Lines - For an Inventory Item navigate to Menu: Setup>Transactions>Items>Inventory items, and verify that the 'Sales Account' is populated in the 'Invoicing' alternate region. For a Memo Line, navigate to Setup =>Transactions =>Memo Lines, and make sure that 'Revenue Account' is populated.
Taxes - Menu: Setup>Tax>Codes and verify that account is populated in 'Tax' column under the 'Accounting' alternate region.
Additionally the following can be checked: Setup of Cross Validation Rules. Run Cross validation Listing Report in GL to identify the cross validation rule stopping the import of this line.
Can Adjustments be imported through AutoInvoice?
we can not create adjustments through Auto Invoice and apply to Invoices.
we can create Only Invoices, Credit Memos, Debit Memos, and On-account Credits can be imported through AutoInvoice. The adjustments can be imported by using Adjustment API's. This API allows users to create, approve, update, and reverse adjustments for invoices using simple calls to PL/SQL functions.
we can create Only Invoices, Credit Memos, Debit Memos, and On-account Credits can be imported through AutoInvoice. The adjustments can be imported by using Adjustment API's. This API allows users to create, approve, update, and reverse adjustments for invoices using simple calls to PL/SQL functions.
How to apply a credit memo (from a legacy system) against an invoice using AutoInvoice:
How to apply a credit memo (from a legacy system) against an invoice using AutoInvoice: To link the credit to an invoice there are 2 options:
1) Populate REFERENCE_LINE_ID on RA_INTERFACE_LINES_ALL with the CUSTOMER_TRX_LINE_ID of the invoice. or
2) Populate REFERENCE_LINE_ATTRIBUTE1 to 15 with the INTERFACE_LINE_ATTRIBUTE1 to 15 of the invoice.
You also need to populate REFERENCE_LINE_CONTEXT with INTERFACE_LINE_CONTEXT of the invoice. INTERFACE_LINE_CONTEXT and INTERFACE_LINE_ATTRIBUTE1 to 15 are stored in RA_CUSTOMER_TRX_LINES_ALL.
To create an on-account credit (i.e. not linked to an invoice) do not populate REFERENCE_LINE_ID, REFERENCE_LINE_ATTRIBUTES or REFERENCE_LINE_CONTEXT.
1) Populate REFERENCE_LINE_ID on RA_INTERFACE_LINES_ALL with the CUSTOMER_TRX_LINE_ID of the invoice. or
2) Populate REFERENCE_LINE_ATTRIBUTE1 to 15 with the INTERFACE_LINE_ATTRIBUTE1 to 15 of the invoice.
You also need to populate REFERENCE_LINE_CONTEXT with INTERFACE_LINE_CONTEXT of the invoice. INTERFACE_LINE_CONTEXT and INTERFACE_LINE_ATTRIBUTE1 to 15 are stored in RA_CUSTOMER_TRX_LINES_ALL.
To create an on-account credit (i.e. not linked to an invoice) do not populate REFERENCE_LINE_ID, REFERENCE_LINE_ATTRIBUTES or REFERENCE_LINE_CONTEXT.
Can we Update An Already Created Invoice Through Autoinvoice Program
The Option/feature Of Updating An Exisitng Invoice In Receivables Through Auto
Invoice Program Is Not Available.
The Autoinvoice Program Is Used To Create New Invoices In Receivables.
Unlike Other Interface Programs, Say Customer Interface Program, Which You Can
Use Either To Create New Customers Or Update Exisitng Customers, The
Autoinvoice Program Cannot Be Used To Update An Existing Invoice Details.
Application we can do ie we can only apply cash receipt, credit memo or adjustment for already created/existing invoice.
You Can Only Create New Invoices Through Autoinvoice Program.
Invoice Program Is Not Available.
The Autoinvoice Program Is Used To Create New Invoices In Receivables.
Unlike Other Interface Programs, Say Customer Interface Program, Which You Can
Use Either To Create New Customers Or Update Exisitng Customers, The
Autoinvoice Program Cannot Be Used To Update An Existing Invoice Details.
Application we can do ie we can only apply cash receipt, credit memo or adjustment for already created/existing invoice.
You Can Only Create New Invoices Through Autoinvoice Program.
Monday, February 16, 2009
(Project Accounting) Steps from Project Creation to AR Flow
Projects To AR:
1.Create a Project using an appropriate Template with Tasks,Keymembers and
Customers who are having a valid Billing Contact.Change the Billing Setup as
COST/COST.
2.Create Agreements and Fundings for that Project.
3.Create Events accordingly. Give any type of Event for a Task. Number of lines of
an Invoice is dependent upon number of Events.
We can create any number of Events for a Task. All these Events will appear as
Lines in Invoice.
4.Define the Percent Complete i.e, Status of the Project and the date on which that
status is reached.
5.Create Approved Cost Budget and Approved Revenue Budget for the Project and
Baseline those Budgets.
6.Change the Project Status as Approved. Complete the Project Flexfield information.
7.Run the PRC: Generate Draft Revenue for a Single Project program to generate Draft
Revenue.Check this in Revenue Review.
8.Run the PRC: Generate Draft Invoices for a Single Project program
to generate Draft Invoice Check it in Invoice Review and Approve and Release that
Invoice.
9. Now, Run PRC: Interface Invoices to Receivables program to interface the Invoice
to Receivables.Now all the Invoices will be in RA_INTERFACE_LINES_ALL
10.Now, Run the Autoinvoice Master Program in Receivables. Batch Source is PROJECTS
INVOICES.
Now, the Invoices are successfully imported.
Or you can do in the below manner also for Foreign currency
Steps done in project creation
1.create project ie copy from existing projrcts go to projects and you can create here , for key memebrs and remaining things you can see the project wich you are copying and create same.
2.now go to Billing----> AGreement and here create funding and save the changes here .
3. now go to the BUDGET and here create budject and try to give amount and save and submit once you have submit then click baseline tab , if amount is not base lines then you have to give the conversion rate amount correctly to make it base line use below query for that
select CONVERSION_RATE*5000 from gl_daily_rates
where 1=1
and FROM_CURRENCY='EUR'
and TO_CURRENCY='USD'
and TRUNC (CONVERSION_DATE) = TO_DATE ('10-10-2008', 'DD-MM-YYYY')
4.Once you have done base line now we must creatre the expenditure items ... go to Expenditures------Pre Approved Batches ---Enter and here you can enter one new batch and create expenditure itemns..save the work and the click SUBMIT button and then Click Release button .
5.now go to Expenditures--->expenditures Inquiry--- Project here open your project and submit the request go to back end see if the concurrent program fails then run
PRC: Generate Draft Revenue for a Single Project for your single project.
6.once completeed then go to Billing--- Revenue Review and check your project and here Release.
7.Now go the expeditures ---- expenditure Inquiry---Project..... and here query for your project and open it and now RUn the Request once Request completed now
Run The request for single project PRC: Generate Draft Invoices for a Single Project
8.Go to Billing-----Inovice Review and check your invoice and expenditure how they appear and now
9. Now, Run PRC: Interface Invoices to Receivables program to
interface the Invoice to Receivables.
Now all the Invoices will be in RA_INTERFACE_LINES_ALL
10.Now, Run the Autoinvoice Master Program in Receivables. Batch Source
is PROJECTS INVOICES.
1.Create a Project using an appropriate Template with Tasks,Keymembers and
Customers who are having a valid Billing Contact.Change the Billing Setup as
COST/COST.
2.Create Agreements and Fundings for that Project.
3.Create Events accordingly. Give any type of Event for a Task. Number of lines of
an Invoice is dependent upon number of Events.
We can create any number of Events for a Task. All these Events will appear as
Lines in Invoice.
4.Define the Percent Complete i.e, Status of the Project and the date on which that
status is reached.
5.Create Approved Cost Budget and Approved Revenue Budget for the Project and
Baseline those Budgets.
6.Change the Project Status as Approved. Complete the Project Flexfield information.
7.Run the PRC: Generate Draft Revenue for a Single Project program to generate Draft
Revenue.Check this in Revenue Review.
8.Run the PRC: Generate Draft Invoices for a Single Project program
to generate Draft Invoice Check it in Invoice Review and Approve and Release that
Invoice.
9. Now, Run PRC: Interface Invoices to Receivables program to interface the Invoice
to Receivables.Now all the Invoices will be in RA_INTERFACE_LINES_ALL
10.Now, Run the Autoinvoice Master Program in Receivables. Batch Source is PROJECTS
INVOICES.
Now, the Invoices are successfully imported.
Or you can do in the below manner also for Foreign currency
Steps done in project creation
1.create project ie copy from existing projrcts go to projects and you can create here , for key memebrs and remaining things you can see the project wich you are copying and create same.
2.now go to Billing----> AGreement and here create funding and save the changes here .
3. now go to the BUDGET and here create budject and try to give amount and save and submit once you have submit then click baseline tab , if amount is not base lines then you have to give the conversion rate amount correctly to make it base line use below query for that
select CONVERSION_RATE*5000 from gl_daily_rates
where 1=1
and FROM_CURRENCY='EUR'
and TO_CURRENCY='USD'
and TRUNC (CONVERSION_DATE) = TO_DATE ('10-10-2008', 'DD-MM-YYYY')
4.Once you have done base line now we must creatre the expenditure items ... go to Expenditures------Pre Approved Batches ---Enter and here you can enter one new batch and create expenditure itemns..save the work and the click SUBMIT button and then Click Release button .
5.now go to Expenditures--->expenditures Inquiry--- Project here open your project and submit the request go to back end see if the concurrent program fails then run
PRC: Generate Draft Revenue for a Single Project for your single project.
6.once completeed then go to Billing--- Revenue Review and check your project and here Release.
7.Now go the expeditures ---- expenditure Inquiry---Project..... and here query for your project and open it and now RUn the Request once Request completed now
Run The request for single project PRC: Generate Draft Invoices for a Single Project
8.Go to Billing-----Inovice Review and check your invoice and expenditure how they appear and now
9. Now, Run PRC: Interface Invoices to Receivables program to
interface the Invoice to Receivables.
Now all the Invoices will be in RA_INTERFACE_LINES_ALL
10.Now, Run the Autoinvoice Master Program in Receivables. Batch Source
is PROJECTS INVOICES.
Subscribe to:
Posts (Atom)