on 09-30-2008 8:40 AM
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
110 | |
12 | |
11 | |
6 | |
5 | |
4 | |
4 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.