These are Progress 4GL reports designed to fully utilize 32printer and LBOX Excel output features. Please feel free to use this source codes. Although these programs have been tested and are being in use by some of our clients, we do not guaranty that these reports will work correctly in your system, because of different MFG/Pro version or service pack level. The purpose is to educate user community of 32printer features and help your fellow co-workers. Feel free to download the sources and make adjustments where necessary.
Table of ContentsOpen Sales Orders Report |
Open Sales Orders ReportThis is multi-purpose Excel report, design to help processing Sales Orders on-time and provide valuable statistics at any given point of time, such as what is shippable what is not shippable how many shortages do we have, full details and executive summary. The report generates 3 tab Excel Workbook, the first one has full details, conditionally colored data set for better visibility, so operators who are processing orders should pay attention to a specifically colored lines. Also it shows decreasing Quantity On Hand – how stock was allocated. The second tab has summary, what is shippable what is not, by product item number. The third tab explodes missing components and lists summary by component item number, sorted by descending dollar value of sales.
Report Prompt, looks like this. ┌──────────────────────────────────────────────────────────────────────────────┐ │ Site: To: │ │ Sales Order: To: │ │ Order Date: / / To: / / │ │ Due Date: / / To: / / │ │ Required Date: / / To: / / │ │ Customer: To: │ │ Ship-to: To: │ │ Salespsn: To: │ │ Product Line: To: │ │ Channel: To: │ │ Site List: 2600 │ │ Order Types: Confirmed [V] │ │ Including RMA: yes │ └──────────────────────────────────────────────────────────────────────────────┘ To download report source code click here. The archive has an Excel template file so_report.xls, which should be placed to $32prn/xlt directory. When report is being prepared, 32printer executes VBA macros which are located in the template. |
Suppliers Spending ReportIn Accounts Payable it is often important to rate suppliers, in order to get the better understanding of their spending habits. It could be a good business practice to rate the suppliers, based on the amount spent during the fiscal year. The old by proven 80 / 20 rule will apply in most cases, which means that 20 percent of suppliers provide 80% of purchases. At the same time it is imperative to identify the occasional vendors, who provide goods and services from time to time, or none. Most likely, you will want to analyze the reasons of such behavior and as a result to find alternative suppliers. But how can we spot these bottom-ranking players? +------------------------------------------------------------------------------+ ¦* ============= Suppliers Spending Report ========== *¦ ¦* Calculates the total amount spent by the supplier *¦ ¦* during the period of time (based on checks issued). *¦ ¦* Amounts are in Base Currency, using Transaction Exchange Rate *¦ ¦ ¦ ¦ Supplier: To: ¦ ¦ Date: / / To: / / ¦ ¦ Entity: To: ¦ ¦ ¦ ¦ Output: 32prn ¦ ¦ Batch ID: ¦ +------------------------------------------------------------------------------+ By bringing this information to excel spreadsheet, you will be able to analyze it, select 32prn output or LBOX excel printer.
Click here to download report source code, feel free to add more statistics for each supplier. |
Fixed Asset ReportAsset Depreciation report in the convenient Pivot Table format, has lots of FA details such as CLASS, BOOK, BASSIS AMT, METHOD, LIFE, RETIRED, ENTITY, SVS DATE , LOCATION, PERIODIC ACC ACCOUNT, CC, ASSET ACC ACCOUNT, CC, ASSET SUSPENCE ACCOUNT, TAG, etc. As well as detailed depreciation amounts by period. xxfadarp.p b+ 50.10.1 Fixed Asset Report 08/05/09 +------------------------------------------------------------------------------+ ¦ Asset: FA0000100 To: FA0000155 ¦ ¦ Book: To: ¦ ¦ Summary: No ¦ ¦ Include Retired Assets: No ¦ ¦ Depreciation: Period Accumulated/Period ¦ ¦ Output: 32prn ¦ ¦ Batch ID: ¦ +------------------------------------------------------------------------------+
Click here to download report source code, feel free to adjust. A couple of columns in the excel with GL Account numbers will display values as numbers instead of text, please add the following lines to columns.ini file which is in $32prn directory: PERIODIC ACC ACCOUNT ASSET* |
