OE Prepayments

I recorded a macro in OE Entry with a prepayment.  After I ran the macro I noticed it did not create an AR receipt batch.  To get around this I just wrote my own code to create the AR Receipt batch prepayment entry.

When I originally recorded the macro it made the following entries to the OE Header view(See code bleow).  Do I still need to populate these fields?  Should OE have anything to do with the receipt entry?

Code:

OEORD1headerFields("REBATCHNUM").Value =     OEORD1headerFields("BANKRECTYP").Value =  
OEORD1headerFields("CHECKNUM").Value =    
OEORD1headerFields("BANKCODE").Value =
OEORD1headerFields("BANKPAYMNT").Value =
OEORD1headerFields("PAYMTYPE").Value =
OEORD1headerFields("CCNUMBER").Value = 

Thanks,
Jeff

  • Yes, you should populate them.

  • You need to create the receipt side of things, it is not recorded. I cannot remember the details but it was simple to do.

  • In case anyone else is looking to insert OE prepayments automaticly here's what I did to get it to work.

    1. Create an AR Receipt batch.  The batch number will be used in the prepayment.

    2. Populate the following fields in the OE Header view (OE0520)


    OEORD1headerFields("REBATCHNUM").Value =   OEORD1headerFields("BANKRECTYP").Value =  
    OEORD1headerFields("CHECKNUM").Value =  
    OEORD1headerFields("BANKCODE").Value =  
    OEORD1headerFields("BANKPAYMNT").Value =  
    OEORD1headerFields("PAYMTYPE").Value =  
    OEORD1headerFields("CCNUMBER").Value =
    OEORD1header.Process

    3. Populate the following fields in the Order Prepayment view (OE0530).  You may be able to get away with not populating all of these fields.  I just ran RVspy and these are the fields that it handles.


     OEORD1PrePay.RecordGenerate False    
    OEORD1PrePayFields("ORDUNIQ").Value =    
    OEORD1PrePayFields("CUSTOMER").Value =     
    OEORD1PrePayFields("CUSTDESC").Value =     
    OEORD1PrePayFields("CUSTCURN").Value =     
    OEORD1PrePayFields("CRATE").Value =     
    OEORD1PrePayFields("CRATETYPE").Value =     
    OEORD1PrePayFields("CRATEDATE").Value =     
    OEORD1PrePayFields("DOCTOTAL").Value =    
    OEORD1PrePayFields("DISCAVAIL").Value =     
    OEORD1PrePayFields("AMOUNTDUE").Value =     
    OEORD1PrePayFields("BATCHNUM").Value =     
    OEORD1PrePayFields("BANKCODE").Value =     
    OEORD1PrePayFields("RECPTYPE").Value =    
    OEORD1PrePayFields("CHECKNUM").Value =     
    OEORD1PrePayFields("RECPDATE").Value =     
    OEORD1PrePayFields("RECPAMOUNT").Value =     
    OEORD1PrePayFields("BANKCURN").Value =     
    OEORD1PrePayFields("BANKRATE").Value =     
    OEORD1PrePayFields("RATETYPE").Value =     
    OEORD1PrePayFields("RATEDATE").Value =     
    OEORD1PrePayFields("PAYMTYPE").Value =
     OEORD1PrePay.Insert
     OEORD1header.Insert