Download the PDF below for the full article on How to Set Up and Manage a Nonperpetual Inventory in 9.1

To open file, right click and choose to open link in new tab or window

B1_NonppInvSys_91.pdf


Table of Contents

Introduction ........................................................................................................................................... 4
Calculation Methods in a Nonperpetual Inventory System ................................................................... 4
Setting Up a Nonperpetual Inventory .................................................................................................... 6
Working with Sales and Purchasing Documents in a Nonperpetual Inventory System ........................ 8
Updating Prices in Open Documents .................................................................................................... 8
Working with Landed Costs Documents ............................................................................................... 8
Splitting Landed Costs Quantities ......................................................................................................... 9
Working with the Inventory Valuation Report ....................................................................................... 11
Generating Inventory Valuation Reports .............................................................................................. 12
Printing Inventory Valuation Reports .................................................................................................... 19
Examples of Inventory Valuation Reports for Different Calculation Methods ....................................... 19
Moving Average..................................................................................................................................... 20
FIFO…………. ..............................................................................………………...…………..…………..20
By Price List .......................................................................................................................................... 21
Last Evaluated Price ............................................................................................................................. 22
Allowing Negative Inventory in Inventory Valuation Reports.................................................................. 23
Inventory Valuation Report Special Cases ............................................................................................ 26
A/P Invoice Based on a Goods Receipt PO .......................................................................................... 26
Landed Costs ......................................................................................................................................... 27
Inventory Transfer .................................................................................................................................. 28
Inventory Revaluation ............................................................................................................................. 30
A/P Credit Memo .................................................................................................................................... 32
Italy: Working with a Purchase Accounts Posting System .......................................................................35
Defining Purchase Accounts ................................................................................................................... 35
Examples for Journal Entry Structures Used When Working with a Purchase Accounts Posting System ... 36
Goods Receipt PO and A/P Invoice ........................................................................................................ 36
Goods Return .......................................................................................................................................... 37
Closing Goods Receipt PO and Goods Return ....................................................................................... 37
A/P Credit Memo ..................................................................................................................................... 38
A/P Credit Memo Based on a Goods Return ........................................................................................... 38
Authorizations .......................................................................................................................................... 39
Database Tables Reference .................................................................................................................... 40
Appendix: Sorting Inventory Valuation Report Results ............................................................................ 41