3 Replies Latest reply on Jul 22, 2008 6:30 PM by 628428

    charge account information

    379746
      Hi,
      I need a report that shows the following information
      P.O. Number
      Vendor
      gl_account number
      Date Entered
      Date Received (of a receipt)
      Description
      PO Total
      I can get everything except the gl_account number . How do I link the po tables to get the account number that a receipt/po is charged to.
      Thanks
      A/A
        • 1. Re: charge account information
          628428
          If the destination is expense and the accrue on receipt is checked for these purchases, use rcv_receiving_sub_ledger.

          If the destination is expense and if do not accrue on receipt but month end and if you pay before month end accruals, you can use ap_invoice_distributions_all and it is not paid, use the same table as the above.

          If the destination is inventory,use mtl_transaction_accounts.

          Thanks
          Nagamohan
          • 2. Re: charge account information
            379746
            Thanks Nagamohan,
            I processed a receipt against a PO. The record showed up in rcv_transactions table but not in any of these---rcv_receiving_sub_ledger,ap_invoice_distributions_all or mtl_transaction_accounts.
            Thanks
            A/A
            • 3. Re: charge account information
              628428
              Asgar
              What is this transaction? Receipt or deliver? If it is not deliver can you deliver? What is your destination?
              Thanks
              Nagamohan