Line 10000 of the shipment which you are attempting to invoice...

Hi all!
Have you ever seen an error message like this?

We're creating invoices, using "Get Shipment Lines" function. By the moment we don't post any document but, we create them so fast that we don't realize we have created the same invoice twice.
The first invoice can be posted without problem but if you try to post the second one the system returns the error:

"Line 10000 of the shipment XXXXX, which you are attempting to invoice, has already been invoiced"

You'll have to use the document to post a different one.

Hope be useful!
See you soon!

Invt. Posting Group Code and Location Code

Hi all !

Do you work with Items, informing the "Location code" in the item transactions?

Have you ever seen an error message like this?

The Inventory Posting Setup does not exist.  Identification fields and values: Location code='MENORCA',Invt. Posting Group Code='TERMINADO'

This message usually appears when you have created a new Location code, (MENORCA in the example) and you're going to post the first item entry to the new location.

The error message appears because there's not a combination of the new "Location code" MENORCA  and the "Invt. Posting Group Code" TERMINADO, in the "Inventory Posting Setup" page:

AND ALSO:

The previous pass it's not enough, as you have to inform the "Inventory Account", otherwise, you will find the following message error:

"Inventory Account must have a value in Inventory Posting Setup: Location Code=MENORCA, Invt. Posting Group Code=TERMINADO. It cannot be zero or empty."

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!

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!

Línea del envío que está intentando facturar, ha sido ya facturado

Hola a tod@s!

¿Alguna vez te has encontrado con un error similar a este?
Línea 10000 del envío 102055, que está intentando facturar, ha sido ya facturado.


Estamos creando facturas, recuperando las líneas de albaranes con la acción “Traer albaranes”. Por el momento, no registramos ninguna de las facturas. Hemos ido tan rápido que sin darnos cuenta hemos repetido una de las facturas. La primera de ellas se registrará sin problemas, pero si no nos percatamos de la duplicidad, e intentamos registrar la segunda, nos aparecerá el siguiente mensaje de error:

SOLUCION:

Puedes eliminar las líneas de la factura y aprovechar la cabecera para una segunda factura, o puedes eliminar toda la factura, situándote sobre cualquier campo de la cabecera.

Y RECUERDA:

Si al intentar borrar una factura aparece el un mensaje de error parecido a este: “Si borra el documento se provocará una discontinuidad en la numeración de la serie de facturas registradas. Se creará una factura registrada en blanco 103057 para completar la misma.
¿Confirma que desea continuar?”, 
puedes leer este post :
http://msgdynamicsnav.blogspot.com.es/2012/06/documento-borrado.html


Hasta pronto!

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!