1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Query Help on the table RA_CUSTOMER_TRX_ALL

Discussion in 'General' started by mist, Nov 25, 2013.

  1. mist

    mist Active Member

    Messages:
    59
    Likes Received:
    2
    Trophy Points:
    160
    Hi all,

    The values are stuck into the table RA_INTERFACE_SALESCREDITS_ALL and how can i check it the above records into the table RA_CUSTOMER_TRX_ALL. Can any one please send the query please


    Thank you
    Mist
     
  2. sambuduk

    sambuduk Forum Advisor

    Messages:
    242
    Likes Received:
    73
    Trophy Points:
    455
    Location:
    Hyderabad , Telangana
    Hi Mist ,

    You can check in the ra_customer_trx_lines_all . Mapping will be INTERFACE_LINE_CONTEXT , INTERFACE_LINE_ATTRIBUTE1.


    Regards
    Sambasiva Reddy.K
     
  3. mist

    mist Active Member

    Messages:
    59
    Likes Received:
    2
    Trophy Points:
    160
    Hi Sambasiva Reddy,

    Thank you for reply and i want to delete records from the table RA_INTERFACE_SALESCREDITS_ALL and ra_interface_lines_all, how can i delete records from the above 2 tables can you please help me how to write a query

    Thank you
    Mist
     
  4. sambuduk

    sambuduk Forum Advisor

    Messages:
    242
    Likes Received:
    73
    Trophy Points:
    455
    Location:
    Hyderabad , Telangana
    Hi

    how many records got strucked??

    Regds,
    Sambasiva Reddy.K
     
  5. mist

    mist Active Member

    Messages:
    59
    Likes Received:
    2
    Trophy Points:
    160
    Hi,

    117 records got strucked in ra_interface_lines_all

    Regards,
    Mist
     
  6. mist

    mist Active Member

    Messages:
    59
    Likes Received:
    2
    Trophy Points:
    160
    Hi,

    Yes, but some records also in salescredits table , can u please explain when the data loads into that table and actually my issue is that
    1)Invalid Warehouse ID
    2) Unable to derive a gl date for your transaction.Please ensure that your transaction

    Regards,
    Mist
     
  7. sambuduk

    sambuduk Forum Advisor

    Messages:
    242
    Likes Received:
    73
    Trophy Points:
    455
    Location:
    Hyderabad , Telangana
  8. mist

    mist Active Member

    Messages:
    59
    Likes Received:
    2
    Trophy Points:
    160
    Hi

    I checked GL_DATE, SHIP_DATE_ACTUAL and SALES_ORDER_DATE in the table RA_INTERFACE_LINES_ALL is everything was ok,My records are strucked in salescredits tables and also lines table, is there any other process please please help me

    Thank you
     
  9. sambuduk

    sambuduk Forum Advisor

    Messages:
    242
    Likes Received:
    73
    Trophy Points:
    455
    Location:
    Hyderabad , Telangana
    Check whether GL and AR periods are open or not for that Gl_DATE..
     
  10. mist

    mist Active Member

    Messages:
    59
    Likes Received:
    2
    Trophy Points:
    160
    I checked all the GL and AR periods are opened