Transaction types in GL entries

Question Status

Suggested Answer
Revathi asked a question on 21 Sep 2017 2:49 AM

Hi,

Need your help on the below;

I am new to Navision. we are extracting GL entries from Navision via SQL, and we need to include the a column transaction type (i.e it should be like AP invoice, AP Payments, AR Receipts, AR Invoice, others). Kindly let me know the join criteria to display the transaction types.

Reply
Suggested Answer
Amol Salvi responded on 21 Sep 2017 3:53 AM

On GL Entry we already have document type ,Source Type and Source Code fields. Based on these fields you can determine the transaction type.

Reply
Suggested Answer
Amol Salvi responded on 21 Sep 2017 3:53 AM

On GL Entry we already have document type ,Source Type and Source Code fields. Based on these fields you can determine the transaction type.

Reply