Dynamics Community Forum Thread Details

Why won't NAV accept -0- value entries? Many (many) other programs will.

In accounts payable, to reserve a netted-to-zero-per-conversation invoice header (invoice number and vendor), to prevent the invoice from being entered by another clerk, and/or at a later date. We put in the vendor/invoice # with a $-0-.

In accounting, we have many journal entries that we upload from Excel. 500-5,000 lines each. These entries are formula based and for many periods, lines within these entries calculate out to -0-. But when it comes time to upload they kick out as 'in error'.

So now we need to take the additional steps of calculating the values of the formulas, pasting values only somewhere, then sort by value, ID the -0- values, then delete those values? Anyone think this is cumbersome and needlessly hands on?

Why can't NAV handle -0- transactions? Is there a flaw in how it stores data?

Hie Raokman,

I think NAV doesn't works like that. We can assign role permission and divide the work. There is very less chances in which your invoice can be entered by another user because in most of the documents we do have assigned user id or related user id which tracks the document. It even filters the document as per user and prevents the document processed by another user.

On the topic of Zero "0" Value, i think NAV do provide you the option to keep any document on hold with no value entered in the line. You just need to create a document and keep it on hold for you to complete later. But because of sophisticated role and permission setup (if done properly) i don't think there is any chance of redundancy or duplication of work.

Quick Links