Credit a Purchase Order -- Stuck

nverma
Member Posts: 396
Hello,
A Purchase order was created for an item (which is Lot tracked) for 6000 pieces. One of the staff members called the Vendor and agreed upon receiving 5800 pieces instead of 6000. However, the staff member forgot to change the quantity on the order. When the goods arrived at the warehouse, they received and invoiced all 6000 pieces. Goods were then moved to a different location and they were consumed. I can do undo shipment, since it's already been invoiced. I need to bring the quantity down by 200. I created a general purpose CM (for a G/L Account) to bring the amount of the invoice down for 200 pieces. How can I bring the inventory down by 200? I was thinking about doing an negative adjustment at the same cost of the original per unit cost. However, since the goods are lot tracked, I do not have a lot to apply this transaction against.
What should I do?
A Purchase order was created for an item (which is Lot tracked) for 6000 pieces. One of the staff members called the Vendor and agreed upon receiving 5800 pieces instead of 6000. However, the staff member forgot to change the quantity on the order. When the goods arrived at the warehouse, they received and invoiced all 6000 pieces. Goods were then moved to a different location and they were consumed. I can do undo shipment, since it's already been invoiced. I need to bring the quantity down by 200. I created a general purpose CM (for a G/L Account) to bring the amount of the invoice down for 200 pieces. How can I bring the inventory down by 200? I was thinking about doing an negative adjustment at the same cost of the original per unit cost. However, since the goods are lot tracked, I do not have a lot to apply this transaction against.
What should I do?
0
Answers
-
I was thinking to turn off Lot Tracking on Negative adjustment so that I can post the item journal line.
I am just not sure what repercussion this action will cause down the road.
Any thoughts?0 -
If the qty. on inventory is 200 too high, that 200 should still have a Lot No. - so you should be able to do a negative adjustment for that qty. using that Lot no.
Turning off Lot tracking is, as far as I know, not possible if there still is inventory in the system that is lot tracked - and I think it is a bad idea to even try.Jan Veenendaal0
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