Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Account SettingDescriptionShortcodesExampleExample Shortcode
Intacct A/P Transaction Memo Field FormatWhen AP transaction is sent from Projector, include this information in the memo field.Projector AP Txn#0000001234,2014-02,PVER00012 ;revcorp-tcs;Exp Doc #ER00042;Vendor Ref #64321Projector AP Txn#{2:D10},{0},{6}   ;{3};Exp Doc #{8};Vendor Ref #{7}
Intacct A/R Transaction Memo Field Format (client level invoices)When an invoice at the client level is sent as an AR transaction from Projector, include this information in the memo field.
  • {0} - Accounting Period - Recommend you use period strings like 2014-02 for Feb, 2014 as it is fixed width and easily sortable
  • {1} - "AR" - Hardcoded to this string
  • {2} - AR Transaction # - recommended you string format this to a fixed number of digits.
  • {3} - Your installation's account name
  • {4} - The display name of the user who sent the transaction
  • {5} - Date and time the transaction was sent from Projector
  • {6} - Invoice #
  • {7} - Invoice Name
  • {8} - null

In addition client level invoices have access to these shortcodes

  • {9} - Client #
  • {10} - Client Name
Projector AR Txn#0000012345,2014-10,INV00009    ;revcorp-tcs;Acme Manufacturing (C0100)Projector AR Txn#{2:D10},{0},{6}    ;{3};{10} ({9})
Intacct A/R Transaction Memo Field Format (PO level invoices)When an invoice at the PO level is sent as an AR transaction  from Projector, include this information in the memo field.

Same as Client section except

  • {13} - Purchase order #
Projector AR Txn#0000012345,2014-10,INV00009    ;revcorp-tcs;PO123456789Projector AR Txn#{2:D10},{0},{6}    ;{3};{13}
Intacct A/R Transaction Memo Field Format (engagement level invoices)When an invoice at the Engagement level is sent as an AR transaction  from Projector, include this information in the memo field.

Same as Client section except

  • {11} - Engagement Code
  • {12} - Engagement Name
Projector AR Txn#0000012345,2014-10,INV00009    ;revcorp-tcs;EA Air Website (P001020)Projector AR Txn#{2:D10},{0},{6}    ;{3};{12} ({11})
Intacct A/R Transaction Memo Field Format (project level invoices)When an invoice at the Project level is sent as an AR transaction  from Projector, include this information in the memo field.

Same as Client section except

  • {11} - Engagement Code
  • {12} - Engagement Name
  • {14} - Project Code
  • {15} - Project Name
Projector AR Txn#0000012345,2014-10,INV00009    ;revcorp-tcs;EA Air Website Support (P001020-002)Projector AR Txn#{2:D10},{0},{6}    ;{3};{15} ({14})
Intacct G/L Transaction Memo Field Format

Each individual GL transaction line includes a memo field. This setting determines what goes into that memo field.

Fields seven through fifteen are only available if you have the additional settings Transmit P&L detail in journal entries and Transmit reconciliation detail in journal entries turned on. Those settings are typically off because it creates an enormous amount of data that needs to flow into Intacct.

  • {0} - Accounting Period - Recommend you use period strings like 2014-02 for Feb, 2014 as it is fixed width and easily sortable
  • {1} - "GL" - Hardcoded to this string
  • {2} - GL Transaction # - recommended you string format this to a fixed number of digits.
  • {3} - Your installation's account name
  • {4} - The display name of the user who sent the transaction
  • {5} - Date and time the transaction was sent from Projector
  • {6} - GL Batch #
  • {7} - The description on a transmitted cost card or the description on a reconciliation item
  • {8} - The expense report number on a transmitted cost card (not populated for reconciliation items)
  • {9} - Client Number
  • {10} - Client Name
  • {11} - Engagement Code
  • {12} - Engagement Name
  • {13} - Resource Display Name
  • {14} - Project Code
  • {15} - Project Name
  • {16} - Payment Voucher # (only populated when you have reconciliation items)

Cost Card

Projector GL Txn#0000012345,2014-12,BATCH00124  ;revcorp-tcs;P001001-001;dinner with John Hentz to discuss plans;ER00005;;Debby Hill

Reconciliation Item

Projector GL Txn#0000012345,2014-12,BATCH00124  ;revcorp-tcs;P001001-001;dinner with John Hentz to discuss plans;;PV001234;Debby Hill

Projector GL Txn#{2:D10},{0},{6}  ;{3};{14};{7};{8};{16};{13}
Intacct G/L Transaction Description Field Format

GL description fields are associated with a parent GL transaction. That parent may contain many GL line item transactions. This setting determines the description for the parent.

Fields seven through fifteen are only available if you have the additional settings Transmit P&L detail in journal entries and Transmit reconciliation detail in journal entries turned on. Those settings are typically off because it creates an enormous amount of data that needs to flow into Intacct.

  • {0} - Accounting Period - Recommend you use period strings like 2014-02 for Feb, 2014 as it is fixed width and easily sortable
  • {1} - "GL" - Hardcoded to this string
  • {2} - GL Transaction # - recommended you string format this to a fixed number of digits.
  • {3} - Your installation's account name
  • {4} - The display name of the user who sent the transaction
  • {5} - Date and time the transaction was sent from Projector
  • {6} - GL Batch #
  • {7} - The description on a transmitted cost card or the description on a reconciliation item
  • {8} - The expense report number on a transmitted cost card (not populated for reconciliation items)
  • {9} - Client Number
  • {10} - Client Name
  • {11} - Engagement Code
  • {12} - Engagement Name
  • {13} - Resource Display Name
  • {14} - Project Code
  • {15} - Project Name
  • {16} - Payment Voucher # (only populated when you have reconciliation items)
 Projector {1} Txn#{2:D10},{0},{6}  ;{3};;;;;
Intacct Journal ID for G/L TransactionsWhen browsing your GJE entries in Intacct, you can sort on transaction type, this value is what goes there. Useful for finding all GL transactions from Projector.There are no shortcodesPPSAGJEPPSAGJE
Intacct Payment Voucher Document Number FormatEach AP transaction must include a "Bill Number." This is where you define that bill number format.
  • {0} - Payment Voucher #
  • {1} - Transaction #
  • {2} - Vendor Invoice #
AMEX01 (PVVI00302){2} ({1})

 

 

Web Services Accounting Interface

These settings are for users of our Azure website and our SOAP-based web services for retrieving accounting data. 


Account SettingDescriptionShortcodesExampleExample Shortcode
Web Services A/P Transaction Memo Field FormatWhen AP transaction is sent from Projector, include this information in the memo field.Projector AP Txn#0000001234,2014-02,PVER00012 ;revcorp-tcs;Exp Doc #ER00042;Vendor Ref #64321Projector AP Txn#{2:D10},{0},{6}   ;{3};Exp Doc #{8};Vendor Ref #{7}
Web Services A/R Transaction Memo Field Format (client level invoices)When an invoice at the client level is sent as an AR transaction from Projector, include this information in the memo field.
  • {0} - Accounting Period - Recommend you use period strings like 2014-02 for Feb, 2014 as it is fixed width and easily sortable
  • {1} - "AR" - Hardcoded to this string
  • {2} - AR Transaction # - recommended you string format this to a fixed number of digits.
  • {3} - Your installation's account name
  • {4} - The display name of the user who sent the transaction
  • {5} - Date and time the transaction was sent from Projector
  • {6} - Invoice #
  • {7} - Invoice Name
  • {8} - null

In addition client level invoices have access to these shortcodes

  • {9} - Client #
  • {10} - Client Name
Projector AR Txn#0000012345,2014-10,INV00009    ;revcorp-tcs;Acme Manufacturing (C0100)Projector AR Txn#{2:D10},{0},{6}    ;{3};{10} ({9})
Web Services A/R Transaction Memo Field Format (PO level invoices)When an invoice at the PO level is sent as an AR transaction  from Projector, include this information in the memo field.

Same as Client section except

  • {13} - Purchase order #
Projector AR Txn#0000012345,2014-10,INV00009    ;revcorp-tcs;PO123456789Projector AR Txn#{2:D10},{0},{6}    ;{3};{13}
Web Services A/R Transaction Memo Field Format (engagement level invoices)When an invoice at the Engagement level is sent as an AR transaction  from Projector, include this information in the memo field.

Same as Client section except

  • {11} - Engagement Code
  • {12} - Engagement Name
Projector AR Txn#0000012345,2014-10,INV00009    ;revcorp-tcs;EA Air Website (P001020)Projector AR Txn#{2:D10},{0},{6}    ;{3};{12} ({11})
Web ServicesA/R Transaction Memo Field Format (project level invoices)When an invoice at the Project level is sent as an AR transaction  from Projector, include this information in the memo field.

Same as Client section except

  • {11} - Engagement Code
  • {12} - Engagement Name
  • {14} - Project Code
  • {15} - Project Name
Projector AR Txn#0000012345,2014-10,INV00009    ;revcorp-tcs;EA Air Website Support (P001020-002)Projector AR Txn#{2:D10},{0},{6}    ;{3};{15} ({14})
Web Services Journal ID for G/L TransactionsWhen browsing your GJE entries in Intacct, you can sort on transaction type, this value is what goes there. Useful for finding all GL transactions from Projector.There are no shortcodesPPSAGJEPPSAGJE
Web Services Payment Voucher Document Number FormatEach AP transaction must include a "Bill Number." This is where you define that bill number format.
  • {0} - Payment Voucher #
  • {1} - Transaction #
  • {2} - Vendor Invoice #
AMEX01 (PVVI00302){2} ({1})