Crystal Reports - PortfolioThese are some of the custom Peachtree reports we have created using Crystal Reports. Assemblies being sold are place on the sales order and each sales order has a Ship By date. This report shows what components will be needed to fill sales orders shipping during the specified report date range. Some Peachtree users are looking for the ability to track inventory that is located in multiple warehouses. This can be done using Crystal Reports. Suppose you want to have 3 warehouses for each item. Setup up each item 3 times in inventory. For example SMOKEALARM01, SMOKEALARM02, and SMOKEALARM03. Now you can buy and sell smoke alarms into and out of each of the warehouses. This is easily accomplished by referencing the appropriate inventory ID for each transaction. If you bought 12 smoke alarms for warehouse #3, reference SMOKEALARM03 on the purchase screen. If you bought 12 smoke alarms for warehouse #2, reference SMOKEALARM02 on the purchase screen. When inventory is moved between warehouses, use the Peachtree command Tasks/Inventory Adjustments. Suppose you've moved 8 smoke alarms from warehouse #1 to warehouse #3. Record this in Peachtree by reducing the quantity on hand of SMOKEALARM01 and increasing the quantity on hand of SMOKEALARM03. Now the only trick is reporting the 3 different warehouse quantities of smoke alarms as one grand total for the overall quantity of smoke alarms. This is where Crystal Reports comes in. This is a custom report that Crystal can easily handle. Simplified General Ledger Report prints for any account specified for a range of dates. Start and end dates are flexible and do not have to be period end dates. The purpose of this report is to prepare data for export to a larger Oracle accounting system. The report prints customers whose TYPE = "D". Customer Custom Field 2 is used for the Oracle GL Account. Shows inventory shortages and replenish costs. Qty Sold YTD is as of the date specified. This is a Sales Order that has been modified for internal use. Included as additional columns on the sales order are the ID of the vendor from whom the item is generally purchased and the cost of the item being sold. Shows 12 months of Quantity Sold data for inventory items - summarized monthly. Prints for customers specified. Data for each customer starts on a new page. The period covered by the report is for the 12 months up through the end date specified. This report can then be sent to customers who can use the information to place their next order. |