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.

Regards,

Pieter

Outcomes