Discount in Outgoing Payment and Cheque for payment PLD

[Former Member]

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

[Former Member]

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.