Order Billing Reports
These reports are common between the Fulfillment Module and the Manufacturing Module.
Open Order
Multi-functional report allowing follow-up for vendors and customers for open orders.
Printing this report on a scheduled basis, such as once a week allows you to review and follow-up on orders in process. Allow customer service to be pro-active in order follow-ups.
Keypoints:
- Target key milestones for order processing. Ie. Unreturned artwork/proofs, non-acknowledged orders, and overdue shipments etc…
- Separate Fulfillment (inventory/ecommerce) orders from Regular (dropship) orders.
- Ability to print line item details in matrix format.
- Print pricing for customer owned items.
- Able to save specific report formats for later use, customize report output.
Available sort options and benefits:
- Customer number/name – Print or display all open orders for all or selected customers.
- Follow-up date – Print or display all open orders for all, selected or range of follow-up dates.
- Ship date – Print or display all open orders for all, elected or range of ship dates.
- In-hand date – Print or display all open orders for all, selected or range of in-hand dates.
- Vendor number/name – Print or display all open orders for all, selected or range by vendor. Track unreturned art, non-acknowledged orders etc…
- Salesperson – Print or display all open orders for all, selected or range by salesperson.
- Item number – Print of display by item or in matrix detail format open orders.
Booked/Billed Order Comparison
This company report provides a three-year history of the total number of orders and invoices and the dollar amount of orders booked and billed for each month. Optionally you may print corresponding costs and gross profit percents. This comparative information allows you to analyze your booked and billed sales and profit, per month, for three years (fig 1).
Booked
The booked information is updated when an order is printed or the invoice for a Bill Only is printed. Credit memos optionally affect this report. Modifications made to open orders also affect these amounts, after the modified order appears on an Order Journal. The month affected is determined by the date orders are entered and the date printed on Bill Only invoices.
Billed
The billed information is updated when invoices are printed. Again, credit memos optionally affect this report. The machine date at the time invoices print, determines the month affected and is the same date printed on your invoices and the invoice journal.
Note: Fulfillment orders can be set to optionally affect this report, please review company information|Fulfillment section for your setting.
Keypoints:
- 3-year analysis of booked and billed with optional GP information.
- Analyze trends over the previous three years and relate them back to your specific market and company marketing plan. Check to see if differences were attributed to seasonal variations, manpower considerations or advertising and promotional efforts
- Graphical analysis is available.
- Able to save specific report formats for later use.
Order Costing Report
This report allows you to compare billed order coss to vendor invoices applied to that order. The billed amounts and the vendor invoice amounts are distributed into columns for merchandise, freight and other costs and can be helpful in analyzing items drop-shipped. For Fulfillment orders stock costs based on inventory costing may be analyzed.
Keypoints:
- Cost variance analysis options.
- Create report for analyzing either Regular or Fulfillment orders.
- Able to suppress marginal variance by amount or percentage.
- Include vouched and/or stock costing information.
- Able to save specific report formats for later use.
Available sort options and benefits:
- Order #, Invoice #, Customer #, and by Sales.
Monthly Booked Orders Report
This report gives you a listing of orders booked including bill onlys, credit memos and orders deleted during the current month.
Each order record that prints, includes the total order amount & cost, gross profit percent and amount, salesperson # (all or only the primary on each order) and the amount of commission on the order.
You may also choose to print this report for selective or a range of time periods or for the entire month. Printing all or selective units is also an option.
Keypoints:
- This is an important management tool for analyzing performance of your company and performance tracking by salesperson.
- Compare current month reporting to previous months and capitalize on developing trends.
- Able to save specific report formats for later use.
Available sort options and benefits:
- Sort by salesperson weekly to track performance.
- Sort by customer to target larger accounts for future promotions.
- Sort by order # and analyze missing numbers which may indicate incorrect order booked dates.
Monthly Billed Orders Report
This report gives you a listing of orders invoiced in the current month.
Each invoice record that prints, includes the total invoice amount, cost, order amount & cost, gross profit percent and amount, salesperson # (all or only the primary on each order) and the amount of commission on the order.
You may also choose to print this report for selective or a range of time period. Printing all or selective units is also an option.
Keypoints:
- This is an important management tool for analyzing sales for your company.
- Breakdown P&L activity by customer, salesperson or fulfillment program for the current month.
- Use in conjunction with the Monthly Booked Orders for monthly evaluation of revenue projections.
- Able to save specific report formats for later use.
Available sort options and benefits:
- Sort by salesperson weekly to track performance.
- Sort by customer to target larger accounts for future promotions.
- Sort by invoice # and analyze missing numbers which may indicate incorrect invoiced dates.
- Sort by program # to analyze each fulfillment program.
Product, Source or Line Code Summary Reports
These reports provide additional analysis of MTD, YTD and LYR invoice activity. Report includes the cost, sale and GP% for each period.
Provide another analysis tool for breaking down P&L activity based on user-defined codes.
Keypoints:
- This is an important management tool for analyzing sales for your company.
- Breakdown P&L activity by either product code, (order) source code or (item) line codes..
- Graphical analysis is available.
- Able to save specific report formats for later use.
Available sort options and benefits:
- Select by product code to analyze costing, sales and GP % by product groups.
- Select by source code to analyze source of the order. Ie. Shows, mailings, advertising etc…
- Select by line item code of additional in-depth breakdown of costing, sales and GP% by sub-product groups.