Charging Inventory to expense

krvenkata
Member Posts: 154
Hi
We have a peculiar scenario in one of our implementation for a supermarket. The Shopping bags are purchased thru purchase module and stored in the central warehouse. These items have seperate Inventory account (Inventory - Consumables).
From the warehouse, it is transferred to all supermarkets. Till now the inventory is tracked for these items.
These items are not sold and is more used as bag for taking out the retail items. Now the client wants to transfer the inventory value as showroom expense. Now how can i handle this scenario..I dont want to directly credit the inventory -Consumables account (against the store code which is global dimension1) and debit the showroom expense code. This will affect my future reconciliation between item quantity and value.
Has anyone came across this scenario before and how it was handled? Any suggestions
Thanks
We have a peculiar scenario in one of our implementation for a supermarket. The Shopping bags are purchased thru purchase module and stored in the central warehouse. These items have seperate Inventory account (Inventory - Consumables).
From the warehouse, it is transferred to all supermarkets. Till now the inventory is tracked for these items.
These items are not sold and is more used as bag for taking out the retail items. Now the client wants to transfer the inventory value as showroom expense. Now how can i handle this scenario..I dont want to directly credit the inventory -Consumables account (against the store code which is global dimension1) and debit the showroom expense code. This will affect my future reconciliation between item quantity and value.
Has anyone came across this scenario before and how it was handled? Any suggestions
Thanks
0
Comments
-
krvenkata wrote:These items have seperate Inventory account (Inventory - Consumables).
What do you mean by "Inventory account"?krvenkata wrote:From the warehouse, it is transferred to all supermarkets. Till now the inventory is tracked for these items.These items are not sold and is more used as bag for taking out the retail items.
Do you mean that only the transferred qty is tracked and the items are not even "shipped"? If so, you have to handle that with the item journal.krvenkata wrote:Now the client wants to transfer the inventory value as showroom expense.
Unless you're not a bookkeeping clerk leave the posting of expenses to them. They should know how to handle that with the general journal. If the requirement is such that it should be done "automatically" then appropriate posting groups have to be set up and the bags have to be shipped and sold with every customer purchase (Price=0); optionally you modify the printout so they are not visible on the bill.0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions