How to change posting date?

hafihafi Member Posts: 8
edited 2000-08-15 in Navision Financials
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

Comments

  • Dave_CoxDave_Cox Member Posts: 83
    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).]
    MindSource (UK) Limited
    Navision Service Partner

    david@mindsource.co.uk
    info@mindsource.co.uk
  • horriganhorrigan Member Posts: 27
    <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>
    Tim Horrigan, NCSD
    <Horrigan@AOL.com>

    Currently in search of new employment!

    Certified as a Solution Developer and an HR/Payroll Specialist!
  • Dave_CoxDave_Cox Member Posts: 83
    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
    MindSource (UK) Limited
    Navision Service Partner

    david@mindsource.co.uk
    info@mindsource.co.uk
Sign In or Register to comment.