Change Posting Date

pvar
pvar Member Posts: 157
edited 2008-04-08 in Navision Attain
I have a sales credit memo posted with a wrong posting date. How do I correct the date on the credit memo and also on all the related ledger records? Or is there a way to cancel that credit memo and create another one with the correct date?

Comments

  • Captain_DX4
    Captain_DX4 Member Posts: 230
    Which version of NAV are you using, if you please?
    Kristopher Webb
    Microsoft Dynamics NAV Developer
  • pvar
    pvar Member Posts: 157
    3.6 sql version
  • Captain_DX4
    Captain_DX4 Member Posts: 230
    Newer versions of NAV have a handly "reverse transaction" function.

    Basically your only option at this point is to create an Invoice that will completely cancel out the incorrect Credit Memo, then recreate the Credit Memo with the correct values. The Invoice needs to be identical, even the date. If you created the Credit Memo using the form, then use the Invoice form and use your Copy Document. If you created it using a sales journal, then just duplicate the Credit Memo posting.

    Cheers,
    Kristopher Webb
    Microsoft Dynamics NAV Developer
  • pvar
    pvar Member Posts: 157
    Thanks Captian for your suggestions but unfortunately I cannot do an invoice to cancel the credit memo because of the special kind of installation we have. In our setup we cannot have certain items that are on the credit memo to be put on the invoice.

    How about if we change the posting date on every related tables through some report utility?
  • Savatage
    Savatage Member Posts: 7,142
    I would think that the customized solution would have a checkbox in the (item or sales) setup somewhere that would allow you to turn such a thing on and off if needed.

    you can't create an invoice for an item that you can create a credit for?
    Harry Ruiz
    http://www.BiloBeauty.com
    http://www.autismspeaks.org
  • pvar
    pvar Member Posts: 157
    We don't use invoice for items like this but do sales order. But I agree on your point to have some kind of setup that allow you to do things like this.

    I guess the only option I have is to change the posting date manually.
  • Savatage
    Savatage Member Posts: 7,142
    sounds crazy but if you can only make a credit memo - have you tested entering another credit memo but entering either a negative qty or negative cost to reverse the entry that way?
    Harry Ruiz
    http://www.BiloBeauty.com
    http://www.autismspeaks.org
  • David_Singleton
    David_Singleton Member Posts: 5,479
    pvar,

    basically you have a customization in your system that was not thought trhough full circle.

    Any thought of going into SQL and changin the posting date is a disaster waiting to happen. The correct solution is to go back to your NAV partner and get them to fix the original system.
    David Singleton
  • Captain_DX4
    Captain_DX4 Member Posts: 230
    Savatage wrote:
    sounds crazy but if you can only make a credit memo - have you tested entering another credit memo but entering either a negative qty or negative cost to reverse the entry that way?

    Standard NAV shouldn't allow negative lines to be entered, unless that has been customised as well. Worth a shot...
    Kristopher Webb
    Microsoft Dynamics NAV Developer
  • Captain_DX4
    Captain_DX4 Member Posts: 230
    pvar wrote:
    We don't use invoice for items like this but do sales order. But I agree on your point to have some kind of setup that allow you to do things like this.

    I guess the only option I have is to change the posting date manually.

    No No NO! Yucky! :sick: Not a nice way to work this solution, imo. If customisations are going to be required, what would you rather do? A) Create a process that goes in to fix the posting dates in all the required tables *goes crosseyed at the thought of all that work*, or B) would you rather update the customisation to allow an invoice to be created to allow the offset? Option B would be the most clean, and would allow you to correct any mistakes into the future.
    Kristopher Webb
    Microsoft Dynamics NAV Developer
  • bbrown
    bbrown Member Posts: 3,268
    ACCOUNTING 101 - Accountants do not have erasers.

    Translation: NEVER change a posted entry. Make all adjustments thru correcting/reversing entries.
    There are no bugs - only undocumented features.
  • ara3n
    ara3n Member Posts: 9,258
    edited 2008-04-02
    bbrown wrote:
    ACCOUNTING 101 - Accountants do not have erasers.

    But they can always borrow one. :mrgreen:


    Jokes aside, actually they have two writing materials; one pencil with eraser, and one pen.

    You write with pencil in a journal, (which you can erase)
    You write to ledger with a Pen (which you can't erase)
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • David_Singleton
    David_Singleton Member Posts: 5,479
    ara3n wrote:
    bbrown wrote:
    ACCOUNTING 101 - Accountants do not have erasers.

    But they can always borrow one. :mrgreen:


    Jokes aside, actually they have two writing material, one pencil with erazer, and one pen.

    You write with pencil in a journal, (which you can erase)
    You write to ledger with a Pen (which you can't erase)

    =D> what a great analogy. I will for sure plagarize that one thanks.
    David Singleton
  • Savatage
    Savatage Member Posts: 7,142
    Captain DX4 wrote:
    Savatage wrote:
    sounds crazy but if you can only make a credit memo - have you tested entering another credit memo but entering either a negative qty or negative cost to reverse the entry that way?

    Standard NAV shouldn't allow negative lines to be entered, unless that has been customised as well. Worth a shot...

    It's basically a simple MinValue being set to Zero on the qty field. Can be removed for an entry.
    8-[
    anyway, the orig solution should have had a way in case a situation like this ever came up, they didn't think of all the possibilites.

    I can negative receive (older version) that's what you need to do sometimes.
    Harry Ruiz
    http://www.BiloBeauty.com
    http://www.autismspeaks.org
  • pvar
    pvar Member Posts: 157
    Alright guys, I took all of your advices and did not change the posting date through back door.

    We did have a credit and re-bill process where I could post a new credit memo on the correct date and the re-bill order on the wrong date to cancel the original bad credit memo.
  • Savatage
    Savatage Member Posts: 7,142
    you'll be glad you did. :mrgreen:

    Was the date SOOO far off?
    Was the amount SOOOO large?

    usually it's not a critical error, and if it isn't then directly changing info on a table(s) is not a good idea.

    Did the solution center that did the mod have any other work around for you?
    Harry Ruiz
    http://www.BiloBeauty.com
    http://www.autismspeaks.org
  • kriki
    kriki Member, Moderator Posts: 9,121
    David Singleton wrote:
    ara3n wrote:
    bbrown wrote:
    ACCOUNTING 101 - Accountants do not have erasers.

    But they can always borrow one. :mrgreen:


    Jokes aside, actually they have two writing material, one pencil with erazer, and one pen.

    You write with pencil in a journal, (which you can erase)
    You write to ledger with a Pen (which you can't erase)

    =D> what a great analogy. I will for sure plagarize that one thanks.
    You should make a Tips&Trick for this one! Or even better : write it on your blog!
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

  • ara3n
    ara3n Member Posts: 9,258
    Yea I haven't written a blog for a while. I do have one thing I want to write about involves webservices :). Maybe next weekend.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n

Categories