Change Posting Date

pvar

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?

Captain_DX4

Which version of NAV are you using, if you please?

pvar

3.6 sql version

Captain_DX4

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,

pvar

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

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?

pvar

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

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?

David_Singleton

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.

Captain_DX4

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...

Captain_DX4

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 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.

bbrown

ACCOUNTING 101 - Accountants do not have erasers.

Translation: NEVER change a posted entry. Make all adjustments thru correcting/reversing entries.

ara3n

bbrown wrote:

ACCOUNTING 101 - Accountants do not have erasers.

But they can always borrow one.


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)

David_Singleton

ara3n wrote:

bbrown wrote:

ACCOUNTING 101 - Accountants do not have erasers.

But they can always borrow one.


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.

Savatage

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.

pvar

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

you'll be glad you did.

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?

kriki

David Singleton wrote:

ara3n wrote:

bbrown wrote:

ACCOUNTING 101 - Accountants do not have erasers.

But they can always borrow one.


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!

ara3n

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.