Skip to Content
avatar image
Former Member

Amendments to Outgoing Payments (System)

Hi All,

I need to amend the outgoing payment (system) report such that it shows the journal enteries that this payment is creating.

As an example.

I am making a payment to account :123120 - VAT payable by cheque.

I would like the outgoing payment report to include (along with the information already present) the following

DR Account Name (Text Field) VAT Payable £xxxxxxx

CR Account Name (Text Field) Main Bank Account (£xxxxxx)

can anyone tell me which database fields I need, and how to link them on the report?

Thanks

Dan

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Oct 16, 2008 at 05:19 PM

    Dan,

    Might not be possible. But you may try - the data is in the JDT1 (Journal Entry lines) table

    Suda

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 16, 2008 at 06:00 PM

    Hi Dan,

    Try to change system default PLD is too risky. The result could be negative no matter how you try. My suggestion would be try it by SQL query. If you can create your query for this purpose, the time spend might be less.

    Thanks,

    Gordon

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 17, 2008 at 05:11 AM

    hi Dan Mitchell,

    Write a SQL Query & developing an add on using SDK will suit

    our requirement.

    Jeyakanthan

    Add comment
    10|10000 characters needed characters exceeded