Screen Two on Inventory Maintenance

Field #

201: Labels - Enter "Y", "N", or "T" in this field. You may set a default entry by setting up SYS Config File, #5, Line 707. Also enter "Bar" in Line 204 to make barcodes print on barcode/price labels.

"Y" - A label may be printed for this item with a barcode.
"N" - A label may not be printed for this item.
"T" - A label may be printed for this item without a barcode.

202: Track - If you want to track the customers who are buying this item enter a "Y". If you do not want to track this item, enter "N" in this field. You may set a default in SYS Config File, #5, Line 711.

203: Status - A one character field that is defined by you. For example, you may want to enter an "O" for Out of Print.

204: Variance - A four character field that is automatically changed when changes are made on the on hand amount and the changes are saved. Will accept a three digit figure and show a minus amount.

205: Binding - A two character field where you enter a code for the type of binding. You may use Spring Arbor’s binding codes or use your own.

206: Analyze - This field has different variables:

"Y" or "blank" WILL analyze with the IVHR History Roll and WILL change the price with the Price Update program IVUP.

"N" WILL NOT analyze with the IVHR History Roll but WILL change the price with the Price Update program IVUP. Will not take the max/min fields to zero on IVR returns, when all items are returned.

"1" WILL NOT analyze with the IVHR History Roll and WILL NOT change the price with the Price Update program IVUP.

"2" WILL analyze with the IVHR History Roll and WILL NOT change the price with the Price Update program IVUP.

207: Taxable - Enter "Y" if item is taxable, or "N" if item is not taxable. Will default to "Y".

208: Promotion # - Enter the promotion # for this item. Will track items sold on a promotional sale.

209: Max Line Disc - Will default to 99 which will give up to a 100% discount on this item. A smaller amount entered here will only allow a discount % up to that amount.

210: Pub. Date - Enter the date the item was published.

211: Mo’s to Stock - Put in the months you want to stock the item and when a work order or an automatic order is made, the item will not be put on the order if you do not want to stock the item during the month you are making the order. Defaults to 01-12. If seasonal item, go to SYS Config File, #2 and put an "X" in the field after the department number so that these items will not be deleted when IVHR History Roll is run.

212: Returnable - One character field, defaults to "Y". If item is not returnable, put a "N". "N" will not allow the item to be pulled to a projected return report, IVR.

213: Return By - Enter the date the item must be returned by.

214: Tl Rtrn - If the item is put on a return request and merged, this amount will show how many were returned.

215: Multiples - A one character field. Enter a "Y" if used to keep count of multiple items sold that are not put on the computer as individual items.
(Example: Pencils.) Enter a "K" if the item you are setting up is a kit. Items with a "Y" or "K" in this field will not be pulled to be ordered on IVWO or IVO automatic orders.
(You may want to put a "1" in the analyze field so the item will not be analyzed with the IVHR History Roll program or price changed with the IVUP Price Update program.)

216: Date - The date of #1 Invoice (1st invoice back) will be entered here as the purchase order is merged.

217: Vendor -The Vendor Number of #1 Invoice will be entered here as the purchase order is merged.

218: Number - The Invoice Number of #1 Invoice will be entered here as the purchase order is merged.

219: Qty - The Quantity received on #1 Invoice will be entered here as the purchase order is merged.

220: Cost - The Cost of the item on #1 Invoice will be entered here as the purchase order is merged.

221: Date - The date of #2 Invoice (2nd invoice back) will be entered here as the purchase order is merged.

222: Vendor - The Vendor Number of #2 Invoice will be entered here as the purchase order is merged.

223: Number - The Invoice Number of #2 Invoice will be entered here as the purchase order is merged.

224: Qty - The Quantity received on #2 Invoice will be entered here as the purchase order is merged.

225: Cost - The Cost of the item on #2 Invoice will be entered here as the purchase order is merged.

226: Date - The date of #3 Invoice (3rd invoice back) will be entered here as the purchase order is merged.

227: Vendor - The Vendor Number of #3 Invoice will be entered here as the purchase order is merged.

228: Number - The Invoice Number of #3 Invoice will be entered here as the purchase order is merged.

229: Qty - The Quantity received on #3 Invoice will be entered here as the purchase order is merged.

230: Cost - The Cost of the item on #3 Invoice will be entered here as the purchase order is merged.

Setup - The date the item is entered on inventory will be entered here after information is saved. Cannot be edited.

1st Rec - The date the item is first merged into stock will be entered here when first purchase order is merged. Cannot be edited.

231: Lst Rec - The last date the item has been received will be entered here when the purchase order is merged.

232: Lst Ord - The last date the item has been ordered will be entered here as a purchase order is made for the item.

233: Sold #1 - The first date back when the item was sold will be entered here when item is sold.

234: Sold #2 - The second date back when the item was sold will be entered here when item is sold.

Cycle - Will compute the number of days since last sold and keep record of last two sales cycles. This field cannot be edited.

Turnover - The item must be in stock six months. Figures turnover based on the greater of stocking level or in stock amount and sales. This field cannot be edited.

235: Week # 1 - Sales for the current Week. When a customer returns item, will subtract the sale but will not go into arrears. Month to date will be accurate.

236: Week # 2 - Sales for the previous Week if the program IVHR Option 3 = Weekly Roll history update has been run.

237: Week # 3 - Sales for the next previous Week if the program IVHR Option 3 has been run.

238: Week # 4 - Sales for the next previous Week if the program IVHR Option 3 has been run.

239: Week # 5 - Sales for the next previous Week if the program IVHR Option 3 has been run.

240: Week # 6 - Sales for the next previous Week if the program IVHR Option 3 has been run.

241: Week # 7 - Sales for the next previous Week if the program IVHR Option 3 has been run.

242: Week # 8 - Sales for the next previous Week if the program IVHR Option 3 has been run.

243: Jan - January Sales for the last January completed.

244: Feb - February Sales for the last February completed.

245: Mar - March Sales for the last March completed.

246: Apr - April Sales for the last April completed.

247: May - May Sales for the last May completed.

248: Jun - June Sales for the last June completed.

249: Jul - July Sales for the last July completed.

250: Jan - January Transactions for the last January completed.

251: Feb - February Transactions for the last February completed.

252: Mar - March Transactions for the last March completed.

253: Apr - April Transactions for the last April completed.

254: May - May Transactions for the last May completed.

255: Jun - June Transactions for the last June completed.

256: Jul - July Transactions for the last July completed.

257: Aug - August Sales for the last August completed.

258: Sep - September Sales for the last September completed.

259: Oct - October Sales for the last October completed.

260: Nov - November Sales for the last November completed.

261: Dec - December Sales for the last December completed.

262: MTD - Month to Date Sales since the last IVHR Option 1 or 2 Monthly history roll was run.

263: GT - Grand Total of all Sales since the item was put on inventory.

264: Aug - August Transactions for the last August completed.

265: Sep - September Transactions for the last September completed.

266: Oct - October Transactions for the last October completed.

267: Nov - November Transactions for the last November completed.

268: Dec - December Transactions for the last December completed.

269: MTD - Month to Date Transactions.

270: GT - Grand Total of all Transactions since the item was put on inventory.

<F2> = Screen 1 - Press <F2> to return to screen one.

<F3> = Screen 3 - Press <F3> to go to screen three to see sales and transactions for the current and last year. See Screen below.

<F4> = Options - Press <F4> for Options. (S)ave, (D)elete, (C)ancel, (U)ndo, (Q)uit

(S)ave - (S) will save the information entered.

(D)elete - (D) will delete the item from inventory.

(C)ancel - (C) will cancel the Options window.

(U)ndo - (U) will undo the changes made or information entered.

(Q)uit - (Q) will exit the program.