Tag Archives: Reports

Using SQL Commands instead of SQL Views in Sage 300 Reports

With Sage 300 Intelligence Reporting, you get a number of Customized and user specific reports that befit your business needs. These crystal and .dll reports are fully customizable and ready to use with drill down capabilities. New Stuff: Modified Tax Summary Representation in Sage 300 Reports In Sage 300, we use crystal reports to print several… Read More »

Sage 300 – Resolution for error while accessing executable from Mapped Drive

In this blog we are going to discuss one issue which may occur while accessing the executable on workstation machine from the server machine.  The below error message occurs if the path for the executable is set using mapped drive while adding executable on the workstation. As you can see in the below screenshot the… Read More »

Sage 300 PJC – Transaction Numbering

With the help of Sage 300 Project and Job Costing module organization can be able to manage estimations, tracking inventory purchase, costing, and billings of projects, miscellaneous costs as well as processing charges. This module also facilitates user to set some formats for the various documents/transactions that are processed under PJC module. In this blog… Read More »

Sage 300 PJC – Posting Date Option

With the help of Sage 300 Project and Job Costing module organization can be able to manage estimations, tracking inventory purchase, costing, and billings of projects, miscellaneous costs as well as processing charges. This module also facilitates user to set some default options which will help in making faster entries and brings uniqueness in process… Read More »

DISTRIBUTION TRANSACTION REPORT

A/R Distribution Codes screen is used to define codes to identify the general ledger Revenue, Inventory, and Cost of Goods Sold accounts to use in sales transactions. Distribution codes are a quick method of specifying the revenue, inventory, and cost of goods sold general ledger accounts to which you post data from sales transactions. New Stuff: How to… Read More »

Error: Sage 300 ERP UI Container has stopped working message occurs when printing reports

Sometimes users face an error message “Sage 300 ERP UI Container has stopped working” when printing reports. This normally occurs on a Windows 2008 R2 or Windows 2012 server when printing reports to the preview screen. When we click to view the problem details, the following message displays: “Assertion failed! Program: C:AppsAccpacRUNTIMEA4WCONTAINERXP.EXE File: repcmd.c Line:… Read More »

GL Clearing Report in Sage 300 ERP

In our previous blog, we discuss about “Auto Generate Document Number in GL Clearing Module for Sage 300 ERP”. Now we will discuss about the reporting part in GL clearing, which shows GL reconciled data saved previously in GL clearing screen. Once GL Reconciliation is completed, user can print reports to know the reconciled document.… Read More »

MRP Report in Sage 300 ERP

It’s very important to predict requirement for materials on a daily basis and plan for procurement accordingly. Sometimes, organization needs to know their; On hand quantity, transferred quantity, quantity required etc. for assembling stock and non-stock items. Hence, for these situations, we have developed report for Sage 300 ERP known as “Material Requirement Planning”, which… Read More »