| Back to Manuals Page | Home | Printable Version |
Order Entry
As in all of the BMS modules, the flow of processing is outlined on the menus themselves. If you need further help, there are help screens available in each screen. The following pages have examples of the help screens available in the order entry module. The help screens will be referred to throughout the course of this manual. In most screens, there is additional on-line more detailed help available. This will be indicated by a statement at the bottom of the screen such as Press F1 for more detailed help.
There are also examples of various screens found in Order Entry included in this manual. These will help you become more familiar with the look of BMS module screens. Since the modules are integrated, the order entry manual will refer to other modules. To find more information on those modules, check the appropriate manuals.
As in most of the BMS modules, a few basic "rules" or keystrokes are in effect for order entry. They are the following:
All functions must be performed in CAPITAL LETTERS
<F1>=Help
<F9>=Clears screen
<Esc>=Exit
<Tab>=Find
<Backspace>=Clears the line
This manual is intended to be used as a guide in learning the Order Entry program. It is not a replacement for a manager's direction. Some processes in the Business Management System are subjective and require specific instructions from a manager as to how your company would like a particular situation handled. Executive Computer Systems is not responsible for any actions taken based upon information found within this manual. Top.
Note: Your system is a customized system. Therefore, the menus may not have exactly the same order or options. Nor may you have all of the same programs listed in this manual.
From the Master Menu, choose O/E for Order Entry System.
This will bring you into the following menu:
|
order entry |
| Order Entry/Update/Inquiry |
| Print Invoices |
| Automatic Billing |
| Backup To Alternate Area |
| Post Invoices to Accounts Rec. |
| Reports |
| Order Entry Utilities |
| Reprint Sales Journal |
| Ad Key-Code Maintenance |
Choose Order Entry/Update/Inquiry
You will then see the following screen:
| Enter Password: |
Enter the password capital letters. Press Enter when done. The password comes from the Company Setup file. See the discussion on passwords in the appropriate section. The operator code corresponding with the password prints on all quotes, orders, picking lists, invoices and credit memos, so you can track who worked on the order. Top.
You will note in the upper left-hand corner the asterisks. This means that you have gone into order entry using a regular password. If you entered the manager's password, there would be pound signs. Please see the section on Company Setup for details on setting up password or speak to your manager.
The Order Entry screen is divided into three sections. The top section, where all of the billing and shipping information is located, is referred to as the header or bill-to area. The middle section, where the items ordered are entered, is referred to as the line-item area. The bottom section, where the tax information and status bar are located, is referred to as the footer area. Top.
In the order entry screen, if you need to know any of the function key assignments, pressing Help <F1> will bring up a help screen. Notice that it shows you the function key layout depending on what point you are on the screen. The Bill-to or header, Line-item and Footing areas are the three main areas of the order entry screen. The following are examples of those help screens.
<F1> Menu of Other Options
Top.
When you first go into order entry, your cursor will be in the "bill-to" area. You must select who you want to bill. There are several methods of pulling up a customer.
Searching
for customer by name:
You can type in the first few letters of the customer's
name and press the <tab> key. If it is a close match, but not quite,
press the Page Up or Page Down to find the next closest match.
Searching
for customer by Numeric ID:
If you know the customer's account number, hit
Enter four times when you get into order entry. Your cursor moves up to the
ID field. Just type in the account number and press Enter. The screen will fill
in the customer name and address. If the customer number is not correct, your
cursor will jump down to the "bill-to" field, meaning there is no
match and additional information is required. Hit the Clear Screen key <F9>
and try another method.
Searching
for customer by Alpha ID:
If you know the customer's alpha account id, simply
hit Enter when you get into order entry. Your cursor moves over to the alpha
ID field. Just type in the alpha id and press <tab> key. The screen
will fill in the customer name and address. If the customer alpha id is not
correct, the system will bring up the customer closest in alpha id to what you
entered. Page Up or Down to find your customer or hit the Clear Screen key <F9>
and try another method.
Searching
for customer by address:
Hit Enter five times until your cursor is on the
second line in "bill-to". Type in part or all of the street address
and press the <tab> key. Pressing PgUp or PgDn will find the next
closest match.
Using
Customer Search Feature:
You can have the system show you a "list"
of your customers and choose which one you want from that list. Press the <F3>
key while your cursor is in the "bill-to" field. The screen will look
like this:
Select your search method by pressing <F7> to scroll through your search options. You can search by customer name, contact, customer phone number or city. Then type in the information you are looking for (ie: name, phone number, etc.) and <tab>. For this example we are using name. You will then see the following screen:
You will see a list of customers that match the closest. Keep hitting Enter to see more customers. When you find the customer you are looking for, hit <Esc>. You will then be asked which line number you want to look at. Enter the line number that corresponds with the customer you want to view, and press Enter. You are then brought back to the order entry screen, and that customer is filled in. If you do not want any of the customers you see, hit escape without selecting a line number.
Editing
or adding a customer while in Order Entry:
There is a point in Order Entry where you can
add a new or edit an existing customer file. This saves time, because you do
not have to exit out of Order Entry, go into the customer maintenance screen,
add or change the information, and go back into Order Entry.
You can bring up your specific customer first by the methods we have already covered or <F7> at a blank order entry screen and bring up the customer from within the customer file maintenance screen.
With your customer selected, while your cursor is in the "bill-to" field, press <F7>. This will take you to the customer file maintenance screen. You can edit the customer profile or add a new customer at this time. If editing, type in part of the company name and use <tab> to find your customer. You can also type in the customer alpha or number id and use <tab> here to find your customer. Once you have found the correct customer, use your Enter key until you get to the field you want to change. Edit the field and then <F10> to save the information.
If you are adding a customer, enter the company name, first and last name of owner (or credit card holder if you are a mail order business), then type in the street address. The cursor will then bring you to the zip code field, skipping the city and state. Type your information and enter. This will automatically input the city and state for that zip code. If there is more than one town for a zip code, a popup list will allow you to select the town that is appropriate.
The system will automatically assign a customer number for any new customer you enter. This number cannot be edited. You cannot enter your own customer number - the system will not save it. The system will also automatically assign an alpha id for any new customer you enter. You may edit this field. You must save the change immediately after by pressing <F10>. If you enter to another field before saving it, the original alpha id will be kept and the changes will be lost.
Continue entering all appropriate information. See the screen below for an example.
<F10> will save the information or press <F9> to clear the screen and not save changes. Escape will take you back into the order entry screen. If you have saved your changes, you will note the change has been made on the bill-to screen. There is help available from this screen by pressing <F1>. See the Customer Maintenance section in the manual for further information on editing or adding a customer.
Deactivating
Customers:
Deactivating customers may only be done by a manager. This is
done in the customer maintenance screen. Bring up the customer you want to deactivate.
Once you have your customer, press <F3>. A message will pop up
asking you want to deactivate this customer. Type Y for yes and Enter.
This customer is now deactivated and not accessible in Order Entry. To activate
this customer, choose <F3> and answer yes.
This feature will allow you to print reports without old customers. It will also prevent operators from entering orders for customers you no longer do business with. Top.
Once you have found the customer you want, press Enter. Your cursor jumps to the ship-to portion. The default ship-to address matches the bill-to. You can change the ship-to address here by simply typing over it. However, if the customer account was set up for multiple ship-to's, the system will prompt you for the ship-to code. (Each location will have its own code to identify it).
To see a listing of all available ship-to's, while your cursor is on "Enter Ship-To/Job #: ", press <F3>. A list of ship-to locations will be displayed. Select the corresponding number you want. You will be returned to the order. Multiple ship-to's are set up in the customer maintenance screen. Please see the Accounts Receivable manual on how to set these up.
If there are no multiple ship-to's, the ship-to defaults to billing address. Either way, press Enter several times or <F7> once until your cursor goes to the bill-to attention line. Enter a name or contact if you wish, if not enter to get to the "By" field. Here you can fill in the name of the person who placed the order with your company. Press enter to get to attention ship to line. Fill in your contact name if you wish, if not enter to Ad Source field. This will bring up the default from the Customer Maintenance screen. You can override this information if you choose; use PgUp or PgDn to scroll through options. Check with a manager to see if an advertisement is being tracked. This field must be completed to process the order.
Press Enter the get to the Purchase Order number field. If you previously set up the customer so that it requires that you enter a purchase order, you cannot bypass this step. Type in the number, if any, and press Enter. If you are not using a purchase order number for this field, you can type in some sort of identifying information here, which will overwrite the words "INVOICE", when posting to A/R. Example, when you print a past due statement or A/R aging detail report, you will see the date, invoice number, etc., as well as P.O. #. It will print "INVOICE" as a default if you do not type in any other information. If you type something else in the P.O.# field, the description will print whatever you type in. This is useful when making collections calls, when statements are printed or when you are viewing customer account activity.
If the system is set up for the operator to be able to change the salesman in order entry, (see company setup), your cursor jumps to the salesman field. You can use the page down key or hit the backspace key to clear that field, and type in the correct salesman number and press Enter. Otherwise, the salesman is the one "assigned" to the customer, in customer setup. The cursor then moves to due date. You can override this date if you wish. Press enter to move the cursor to terms field. This field must be filled in. Payment terms may be changed if allowed in your initial company information setup. If not this will default to what is setup in the customer maintenance screen for this customer. When you have entered again, your cursor jumps to the line item section of the order.
The system then assigns an order number in the upper right-hand section. Order numbers are incremented by 10. Every new order will end with the number zero. If you create a backorder, that backorder will be the same as the order number, except it will end in a 1. Every subsequent backorder for that particular original order will increment by 1. Theoretically, you could have nine backorders for one original order. Your cursor then jumps down to the line item section. You are now ready to add items to the order.
Your screen will now look something like this:
Adding
items to an order::
You will note that your cursor is already on item number, with line number 1
ready to go. At this point you should begin adding line items (parts) to the
order. The number 1 means line 1 of the order. This number does not print on
invoices. There are several ways to search for a part if you do not know the
item number. This will be covered later.
Browsing
customer history::
You can view on the screen the last items the customer purchased
by hitting <F3> to see Customer Sales History. This screen
displays the item #, description, quantity, price paid, next date and price.
Enter the product code, part of it, or just hit Enter to see all the items
this customer ordered. Continue to Enter to see the next "pages".
Press <Esc> and enter line item number if you wish to choose an
item from this screen. When done viewing, press <Esc> to clear
the screen. Your selected item will be added to your order. More options are
shown on the bottom of this screen. Top.
Adding An Inventory Item
There are several ways to find a item number in order entry if you do not know it. The following is an example of the inventory master screen.
|
H E L P |
|
Press <F1> for more detailed help! |
| <F2> View Orders Committed On |
| <F3> = Other Options |
| <F4> List of Inventory Items |
| <F5> On Hand Quantity by Warehouse. |
| <F6> Year-to-year Financial Analysis. |
| <F7> Select Category From Popup List |
| <F7>
View Sales/Purchase History By Customer/Vendor. |
| <F8> Purchase Order Options |
| <F9> Clear This Screen. |
| <F10> Save Record After Changes. |
|
<Press ESC to exit help> |
F3 = Other Options menu
(This menu is only available after you have selected an inventory item.)
|
| | | H E L P | | | |
| <F2> Add or Edit Product Information |
| <F3> Add or Edit Hazardous Message |
| <F4> Add or Edit Kits |
| <F5> Add or Edit Suggested Items |
| <F6> Add or Edit Quantity Breaks |
| <F8> Deactivate Products |
| <F9> Activate Products |
| <F10> Set Up Groups |
To search for an inventory item number, while in Order Entry, your cursor should be in the line item section of the order. Use any of following ways:
(A) Browse Inventory
(1) You can also add items to inventory from order entry
(B) List Inventory
(C) Browse Inventory From Within Order Entry
Below is an explanation of each method:
(A) Browse Inventory
Press the <F4> key. The system will display an inventory screen.
You can search for items either by item #, group, mfg. code, or product description.
Press Enter to get to the inventory field you want to search by, type in the
first few letters and press <tab>. Use your PgUp and PgDn keys
to scroll.
When you find the item you want, press <Esc>. You will see the item number, description, number on-hand, committed and available, as well as 10 prices. You will be returned to the order entry screen. You will see a window with the last date this customer ordered this item, the order no., the P.O. #, quantity and price paid. To continue at this point, please see the section below on "Once you have found the item you want".
Adding a item to inventory while in order entry.
(B) List Inventory
To see a straight listing of inventory items from the inventory master
screen, press <F4>. Enter the item number (or part of the number)
you want and press Enter. If you do not know the item #, press Enter to get
a complete inventory list. Enter will continue through all items. The following
is an example of this screen:
You will see the item number, description, number on-hand, committed and price, as well as the price assigned to that customer. Items having less than 1 available will be highlighted.
Press Enter to display additional items. When you find the item you want to add to the order, hit <Esc> and type in the line item # you wish to select and press Enter. This will add that item into your order. To exit hit <Esc>. Help is available in this screen by pressing <F1>. The following is an example of the help screen.
|
| | | H E L P | | | |
| <F2>
Customer Ranking by Yearly Sales
Vendor Ranking by Yearly Purchases. |
| <F3> View Default Ad Prices. |
| <F4> Company Yearly Sales & Purchases. |
| <F5> Set Up Ad Source. |
| <F6> Set Up Special Pricing. |
| <F7> Sales Or Purchases Order Aging. |
| <F8> View Prices for Product by Ad. |
| <F9> Daily Sales by User. |
| <F10>
Shipping Profit Report.
Down Arrow - Search by Item # or Group. Up Arrow - Toggle All / Allocated Greater Than On Hand. Press the Desired <F > Key TWICE |
As you can see from this help screen, there are alot of valuable features available from the "List of Inventory Items" screen. Please check your inventory manual for further descriptions and information.
(C) To look
for an inventory item number from within Order Entry
If you are not already in the line-item section of the order, (A)dd
a line to the order. Type in the item number, or part of it and press <tab>.
Or, you can bypass the item number by pressing Enter, and go right to the description
field. Type in the first few letters and press <tab>. Press PgUp
or PgDn, if needed, to find the item you want.
Once
you have found the item you want
Again, you will note that the top of the order
entry screen gives you some information about this item. It tells you if this
customer ordered this item before, the date, order number, purchase order number,
quantity, price paid and cost.
You also see the ten different prices. The highlighted price in the price list is the price this customer should be charged according to the price schedule in the customer setup. See the sample of the Customer Maintenance screen. The default price level section is where customer pricing is set up. If you have assigned a special price for this item, that special price would be shown in the upper right-hand corner. (See discussion of special pricing in the Inventory Manual). Press Enter to add the item to the order. Enter the number ordered, and the number shipped.
The cursor then goes to the price code field. It defaults to the price level assigned to the customer for inventory in customer setup. However, you can (O)verride this price by typing an "O" and manually entering a price. You can type in any of the other prices shown also.
Price Codes Price Codes are as follows:
A through
J
P = Promotional Pricing (set up in
inventory module)
H = History Price (this is the price this customer has historically
paid for this item)
O = Override (using this code allows the operator to put in his or
her own price)
S = Special Price (see Inventory Manual)
To use the price code already there, press Enter.
The system then calculates the price times units shipped, puts that figure in extended amount, and also calculates the tax, if any. Subtotals are added to the totals. If you are shipping less than the customer purchased, you will create a back-order. When this happens, the particular line item will be highlighted. Highlighting is done so this line item stands out and you will realize you have created a backorder. The actual backorder will be created when the Post to Accounts Receivable program is run. This program will be discussed later.
Tax
Charges
Tax is calculated based on how the item is set
up in inventory. It can be either taxable or non-taxable. You may, however,
have a customer that is non-taxable and is setup as non-taxable in the customer
maintenance screen. No tax will be charged on a non-taxable customer, even if
the item is set up in inventory as taxable.
If you enter a non-inventoried item, and the customer is taxable, you will be prompted to enter whether to tax the item. Enter the appropriate response at this point. Check with your manager if you are not sure.
Please check all help screens when available, in any program, for more detailed information. Top.
Most of the following features that will be discussed can be accessed through the help screens. Samples of these screens were shown earlier.. These are just a few of the options available. Check the help screen for more options.
More
than six line items on an order:
If there are more than six lines on an order,
the order splits into additional screen "pages" (see the lower left
corner of the order for the page number you are on). To see the first page of
the order, while your cursor is in the footer section of the screen, press the
up-arrow key. Use up-arrow and down-arrow to get to the page you want. When
you get to the second page, the line item numbering starts over.
To
cancel the line you are working on:
While your cursor is on the status field, press
<F2>. This will bring your cursor back to the status field.
To
delete a line that has already been added to the order:
While your cursor is on the status field, page
up or down to get to the page the item is on. When you are on the right page,
type D for Delete, type in the line number to delete, and press Enter.
The item is removed, and the order recalculated. However, the line is not re-used.
New line items will be appended.
To
change an amount ordered or shipped or change a price charged:
While your cursor is on the status field, type
E for Edit and type in the line number. The cursor jumps to that line.
If the item is an inventory item the cursor will jump to the "ordered"
field. Make the appropriate changes and Enter through. The order is then recalculated.
If the item was not an inventory item, you will have access to all parts of
the line. If it is an inventory item, you can only change the quantity ordered,
shipped, price and cost.
To
add a note to an order:
While your cursor is on the status field, type N for Note.
You will get a window where you can add your notes. Press <F9>
when done. This note will only print on this particular order. See the section
on Messages for information on how to have messages print on every order,
as well as the section on "Body Notes" in company setup for other
types of messages. Only a total of four lines of notes will print on an order.
To
change data in the heading of the order:
While your cursor is on the status field, press
H for Heading. The cursor jumps to the top of the screen where you can
change any and all information in the heading area. This includes ship-to information
(even from a ship-to table).
To
change data in the bill-to area of the order:
While your cursor is on the status field, press
B for Bill-To. The cursor jumps to the top of the screen where you can
change any and all information in the bill to area. Check with your manager
before making any changes in the section.
If
you want to add a non-inventoried item to an order:
While your cursor is on the status field, press
A to add a line to the order. Type in a made-up item number, or use the
item number "SPECIAL". Your cursor goes to the description field.
Type in the description of the item, press Enter to get to the amount ordered
and shipped. You then must fill in the price. You will then be prompted for
the item cost and whether it is taxable.
Check with a manager before doing this. This will not save this entry in the inventory master file. It is only for this one time use.
To
insert an item into an order:
While your cursor is on the status field, type
I for Insert and enter the line # where you wish to insert your item.
This will insert your item before the line # that you choose.
When
the system prompts you for the cost of an item:
This happens because when the item was set up
in inventory, the cost was not set up. It will also happen when you are entering
a non-inventoried item with a price. Typically, this should not happen. You
should notify management about this so it can be corrected. However, some companies
prefer to have the system prompt you for cost. It is a management decision.
In either case, you should find out the cost of the item so it can be entered
here.
When
the system asks if an item is taxable:
This will happen when adding a non-inventoried
item. It will ask is it (T)axable or (N)o. Enter the appropriate
response.
Adding
"freeform text" after a line item:
At any point on a blank item line, enter to the
description field, type in what you want and hit Enter. Do not enter an item
number or hit Tab, as the system will think you want to search for an "item".
This "freeform text" will print on the order, invoice and/or quote.
You can type in as many "freeform text" lines as you wish.
Override
credit limit/credit hold:
If your customer has exceeded its credit limit
or has been put on credit hold, you will be prompted to type in the override
code during order entry. Typically, management should decide whether to proceed
with processing of this order. The code should not be made known to everyone.
Ask a manager for the method for determining the code or to override it.
Printing
Shipping Labels:
The option to print shipping labels is available
through the order entry menu. Select Print Shipping labels from the menu. Once
in the program, type in the customer number for whom you wish to print a label.
You can have the program print more than one label. Make sure you have labels
in your printer. You can also add comments to your label from this program.
Top.
View Customer
Account Activity
While in order entry, you can look at the customer's account in detail.
Press <F8> from the bottom of the order entry screen. See the screen
below. First, you will see all open invoices, then you have further choices.
Other Options Available by Pressing:
<F2>
to view A/R summary aging to view A/R summary aging
<F3> to print a statement on white paper
<F4> to view notes
<F6> to see only open invoices
<F7> to see only paid invoices
<F9> to see all activity
You can also view archived invoices by selecting the line item.
<Esc> to exit this screen
You can select the line item number of an invoice you wish to view and the system will put you into that archived invoice to view its' contents. Top.
When you are done entering your order, you have a few choices.
While your cursor is on the status field, type S for Status. You have four choices here.
1) (E)ntered - You can change a quote to an order by choosing E from the status selection. Your quote will then become an entered order. Quotes will be discussed later in this manual. When you have entered an order without going through the quote process, you will note on the top of your order that it already has a status of "E". This means that as soon as you enter the information, an order number is assigned and it becomes an entered order. So, if your order already has a status of "E" when you are done, and you do not wish to invoice at this time press <F9> to clear the order from the screen.
2) (P)ick-Ticket - Selecting P will print a pick ticket immediately. Be sure the appropriate form is in your printer. A pick ticket is essentially an invoice without prices for use by your shipping department. You do not have to print one. A pick-ticket also shows the number of times a pick-ticket has been printed, along with the date and time it was printed and by whom. This is so that the shipping department can find out why there may have been more than one pick-ticket printed to avoid duplicate shipping. You may also see Inventory Messages on pick-tickets, if they were set up. (See Inventory manual for more information). Once you print a pick-ticket, press Enter. This completely clears the order, but does not invoice it. The order can still be edited. The status on this order will now be "P" because it was printed as a pick ticket.
3) (I)nvoice - This turns the order into an invoice and updates inventory simultaneously. This means you can no longer edit the order. An invoice will be printed later when you run the Print Invoices Program. You may also print the invoice from the order entry screen by typing P when your cursor is on the status field. Accounts receivable will be updated when you run the Post to Accounts Receivable program. You will need to do a credit memo to reverse an order invoiced by mistake. (See the discussion on credit memos for details).
4) (V)oid - This completely wipes out the order, even if you have already printed a pick-ticket. the order number is not reassigned. After post to A/R is run, all reference to this order will be gone. You cannot void an invoice.
This is a fully completed order, with the Status of "I".
When you type (S)tatus, then (I)nvoice, your cursor goes to cartons, via, date shipped, whse and freight fields. Enter in the appropriate information. Then the system will say "Updating Inventory", and finally "View Only". Your cursor will be on the right next to View Only. Here, you can type P to print this invoice immediately (make sure you have forms in the printer to do this). But normally, you would just hit Enter.
This invoice is now ready to be printed. You cannot edit this invoice now. Once the status is changed to (I), you would have to do a credit memo to clear it out. That is why the system lets you keep open orders until you are sure they are correct. You control when the order is changed to an invoice. See Print Invoices section for printing information. Top.
The Order Entry module contains a feature called "Quotes". With quotes, you can enter in a quoted order to a customer for any item in your inventory, and items that are not in your inventory. When you print the quote out as a pick-ticket, prices will print, and the word "Quote" will clearly be printed. A quote can be turned into an order at any time. A quote can be edited, and once you turn it into an order, the order can be edited. A quote can be voided by changing the status from quote to void.
Quotes can also be entered and used as "blanket orders". That is, orders that are essentially the same can be entered as quotes and changed into orders as many times as needed. This is a very helpful feature when a customer continuously orders the same item from you.
To enter a quote, while at a blank screen in Order Entry, press <F5> and then <F9>. It will show **** QUOTE MODE **** at the top of the screen. All functions of quotes are the same functions available in order entry. No special instructions are required. To view all open quotes, you must first get to a blank screen in quote mode. Press <F6> and enter Q at the enter status prompt. This is just like looking for all open orders. (See editing an order section for a sample screen.) Top.
A credit memo is simply an invoice with negative numbers in it. All you need to do is enter an order the same as you normally would. In the purchase order section of the heading, you may want to indicate here "credit memo" or something that will help you identify it as a credit memo. This will help you identify this item in the customer's activity screen.
When you enter the item (or items) you want to give credit on, enter negative numbers in the ordered and shipped columns. The negative sign should be typed first, then the number you are giving credit for. The order is the same after that. It is discretionary, however, whether you want to credit shipping costs. If you do, remember to enter a negative number. Then simply invoice the order as normal.
You must, however, remember to "keyoff" the credit memo against the original invoice in Accounts Receivable - Cash Receipts. When the credit memo is invoiced you will notice at the top of the form, it will say CREDIT MEMO with the number. The advantage to using credit memos as to making adjustments is that a credit memo will reverse the charges to all the original accounts while leaving a "paper trail" of what happened. This may be very important when viewing sales totals, or at a later date when you need to review this transaction. Top.
The option to setup quotes for recurring sales to be billed automatically is available through order entry. You may have something that is billed once a year, every quarter or every month. These can be set up through this process. This option is only available for quotes not orders. To setup up billing codes, you must have your quote up on the screen and your cursor in the footing area. As is stated in the help menu in quote mode for the footing area, type B. This will bring up the following screen:
|
Billing Codes A Code of M = Monthly Billing A Code of Q = Quarterly Billing A Code of Y = Yearly Billing Any other letter from A to Z, with the exception of M, Q & Y, may be used for special billing cycles. Enter Billing Code: |
Enter the code you wish to use. A code of a M or a Special code will complete the setup process. It will then bring you back into your quote. Please remember that for Special Billing, you cannot use an M, Q, or Y. These are designated for Regular Billing. A code of Q or Y will bring you into the following screens:
Q=
|
Billing Cycle Enter Month of Quarter (1,2, or 3) |
Y=
|
Billing Cycle Enter Month of the Year (1 to 12) |
Once you have made these selections, you will be brought back into your quote. You will notice in the heading area under status, it will show the automatic billing codes you assigned to the quote.
When you are ready to process your automatic billing and turn them into invoices, you will find that option on the order entry menu. Select Automatic Billing and Enter. The following is an example of this screen:
If you have selected a R - regular cycle, you will then be prompted to enter the month number you assigned to this particular batch of automatic billing. If you have selected an O - other/special cycle, you will then be prompted to enter the code letter you have assigned to this particular batch of automatic billing.
This converts all quotes scheduled for automatic billing into invoices. These invoices can be viewed, but not edited, through order entry until they are posted to Accounts Receivable. At that point they can be viewed through Archive Invoice screen in Order Entry. Make sure you have invoice forms loaded into your printer. Invoices will print automatically when this program is run. Top.
Cash/Check/Credit Card
When invoicing customers that have been set up without a credit limit, (ie. Cash Sales), the system will ask for a method of payment. It will pop-up the following screen into your invoice:
|
Cash Sale |
| Amount Tendered: |
| Total Amount Due: |
|
------------------- |
| Change ====>: |
|
Paid By |
| (1) Cash |
| (2) Check |
| (3) Credit Card |
| Select: |
If you want to give them a credit limit, do not enter any information at the prompt. Press <F9>, which will clear the order. Bring up the customer again and press <F7>. This will put you in the Accounts Receivable, Customer Maintenance screen. Enter the new credit limit and press <F10> to save. Escape and this brings you back in to order entry. You can now bring up the order and invoice as normal. It will not ask for cash/check/credit card.
If this is what you want, you can enter the appropriate payment type. You can enter more than one if that is how the customer is paying. Enter in either (1)cash, (2)check or (3)credit card. If you choose a payment by check, you will be prompted for the check number and amount of check. If you choose a payment of credit card, you will be prompted for card number, authorization number, and expiration date. If your customer is splitting the payment, do not enter the entire combined payment. Example, if they are paying $50 by check and $35 by credit card, you would enter (1)cash, then $50.00 under "payment amount". Then your cursor would go back to the payment type window. You would enter (3)credit card, go to the payment type and enter $35.00. The system would stop and tell you the change to give if applicable. When you are done, hit Enter. Top.
Pulling Up A Back Order
If you want to look up any order regardless of status, you can pull it up several ways--listing all, or searching through individual orders by customer. To look up an order that has not yet been posted, you must be at a blank order entry screen.
To list all orders: Press the <F6> key. This will bring up the following screen:
To see all open items at this time, press Enter and it will list all open and unposted orders.
Cursor is at (S)tatus, which will allow you to select orders by status code. The codes are:
(I)nvoice
(E)ntered order
(Q)uote
(P)ick-ticket
(B)ack order
(O)rder printed with pricing
(D)eposits
Type in the code you want and hit Enter. This will bring up a list of orders under that code.
(D)eposits will show you all orders that have deposits on them, but which have not been paid off. (Therefore, they are still orders, not invoices.) To select the order you want to see, type in the line number of the order you want to see and hit Enter. The order will then be brought up. Any order except those with a Status I or V can be edited. Status I or V orders can only be viewed. Invoices, orders with a status I, will print when you run the Print Invoices program. You cannot void them at this point.
Orders with a status P can be edited just like a status E. Once you select a status P order, you will note on the bottom right information about the pick-ticket, such as who printed it, how many times, and the last date and the time it was printed.
2. To
search through individual orders:
This can be done two ways - you can just pull up the order number
(if you know it), or you can pull up a customer and then show any orders.
If
you know the order number:
On a blank order screen, press <F8>. Your cursor
jumps to the order number field. Type in the order number and press <tab>.
The order comes on the screen. At this point you can enter through the heading
information and make changes if you need to or you can press <F7>
to bring your cursor to the status field to work from here. If you have brought
up the wrong order number, use PgUp or PgDn to "scroll" through other
orders.
If
you know the customer, but not the order number:
On a blank order screen cursor is in the customer field in the
bill-to section. Enter the customer, and hit <tab>. (PgDn will
also work here.) You may also use any of the other search options previously
discussed. Once your customer is up, it will display at the bottom of the screen
how many orders and quotes are in process for the customer. Press <F6>
and this will list all open items for this customer. Type in the line item of
order you wish to see and press Enter. This will put you in that order.
Once you find an order you want to edit, go ahead and do what it is you need to do. If you are completely done with it, change the (S)tatus to (I)nvoice. Otherwise, it will not print when you run "print invoices" program. Top.
All orders with a status of "I" will be available to print. Load your invoice forms in your printer. This program will print all invoices that have not been posted. The following is a sample screen of print invoices, which can be accessed from the order entry menu:
You can choose to print invoices that have been printed before or choose not to print those invoices again. You may also choose to print the invoices individually or in a group. If you are printing all invoices, just enter through and type C to continue. The invoices will then print. If you are printing specific invoices, type in the invoice number and hit Enter. The invoice will then print. You can type in more invoice numbers and keep going. When you are finished, hit <Esc>.
If any invoices are incorrect, remember that you cannot edit these. The easiest way to correct an invoice would be to do a credit memo for the incorrect one, and then re-do the order and invoice it. See the credit memo section for details. Just remember to keyoff the credit against the original incorrect invoice in the Cash Receipts program. For further details on this program please refer to the Accounts Receivable manual. If something happens when printing invoices, you can reprint these invoices by answering yes to "print invoices that have already been printed". Top.
This program allows you to enter messages on orders, invoices or cash register pole displays. It also allows you to generate ASCII files for UPS for those using our UPS Shipping module. to access these programs, select Order Entry Utilities from the Order Entry Menu. The following screen will come up.
| Messages on O/E Forms |
| Screen and Pole Displays |
| Generating ASCII File for UPS |
| Regenerating ASCII File for UPS |
You will then have to option of choosing "Messages on Order Entry Forms" or "Screen and Pole Displays" to enter messages. The following is an example of messages to be printed on forms. The purpose of this module is to allow you to enter messages which will print on the bottom of every invoice printed.
Your cursor will be on the first invoice message line. Type in the message, hitting the Delete key on the keyboard to take out extra characters. You can enter two lines of messages that will print on an invoice. The ticket message is to print a message on the pick ticket. This message will show on a printed pick ticket. The Receipt message only applies if you have a point-of-sale system with a cash register. This will print on customer receipts. Press Enter after each message, then press <F10> to save the messages. Press <Esc> to go back to the menu.
The other message option available is Screen and Pole Displays. This will allow you to enter messages to popup in Order Entry and Pole Display messages for Point of Sale systems.
The order entry message may be used to remind the operator of a special promotion, sale, etc. This will not print on the order or when it is invoiced. It is just for the operator to view. The pole Display message will appear on the cash register pole display to be viewed by the customer. It will not print on the order or invoice.
Another "message" or notice you may wish to have printed on the customer's invoice is their individual aging. This is an option you can select through the company setup. Please check the company setup manual for information.
The other two options available through this program are to generate ASCII files for UPS. These are used by customers who have the UPS shipping module. Top.
This module is on the Order Entry Menu. It is extremely important that it be run before you Post to Accounts Receivable. The system will make "copies" of certain files in order entry and store it in another area of your hard disk. In case of problems during Post to Accounts Receivable, you can restore from this alternate area. This will get you back to the point you were before you ran the Post to A/R program. If you do not backup to alternate area and there is a problem, you may lose all of your work. If this program is not working, please call ECS for assistance.
If you do not backup to alternate area and there is a problem, you may lose all of your work. If this program is not working, please call ECS for assistance.It is also recommended that regular backups be done outside of this particular one. You should not avoid that step. When your system was set up, you received instructions on how to do daily backups to tape or diskette. If you are not doing this, please call ECS for assistance. Top.
Posting Invoices To Accounts Receivable
After you have printed invoices, you need to post these to Accounts Receivable. This is available through the Order Entry menu. All orders with a status "I" will be posted, even if the invoice was not printed!!!
REMEMBER TO BACK UP TO AN ALTERNATE AREA BEFORE POSTING.
Choose Post Invoices to Sales and A/R. This will take you to the posting screen. At this point you can (C)ontinue or (A)bort. This will transfer the invoices from order entry to archive invoices. It will also post the financial information to sales and all other appropriate accounts. Posting should be done at the end of each day. Make sure you have blank paper in your printer as this will automatically print a report when it is finished posting. Once this program is run, any and all back-orders created during this billing cycle will be assigned order numbers and will now show in Order Entry as open orders. Top.
This allows you to reprint your most recent posting reports. This is a valuable feature in case of printer problems during your posting or if you have misplaced you report. Once you select this option from the menu, it will automatically reprint your last posting reports. Make sure your report printer is set up properly. Top.
As was explained in the section on Posting to A/R and Sales, the invoices are moved to Archive Invoices. Any invoice that was posted can be looked up through Archive Invoices. This feature allows you to view all past invoices.
How to access archived
invoices:
At a blank order entry screen, hit <F10>. This will put you in
archived invoices. At this point you can search for a particular invoice in
a few ways.
1)If you happen to know the invoice number, hit Enter at this time. The cursor will move to the order number section at the top right hand side of the screen. Enter the invoice number and <tab>. This will bring up the invoice number that was entered or it will find the next closest invoice number. Page up and page down will allow you to scroll through the numbers in chronological order.
2)If you know the customer name you can search, as in order entry, by typing in a part of or the whole customer name and <tab>. This will bring up the oldest invoice on record for this customer. Use page up and down to scroll through all of the archived invoices for this customer.
To view invoices with more than one page, press <F7> and use the up and down arrows to scroll the pages.
3)If you know the approximate date of the invoice, use <F6> to search by date range. You must be at a blank archive invoice screen. This screen is very similar to the example shown in the editing orders section. Enter the date range and Enter. If you know the specific customer you can enter that information here as well. Hit <Esc> and enter the line item number of the invoice you want to view and enter. This will bring up that specific invoice.
Once you have found the archived invoice you are looking for, press <F7> to bring you to the status field. At this field, the up and down arrows will allow you to scroll through invoices that are more than one page. To print a copy of an archived invoice, press P at the status field. Be sure to have invoice forms in the printer because this will print automatically. Top.
One of the many features in BMS software is tracking sales by advertising. You can enter any and all of the advertisements you have running in the system. This is linked to order entry so that you can add or edit ad source for each customer. This will allow your company to track sales by the different advertisements you had placed.
Select Ad-Key Code Maintenance from the Order Entry menu. The screen for the ad source program is as follows.
At a blank screen, enter the information for your current ad. Once you have entered the information, you need to add the inventory items that are on sale through this ad. Press <F3> to copy items and prices from a previous ad to the new one.
To enter the items for a new ad, press <F7>. From here you can enter the items on sale in this ad and you can assign pricing by quantity breaks for a particular item. The system allows for up to three price/quantity breaks. This can be done for a certain ad or done under the DEF default ad, which can remain in place for however long you wish and be applicable to customers not responding to an ad. Pressing <F2> from this screen will allow you to delete or edit price/quantity breaks previously entered.
Once the ad has been running and sales have been generated by it, you can view the sales figures by week for this ad. You may also view a sales analysis by pressing <F6>. This will show the sales in dollars & units for invoices generated by this specific ad source code. Top.
The following are menu selections of reports available through Order Entry.
|
Reports |
| Back Order Detail Report |
| Back Order (by Product) |
| Back Order (by Order) |
| Orders Due (by Item) |
| Orders Due (by Customer) |
| Sales Commission by Salesman |
| Sales Report |
| Sales Journal By Date Range |
| Sales Journal By Order Number |
The following is a brief description of each report as listed on the above menu.
1)Back Order
Detail Report
This report will list all item on order that are a Status "B"
(backordered), sorted by customer.
2)Back Order
(By Product)
This report will list all item on order that are a Status "B"
(backordered), sorted by item.
3)Back Order
(By Order)
This report will list all item on order that are a Status "B"
(backordered), sorted by order.
4)Orders Due
(By Item)
This report will print a list of open orders within the date range selected.
An open order is an order or invoice that has not yet been posted. Enter a range
of item number that you want covered in this report. You may also select to
print orders with a certain status or all orders.
5)Orders Due
(By Customer)
This report will print a list of open orders within the date range selected.
An open order is an order or invoice that has not yet been posted. Enter a range
of item number that you want covered in this report. You may also select to
print orders with a certain status or all orders.
6)Sales Commission
by Salesman
This report shows sales based on a salesman number or operator code. The
report can be broken to print for a specific customer or a specific item or
run for all items. The report will list the item number and description, invoice
number it was purchases on, date, quantity, price and price code. This report
will print right away.
7)Sales Reports
This option will bring you to an additional menu with further options. A
sample of this menu is shown below.
8)Sales Journal
By Date Range
This report prints a journal for all archived sales within the date range
entered by the operator.
9)Sales Journal
By Order Number
This report prints a journal for all archived sales within the order number
range entered by the operator.
The following is a sample menu of the options available when you select Sales Reports.
|
Sales Reports |
| Customers Last Purchase Report |
| Customer Price List |
| Company Sales Per Month |
| Sales History by Customer |
| Sales History Variance |
| Sales by Year by Product |
| Sales by Year by Cust. by Prod. |
| Sales by Date Range |
| Sales by Date Range by Product |
The following is a brief description of each report as listed on the above menu.
1)Customer Last
Purchase Report
This report prints a list of all customers who purchased between a specific
date range. This report will print customer, phone number, balance, date and
amount of last purchase. Report can be printed by salesman or for entire company.
2)Customer Price
List
This report prints a list of all items a customer purchased. This report
allows you to select all customers by salesman or just one specific customer.
This report will allow you to select customers by sales figures, to print profit
margins, last sale price, credit limit and aging.
3)Company Sales
Per Month
This program shows company sales month by month, year by year.
4)Sales History
by Customer
This report will print a sales history by customer, product, sales amount,
year, and other options.
5)Sales History
by Variance
This report will print a sales history by variance by customer and/or product.
6)Sales by Year
Product
This report will print a sales history by year by product.
7)Sales by Year
by Customer by Product
This report will print a sales history by year by customer by product.
8)Sales by Date
Range
This report will print a sales history by date range.
9)Sales by Date
Range by Product
This report prints a sales history by date range by product.
These reports are easy to use and most are self-explanatory. To select the report you want, move your cursor to that report and hit Enter. If you select the wrong report or chose not to run it at this time, just <Esc> to abort the report. There may be other options available, depending on the report. Check the bottom of the screen to see if there are options for a particular report. Top.