Skip to Content
avatar image
Former Member

Discount in Outgoing Payment and Cheque for payment PLD

Hi,

Using SBO2007A PL30

I have tried to find whether there are system variables for amount outstanding and discount which show amounts in foreign and local currency.

I can't find any references in the .xls document how to use system variables in SBO 2007., and strangely there is no reference in that document to the system variables which already exist in the in- built layouts

Cheque for Payment

- total amount paid ( variable 97 )

Outgoing Payment

- posting date ( variable 202)

- Doc Ref ( var 200)

- Your Ref ( var 201)

- amount paid ( var 63)

This leads me to suspect that system variables for outstanding amount and discount may well exist.

In the meantime I have had to do this using references to database fields Outgoing Payments - Invoices: Discount Amount and Outgoing Payments - Invoices : Amount before Discount with formulae to determin whether the document is in local or foreign currency.

A further downside to this is that a credit memo is displayed from the latter database field without a negative sign

Does anyone have any suggestions here?

Thanks

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Oct 01, 2008 at 04:13 PM

    Managed to figure out most of it but for the record I have discovered an additional 4 system variables in use for paid document details at line level. Here is the complete list so far:

    outgoing Payment

    PostingDate 202

    our Ref 200

    your Ref 201

    o/S Amt ? ( used formula based on db fields instead)

    Discount ? ( used formula based on db fields instead)

    Payment 63

    Cheque for Payment

    posting Date 104

    our ref 101

    your ref 100

    O/s amt 96

    Discount ? ( use formula :difference between 96 and 97)

    Payment 97

    If anyone can supply the missing variables if they exist, I'd be grateful.

    Add comment
    10|10000 characters needed characters exceeded