Batch Job Cost User Guide

Full Order Entry Reports User Guide

Order Entry>Reports>Batch Job Cost 

Batch Jobcosting is an add-on.  Please Contact RFMS at 800.701.7367 for more information. 

This feature allows job costing multiple customer orders simultaneously.  Select the appropriate parameters from the fields available and click Process.  All Customer Orders that fall under the selected parameters will be processed. Criteria for Batch Job Costing:

• Finds the greatest Date from Providers.
• Finds the greatest Order Date from Order Header (including Overages).
• Finds the first day of the month after the last Journal Close.
• The greatest of these three will be used for Job Costing.

Field Explanations

General

Delivery Date

Custom-Choose the date to use by clicking the down arrow.  

UD ED Date-This date is the field that was named in the Estimate Delivery Date Prompt system option.

Invoice Date-When Invoice Date is selected as the Delivery Date, Estimated Delivery Date group will change to deal with Invoice Date.

User Providers Install Date as 1^st Option for Del Date

Checking this box uses the greatest Provider Install date if available. If the Install date is not available, then the option selected in the Delivery Date drop-down menu is used.

Overhead Margin

As of version 22.1 this is pulled from the standard overhead margin.

See Standard Overhead System Option.

Discount Rate

This field represents any percentage discount allowed to the customer on the invoice amount.  Enter the appropriate amount in the space provided.  This amount will be a factor in each order that is job costed through the Batch Job costing procedure. 

How Discount Rates work:

It may be that you allow customers to take a 2% discount if they pay their invoice by a specified date.  Putting that rate into this field will cause that calculation to be made and reflected on the monthly statement sent to the customer.  That discount will be automatically calculated and reflected when you post a payment to this invoice.  Discounts will remain in effect until the Post Finance Charge routine is run.  At that time, any potential discounts are cleared.

Due Date

This date represents that date the invoice is due for payment.  If a discount rate has been posted in the way that is described above, then the system will require you to then post a due date.

Sort Order

The ability to sort the batch and thus the report was added in version 10.5.5.  The possible sorts are Order Number, Store, Order Number, Sold-To Name, Store, and Sold-To Name.

Report Destination

Select the printer that you wish to have the Result Report printed to.

Gross Profit Percent/ Labor Profit Percent

Min – This field represents the minimum Profit % required for Batch Job Costing.

Max - This field represents the maximum Profit % required for Batch Job Costing.

Estimated Delivery Date (Invoice Date)

In order to select Estimated Delivery Date, you must select the box next the "Use Estimated Delivery Date" parameter.  This will display the "Beginning" and "Ending" date fields. 

Customers

Select All Customers (which is default) or select a single customer.  In order choose a single customer, you must deselect the All Customer option by un-checking the box.  Then you must click the F8 button to search for the appropriate one.

Invoice Date Required

If this parameter is selected, an Invoice Date must be present on each Customer Order in order to Batch Job Cost.

Include Orders on Hold

If this parameter is selected, orders that are marked as “HOLD” will be included in this Batch Job Cost routine, IF and ONLY IF all other criteria matches.

Ship-To County Required

If this parameter is selected, a Ship-To County must be present on each Customer Order in order to Batch Job Cost.

All Lines must be in a Delivered Status

If this parameter is selected, all lines on the Customer Orders will display as Delivered after the Batch Job Cost routine has been run.

Provider Information Required

If this parameter is selected, Provider Information must be present on each Customer Order in order to Batch Job cost.

Auto Balance Providers

If this parameter is selected, all Customer Orders being Job Costed by this Batch Job Cost routine will have its provider information automatically balanced.

Ignore Orders Without Lines

If this parameter is selected, then orders that do not contain lines will not be batch job costed.

Preview Result Report

After the Batch Job Cost takes place, the Result Report will display on your screen, if you have this parameter selected.

List Filters Tab

Store

Select All Stores (which is default) or select a single store.  To access the single store option, you must deselect the All Stores option.  After doing so, drop down list of all your stores will display.

Customer Type

You may select All Customer Type (which is default) or you may select a single customer type.  In order choose a single customer type, you must deselect the All Customer Types option by un-checking the box.  Then you must click the F8 button to search for the appropriate one.

Sales Rep

You may select All Sales Representatives (which is default) or you may select a single Sales Representative.  In order choose a single Sales Rep, you must deselect the All Sales Reps option by un-checking the box.  Then you must click the F8 button to search for the appropriate one.

 

Print Options Tab

Job cost Sheet

Copies

Enter the number of Jobcost Sheets that you wish to print.

Post to Batch

If this box is checked then, the Job Cost Sheet will print during Batch Printing

Unit to Print

Select either Gross Cost or Total Gross Cost.  Selecting Gross Cost will print the Product Per Unit cost on the line detail section of this job cost sheet.  Selecting Total Gross Cost will print the total unit cost for the line (per unit cost multiplied by the quantity sold).

Print Commissions

Click in this box to print commission percentage and dollar amounts on the job cost sheet. 

Destination

Select the printer that you wish to have the Job Cost Sheet printed to.

Invoice

Some customer may only need a statement while others require an invoice. As of version 11.2 customers can be marked so that an invoice will not be printed for them during the batch job costing process.

Go to Order Entry>File>Customers>Select a Customer>Additional Information Tab

Deselect the box if invoices are not needed. Customers will default to having this box checked, so it is only required to edit those which will not need invoices. If the Batch Job Costing Software has not been purchased, this box will be grayed out. 

Invoices to Print

Select the invoice to print from the drop down menu.

Print Invoice

Select this check box if you wish to print a copy of the Invoices associated with the Customer Orders in this Batch Job cost routine.

Print Overages

Check this box if you want the overages to print on the invoice.

Email PDF

If this box is checked, two options appear for the source of the email under the title

Send Email to

Order Email Address: Orders being processed must have a valid email address,
Customer Contacts: Contact associated with order customer must have both a valid email address and the box checked to Receive Invoices (see Customer Contacts for additional information).

If Print Invoice is also checked, and no valid Email address, then the Order's Invoice will be printed.

Save to PDF History

All processed Orders will automatically save the Order's PDF to History

Copies

Enter the number of Invoices to print.

Post to Batch

If this box is checked then, the Job Cost Sheet will print during Batch Printing.

Destination

Select the printer that you wish to have the Invoices print to.

Options

These are the same options you have for printing invoices from order entry

Standard

This is the same message option you have for printing invoices from order entry

Output CSV To:

This field allows you to select where the CSV will be created.