AnsweredAssumed Answered

Max (InvoiceNumber) has stopped working

Question asked by pietergorisio on Jul 1, 2017
Latest reply on Jul 3, 2017 by philmodjunk

Hi fellow FM'er,



I HAD a smooth running invoicing numbering which I messed up somehow.

I don't know why but my Max (InvoiceNumber) stays empty. And I don't see the difference compared to backup previous versions.


My field InvoiceNumber is set to 1

When I create a new invoice it runs this script:


Screen Shot 2017-07-01 at 23.35.17.png


This is the relation between the two table occurrences:


Screen Shot 2017-07-01 at 23.36.55.png


Somehow the s_MaxInvoiceNumber always stays empty.

Anyone any idea? Might be something silly but I just don't see it.


All help is much appreciated.