FIFO Unit Cost with lots

Rikarddo
Member Posts: 80
Hi all,
For what i understand NAV allows the item to be batch(Lot) tracked
Purchases:
Posting date = 01/01/2021
Item code = A
Qty = 1
Item cost = 1000
Lot No = A1
Posting date = 02/02/2021
item code = A
Qty = 1
Item cost = 2000
Lot no = A2
When we make a sales order :
Posting date = 03/03/2021
Item code = A
qty = 1
Item Price = 3000
Lot No =A2 ( that means system has to take the item cost = 2000 /-)
Is there any chance that using FIFO the system can always take in consideration the unit cost of the first item in stock?
In the above case the unit cost should be 1000 , although i'm selling the Lot A2
Thanks for the help.
For what i understand NAV allows the item to be batch(Lot) tracked
Purchases:
Posting date = 01/01/2021
Item code = A
Qty = 1
Item cost = 1000
Lot No = A1
Posting date = 02/02/2021
item code = A
Qty = 1
Item cost = 2000
Lot no = A2
When we make a sales order :
Posting date = 03/03/2021
Item code = A
qty = 1
Item Price = 3000
Lot No =A2 ( that means system has to take the item cost = 2000 /-)
Is there any chance that using FIFO the system can always take in consideration the unit cost of the first item in stock?
In the above case the unit cost should be 1000 , although i'm selling the Lot A2
Thanks for the help.
0
Answers
-
No, your example above is not possible, it will work on FIFO per lot basis.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