1 / 31

Inventory Item Setup & Constants File

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

Download Presentation

Inventory Item Setup & Constants File

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. Inventory Item Setup & Constants File

  2. Setup of • Fine Line Code • Department • Items

  3. The difference between Fine Line Codes and Departments FLC are assigned to G/L numbers, Dept aren’t

  4. 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

  5. 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

  6. 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

  7. 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

  8. Item Master File • Transfer # and Qty per Unit • Item Code

  9. 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

  10. 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#

  11. 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

  12. 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.

  13. 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

  14. 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.

  15. 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

  16. Item Balance File • Valid margins enforced in counter invoicing • Default Margin allocates a cost of sales • Fuel Type used in contracting in AR

  17. 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.

  18. Creating Items in a new Location • Quickly create items into a new added branch location from an existing locations file.

  19. Inventory Constants File

  20. 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

  21. Inventory Constants File • Accounting Method • Average • FIFO • Standard • Last • LIFO at EOY • Do you want to back order? • G/L number for AP

  22. 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

  23. Inventory Constants File • Answer Y allows the Retail in the Item Balance file to be updated when the IR batch is merged

  24. 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.

  25. 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.

  26. 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.

  27. Inventory Constants File • Use UPC at Receiving allows you to enter the UPC# in the Inventory Receiving screen and in Purchase Orders

  28. 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

  29. ?

  30. THANK YOU Please fill out your Evaluation forms

More Related