Link address is not valid.

Hi all !

In Dynamics NAV you can attach a link (pdf, image…) to a specific record, such as a Posted Sales Invoiced:

The system saves the address and name of the document associated, so if you delete or rename it, or if you move the document to another place, you will find the following error message next time you try to open the link:

Link address is not valid.

Note:

You can delete a link if the IT administrator has assigned the necessary user permissions to you. 

If a user deletes a single record then all the links attached to the record are deleted. However, if you delete records using a batch job, such as the "Delete Invoiced Sales Orders batch job", then the links are still stored in the Record Link table. To delete the links from the database, run the "Delete Orphaned Record Links" codeunit.

Have a nice day !

@MsgDynNav 

The quantity on inventory is not sufficient to cover the net change in inventory.

Hi all!

When you enter the quantity field in sales documents or output item journal lines, the program can warns you if there are not enough items on inventory:

The quantity on inventory is not sufficient to cover the net change in inventory. Do you still want to record the quantity?

If you want to set up it you only need to select the "Stockout Warning" check box in the "Sales & Receivables Setup" page:

The warning is based on a calculation that sums quantity on inventory and unposted sales order lines, including reserved quantities and considering location code.

Hope be useful!
Bye! ;)

Document No. must be equal to 'G00003' in Gen. Journal Line: Journal Template Name=GENERAL, Journal Batch Name=CAJA, Line No.=10000. Current value is 'PG0045'.

Hi all!

You can have the following error message posting Journal Lines:

Document No. must be equal to 'G00003' in Gen. Journal Line: Journal Template Name=GENERAL, Journal Batch Name=CAJA, Line No.=10000. Current value is 'PG0045'.

Look at the following image. If the "No. Series" field on the journal batch is filled in, the program automatically enters the next number in the series in the "Document No." field of the Journal Line.  The error message occurs if you manually change the "Document No." filled by the system.

Have a nice day!

Dimensions in Close Income Statement Batch Job

Hi all!

Close Income Statement Batch Job is used to transfer the year's result to an account in the balance sheet and to close the income statement accounts, for example 6010001 account.

Suppose that when the fiscal year begins, the 6010001 account hasn’t any default dimension and G/L entries are posted without a dimension code. Then, at mid year someone decides that DPTO dimension for this account must have a dimension value when posting:

If so, when you execute the Close Statement Batch Job and you don't select DPTO dimension in "Close by dimensions" option, the system returns an error message:

The following G/L Accounts have mandatory dimension codes that have not been selected: 601001

In order to post to these accounts you must also select these dimensions: DPTO

Do you want to continue?

 

The message is clear, you have to select DTPO dimension in "Dimensions field":

Once you click the OK button:
A dimension used in Gen. Journal Line GENERAL, PREDET., 30000 has caused an error. Select a Dimension Value Code for the Dimension Code DPTO for G/L Account 601001.

What exactly happens?

Well, the batch job processes all G/L accounts of the income statement type and creates entries that cancel out their respective balances. These new entries are placed in the journal selected and are automatically posted.

For the 6010001 account, the program creates a journal line that will be the sum of all the G/L entries without DPTO dimension. When the program try to post this line and checks the mandatory dimension set up for this account, returns the error message.

As you can see, Code Mandatory in the Default Dimension of the 601001 account it’s not a correct option in order to post correctly the “Close Income Statement Batch Job”. You can fill in blank the Value posting in the Default dimension, post the “Close Income Statement Batch Job” and fill Value posting again. The next entries in the new fiscal year will have DPTO dimension sure!

Hope be useful!

This function checks the consistency of and completes the Chart of Accounts

Hi all !

In the Chart of Accounts page there's a process called "Indent Chart of Accounts".

If you execute it, the system not only indents the descriptions of the accounts, but also prints in bold the "totaling" accounts (classic version only) and checks some account fields.

This is the warning message and the list of checks returned by the system when you click "Indent Chart of Accounts":

This function checks the consistency of and completes the Chart of Accounts:

- Checks that a corresponding heading account exists for every posting account.

- Checks that all accounts comply with the Chart of Account account length requisites.

- Assigns values to the following fields: Income/Balance/Capital, Account Type, Indentation, Totaling and Debit/Credit.
- Checks that an Adjustment Account exists for every account of the Income Statement and Capital types.

Do you wish to check the Chart of Accounts?

Chart of accounts page:

Don't forget to use it!

Hope be useful!

Once the fiscal year is closed it cannot be opened again, and the periods in the fiscal year cannot be changed.

Hi all!

Before close the income statement accounts, you have to close the fiscal year from the Financial Management menu / Periodic Activities / Fiscal Year / Accounting Periods:

When you select the "Close Year" process from the "Accounting Periods" page you receive the following message:

This function closes the fiscal year from 01/01/12 to 31/12/12. Once the fiscal year is closed it cannot be opened again, and the periods in the fiscal year cannot be changed.

Do you want to close the fiscal year?

What does it mean?
Well, it only means that, if you confirm the message, the year cannot be re-opened and the accounting periods cannot be changed, but if you need to post G/L entries in the closed period you can do it.

Hope be useful!
See you soon!

The entered VAT Registration number is not in...

Hi all!

You can specify a format for the VAT Registration number for a Customer, Vendor, Bank or Contact account. So, if you enter a VAT Registration number that is not according to the format specified, the system will return a message error like this:

The entered VAT Registration number is not in agreement with the format specified for Country/Region Code ES.

The following formats are acceptable: ES########@, ########@

Classic version:

Role Tailored version:

Formats can be defined in the Country/Region page. For each line, you can access to "VAT Registration No. Formats" by clicking "Related Information".

Country/Region page:

This is the "VAT Registration No. Formats" page, where '#' defines a digit, '@' defines a letter, and '?' defines any character.

When you enter the VAT Registration No. field in a Customer account,  the program also checks that the number entered has not already been entered for another Customer account (idem for Vendor and Contact accounts)

Remember that in classic version of Dynamics NAV...

You will find the "VAT Reg. No. Formats" button in the "Country/Region" form.

See you soon!

Deleted document

Have you ever seen an error message like this? Are you trying to delete a not posted document?

"Deleting this document will cause a gap in the number series for posted invoices. An empty posted invoice 103061 will be created to fill this gap in the number series.
Do you want to continue?"

 

Maybe you understand what it means but, what's happening?

Suppose you're trying to register a sales invoice but the system cancels the post because you haven't filled "Document external No." field.

 

 

You can think that, as the action was cancelled, nothing has changed in the document but it's not. In the header document ,"Posting No." field has been automatically filled (You can check it by clicking "About This Page" and "Table Fields" in the Role Tailored version, or by clicking Tools / Zoom in the classic version). So the invoice series has been incremented by one position.
Anyway, if you finally delete the document without posting, you can cause a gap in the number series for posted invoices and in order to avoid this, the system creates a posted invoice with the "Posting No." number. It's a posted invoice which only has one line, description equals to "Deleted document" and of course, it has not ledger or item entries.

Hope be useful,

See you soon!

Can you delete a posted invoice?

Hi all !

You can't delete a posted invoiced but, can we try it?

I have done it in a Cronus company and this is what it happens:

I'm over the posted document (sales invoice), I try to delete it but the system returns the following error message:

"No. Printed must have a value in Sales Invoice Header:

No.=103003. It cannot be zero or empty."

OK, there's no problem. I print at least once.

Then I try to remove it again and now the document disappear.  

If I access to the list documents the invoice is not there. It seems I have deleted it but it's not.
If I navigate using 103003 document number, I can see ledger entries, VAT entries, Item entries and so on. That happens because I only have deleted the register of the header and the document lines, but ledger entries and others remains in the tables.

So, If you post an incorrect invoice, you have to post a credit memo in order to correct the invoice.

REMEMBER:

- Before posting the Credit memo, you can apply it to the correspondent invoice (only if the correspondent customer ledger entries hasn’t been applied yet), using  “Applies-to Doc. Type” and “Applies-to Doc. No.” fields in the Application FastTab.

-- You can easily create a Credit Memo using the Copy document function to fill in the document automatically from another posted document. Don’t forget to select the “Include Header” check box.

- If you doubt about any test or post, you can do it before in the Cronus Company. If you haven’t any Cronus Company, or you don’t know how to create it, or you are not authorized to do it, the system administrator or your partner can help you!


See you soon!

Recurring Journals: There is nothing to post

Hi all !

Are you using Recurring journals?

Have you ever seen this error message?

"There is nothing to post."

Check dates, you will see that the Posting date is later than the current Work date, so system interprets that the day to post doesn't arrived yet.

SOLUTION

If it's necessary, this control can be easily skipped by either changing the Work date, or by modifying the Posting date on the Journal lines.

Remember it only happens in Recurring Journals.

See you soon!