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 and gift certificates processed at pick slip generation. 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. The Cash Receipts Header table is updated with the Async date if you automatically post to cash receipts (the Deferred Liability Cash Post Method (C48) system control value is set to ORDER); if you enter cash through Working with Cash Receipts (WCRT) (the Deferred Liability Cash Post Method (C48) system control value is set to CASH RCPT), the Cash Receipts Header table is updated with the batch date. This dollar amount should balance to the Total for deposit amount field on the Daily Cash Receipts Journal.

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). This dollar amount should balance to the Total for deposit amount field on the Monthly Cash Receipts Journal.

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.

A/R: The total dollar value of the open accounts receivable balance, based on the job date. This includes all open, allocated, or disputed open items across all bill to accounts. This total is negative if the dollar total of credits is greater than the dollar total of open invoices. This is the Open A/R balance in the Order Control Summary table.

A/P: The total dollar value of the accounts payable balance, based on the job date. This includes all outstanding (unpaid) A/P invoices, across all vendors. This total is negative if the dollar total of credits is greater than the dollar total of unpaid invoices. This is the Open A/P balance field in the Order Control Summary table.

A/R aging amounts: The A/R open item dollar amount for each aging bucket, based on the job date.

• current: dollar amount of A/R for the current date

• 1 - 30: dollar amount of A/R 1-30 days old

• 31 - 60: dollar amount of A/R 31-60 days old

• 61 - 90: dollar amount of A/R 61-90 days old

• 91 - 120: dollar amount of A/R 91-120 days old

• over 120: dollar amount of A/R over 120 days old

A/P aging amounts: The dollar amount from the A/P Invoice Header table for each aging bucket, based on the job date.

• current: dollar amount of A/P for the current date

• 1 - 30: dollar amount of A/P 1-30 days old

• 31 - 60: dollar amount of A/P 31-60 days old

• 61 - 90: dollar amount of A/P 61-90 days old

• 91 - 120: dollar amount of A/P 91-120 days old

• over 120: dollar amount of A/P over 120 days old

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, gift certificates processed at pick slip generation. 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, gift certificates processed at pick slip generation. 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).

CS06_01r Serenade 5.0 March 2015