Auto Invoicing Setup Steps

1) In OM System Parameters Window, For item Validation Organisation assign Master Inventory(MI) or Actual Inventory (AI).

2) Create Transaction Type for line and order.
3) Define Document Sequence for the transaction type.
4) Assign Document Sequence and Document Category in Document Assignment window
5) For OM Responsibility assign " QP Item Validation Organisation".
6) Assign you item in advance pricing form.
7) Define Carrier Method.
8) Define Release Sequence Rule.
9) Define Pick Slip Grouping Rule.
10) Define Release Rules.
11) Define Document Set for Pick Release.
12) Define Document Set for Ship Confirmation.
13) Define Ship Confirmation Rules.
14) Shipping Parameters.
15) Define Picker Role.
16) Define Shipper Role.
17) Define grants to shipper and picker
18) Open Periods in Inventory, Purchasing and General Ledger Modules.
19) Create Receivables Transaction Type
20) Create Imported Transaction Source
21) Assign Receivable transaction type and sources to Transaction type create in OM.

You have encountered an unexpected error. Please contact the System Administrator for assistance. Unable to Open Supplier OAF Page

Solution: Need to Set MO: Operating Unit at Site Level(Specify your Operating Unit)

Unable to make payment for the Invoice. Due to Invoice Status: 'Selected for Payment'. But no Payment Batches created by selecting this invoice.

Run the below SQL Query. The invoice Status will be changed automatically to "Validated"

update ap.ap_payment_schedules_all 
set checkrun_id =''
where invoice_id ='57553'-- Give your Invoice_ID
and checkrun_id ='34564'--- Give your Checkrun_ID

Now you cancel the invoice or You can make the Payment for the invoice.

AP invoice accounting status not updated to ‘yes’ still it is showing ‘no’ for one invoice

Analysis: We are able to see JE for invoice when we checked view accounting from invoice screen, so the problem with only status

Solution: As it seems data corruption issues, we logged a ‘SR’ with oracle, they have provided data fix. The issue has been resolved.

2 Journals are not getting posted when auto post program run

Analysis: Journals are created after program completion that is at 11.00 pm

Solution: We asked user to wait until next run so that it will get posted

Not able to account payment document when I tried from action window of payment work bench

Analysis: Associated invoice not accounted hence payment not getting accounted

Solution: Account the invoice and then account payment

Invoice not getting validated

Analysis: Quantity Received hold is placed on invoice, customer using 3 way matching, but still receiving transaction not created in oracle for this PO, hence it could not be validated.

Solution: Require to update received qty for this PO. So this invoice will get validated

There are 10 assets under one corporate book in which user want to calculate depreciation for 7 assets

Solution: (disable) depreciation check box at asset workbench for which depreciation should not calculate.

Unable to add bank statement lines manually to imported bank statement

Solution: Enable allow adding lines imported statement in system parameters.

User not able to create invoice for supplier but PO already created for same supplier.

Analysis: While creating supplier user forget to enable payment purpose at address and site level

Solution: Payment purpose at address and site level.