Hi All -
BACKGROUND / CONFIG - Currently our account is configured as 'always allow per line classifications on journal' = T. We also have location as both a body field and a column field on our sales orders and purchase orders. We use multiple inventory locations to manage our Retail (Location: Retail) and Wholesale (Location: Wholesale) inventory, so we have quantity of most items in both locations.
QUESTION - I would ideally like location to be specified at the body level and then to have that location apply to all line items and not require staff to set the location with each item they add to an order. I am referring specifically to inventory locations as in the location to/from which item quantities are received/fulfilled - not necessarily for reporting/classification purposes.
Is this possible? If so, what is the best way to go about this?
Some more specific questions -
1 - If I remove the column location field from sales orders, will the line items then refer to location specified in the location body field?
1b - If so, how is this information stored? I have many saved searches written that refer to the inventory location field on line items - will those be affected at all - does this field still store the information?
search formula example: case when {transaction.type} = 'Sales Order' and {transaction.custbody3} = 'Wholesale' and {inventorylocation} = 'Inventory: Retail' Then nvl({transaction.quantity},0) end
(this is actually from an item saved search - convoluted way to get an item by item sales analysis - but I use this same logic to sum roughly 15 different columns)
2 - I am positive that many old orders have different locations set at the body vs. line item fields - for example an order might have 'Inventory Location: Wholesale' set at the body field but the line items may have been set as 'Inventory Location: Retail' - however I am certain that no single order has line items that reference different locations. Will these existing and already fulfilled & billed transactions be affected if I remove the location column field? Must I adjust the body level location to match the line item locations if I want to make this change?
3 - How does the 'always allow per line classifications on journal' option in Setup>Accounting>Accounting Preferences come into play?
Normally I would just go ahead and change the configuration and test transactions and reports, but my instincts have me concerned that such changes could have immediate impact on both open and closed transactions - this would not surprise me.
Any guidance/thoughts much appreciated - thanks in advance.
Pete