310 likes | 433 Views
Inventory Item Setup & Constants File. Setup of Fine Line Code Department Items. The difference between Fine Line Codes and Departments. FLC are assigned to G/L numbers, Dept aren’t. Fine Line Code Setup. A FLC for every sales G/L number Set up saves time and accuracy adding items
E N D
Inventory Item Setup & Constants File
Setup of • Fine Line Code • Department • Items
The difference between Fine Line Codes and Departments FLC are assigned to G/L numbers, Dept aren’t
Fine Line Code Setup • A FLC for every sales G/L number • Set up saves time and accuracy adding items • All Inv and Sales report selections allow for FLC selection • FLC more detailed than department • Group FLC with same G/L# groups together • If not using FLC now is the time
Department Setup • Departments are NOT Locations • Departments allow you to quickly and easily select items your want on a report. • A price listing will skip to a new page for each department. • Sample agronomy department list • Bulk fert • Liquid fert • Herbicides • Insecticides • Corn Seed
General Ledger Misc Hardware General Ledger Steel Yard General Ledger Feed General Ledger Animal Health FLC Hand Tools Buckets Chicken Waterers Chicken Feeders Pet Bowls Pet Toys Collars FLC Field Fence T-Posts Livestock Panels Chicken Wire Gates Water Tanks FLC Dog Feed Cat Feed Cattle Feed Sheep & Goat Feed Chicken Feed Pig Feed Rabbit Feed FLC Cattle Med Cattle Wormers Pig Med Pig Wormers Chicken Med Pet Med Pet Wormers DEPT Misc Hardware DEPT Steel Yard DEPT Feed DEPT Animal Health
General Ledger Misc Hardware General Ledger Steel Yard General Ledger Feed General Ledger Animal Health FLC Hand Tools Buckets Chicken Waterers Chicken Feeders Pet Bowls Pet Toys Collars FLC Field Fence T-Posts Livestock Panels Chicken Wire Gates Water Tanks FLC Dog Feed Cat Feed Cattle Feed Sheep & Goat Feed Chicken Feed Pig Feed Rabbit Feed FLC Cattle Med Cattle Wormers Pig Med Pig Wormers Chicken Med Pet Med Pet Wormers DEPT Cattle DEPT Chicken DEPT Pet DEPT Hog
Item Master File • Transfer # and Qty per Unit • Item Code
Item Transfer and Qty per Unit • Allows you to create different prices and sell the item by different unit of measure. Transfer Qty / Inventory Qty = Qty per Unit
Item Master File • Transfer # and Qty per Unit • Item Code • Minimum Amt ($15.00 delivery) • Manufacturer (chemical rebate) • Inactive Code (all locations) • Selling Item# • Lot Tracking • EPA#
F6 Mult UPC / Item UPC Number File Maintenance • Allows as many UPC codes as needed • Boots • Jeans • Pet collars • Checks for duplicate UPC codes • UPC can be used in inventory receivers, transfers, and purchase orders
F8 Vendor Items / Item Reorder Number File Maintenance • Reorder number is the Vendor’s Item number • The reorder number is usually on the packing list and invoice • Purchase Factor in the Item Reorder screen only effects quantity and cost when the reorder number and vendor number is used in the Purchase Order and Inventory Receiving screens.
F8 Vendor Items / Item Reorder Number File Maintenance • Reorder numbers can be keyed in as item numbers in Purchase Orders and Inventory Receivers • Reorder number will print on the Purchase Order and on the Receiver batch edit
Item Balance File • Purchase Factor in the Item Reorder screen only effects quantity and cost when the reorder number and vendor number is used in the Purchase Order and Inventory Receiving screens.
Item Balance File • Low price / High price • Beginning Balance • Selling Factor • Inactive Code (per location) • Promo pricing allows sales for a date range for all locations
Item Balance File • Valid margins enforced in counter invoicing • Default Margin allocates a cost of sales • Fuel Type used in contracting in AR
Changing Item Numbers • Allows a way to remove multiple items numbers for the same product. • Some keep the vendors item as their item. • Changes all purchase and sale history to the new item.
Creating Items in a new Location • Quickly create items into a new added branch location from an existing locations file.
Inventory Constants File
Inventory Constants File • Where merged inventory receivers post in the general ledger • How merged inventory receivers effect cost • How merged inventory receivers effect retail • Need to setup for each location in the company
Inventory Constants File • Accounting Method • Average • FIFO • Standard • Last • LIFO at EOY • Do you want to back order? • G/L number for AP
Inventory Constants File • The general ledger account for the accounts payable ledger account credited when you receive inventory that is not invoiced • Should not be the same account number as the one you use for regular accounts payable
Inventory Constants File • Answer Y allows the Retail in the Item Balance file to be updated when the IR batch is merged
Inventory Constants File • Enter ‘Y’ to set the retail that was changed in the receiver for the receiving location for all locations. • Enter ‘N’ if you want the retail to vary from location to location.
Inventory Constants File • Enter ‘Y’ if you want the received cost a one location to update all other location’s replacement cost in the Item Balance file when the IR batch is merged.
Inventory Constants File • N=Do not update the Inventory Cost file (U8ICOST) when Inventory Receivers are entered. The cost will be updated instead when the invoice is entered via AP. • Y=Update the Inventory Cost file (U8ICOST) when Inventory Receivers are entered. The cost will also be adjusted when the invoice is entered in AP.
Inventory Constants File • Use UPC at Receiving allows you to enter the UPC# in the Inventory Receiving screen and in Purchase Orders
Inventory Constants File • Use UPC at Transfer Time allows you to enter the UPC# in the Inventory Transfer screen • This allows entry of transfers from counter invoicing easier
THANK YOU Please fill out your Evaluation forms