web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Purchase Invoice payme...
Microsoft Dynamics NAV (Archived)

Purchase Invoice payment split

(0) ShareShare
ReportReport
Posted on by Community Member

I am not able to find a way to split one posted invoice into two/multiple separate payments with different due dates. I have seen something as a Spanish localization, but am looking for the standard NAV solution.

Does anyone know whether this is possible in NAV?

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Aleksandar Totovic Profile Picture
    Aleksandar Totovic 16,765 on at

    It is not possible in standard NAV solution. We made similar customization fr Serbian localization, but in standard it doesn't exist. And yes, this is great benefit.

  • Community Member Profile Picture
    Community Member on at

    What you can do is divide the "Qty to Invoice" by 2 for each item.

    Enter your Invoice number(A) & due date info - post.

    Then with the remaining "Qty to Invoice".

    Enter your Invoice number(B) & due date info - post.

    It will then create two invoices (A) & (B) with two due dates based on what you wanted.

    NOTE: when Qty's are divisible by two it's great else the two invoice amounts can be off just a bit.

    Also if you have alot of lines it can be a big job.

    So, long ago I made some small functions to split & unsplit (in case someone accidentally chose split in error)

    **WE use the MOD function incase the qty is an ODD #.

    Text1 = Would You Like To Split This Invoice?

    Text2 = Would You Like To UNDO Split Of Invoice?

    //Split Invoice

    OnPush()
    IF NOT DIALOG.CONFIRM(Text1,TRUE)
    THEN EXIT ELSE
    Purchline.RESET;

    Purchline.SETRANGE(Purchline."Document Type","Document Type");
    Purchline.SETRANGE(Purchline."Document No.","No.");
    IF Purchline.FIND('-') THEN
      REPEAT
       IF Purchline."Quantity Received" <>0 THEN BEGIN
        Purchline."Qty. to Invoice" := (Purchline."Quantity Received" / 2);
        Remainder := Purchline."Quantity Received" MOD 2;
        IF Remainder <> 0 THEN MESSAGE('Item %1 Needs Rounding',Purchline."No.");
        Purchline.VALIDATE("Qty. to Invoice");
        Purchline.MODIFY;
       END;
      UNTIL Purchline.NEXT = 0;

    //Undo Split

    IF NOT DIALOG.CONFIRM(Text2,TRUE)
    THEN EXIT ELSE
    Purchline.RESET;
    Purchline.SETRANGE(Purchline."Document Type","Document Type");
    Purchline.SETRANGE(Purchline."Document No.","No.");
    IF Purchline.FIND('-') THEN
      REPEAT
       IF Purchline."Quantity Received" <> 0 THEN BEGIN
        Purchline."Qty. to Invoice" := (Purchline."Qty. to Invoice" * 2);
        Purchline.VALIDATE("Qty. to Invoice");
        Purchline.MODIFY;
       END;
      UNTIL Purchline.NEXT = 0;

    Works for us.

  • Community Member Profile Picture
    Community Member on at

    Pretty sure he's asking how to do this for an already posted invoice.

    Otherwise, yes, he could just enter two separate invoices, either doing the math with a pen on the invoice itself or via all the coding above.

    Many other systems let you unpost an invoice up until it is paid making this is a trivial problem to deal with.  In NAV though....

  • Community Member Profile Picture
    Community Member on at

    If it's already posted you could create a credit journal entry for the full amount

    & then 2 new invoice journal entries for half amount each.

    set the due dates to whatever they are supposed to be for the invoices

    Just make sure you us the same g/l account for the credit & the invoices so it all gets balanced out.

    Or... if you have terms like 1/2 30 days - 1/2 60 days.. set the invoice for the 30 days.  pay half when due then adjust the due date on the remaining balance afterwards.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans