11/20/2009

FRx Transaction Detail codes for Dynamics GP

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