Does anyone know if you can make multiple prepayments on a purchase order? We have an order where we prepay when the product is released but it was all ordered on one PO originally. All payments associated with this PO will be prepayments.
Awhile ago I tried this and it worked... Note that you cannot have Approval Workflow on the Purchase Order.
Thank you so much for your response. When I try to edit the Prepayment % or Premt. Line Amount Excl. Tax (I don't have the option to add Prepmt. Line Amount Excl. VAT to my view) I get the following error:
I have tried using designer on the web client and customize in the rich client to see if I can add Prepmt. Line Amount Excl. VAT but I am unable to find that field at all.
Do you know why this might be happening? We are on BC13, I forgot to mention that in my initial post.
------------------------------Lillie BerryBrew Dr. Kombucha------------------------------
Wow. I am opened my old NAV database, not BC, and it worked.. I then tried in a BC 17.2 version and it did not work and I received the same message you did. I am questioning whether back in this NAV 2018 database a programmer steps in to remove the validation (error message). I have submitted a ticket to Microsoft to see if this could be added to a future release. My apologies for sending this reply as I thought this was functional.
In the meantime, I did, in BC 17.2 test the following and it did work:
1. Created a PO with a Prepayment Purchase Line record and amount. I then entered the 1st Prepayment amount in the % or Amount column as 100% of the amount and Posted the Prepayment
2. Below you see the Prepayment of 250 under the Prepmt. Amt. Inv. Excl Tax column.
3. Below I repeated a prepayment for the 2nd Purchase Line and posted the prepayment. I repeated this a 3rd time and on then when the Items Received Post Receive and then final Invoice arrived Post Invoice.
My apology again for answering the original discussion with something that was unknowingly modified. The above is not very streamlined but does accomplish the multiple prepayments against a single PO. Hopefully we will see the correct way in a future release.
Thanks and Happy Holidays,
------------------------------Lillie BerryBrew Dr. KombuchaOriginal Message:Sent: Dec 22, 2020 05:00 PMFrom: Steven ChinskySubject: Multiple Prepayments on a Purchase Order
If I recall correctly, per @Thomas (Tom) Blaisdell, the multiple prepayment functionality was removed because of complications with the tax calculations.
Thank you so much for the update... I was scanning all my old prepayment emails and wondering what the culprit was. Glad you kept the notes :) !!
Hi its not the best solution but we create a line in the PO for each payment and receive each line as payment is due. Everything else we've tried seems to create more complication.
If you've found this thread useful, dive deeper into User Group community content by role