Howdy, Stranger!
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
- 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
- 304 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
- 260 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Unable to credit a purchase prepayment
MBClarke
Member Posts: 71
Hi,
My client has an issue with trying to credit a prepayment PO. The scenario is below, they are currently running an Azure cloud version. There version is CA Business Central 19.5
The scenario is as follows:
A PO was created and a 100% prepayment was posted. Purchase & Payable setup allows them to receive etc on the PO without paying the prepayment. Once the prepayment invoice was posted, we can see it on the Vendor Ledger Entry table, document PP-13. The warehouse user then went into the PO and realized the PO was wrong, and without checking anything re-opened the PO, changed the quantity on one line and released again.
The finance team picked this up, so they re-opened the PO again, changed the line back to the original quantity and then tried to post a prepayment credit, but when they do that they get errors.
Error is:
Prepayment Invoice must be equal to 'No' in Purch. Inv. Header: No.=PP-13. Current value is 'Yes'
We then tried to cancel the Invoice, or create corrective entries, and each time we get the following error:
Prepayment No. must be equal to '' in Purchase Header: Document Type=Order. No.=PO-10027. Current value is 'PP-14'
What I cannot understand is why is it referencing PP-14, when the prepayment invoice is PP-13? We have searched the entire system and there is no document PP-14. The No. series field for the prepayments has the last number as pp-14, but we cannot find that document. We cannot go into the PO header and remove it either as this is Business Central. When you zoom the PO document there are two fields that reference prepayment, one says 'Last Prepayment No. and that has a value of PP-13, and then another field Prepayment No. which is PP-14, which is the cause of the issue.
Please can someone let me know how to resolve and what one suggests we do to correct?
Thank you for your time.
Malcolm
My client has an issue with trying to credit a prepayment PO. The scenario is below, they are currently running an Azure cloud version. There version is CA Business Central 19.5
The scenario is as follows:
A PO was created and a 100% prepayment was posted. Purchase & Payable setup allows them to receive etc on the PO without paying the prepayment. Once the prepayment invoice was posted, we can see it on the Vendor Ledger Entry table, document PP-13. The warehouse user then went into the PO and realized the PO was wrong, and without checking anything re-opened the PO, changed the quantity on one line and released again.
The finance team picked this up, so they re-opened the PO again, changed the line back to the original quantity and then tried to post a prepayment credit, but when they do that they get errors.
Error is:
Prepayment Invoice must be equal to 'No' in Purch. Inv. Header: No.=PP-13. Current value is 'Yes'
We then tried to cancel the Invoice, or create corrective entries, and each time we get the following error:
Prepayment No. must be equal to '' in Purchase Header: Document Type=Order. No.=PO-10027. Current value is 'PP-14'
What I cannot understand is why is it referencing PP-14, when the prepayment invoice is PP-13? We have searched the entire system and there is no document PP-14. The No. series field for the prepayments has the last number as pp-14, but we cannot find that document. We cannot go into the PO header and remove it either as this is Business Central. When you zoom the PO document there are two fields that reference prepayment, one says 'Last Prepayment No. and that has a value of PP-13, and then another field Prepayment No. which is PP-14, which is the cause of the issue.
Please can someone let me know how to resolve and what one suggests we do to correct?
Thank you for your time.
Malcolm
0