Please enable JavaScript to view this site.

>Purchasing >Purchasing Worksheet >Generate Worksheet Button

 

If Purchasing menu is not active check the setting on >Maintenance >Acme Setup Information >Store Information tab

 

 

 

Generate Purchasing Worksheet

 

flag_greenKey Information
When you generate a worksheet, items already on the worksheet (if any) are not removed, they are re-calculated. If you wish to start fresh, empty the worksheet before generating.

 

 

 

 

GenerateWorksheet

 

 

 

Select Store Location(s) -If this is a Central Acme, choose the store(s) you wish to place orders for. If this is a single or satellite store then you cannot make a selection, you can only order for your own store.

 

Select Vendor(s) -choose the vendor(s) you wish to consider purchasing from.

 

Select Departments -choose one or more departments to work with.

 

Preferred Vendor --select only items that where the selected vendor (above) is the item's Preferred Vendor as designated on the Item's Purchasing tab.
 
OR -Select all items available from the selected vendor. This is only available when a single vendor has been selected.

 

Reorder Point -choose to..

Select only Reorder Point items. -these are items where the on hand (plus any on order) is less than or equal to the item's reorder point.
OR

-Ignore Reorder Point.

 

Item Purchase on Hold -Item's on "Purchase Hold" will not be added to worksheets. If you put an item on hold while the item is on a worksheet the item is not automatically removed from the worksheet. Re-generating the worksheet will not remove the item, you should empty the worksheet and then generate.

 

 

flag_greenReplenishment Math

 

 
Take Reorder Point (or Target Stock Level if higher)

Subtract On Hand Qty (if negative, subtract 0)

Subtract Qty on Submitted Orders
Subtract Qty on Suggested Orders

==================

Equals Suggested Order Qty for this order.
 
If the Suggested Order Qty is less than 0, the item will not be automatically added to the Worksheet. You can add it manually if desired.

 

If you ignore reorder point, you can choose to

Apply standard reorder quantity from the location or, if not set at location, from the item.

Apply Vendor Minimum Order Quantity (for the location)

Apply 0 Order Qty -assumes you will edit the quantity on the items you actually want to order.

 

 

prod_tipProductivity Tip
Do not overlook the power of "Apply 0.." -it allows you to create an list for everything the vendor sells you!
 
You can work with the list as a Worksheet or export to Excel, edit the spreadsheet, then import to update the worksheet.

 

Ignore Vendor Minimum Quantity button - only available if you did not select to ignore Reorder Point above. If checked, the Suggested Quantity to order will not take Vendor Minimum Quantity into consideration.

 

 

flag_greenTip
Reorder Point and Ignore Vendor Minimum Order controls are also available AFTER you Generate the Worksheet.

 

 
If you Generate a Worksheet then Work the Purchasing Worksheet and use "Auto-set Quantity" you can manipulate these controls and watch the order values change!

 

 

Next Step

 

Work the Purchasing Worksheet

 

 

Related Topics

 

Purchasing Worksheet -overview

 

 

 

 

Acme Point of Sale is brought to you by Total BusinessWare Inc.

  

Keyboard Navigation

F7 for caret browsing
Hold ALT and press letter

This Info: ALT+q
Page Header: ALT+h
Topic Header: ALT+t
Topic Body: ALT+b
Contents: ALT+c
Search: ALT+s
Exit Menu/Up: ESC