Supported Dynamics GP Sales Documents Fields

Sales Documents Fields for Bulk Update 

TitaniumGP allows you to easily bulk update open sales documents in Microsoft Dynamics GP. The list below shows all supported fields in the Sales Transaction Entry window. Roll Down updates the field on all detail lines in addition to the header information.

Field NameField CodeRoll Down
Shipping MethodSHIPMTHDCheck
Document DateDOCDATE
Freight AmountFREIGHT
Misc. AmountMISCAMNT
Trade Discount AmountTRDISAMT
Trade Discount PercentageTRADEPCT
Customer PO NumberCSTPONBR
Ship to NameShipToNameCheck
Address 1ADDRESS1Check
Address 2ADDRESS2Check
Address 3ADDRESS3Check
Contact PersonCNTCPRSNCheck
Fax NumberFAXNUMBRCheck
CityCITYCheck
StateSTATECheck
Zip CodeZIPCODECheck
CountryCOUNTRYCheck
Phone 1PHONE1Check
Phone 2PHONE2Check
Phone 3PHONE3Check
Sales TerritorySALSTERRCheck
Sales PersonSLPRSNIDCheck
Batch IDBACHNUMB
Primary Bill To Address IDPRBTADCD
Primary Ship to Addres IDPRSTADCDCheck
Payment TermsPYMTRMID
Due DateDUEDATE
Discount DateDISCDATE
Create commissionsCREATECOMM
Create DistributionCREATEDIST
Create taxesCREATETAXES
Comment IDCOMMNTID
Quote Expiration DateQUOEXPDA
Quote DateQUOTEDAT
Invoice DateNVODATE
Backorder DateBACKDATE
Return DateRETUDATE
Tracking NumberTracking Number
USRDAT01USRDAT01
USRDAT02USRDAT02
USRTAB01USRTAB01
USRTAB09USRTAB09
USRTAB03USRTAB03
USERDEF1USERDEF1
USERDEF2USERDEF2
USRDEF03USRDEF03
USRDEF04USRDEF04
USRDEF05USRDEF05