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!

You must specify Statistics Period in Intrastat Jnl. Batch Journal Template Name='INTRASTAT',Name='GENERICO'.

Hi all!

The following error message can occurs when you try to execute the "Get Entires" process from the Intrastat journal:

Classic version:

You must specify Statistics Period in Intrastat Jnl. Batch Journal Template Name='INTRASTAT',Name='GENERICO'.

Role Tailored version:

Statistics Period must have a value in Intrastat Jnl. Batch Journal Template Name=ITRASTAT, Name=GENERICO. It cannot be zero or empty.

It means that the "Statistics Period" field in the Intrastat Jnl. Batch is empty. You must enter here the year and month that apply to the intrastat journal batch, for example:

For the intrastat journal batch for May in year 2012, enter 1205:

Next time you click the "Get Entries" button, the program will set Starting and Ending date to the Intrastat Journal window automatically:

Hope be usefull!

See you soon!

Account Type or Bal. Account Type must be G/L Account or Bank Account.

Hi all!

The following error appears when you try to create a unique journal line using a Customer and a Vendor account.

Account Type or Bal. Account Type must be G/L Account or Bank Account.


Role Tailor version:

Classic version:

 You have to create two journal lines, the first one from the Customer to an intermediate G/L Account or Bank and the second one from the intermediate G/L Account or Bank to the Vendor.

Hope be useful,

See you soon!

Direct Posting must be equal to 'Yes' in G/L Account: No.

Hi all!

In Journal lines and document lines, you can enter the number of the account you want to post to. Sometimes, the system can return the following error message:


Role Tailored version:
Direct Posting must be equal to 'Yes' in G/L Account: No.=6000001. Current value is 'No'.

Classic version:

Direct Posting must be Yes in G/L Account No.='6000001'.

Look at "Direct Posting" field in the account card:

In this case, "Direct Posting" field has not a check mark, so you will not be able to post directly to this G/L account.

An example of indirect posting is the automatic VAT entry (or entries) that appears in a receivables account when you post to a customer.


REMEMBER:

- By default, when you create a new account card, "Direct Posting" field has not a check mark.

Hope be useful,

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!

The autosplitkey facility cannot find a key between the current and the previous record.

Hi all !

There's an error message that can appear when you're inserting lines between two existing lines. 
Although it seems you can repeat this action over and over, the system finally generates the following error message:

Classic version says like this:

“The autosplitkey facility cannot find a key between the current and the previous record.”

And Role Tailored version says like this:

“The line cannot be split.”

Look at the previous image: In the document lines, there's a field called "Line No". This field is used to give a number for every line. The system assigns this value automatically and sequentially  in increments of 10.000.

What happens when you insert a line between line #10.000 and line #20.000? The new one will be line #15.000. That is, halfway between the two existing lines.

So,

A new line between line #10.000 and line #15.000 will be line #12.500 

A new line between line #10.000 and line #12.500 will be line #11.250

If you continue like this, there comes a time when you try to insert a new line between line #10.000 and line #10.001 and the system generates the error.

You have to add the new line in another position.

AND REMEMBER:

If you are in the classic version of Dynamics NAV, you can select all the lines in a journal, Cut the lines, and immediately Copy the lines. When the system copies all the lines, the "Line No." field is recalculated, and all the lines appear again in increments of 10.000. So, you can continue inserting new lines in the desired position.

Be careful! If you are in the lines of a document, you can Copy the lines, but you can't  Paste them, as this action is not available in this kind of forms.

See you soon!

General Journal Error

Hello again!

There are three common errors when you post Journal Lines.

Suppose that we're going to post a simple entry. I mean, without VAT entries or additional ledger entries. For example:

Note that "Gen. Posting Type", "Gen. Bus. Posting Group" and "Gen. Prod. Posting Group" fields aren't blank. Moreover, "VAT Bus. Posting Group" and "VAT Prod. Posting Group" fields are not visible but maybe they have a value.

Anyway, when you try to post it, the program reports one of the following error messages:

1.- Check that the all the entries with the same Document No. and a VAT. Bus. Posting Group and VAT Prod. Posting group associated have a Customer/Vendor associated, check that all the lines with the same Document No. have not more than one Customer/Vendor associated, check that all the lines with the same Document No. have in the field Document Type the same value: Invoice, Credit Memo or Finance Charge Memo

This error appears because at least one line has a value in the "Gen. Posting Type", "Gen. Bus. Posting Group" and "Gen. Prod. Posting Group" fields. If previous fields are blank then check "VAT Bus. Posting Group" and "VAT Prod. Posting Group" fields.
Anyway, the program considers you´re trying to post an invoice or a credit memo, and so, you need to specify a customer or a vendor.

2.- Gen. Posting Type must not be    in Gen. Journal Line: Journal Template Name=GENERAL, Journal Batch Name=CAJA, Line No.=10000

In this case "Gen. Posting Type" field is blank. The error appears because line 10000 has a value in "Gen. Bus. Posting Group" and "Gen. Prod. Posting Group" fields. If the previous fields are blank then check "VAT Bus. Posting Group" and "VAT Prod. Posting Group" fields. 
The program considers you're trying to create sales or purchases entries, and so he needs to know if the posting type is a sales or a purchase type.

3.- The VAT Posting Setup does not exist.   Identification fields and values: VAT Bus. Posting Group=",VAT Prod. Posting Group="

This error appears when at least one line has the following characteristics:
"Gen. Bus. Posting Group", "Gen. Prod. Posting Group", "VAT Bus. Posting Group" and "VAT Prod. Posting Group" fields are blank, but the "Gen. Posting Type" field has a value.
The program considers that you want to post additional sales or purchases entries and so, he needs posting groups and VAT posting groups.

THE SOLUTION:

In order to avoid the previous error messages, you have to leave blank the following fields in the journal lines: "Gen. Posting Type", "Gen. Bus. Posting Group", "Gen. Prod. Posting Group", "VAT Bus. Posting Group" and "VAT Prod. Posting Group"

See you soon!