Reverse Posted Item Journal

Beatrice
Beatrice Member Posts: 346
edited 2007-04-06 in NAV/Navision Classic Client
Hi,

A user wants to reverse a posted item journal, which had 16 lines with Entry Type as Negative Adjustment and one line as Positive Adjustment.

The user noticed that after posting the above item journal, stock for some of the items became negative.

Now users are not able to make any shipment.

Please advise how to reverse this journal.

Thanks and Regards,
Beatrice.

Answers

  • nunomaia
    nunomaia Member Posts: 1,153
    You have to do the reverse operation.
    16 lines positive and 1 negative
    Nuno Maia

    Freelance Dynamics AX
    Blog : http://axnmaia.wordpress.com/
  • Beatrice
    Beatrice Member Posts: 346
    Thanks for reply.

    I did same for the purpose of testing on a posted item journal.

    I noticed that the Cost Amount (Actual) is different on the Item Ledger Entry when I posted the reversal although I have put same Unit Cost as on the original Item Journal.

    Also the Quantity on some of the stock items have become Negative.

    Please advise.

    Thanks and Regards,
    Beatrice.
  • nunomaia
    nunomaia Member Posts: 1,153
    In Item item journal fill Applies-to Entry
    Nuno Maia

    Freelance Dynamics AX
    Blog : http://axnmaia.wordpress.com/
  • Beatrice
    Beatrice Member Posts: 346
    Hi,

    When I fill the Applies-to Entry field, should I choose same Entry No. as the one on the originally Posted Item Journal's Item Ledger Entry?

    Thnx and Rgds,
    Beatrice.
  • nunomaia
    nunomaia Member Posts: 1,153
    yes
    Nuno Maia

    Freelance Dynamics AX
    Blog : http://axnmaia.wordpress.com/
  • ayhan06
    ayhan06 Member Posts: 210
    for new 16 positive adjmt. lines, you should select posted negative adjmt. lines in the "Apply-from Entry" field.
    for new negative adjmt. line, you should select posted positive adjmt. line in the "Apply-to Entry" field.
  • Beatrice
    Beatrice Member Posts: 346
    I have done as you mentioned, but for some lines when I lookup on the Applies-To Entry field and select the Item Ledger Entry, I get the following message:

    Quantity must be negative in Item Journal Line Journal Template='ITEM', Journal Batch Name='DEFAULT',Line No='10,000'.

    Please advise.

    Thanks and Regards,
    Beatrice.
  • nunomaia
    nunomaia Member Posts: 1,153
    reverve the line with the same entry type with negative qty.
    Nuno Maia

    Freelance Dynamics AX
    Blog : http://axnmaia.wordpress.com/
  • Alex_Chow
    Alex_Chow Member Posts: 5,063
    If the inventory is in the negatives and you want to do positive adjustment, you'll need to use the Applies-From Entry No.

    Using the Applies-From Entry No. will create an additional open entry with the positive quantities. This means that the negative remaining quantity will not be applied to the positive remaining quantity.

    Since the inventory is in the negatives, when you post a regular positive adjustment, it will use the cost that's associated with the positive adjustment. This means that it's important for you to specify the correct Unit Amount on the positive adjustment.
    Confessions of a Dynamics NAV Consultant = my blog
    AP Commerce, Inc. = where I work

    Getting Started with Dynamics NAV 2013 Application Development = my book
    Implementing Microsoft Dynamics NAV - 3rd Edition = my 2nd book

Categories