Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.6K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 295 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
NAV 2013 - Amount must be negative in Gen. Journal Line ...
CGChief97
Member Posts: 6
NAV 2013 error message:
Here is what is happening in my case:
Purchasing created a PO with estimated freight charges and received all items including the estimated freight.
AP received the invoice and entered two additional lines to the PO. One to reduce the freight by $25 (a negative amount) and one to capture the prompt payment discount (also a negative amount). These additional lines have both been received.
AP invoiced the the original lines from the PO and is now trying to invoice the additional two negative amount lines. this is the action that is generating the error shown above.
It appears as if we are not doing this process correctly but now that we have started down this path, how do we correct it? We have tried transferring the negative lines to a credit memo (function) but NAV says there is nothing to transfer.
Thoughts? How do we unwrap this mess and what is the right way to process freight amount reductions and prompt payment discounts?
Thanks in advance!
I have reviewed the previous posts of this error in other versions of NAV but I am not sure I follow what needed to be done to resolve it.Amount must be negative in Gen. Journal Line Journal Template Name='',Journal Batch Name='',Line No.='0'.
Here is what is happening in my case:
Purchasing created a PO with estimated freight charges and received all items including the estimated freight.
AP received the invoice and entered two additional lines to the PO. One to reduce the freight by $25 (a negative amount) and one to capture the prompt payment discount (also a negative amount). These additional lines have both been received.
AP invoiced the the original lines from the PO and is now trying to invoice the additional two negative amount lines. this is the action that is generating the error shown above.
It appears as if we are not doing this process correctly but now that we have started down this path, how do we correct it? We have tried transferring the negative lines to a credit memo (function) but NAV says there is nothing to transfer.
Thoughts? How do we unwrap this mess and what is the right way to process freight amount reductions and prompt payment discounts?
Thanks in advance!
Best regards,
Paul
Paul
0
Answers
In working through this situation with my team, we discovered that:
1. The PO was posted as invoiced for everything except the adjustments (two negative lines)
2. Even though the freight charge line had been posted received, we would still be able to change the 'unit cost' amount to reflect the actual invoiced freight charges (prior to invoicing the PO).
3. The prompt payment discount line of 1% only applied to the materials and not to the freight so this either needed an negative amount line to be received and posted with all of the other lines OR it needed a purchase credit memo (this was our case).
In this case, to get past the posting error, we simply changed the 'unit cost' amounts to zero prior to posting as invoiced. Then we created and posted a purchase credit memo to account for the adjustments. =D>
](*,)
Paul