How to change posting date?

hafi · 2000-08-14

I am an end user and am bringing data from another accounting package (Sage) using a mixture of imports & manual entries. I have found that some of my journals have taken the actual date of posting as opposed to the posting date.

This is causing me problems as extremely detailed invoices may have to reposted. It would be v.straight forward for me to change the posting daates as you can in sage using the Maintenance function

Dave_Cox · 2000-08-14

Hafi

Sorry there is no way to change posted Ledger data's Posting Tax/Point Date Maually.

You could however ask your NSC if they could help by creating a codeunit or report to do this.

It is very Important that this is done by someone who is experienced and understands the way Navision works, If the data is not correct then Inconsistancies will corrupt your Database.

If G/L,VAT,Bank,Customer,Vendor Ledgers have been created they will all have to be updated on Posting Date Document Number, That is if you are sure that no Duplicates Exist.

Ask you NSC to set you up with a Local Copy to enable you to do some test posting, before entering them on your live system!

MindSource (UK) Limited
Navision Service Partner

david@mindsource.co.uk
info@mindsource.co.uk

[This message has been edited by Dave Cox (edited 14-08-2000).]

horrigan · 2000-08-14

<BLOCKQUOTE><font size="1" face="Verdana, Arial">quote:</font><HR>Originally posted by Dave Cox:

You could however ask your NSC if they could help by creating a codeunit or report to do this.

It is very Important that this is done by someone who is experienced and understands the way Navision works, If the data is not correct then Inconsistancies will corrupt your Database.

[/B]<HR></BLOCKQUOTE>

The Navision way of doing this is to cancel out the erroneous entries by putting balancing entries through the appropriate JOURNAL. You are NOT supposed to write directly to the ledger EVER--- unless you absolutely have NO alternative, at least. This is not one of those cases where you have no alternative.

It sounds like the erroneous entries were made while initializing a new database, and few if any transactions have posted since then. It might not be a bad idea to simply create a whole new database with correct opening entries in it.

Tim Horrigan, NCSD
<Tim.Horrigan@emsolution.com>

Dave_Cox · 2000-08-15

Quite Right Tim

That is why I suggested that Hafi contact his NSC they will evaluate the number of postings then decide the best action to take, I know that Hafi has made previous postings and is live on SOP, correcting missposted entries is an area of Navision that often comes up when Installations go live, It seems that a function like on the Fixed Assets to cancel the last posting would be of benifit as it is often asked for and seen as something that is lacking in Navision.

MindSource (UK) Limited
Navision Service Partner

david@mindsource.co.uk
info@mindsource.co.uk

Howdy, Stranger!

Quick Links

Categories

How to change posting date?

Comments