Sage 300 PJC – Option to default AR Invoice Comment Field

By | November 22, 2016

With the help of Sage 300 Project and Job Costing module, organizations can be able to manage estimations, tracking inventory purchase, costing, and billings of projects, miscellaneous costs as well as processing charges. These types of bills are finally incorporated as Account Receivable invoices so that it will be considered as accounts statement while accounts audits and reporting.

In this blog we are going to discuss about the option provided in Sage 300 PJC module which allows user to default AR Invoice detail line comment value as one of the field value from PJC bill. It is definitely helpful for users to identify the bill is from PJC module and enables them to copy the particulars or remarks from PJC bill to A/R Invoice bill.

New stuff: How to Allow User to Enter the Timecards for Specific Payroll Employees

  • In order to access the screen navigates to Project and Job Costing ->PJC Setup -> Options screen -> Integration Tab. Kindly refer the screenshot for the same.

PJC Option field

  • As shown in screenshot above there are eight values which you can set as a comments for A/R invoice generated detail lines. Please find list of the same with detailed explanation :
  1. Type-Worksheet Number-Document Number
    This will set concatenated values of invoice type, Billing Worksheet Number and Document Number separated by “-” as the A/R Invoice detail line comment.
  2. Contract-Project-Category
    This will set concatenated values of contract code, project code and category code separated by “-” as the A/R Invoice detail line comments.
  3. Comment
    This will set Billing Worksheet comments as the A/R Invoice detail line comments.
  4. Description
    This will set Billing Worksheet description as the A/R Invoice detail line comments.
  5. Reference
    This will set Charges Reference field as the A/R Invoice detail line comments.
  6. Detail Description
    This will set worksheet detail line’s description field as the A/R Invoice detail line comments.
  7. Contract Description
    This will set worksheet detail line “Contract Description” field as the A/R Invoice detail line comments.
  8. Project Description
    This will set worksheet detail line “Project Description” field as the A/R Invoice detail line comments.
  9. Category Description
    This will set worksheet detail line “Category Description” field as the A/R Invoice detail line comments.
  • By default A/R Invoice comments field is set to third option i.e. Billing Worksheet comments.

Note: User can change the value for this option any time. It will apply these changes when user will next time onwards posts the PJC Billing Worksheets to create A/R Invoice from PJC Bills, however it will not affect the existing A/R Invoice entries created from PJC Billing worksheets.

Example:

Please refer to the below screenshot, here the option is set to “Contract-Project-Category”.

PJC Option change

Created one PJC Billing Worksheet as below.

PJC Billing Worksheet

As displayed in below screenshot for A/R invoice, it has taken value of invoice detail line description as Contract Code – Project Code – Category Code i.e.  “120-1400-100”.

Invoice entry

About Us
Greytrix a globally recognized Premier Sage Gold Development Partner is a one stop solution provider for Sage ERP and Sage CRM needs. Being recognized and rewarded for multi-man years of experience, we bring complete end-to-end assistance for your technical consultations, product customizations, data migration, system integrations, third party add-on development and implementation expertise.

Greytrix offers unique GUMU™ integrated solutions of Sage 300 with Sage CRM, Salesforce.com and Magento eCommerce along with Sage 300 Migration from Sage 50 US, Sage 50 CA, Sage PRO, QuickBooks, Sage Business Vision and Sage Business Works. We also offer best-in-class Sage 300 customization and development services and integration service for applications such as POS | WMS | Payroll | Shipping System | Business Intelligence | eCommerce for Sage 300 ERP and in Sage 300c development services we offer services such as upgrades of older codes and screens to new web screens, newer integrations using sdata and web services  to Sage business partners, end users and Sage PSG worldwide. Greytrix offers over 20+ Sage 300 productivity enhancing utilities that we can help you with such as GreyMatrixDocument AttachmentDocument NumberingAuto-Bank ReconciliationPurchase Approval SystemThree way PO matchingBill of Lading and VAT for Middle East.

For more details on Sage 300 and 300c Services, please contact us at accpac@greytrix.com. We will be glad to assist you.