× Discuss on Template programming, jBASE programming, Enquiries, No-File enquiry, Enquiry routines, Version, Version routines, Menus, Abbriviations, Creating local reference fields, Fast path enquiries, Creating charts and graphs, Generating Reports, Deal slips, Straight through processing, Multi Company and Multi Book setup, Tabbed screens, Composite Screens, T24 API, etc...

How to split commission and vat from FT transaction

  • ridhame
  • ridhame's Avatar Topic Author
  • Offline
  • Senior Member
  • Senior Member
More
6 years 9 months ago #21932 by ridhame
HI,

How to split the commission and the vat of the amount of the transaction in FT transaction, to have an account statement with details.

Debit Amount
Commission
Vat

Regards.

Please Log in or Create an account to join the conversation.

  • silvergem
  • silvergem's Avatar
  • Offline
  • Elite Member
  • Elite Member
  • TAFC|R12/R13, TAFJ|R20
More
6 years 9 months ago - 6 years 9 months ago #21940 by silvergem
For Enquiry viewing on on Account statement, you can get the value from STMT.ENTRY on Enquiry or you can use below

Narratives on STMT.ENT.BOOK, STMT.ENT.TODAY enquiries are either of the content from NARRATIVE field in the STMT.ENTRY file or
based on the STMT.NARR.FORMAT setup which is attached to each statement through TRANSACTION.CODE.
  
If STMT.NARR.FORMAT setup is not attached with TRANSACTION.CODE then STMT.ENT.BOOK enquiry shows the content from NARRATIVE field of STMT.ENTRY record.
Incase STMT.NARR.FORMAT setup attached with TRANSACTION.CODE then Enquiry Narratives will be shown based on this setup.
  
"Narrative_STMT.ENT.BOOK.doc" which explains how this STMT.NARR.FORMAT setup works and also how the content of NARRATIVE field in STMT.ENTRY is displayed in the enquiries like STMT.ENT.BOOK etc.


TCSP Ref
Last edit: 6 years 9 months ago by silvergem.
The following user(s) said Thank You: ridhame

Please Log in or Create an account to join the conversation.

More
6 years 9 months ago #21946 by MarkTaylor
You might need to check field CHG.COMM.SEPARATE in FT.GROUP.CONDITION

Please Log in or Create an account to join the conversation.

  • ridhame
  • ridhame's Avatar Topic Author
  • Offline
  • Senior Member
  • Senior Member
More
6 years 9 months ago #21962 by ridhame
THANK YOU Mr. Mark Taylor,

IS IT POSSIBLE TO GENERALIZE THIS RULE FOR ALL FT TRANSACTIONS FROM A TABLE FOR GENERAL SETTING.

REGARDS

Please Log in or Create an account to join the conversation.

Time to create page: 0.031 seconds