Daily Business Status Report

How to print: Enter DBST in the Fast path field at the top of a menu, select Printing the Daily Business Status Report (DBST) from a menu, or run the Daily Business Status Report periodic function (program name ACR0178).

For more information: See the sample report in PDF format.

Contents: Each field below indicates if the value is based on the Processing date you defined at the Daily Business Status Screen or the date you generated the report (job date). If the field indicates the value can be from either: the value is based on the Processing date if one exists; otherwise the job date is used to determine the value.

• Sales today: The merchandise dollar amount of sales today, based on the processing date or job date. This dollar amount includes shipments confirmed. This is the $ orders shipped from the Order Control Summary table.

• Sales MTD: The merchandise dollar amount of sales month to date, based on the processing date or job date. This is the $ orders shipped from the Order Control Summary table, based on the accounting period start and stop date.

• Cash today: The dollar amount of cash, based on the processing date or job date. This amount is from the Deposit amount field in the Cash Receipts Header table.

• Cash MTD: The dollar amount of cash month to date, based on the processing date or job date. This dollar amount comes from the Deposit amount field in the Cash Receipts Header table based on the accounting period start and stop date defined in Working with Accounting Periods (WACP).

• Inventory primary warehouse: The system uses this calculation, based on the job date, to determine the inventory for the Default Warehouse (A04): on hand quantity for primary warehouse x item cost = inventory for primary warehouse.

• Inventory all others: The system uses this calculation, based on the job date, to determine the inventory for all other warehouses besides the default warehouse: on hand quantity for all non-primary warehouses x item cost = inventory for all other warehouses.

• Orders entered today #: The number of orders entered, based on the processing date or job date. This includes the total number of ship-to addresses, orders which include only sold out items or non-inventory items, returns processed by negative quantities in order entry. This total does not include batch orders that have not yet been accepted. This total is not based on the date, but from the last time you cleared the daily totals (Daily Clear Process periodic function, program name MSR0574). This is the Orders entered number in the Order Control Summary table.

• Orders entered today $: The merchandise dollar total of orders entered, based on the processing date or job date. This includes merchandise dollar total of sold out items and non-inventory items. This total does not include merchandise dollars for items returned during order entry or merchandise dollars for batch orders that have not yet been accepted. This total is not based on the date, but from the last time you cleared the daily totals (Daily Clear Process periodic function, program name MSR0574). This is the Orders entered dollars in the Order Control Summary table.

• Orders entered month to date #: The number of orders entered for the month, based on the processing date or job date. This total is not based on the date, but from the last time you cleared the monthly totals (Monthly Clear Process periodic function, program name MSR0576). The system totals the Orders entered number value in the Order Control Summary table for each transaction date in the accounting period to determine the number of orders entered for the accounting period.

• Orders entered month to date $: The merchandise dollar total of orders entered for the month, based on the processing date or job date. This total is not based on the date, but from the last time you cleared the monthly totals (Monthly Clear Process periodic function, program name MSR0576). The system totals the Orders entered dollars value in the Order Control Summary table for each transaction date in the accounting period to determine the merchandise dollar total of orders entered for the accounting period.

• Average per order entered today $: The average merchandise dollar amount for the orders entered, based on the processing date or job date. The system uses this calculation to determine the average per order: orders entered today dollars / order entered today number = average per order entered today dollars

• Average per order entered month to date $: The average merchandise dollar amount for the orders entered for the month, based on the processing date or job date. The system uses this calculation to determine the average per order: orders entered month to date dollars / order entered month to date number = average per order entered month to date dollars

• Number of units entered today: The number of units ordered for the day, based on the processing date or job date. This includes the main set item as well as each component item, units of sold out items or non-inventory items. This does not include units returned in order entry, units on batch orders that have not yet been accepted. This is the Quantity ordered in the Order Control Summary table.

• Number of units entered month to date: The number of units ordered for the month to date, based on the processing date or job date. The system totals the Quantity ordered value in the Order Control Summary table for each transaction date in the accounting period to determine the number of units ordered for the accounting period.

• Packages shipped today #: The total number of shipped orders, based on the processing date or job date. This is the Orders shipped number in the Order Control Summary table. The setting of the Order Control Summary Shipment Update Method (I55) system control value determines how the system updates the # Orders shipped field in the Order Control Summary table.

• Packages shipped today $: The merchandise dollar total of shipped items, based on the processing date or job date. This includes shipments confirmed. This total does not include dollars for returns processed in order entry. This is the Orders shipped dollars in the Order Control Summary table.

• Packages shipped month to date #: The total number of shipped orders for the month to date, based on processing date or job date. The system adds the Orders shipped number in the Order Control Summary table for each transaction date in the accounting period to determine the total number of shipped orders for the accounting period.

• Packages shipped month to date $: The merchandise dollar total of shipped items for the month to date, based on processing date or job date. The system totals the Orders shipped dollars value in the Order Control Summary table for each transaction date in the accounting period to determine the merchandise dollar total of shipped items for the accounting period.

• Average per package shipped today $: The average merchandise dollar amount for the orders shipped, based on processing date or job date. The system uses this calculation to determine the average per package shipped: packages shipped today dollars / packages shipped today number = average per package shipped today dollars

• Average per package shipped month to date $: The average merchandise dollar amount for the orders shipped for the month, based on processing date or job date. The system uses this calculation to determine the average per package shipped: packages shipped month to date dollars / packages shipped month to date number = average per package shipped month to date dollars

• Number of units shipped today: The total number of shipped units, based on processing date or job date. This includes shipped units confirmed. This total does not include units for returns processed in order entry. This is Quantity shipped in the Order Control Summary table.

• Number of units shipped month to date: The total number of shipped units for the month to date, based on processing date or job date. The system totals the Quantity shipped value in the Order Control Summary table for each transaction date in the accounting period to determine the total number of shipped units for the accounting period.

• Warehouse value: The merchandise dollar amount of the inventory located in the specified warehouse, based on job date. The system uses this calculation to determine the dollar amount: units x item cost = item inventory value.

• Warehouse units: The number of units of the inventory located in the specified warehouse, based on job date. PRIMARY displays to the right of the primary warehouse (from the Default Warehouse (A04).