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
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.
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....
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.
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (