Thursday, July 4, 2019

Set Class and Department Information in the Line Item Level of Inventory Adjustment Transactions

Answer:
The ability to designate a Class and Department in the line item level of an Inventory Adjustment transaction as well as an Inventory Worksheet is not yet available in the system.  This is discussed under:
Enhancement 131807:  Transactions > Inventory > Adjust Inventory:  Provide the ability to use per line Classes and per line department on the Inventory Adjustment Page
As an alternate solution, the user has (2) options:
a. Set the Class and Department in the main line level field of the Inventory Adjustment form but the line items that may only be added when recording the transactions should all pertain to the same Class and Department.

b. Not to set any Class and Department in the main line level fields of the Inventory Adjustment form but subsequently record a Journal Entry to appropriately reclassify all GL lines with no Department or Class designations to the correct class and department.

To illustrate:
Inventory Adjustment # 1 has the following GL account postings when a negative inventory adjustment was recorded:
(Correct Class: Retail | Department: Sales)

Loss from Damaged Goods (Debit) $1,000
                                   Inventory Asset (Credit) $1,000

-No Class or Department designated to the above GL posting.

To reclassify, we simply reverse the entry via (JE) then re-establish the balance of the latter accounts with the designated class and department.  The reclassification entry would be recorded as:

Inventory Asset (Debit) $1,000 | without a class and department
Loss from Unsellable Damaged Goods (Debit) $1,000 | Class: Retail | Department: Sales
                     Loss from Unsellable Damaged Goods (Debit) $1,000 | without a class and department
                     Inventory Asset $1,000 (Credit) | Class: Retail | Department: Sales

Note: The above entry may still be subject to the approval of the accounting department/management if such type of process is acceptable.

No comments:

Post a Comment