Accounts Receivable
The Accounts Receivable feature enables Project Manager to generate customer invoices by posting eligible timesheet entries to the ERP system. This feature is available from the Project CRM main menu or by right-clicking the Project icon in the left-hand navigation menu.
Only timesheet entries with an AR Status of PO Received are eligible for posting. These entries must be associated with tasks that are also in the PO Received status. Once an entry is successfully posted, its AR Status is automatically updated to Posted.
Posting to Accounts Receivable
To post timesheet entries to Accounts Receivable:
Open Accounts Receivable from the Project CRM menu.
Review the list of eligible timesheet entries.
Click Generate AR Invoice.
Confirm the invoice generation.
After confirmation, Project Manager displays a summary of the records that have been processed and the generated Accounts Receivable Batch Number.
Accounts Receivable Entry Details
The Accounts Receivable screen displays the following information for each eligible timesheet entry:
Field Name
Description
Entry Date
The entry date of the timesheet
Entry User
The user who entered the timesheet
Project
The project associated with the timesheet
Customer
The customer associated with the project.
Task Name
The name of the task associated with the timesheet
Billed
The timesheet billed amount
Remaining
The amount of days remaining on the task.
Status
The status of the task
AR Status
The Accounts Receivable status on the timesheet
Generating AR Invoices
Selecting Generate AR Invoice automatically groups timesheet entries by their associated tasks, projects, and companies before posting them to the ERP system.
The way invoices are generated depends on the Invoice Method configured for the project:
By Project – A single invoice is generated for the entire project.
By Task – Separate invoices are generated for individual project tasks.
Project Manager then creates the appropriate invoice entries in the company's ACCPAC database.
Posting Results
After the posting process is completed:
A summary of the processed records is displayed.
An Accounts Receivable Batch Number is generated.
The corresponding batch can be viewed in ACCPAC using the same batch number.
The AR Status of successfully posted timesheet entries is automatically updated to Posted.
ACCPAC Configuration
On a default installation, CRM Project Manager includes demonstration data that is configured for posting to ACCPAC. In the sample configuration, all project tasks and timesheets are assigned to the System Administrator, who is mapped to the sample ACCPAC Vendor 7400.
Project Manager uses the configuration file enbu_accpac_config.js, located in:
This configuration file contains two SQL filters used during the posting process:
AR_SQLFILTER – Filters Accounts Receivable timesheet entries.
AP_SQLFILTER – Filters Accounts Payable timesheet entries.
These filters can be modified to match an organization's business rules or Project Manager customizations.
By default:
The Accounts Payable filter requires:
Timesheet AP Status to be Posted.
The Timesheet User ID to be mapped to a valid ACCPAC Vendor.
No default filter is applied to Accounts Receivable timesheets.
The configuration file also contains additional options such as:
General Ledger Account
Revenue Account
Tax Group
These values can be modified according to the organization's ACCPAC configuration.
ACCPAC Field Mapping
Project Manager maps CRM fields to corresponding ACCPAC fields during the posting process.
The standard field mappings include:
user_accpacitemno
IDITEM
user_vendorname
VENDNAME
task_c_poreference
PONBR
proj_projectno
task_ap_rate + task_CONS_Rate + task_CONS_EXP_Rate *
ORDRNBR
tish_billabletskd
AMTGROSTOT
tish_entrydate task_ap_rate or
OPTFIELD
task_ap_rate
comp_idcust +
VALIFDATE
ap_workdate
tish_c_document_date or
INVCDESC
today’s Date
DATEINVC
Last updated