Versions Compared

Key

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

...

This form is reached from the Administration Tab | Setup | Account Settings and clicking Edit.  

Image RemovedImage Added



Permissions and Settings

...

These are settings that are not grouped into a category. They affect different areas of your installation. See the table below for more information on each one.

Image RemovedImage Added

Account SettingDescriptionShortcode MappingsExampleExample Shortcode
Display Name Format

When creating new resources and new users, this format is used to auto-populate their default display name. Afterwards you can change the display name to be anything you want. Changes here will not affect existing users and resources in the system, only new ones.

After making an edit here you will need to logout and then log in.

  • {0} - First Name
  • {1} - Middle Name
  • {2} - Last Name

Tom Sherman

{0} {2}

Named Role Format on Resource Scheduling TabWhen on the resource scheduling tab, how do you want to display roles that are assigned to someone?
  • {0} - Resource Name
  • {1} - Role Name
  • {2} - Title Name
Tom Sherman (Engineer)


{1} ({0}) - {2}

Unnamed Role Format on Resource Scheduling TabWhen on the resource scheduling tab, how do you want to display roles that are unassigned?
  • {0} - Role Name
  • {1} - Title Name
Senior Consultant (Engineer){0} ({1})
Force equivalent FX rates when costs are incurred and invoiced in the same currency

There is a certain situation called a "double hop" where the amount incurred on an expense will not match the amount invoiced. Or in layman's terms, the receipt says $10, but the client is billed $10.05 due to FX conversions. In most contracts the client is expected to absorb the cost of these FX conversions between when an expense is incurred and an expense is invoiced. By ticking this setting you force the expensed amount to equal the invoiced amount and your company will absorb the cost of FX conversions. Please see the FX Rates, Expenses, Invoicing, and Reports article for more information.

n/a

Tentative Role StringYou can enter a special character here. When that character is detected in a role name, it will be treated as tentative. This setting is very rarely used.n/a

Allow Detailed Task ManagementDetailed Task Management is a special feature of Projector that allows you to create sub task-type tasks on a project. This allows for advanced project planning features like Gantt charts, percent complete tracking, and budgeting. Most organizations will leave this ticked.n/a

Allow Resources to Update Hours to Go

When a project has Detailed Task Management enabled, resources are typically allowed to provide feedback through time entry on their task progress. This automatically updates your DTM plan based on resource feedback. For example, a task may be expected to take 10 hours. However, the resource reports through time entry that it will take them 12 hours.

With this setting off the resource cannot provide feedback on their progress through time entry.

n/a

Allow Resources to Use Web Calendar

A resource can subscribe to their Projector Calendar so that they can view it in applications like Outlook, iCal, or Google Calendar.

With this setting off the resource will not have access to their calendar through other applications.

n/a

Enable Resource Cost Center Mapping OverridesWhen ticked you can reroute accounting data for a resource to a different cost center. You choose where the revenue goes on a per-resource basis from the Resource Info Tab. Most organizaitons will not use this feature.n/a

Open Projects in PM Mode by DefaultNormally Projector opens projects in the most permissive mode possible. However, in some cases you may want your users to open projects in a less permissive mode. In this case, PM Mode. The more permissive mode you are bypassing is called Scheduler Mode. You can learn more about both in the Project Resource Scheduling Tab documentation.


Allow Authentication via Report Authentication TokensWhen you run Projector reports, you have the option of accessing them via the web. Normally this access requires that you authenticate using your Projector username/password. When enabled, this option allows you to instead authenticate using a special token. The token can safely be shared without compromising your personal passwords. See Report Web Services for more information.n/a

Allow Self-Approval of Expenses via Override/Set StatusTypically for audit purposes the ability to approve expenses for repayment to yourself is blocked. With this flag enabled, users with the cost center permission Administer Expense Document Approval and Payment can use the Set To dropdown box to approve-to-pay their own expenses.


Auto-confirm A/R transactions that are entirely zero amountIf you issue an invoice with no net balance, then don't bother sending it over to your accounting system. This might happen if you have a pre-payment balance which entirely consumes the invoice amount. Or, you may have outstanding zero dollar time cards or cost cards and want to sweep them onto an invoice to clear them out of the system.


Allow Specification of Force Dates Setting

This should almost always be off. If you turn it on, then a new option is presented in the QuickBooks and Dynamics GP accounting interfaces called Force the date of each transaction to fall within its accounting period. That option allows you to force transactions out of their natural Projector accounting period and to instead use date of synchronization as the accounting period. If you do this, Projector and your accounting system could be out of sync.

If you believe you have a legitimate reason for enabling this option, please contact the Projector Support desk to confirm.




Allow Fixed Price for Cost Contract Terms

It's often best to model Fixed Price cost contracts as Not to Exceed or to simply combine cost into your time contract. The reasons behind this logic are covered in How to clear deferred revenue on fixed price cost contracts.




Allow Requested Resources to Report Time/Expense on Projects Requiring AssignmentWhen time entry is limited through the flag Resources assigned to a role on the Project Info Tab, this checkbox governs whether the resource must be booked simply requested.


Prioritize revenue earn by date for unscheduled revenue

When enabled, any unscheduled system revenue for a CLI falls on the "Revenue will be earned by date". When not enabled unscheduled revenue falls on the Actuals Cutoff Date of the report or dashboard.

For clients who use Projector for resource scheduling, this setting should most likely be turned off. The default is for this setting to be turned off.

For clients who are not using Projector for resource scheduling, this setting should most likely be turned on, and the revenue earned by date should reflect the expected end date of the of the underlying project(s).

Field Validation Enabled

Invoice Name

These settings affect the default name of invoices in two places.

  • Invoices that are saved as PDF files or emailed to clients
  • The default value of the Invoice Name field as seen on the invoice editor
  • The default subject line for emailed invoices

Image Removed

An important concept for all these settings is Invoicing Levels. An invoice level determines how time, expense, and milestones are grouped onto an invoice. For example, if you invoice by PO#, then all projects with same PO number will have their billable items grouped onto a single invoice. There are four invoicing levels,

  • Client
  • PO
  • Engagement
  • Project

You choose the level you want from the client editor, but this can be overridden on the engagement editor.

Shortcodes that relate to dates come from three locations.

Account SettingDescriptionShortcode MappingsExampleExample Shortcode
Invoice PDF File Name (Client Invoices)Default name for Client invoices that are saved as PDF or emailed as attachments.
  • {0} - Invoice Number
  • {1} - Client Name
  • {2} - Client Number
  • {5} - Invoice Date
Invoice for Acme CorporationInvoice for {1}
Invoice PDF File Name (PO Number Invoices)Default name for PO invoices that are saved as PDF or emailed as attachments.
  • {0} - Invoice Number
  • {1} - Client Name
  • {2} - Client Number
  • {5} - Invoice Date
  • {6} - PO Number
Invoice INV00031 for PO JDF00482291Invoice {0} for PO {6}
Invoice PDF File Name (Engagement Invoices)Default name for Engagement




Prevent Unbounded Deletion of FRO Time and Cost CardsWhen enabled, both a start and end date must be specified when deleting FRO time or cost cards with data loaders that invoke OpsCloseTimeCardBatch or OpsCloseCostCardBatch web services.


Default Location for New Resource

When creating new resources, the new resource's location will default to either Blank or the Location of Creator as defined by the account setting for Default Location for New Resource.

The default setting is to initialize the new resource's location to the location of the user creating the resource. This works well when the new resource and the administrative user typically creating resources share a common location. If your administrative users are not sharing a location, setting the default to blank ensures that the creator must explicitly select a value rather than going with the default and potentially locating the new resource in the wrong location. Location impacts a resource's normal working schedule, holidays, and mileage rates.




Generic Time Off Reason Name

The Generic Time Off Reason will replace actual time off reasons for time off requests and time off time cards when the current user does not have permission to view the time off reason for the resource associated with the request or the card. The cost center-based permission View Time Off Reasons for All Resources determines whether a given user will see actual time off reasons or the generic time off reason for each resource.

The default value is "Time Off", but any text string can be used.


Time Off Reason Obfuscated

Invoice Name

These settings affect the default name of invoices in two places.

  • Invoices that are saved as PDF files or emailed to clients
  • The default value of the Invoice Name field as seen on the invoice editor
  • The default subject line for emailed invoices

Image Added

An important concept for all these settings is Invoicing Levels. An invoice level determines how time, expense, and milestones are grouped onto an invoice. For example, if you invoice by PO#, then all projects with same PO number will have their billable items grouped onto a single invoice. There are four invoicing levels,

  • Client
  • PO
  • Engagement
  • Project

You choose the level you want from the client editor, but this can be overridden on the engagement editor.

Shortcodes that relate to dates come from three locations.


Account SettingDescriptionShortcode MappingsExampleExample Shortcode
Invoice PDF File Name (Client Invoices)Default name for Client invoices that are saved as PDF or emailed as attachments.
  • {0} - Invoice Number
  • {1} - Client Name
  • {2} - Client Number
  • {35} - Engagement Name{4} - Engagement Invoice Date
Invoice for Acme CorporationInvoice for {1}
Invoice PDF File Name (PO Number Invoices)Default name for PO invoices that are saved as PDF or emailed as attachments.
  • {0} - Invoice Number
  • {1} - Client Name
  • {2} - Client Number
  • {5} - Invoice   Date
  • {6} - PO Number
06/05/2012 - Invoice INV00031 for P001023{5} - PO JDF00482291Invoice {0} for PO {46}
Invoice PDF File Name (Project Engagement Invoices)Default name for Project Engagement invoices that are saved as PDF or emailed as attachments.
  • {0} - Invoice Number
  • {1} - Client Name
  • {2} - Client Number
  • {3} - Engagement Name
  • {4} - Engagement Number
  • {5} - Invoice Date
  • {6} - PO Number
  • {7} - Project Name
  • {8} - Project Number
Invoice for project Rocket Propelled Roller Skates (P0001023-001)Invoice 06/05/2012 - Invoice INV00031 for P001023{5} - Invoice {0} for {4}
Invoice PDF File Name (Project Invoices)Default name for Project invoices that are saved as PDF or emailed as attachments.
  • {0} - Invoice Number
  • {1} - Client Name
  • {2} - Client Number
  • {3} - Engagement Name
  • {4} - Engagement Number
  • {5} - Invoice Date
  • {6} - PO Number
  • {7} - Project Name
  • {8} - Project Number
Invoice for project Rocket Propelled Roller Skates (P0001023-001)Invoice for project {7} ({8})
Invoice Name Format (no date range)

Default name for new invoices that do not cover a date range or only have a start date. Engagement name and code are listed twice so that you can show both for project level invoices.

If you invoice at the client or PO level then

  • {0} - Client Level 0*
  • {1} - Client Level 1*
  • {2} - Engagement Name (for engagement/project client levels only)
  • {3} - Engagement Code (for engagement/project client levels only)
Invoice P001020Invoice {3}
Invoice Name Format (with end date)Default name for new invoices that only have an end date. Engagement name and code are listed twice so that you can show both for project level invoices.
  • {0} - Client Level 0*
  • {1} - Client Level 1*
  • {2} - Engagement Name (for engagement/project client levels only)
  • {3} - Engagement Code (for engagement/project client levels only)
  • {5} - Invoice through date
Invoice for P00120-001 through Oct 30, 2013Invoice for {1} through {5}
Invoice Name Format (with start and end dates)Default name for new invoices that have both a start and end date. Engagement name and code are listed twice so that you can show both for project level invoices.
  • {0} - Client Level 0*
  • {1} - Client Level 1*
  • {2} - Engagement Name (for engagement/project client levels only)
  • {3} - Engagement Code (for engagement/project client levels only)
  • {4} - Invoice from date
  • {5} - Invoice through date
Invoice for Rocket Propelled Roller Skates for work from Oct 1, 2013 through Oct 31, 2013Invoice for {0} for work from {4} through {5}
Invoice Email Subject FormatBy default the Invoice distribution email uses the invoice name in the subject line. The default can be change to use the invoice number instead.
  • {0} - Invoice Name*
  • {1} - Invoice Number*

Invoice P001020

INV00031

{0}

{1}

...

Great Plains Accounting Interface

...

Info
titleRelated Content

Additional Dynamics GP documentation can be found under Accounting System - Dynamics GP.

These settings apply to clients who are integrated with the Great Plains accounting package. They should be configured in coordination with the Projector professional services team who are trained in Great Plains integrations. 

...

Account SettingDescriptionShortcode MappingsExampleExample Shortcode
Exchange Rate Decimal PlacesNumber of decimal places in the GP exchange raten/a

Great Plains Account String Format

Account string built by Projector for GP. Typically this is in the form {0}-{1}.

There is some extended functionality with these shortcodes that allow you to splice off certain sections of characters. You use these features if you need to match a more complex Chart of Accounts structure.

Start at Character X

{0:2} - Place a colon and a number to start at a specific character. In this example the value would be everything from the third character in the cost center name onwards.

Start at Character X for Length L

{0:2,4} - Place a comma and a number for the length to get. In this example the value would be the first four characters after the third characters.


As a complex example, let's say our chart of accounts structure is:

 Department - Account - CostCenter (xx-xxxx-xx)

In this case, notice how the Account number is smushed between the Department and Cost Center. The Department and Cost Center values are both going to come from the {0} shortcode. We will use the string manipulators above to grab the portion that we need.

Our base format is:

{0}-{1}-{0}

We then grab the first three digits of the {0} shortcode to populate the department:

{0:0,3}-{1}-{0}

Finally, we grab the remaining characters in the {0} shortcode to populate the Cost Center.

{0:0,3}-{1}-{0:3}

US-4100{0}-{1}
Vendor Invoice Document Number FormatDocument number format for vendor invoices
  • {0} - PV number
  • {1} - Transaction number
  • {2} - VI number
  • {3} - VI reference number
PV00045-5001{0}-{1}
Unapproved to Pay Vendor Invoice Document NumberDocument number format for voided invoices
  • {0} - PV number
  • {1} - Transaction number
  • {2} - VI number
  • {3} - VI reference number
PV00045-5001V{0}-{1}V
Expense Report Document Number FormatDocument number for expense reports
  • {0} - PV number
  • {1} - Transaction number
  • {2} - ER number
PV00045-5001{0}-{1}
Unapproved to Pay Expense Report Document NumberVoided Expense Reports
  • {0} - PV number
  • {1} - Transaction number
  • {2} - ER number
PV00045-5001V{0}-{1}V
Great Plains A/P Transaction Description Field Format

When AP transaction is sent 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} - "AP" - Hardcoded to this string
  • {2} - AP 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} - Payment Voucher #
  • {7} - Vendor Reference Invoice # - Found on a resource's profile for expense reports. Found on a vendor's profile for vendor invoices.on a payment voucher
  • {8} - Expense Document #
  • {17} - Expense Document Name
ER00123{17}
Great Plains A/R Transaction Description 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
INV00101{7}
Great Plains A/R Transaction Description 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 #
INV00101{7}
Great Plains A/R Transaction Description 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
INV00101{7}
Great Plains A/R Transaction Description 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
INV00101{7}
Great Plains G/L Transaction Description Field Format

When a GL batch is sent from Projector, include this information in the 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 QuickBooks.

  • {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)
PGJE#1234*P001023-001PGJE#{2}*{14}

...

Account SettingDescriptionShortcodesExampleExample Shortcode
QuickBooks A/P Transaction Memo Field FormatWhen AP transaction is sent 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} - "AP" - Hardcoded to this string
  • {2} - AP 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} - Payment Voucher #
  • {7} - Vendor Reference Invoice # - Found on a resource's profile for expense reports. Found on a vendor's profile for vendor invoices.on a payment voucher
  • {8} - Expense Document #
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}
QuickBooks A/R Transaction Memo Field Format (client)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})
QuickBooks 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}
QuickBooks 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})
QuickBooks 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})
QuickBooks G/L Transaction Memo Field Format

When a GL batch is sent from Projector, include this information in the 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 QuickBooks.

  • {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}

...

Info
titleRelated Content

Additional QuickBooks Intacct documentation can be found under Accounting System - Intacct

...

Account SettingDescriptionShortcodesExampleExample Shortcode
Intacct A/P Transaction Memo Field FormatWhen AP transaction is sent 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} - "AP" - Hardcoded to this string
  • {2} - AP 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} - Payment Voucher #
  • {7} - Vendor Reference Invoice # - Found on a resource's profile for expense reports. Found on a vendor's profile for vendor invoices.on a payment voucher
  • {8} - Expense Document #
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})

Business Central Accounting Interface

Info
titleRelated Content

Additional QuickBooks documentation can be found under Accounting System - Business Central

These settings apply to clients who are integrated with the Business Central accounting package. When transactions are sent from Projector to Business Central, you have the option of including some custom information inside of description fields. These description fields are then useful for running audits on data between the two system if they should get out of sync (which should not happen if proper procedures are followed!).

You can change these values, but their formats were specifically chosen to make account reconciliations between Projector and Business Central faster. If you ever require our consulting team to go in and do an audit on your books, it may take longer if these standard settings are changed. If you do make changes, the information before the first semi-colon should try and stay a fixed width, for instance 80 characters. That is why we have padding spaces before the first semi-colon AND why we use a string formatter, {2:D10}, to force transaction numbers to be ten digits. Information after that semi-colon you can feel more free to edit. 

Image Removed 

Description field format for payment vouchers..
Account SettingDescriptionShortcodesExampleExample Shortcode
BC Tenant NameName of the Business Central Tenant to connect to.NULLBC Dimension NamesWhen mapping to dimensions, this allows the user to specify, positionally, the name of each dimension.  Enter the names of the configured dimensions, separated by pipe characters, in the same order the dimension values are specified in in cost center mappings.NULLBC Tax CodeProjector will use this as the tax code in all transactions sent over to Business Central. Tax should be set up with a 0% rate, as Projector handles taxes as separate items.PPSATAXBC A/P Transaction Description Field Format



Business Central Accounting Interface

Info
titleRelated Content

Additional Business Central documentation can be found under Accounting System - Business Central

These settings apply to clients who are integrated with the Business Central accounting package. When transactions are sent from Projector to Business Central, you have the option of including some custom information inside of description fields. These description fields are then useful for running audits on data between the two system if they should get out of sync (which should not happen if proper procedures are followed!).

You can change these values, but their formats were specifically chosen to make account reconciliations between Projector and Business Central faster. If you ever require our consulting team to go in and do an audit on your books, it may take longer if these standard settings are changed. If you do make changes, the information before the first semi-colon should try and stay a fixed width, for instance 80 characters. That is why we have padding spaces before the first semi-colon AND why we use a string formatter, {2:D10}, to force transaction numbers to be ten digits. Information after that semi-colon you can feel more free to edit. 

 Image Added

Account SettingDescriptionShortcodesExampleExample Shortcode
BC Tenant NameName of the Business Central Tenant to connect to.  Ask the development team for details please.

NULL
BC Environment NameThe name of a Business Central Sandbox environment.  Leave it blank if integrating with the real Business Central instance. 


BC API Version NumberThe API version number used in the transaction synchronization.  Ask the development team for details please. 


BC Cost Center Mapped Dimension NamesWhen mapping to dimensions, this allows the user to specify, positionally, the name of each dimension.  Enter the names of the configured dimensions, separated by the designated delimiter, in the same order the dimension values are specified in cost center mappings.  Matching dimension names and value lists need to exist in Business Central for the synchronization to succeed. 

NULL
BC Dimension DelimiterThe delimiter used to decode the cost center dimension string, A/P, A/R and G/L line dimention string 
|
Set Mapped Dimesnions at A/P Invoice LevelIf set to true, A/P transaction's GL line's cost center dimension will be set at the A/P invoice level.  other wise, A/P line's cost center dimension is set at the line level only. 


Set Mapped Dimensions at A/R Invoice LevelIf set to true, A/R transaction's GL line's cost center dimension will be set at the A/R invoice level.  other wise, A/R line's cost center dimension is set at the line level only. 


BC Tax CodeProjector will use this as the tax code in all transactions sent over to Business Central. Tax should be set up with a 0% rate, as Projector handles taxes as separate items.

PPSATAX
BC A/P Transaction Description Field FormatDescription field format for payment vouchers..
  • {0} - Accounting Period - Recommend you use period strings like 2022-02 for Feb, 2022 as it is fixed width and easily sortable
  • {1} - "AP" - Hardcoded to this string
  • {2} - AP 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} - Payment Voucher #
  • {7} - Vendor Invoice # on a payment voucher
  • {8} - Expense Document #
  • {9} - Expense Document Name

Projector {1} Txn#{2:D10},{0},{6}   ;{3};Exp Doc #{8};Vendor Ref #{7}
BC A/P Invoice Line Dimension MappingsAdditional A/P invoice line dimension delimited using BC Dimension Delimiter. Matching dimension names and value lists need to exist in Business Central for the synchronization to succeed. See above 
PVNo={6}|VendNo={7}
BC A/R Transaction Description Field Format (client level invoices)Description field format for client level invoices. The limit is 100 char. 
  • {0} - Accounting Period - Recommend you use period strings like 2022-02 for Feb, 2022 as it is fixed width and easily sortable
  • {1} - "
AP
  • AR" - Hardcoded to this string
  • {2} -
AP
  • 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} - Payment Voucher #
  • {7} - Vendor Reference # - Found on a resource's profile for expense reports. Found on a vendor's profile for vendor invoices.
  • {8} - Expense Document #
    • sent the transaction
    • {5} - Date and time the transaction was sent from Projector
    • {6} - Invoice #
    • {7} - Invoice Name
    • {8} = Client Number
    • {9} = Client Name
    • {10} = Purchase Order Number
    • {11} = Engagement Code
    • {12} = Engagement Name
    • {13} = Project Code
    • {14} = Project Name

    Projector {1} Txn#{2:D10},{0},{6}
      
        ;{3};
    Exp Doc #
    {
    8};Vendor Ref #{7}
    10} ({9})
    BC A/R Transaction Description Field Format (
    client
    PO level invoices)Description field format for
    client
    purchase order level invoices. The limit is 100 char
    • {0} - Accounting Period - Recommend you use period strings like 2022-02 for Feb, 2022 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} = Client Number
    • {9} = Client Name
    • {10} = Purchase Order Number
    • {11} = Engagement Code
    • {12} = Engagement Name
    • {13} = Project Code
    • {14} = Project Name

    Projector {1} Txn#{2:D10},{0},{6}    ;{3};{
    10} ({9
    13}
    )
    BC A/R Transaction Description Field Format (
    PO
    engagement level invoices)Description field format for
    purchase order level invoices.
    engagement level invoices. The limit is 100 char. 
    • {0} - Accounting Period - Recommend you use period strings like 2022-02 for Feb, 2022 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} = Client Number
    • {9} = Client Name
    • {10} = Purchase Order Number
    • {11} = Engagement Code
    • {12} = Engagement Name
    • {13} = Project Code
    • {14} = Project Name

    Projector {1} Txn#{2:D10},{0},{6}    ;{3};{12} ({
    13
    11})
    BC A/R Transaction Description Field Format (
    engagement
    project level invoices)Description field format for
    engagement
    project level invoices.  The limit is 100 char
    • {0} - Accounting Period - Recommend you use period strings like 2022-02 for Feb, 2022 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} = Client Number
    • {9} = Client Name
    • {10} = Purchase Order Number
    • {11} = Engagement Code
    • {12} = Engagement Name
    • {13} = Project Code
    • {14} = Project Name

    Projector {1} Txn#{2:D10},{0},{6}    ;{3};{12} ({11})
    BC
    A/R Transaction Description Field Format (project level invoices)Description field format for project level invoices. 
    • {0} - Accounting Period - Recommend you use period strings like 2022-02 for Feb, 2022 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} = Client Number
    • {9} = Client Name
    • {10} = Purchase Order Number
    • {11} = Engagement Code
    • {12} = Engagement Name
    • {13} = Project Code
    • {14} = Project Name
    Projector {1} Txn#{2:D10},{0},{6}    ;{3};{12} ({11})
    G/L Journal IdentifierIf specified, lines will be added to an existing journal in Business Central, identified by this value. Otherwise, a new journal is created and lines added to the new entry.  If a matching journal could not be find in Business Central, GL transactions will fail. 

    GL-10001
    BC A/R Invoice Line Dimension MappingsAdditional A/R invoice line dimension delimited using BC Dimension Delimiter. Matching dimension names and value lists need to exist in Business Central for the synchronization to succeed. See code for BC A/R Transaction Description Field Format (project level invoices)
    InvNo={6}|ClinNo={8}
    BC G/L Code Field FormatThis field defines the journal code when Projector is creating journals. It supports two placeholders: {0} – Transaction Batch Number and {1} – GL Transaction Number. Default value is ‘{1}’.
    • {0} – Transaction Batch Number
    • {1} – GL Transaction Number


    BC G/L Comment Field FormatComment field format for journal entries. 
    • {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)

    PPSAGJE
    BC G/L Display Name Field FormatDisplay name field format for journal entries. 
    • {0} = Company Number
    • {1} - Accounting Period - Recommend you use period strings like 2022-02 for Feb, 2022 as it is fixed width and easily sortable

    C{0}-AP{1}
    BC G/L Transaction Description Field FormatDescription field format for journal entries. The limit is 100 char. 
    • {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};{14};{7};{8};{16};{13}
    BC G/L Transaction Document Number Field FormatDocument Number field format for journal entries. 
    DOC{1}
    BC G/L Journal Line Dimension MappingsAdditional G/L invoice line dimension delimited using BC Dimension Delimiter. Matching dimension names and value lists need to exist in Business Central for the synchronization to succeed. 


    Create Vendors in BC AutomaticallyTurn this setting on to have Projector create vendors in Business Central automatically as necessary.When Projector tries to send over an AP transaction and the vendor does not already exist in Business Central, Projector will attempt to create the vendor in BC. Note there is no ongoing synching of vendors, only initial creation.
    0
    Create Customers in BC AutomaticallyTurn this setting on to have Projector create customers in Business Central automatically as necessary.When Projector tries to send over an AR transaction and the customer does not already exist in Business Central, Projector will attempt to create the customer in BC. Note there is no ongoing synching of customers, only initial creation.
    0



    Web Services Accounting Interface

    ...

    Account SettingDescriptionShortcodesExampleExample Shortcode
    Web Services A/P Transaction Memo Field FormatWhen AP transaction is sent 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} - "AP" - Hardcoded to this string
    • {2} - AP 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} - Payment Voucher #
    • {7} - Vendor Reference Invoice # - Found on a resource's profile for expense reports. Found on a vendor's profile for vendor invoices.on a payment voucher
    • {8} - Expense Document #
    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})

    ...