Item Transaction Types (STRAN.ST_TRTYPE)

Asked by: matbroughty 997 views Questions Back to Questions »

Good Morning,

I was wondering if anyone could shed any light on the various transaction types that are possible on sales ledger items (or for that matter purchase ledger items).  These are stored in the STRAN.ST_TRTYPE (sales ledger) or PTRAN.PT_TRTYPE (purchase ledger).

Some seem quite straight forward, for instance:

  • ‘A’ – Adjustment, credit or debit.
  • ‘C’ – Credit Note.
  • ‘F’ – Refund (another kind of credit adjustment).
  • ‘I’ – Invoice.
  • ‘R’ – Payment\Cash sales ledger.
  • ‘P’ – Payment\Cash purchase ledger.
  • ‘D’ – Discount – (another kind of credit adjustment).

But then I am slightly less clear about:

  • ‘B’ – Visible as “B/F” Brought Forward – what does this mean?  Opening balance?

I have searched in vain for a list or transaction type descriptions, so if anyone can offer any help it would be appreciated.  Am I roughly correct?

 

Cheers

Mat

3 Answers



  1. PegasusExpert on Jul 19, 2011 reply

    Hi Mat,

    >> ‘B’ – Visible as “B/F” Brought Forward

    This is a special transaction type that only appears on accounts that are managed on a ‘Balance Forward’ basis, i.e. not ‘Open Item’.

    With B/F accounts all transactions are summarised during the Period End processing and only grouped into just a single line.

    I can’t se any justification for using B/F these days, however, many have done so by accident, not realising what they did. B/F accounting is possible in all of Sales, Purchase and also the Nominal Ledger.

    B/F accounts might be useful in a ledger where the transaction volume is extreme high and normally of low value. It was also common decades ago when disk (floppy) size was very limited and a system needed to limit the size of ever expanding data.

    Hope this help …

    Diarmaid

    0 Votes Thumb up 0 Votes Thumb down 0 Votes



  2. matbroughty on Jul 19, 2011 reply

    Excellent, thanks Diarmaid.

    I work in the factoring industry, so your explanation makes sense.

    ‘Balance Forward’ basis sounds a bit like Bulk Invoice Discounting business where only the totals are finaced, not the individual items.

    Cheers

    Mat

    0 Votes Thumb up 0 Votes Thumb down 0 Votes



  3. SR on Sep 07, 2011 reply

    I may be way off beam here but if you accidentally de-select the box marked “open item” on a customer account then the next month all you will get is the brought forward balance when you look at the account. (In the customers record in the financials section, select Action then Options and the box is there).

    We used to experience this problem when somebody changed the nominated bank account for a customer – now I just double check the box is selected before saving any changes.

    0 Votes Thumb up 0 Votes Thumb down 0 Votes


Answer Question

Notify me of followup comments via e-mail. You can also subscribe without commenting.