Following are the list of FRx Transaction Detail codes that work with Dynamics GP • TSDESC (Transaction Description) ---will pull the Dynamics transaction description field (Don’t use this code if a description should appear in the DESC column) • TJDESC (Journal – or batch header – Description) --- will pull the Dynamics batch name for unposted transactions or the originating source for posted transactions • TAPL (Transaction Apply Date) --- will pull the Dynamics transaction date field • TDOC (Source Document – Doc #) --- will pull the Dynamics source document field • TSDOC (Original Source Doc – ex. Invoice) --- will pull the Dynamics originating document number field • TREF (Reference Code) --- will pull the Dynamics transaction reference field • TTYP (Transaction Type) --- will pull the Great Plains transaction type (standard or reversing) • TSID (Source ID – Module, Journal Code, etc) --- will pull the Great Plains transaction source code field • TBAT (Batch Code) --- will pull the Great Plains general ledger batch number field • TCUR (Currency Code) --- will pull the Great Plains currency ID field • TCURX (Currency Exchange Rate) --- will pull the Great Plains currency exchange rate field Source: Dynamics GP Partner forum Thread, Credit to Cory Severson
Continue reading →