Tag Archives: Excel Export

Customization for RCM Entries in Sales Register

The GST Sales Register helps Users to maintain the record of Sales made for a particular period. The report helps to compute the periodic taxes and analyze the periodic turnover. In Sage 300 ERP the report mainly refers to the data that is fetched from AR Invoice screen and OE Invoice screen. But we also… Read More: Customization for RCM Entries in Sales Register »

Indirect Expense Report from AP-GL Module

In Sage 300 ERP, when you enter a transaction in AP invoice, AP Payment and GL Entry, there iscurrently not any report that generates according to the GL Account mapped with the AP-GL Module. So, we came up with the report utility to display the summarized report for AP-GL moduleand to identify the Indirect Expenses/Costs… Read More: Indirect Expense Report from AP-GL Module »

Cash Flow Statement in Sage 300 ERP

In Sage 300 ERP, A cash flow statement is a financial statement that shows how changes in Bank Transactions, Customers, Sales Orders, Vendors, and Purchase Orders affect cash and cash equivalents in general ledger accounts. This statement then helps to divide the analysis down to operating, financing and investing activities. New Stuff: Provision to Set… Read More: Cash Flow Statement in Sage 300 ERP »

PW Management Inquiry Report

Purchasing Workflow (PW) ships with the screens required for the Purchase Requisition (PR) process. Screens are provided for adding requisitions, approving/declining requisitions and creating Purchase Orders (PO) from requisitions. PW’s business rules can include multiple authorisation steps. For example, PR’s may be required to be approved by a requisitioner’s manager, and then by a manager… Read More: PW Management Inquiry Report »

Purchase Receipt details against Purchase Orders Report

During Purchase Process, there are multiple Purchase Orders booked for various purposes. These Purchase Orders are then booked against Purchase Receipts to confirm the transactions. We have developed a custom report to help keep track of the number of Purchase Receipts posted against a Purchase Orders. The report will list the details of PO Orders… Read More: Purchase Receipt details against Purchase Orders Report »

Sales Statistics of Salesperson per Invoice

In Sage 300 ERP, when you enter a transaction in Order Entry, the salespersons assigned to the customer account in Accounts Receivable appear on the Sales Split tab by default. You can assign portions of each transaction to the salesperson or salespersons responsible for the customer account or sale. Sales commissions are calculated when you… Read More: Sales Statistics of Salesperson per Invoice »