Determining pre-payments against a CUSTPO 1

[MatthewRheinberger]

Hi,

I am creating invoices and need to know if a prepayment has been made against a CUSTPO.

Reason is that I need to alter amount due on 2 payment dates by the pre-payment.

Is there a nice way to look up payments made against a CUSTPO?

my thanks,
Matthew

 

[ettienne]

What is a CUSTPO?
I'm assuming an OE Order, you can lookup OE prepayments in OEPPRE.

 

[MatthewRheinberger]

Thanks,

CUSTPO is a field on our invoice (not sure if it is a custom field) but is accessed via invoice import/export.

Do you have a sample of how to use the OEPPRE search? so that I can figure out logic required for my use?

my thanks,
Matthew

 

[ettienne]

Dim mDBLinkCmpRW As AccpacCOMAPI.AccpacDBLink
Dim OEPPRE As AccpacCOMAPI.AccpacView

'Open dblink
Set mDBLinkCmpRW = OpenDBLink(DBLINK_COMPANY, DBLINK_FLG_READWRITE)
'Open view
mDBLinkCmpRW.OpenView "OE0620", OEPPRE

OEPPRE.Fields("APPLYTO").PutWithoutVerification 2 '2 = order, 4 = invoice
OEPPRE.Fields("DOCNUMBER").PutWithoutVerification "ORD0000000000000000001" 'Order number
OEPPRE.Fields("PPNUMBER").PutWithoutVerification 1 '1=First prepayment, 2=second prepayment, etc
If OEPPRE.Read Then
    MsgBox "Order prepayment exists"
Else
    MsgBox "No order prepayment"
End If

'Cleanup
Set OEPPRE = Nothing
Set mDBLinkCmpRW = Nothing