> For the complete documentation index, see [llms.txt](https://docs.greytrix.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.greytrix.com/sage-crm-add-ons/crm-project-manager/user-guide/accounts-receivable.md). # 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: 1. Open **Accounts Receivable** from the **Project CRM** menu. 2. Review the list of eligible timesheet entries. 3. Click **Generate AR Invoice**. 4. 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: ``` \WWWROOT\CustomPages\Enbu\Project\ACCPAC ``` 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:

Field Name
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