Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Reverse or Correct tra...
Microsoft Dynamics NAV (Archived)

Reverse or Correct transaction releated to item in g/l entry table(wrong account as inventory adjustment)

(0) ShareShare
ReportReport
Posted on by ahmed barbary 4,548

Hi guys I have big proplem I make  reverse to production order from item journal as positive adjustment to consumption and negative adjustment to output and after i

finish i see item ledger entry i see raw material consumped to this production order is reversed and output also until here no proplem. i go to Financial management-

navigate i write document no of item journal have positive and negative adjustment i found all raw material and output on g/l entry and extra account has value.this

account found when i make any adjustmnent to inventory i go to general posting setup i found as following i found extra account as name open as following

gen.bus.posting group     gen.product.posting group      inventory adjustment

                                              agg1                                       999999   (extra)

   tp                                          agg1                                        14382

so that i will delete  this account but how i will correct or reverse his transactions

Now how i correct or reverse this extra account tranasctions ..

*This post is locked for comments

  • Suggested answer
    Neville Foyn Profile Picture
    Neville Foyn 4,320 on at
    RE: Reverse or Correct transaction releated to item in g/l entry table(wrong account as inventory adjustment)

    Hi

    There are many different ways to capture these journals depending what you are trying to accomplish, this is how you capture a basic journal to move values between 2 GL accounts though

    Open the "General Journal"

    Fill in the following

    Posting Date = Today

    Document Type = Blank

    Document Number = Leave it to default to what is in the journal

    Account type = G/L Account

    Account number = The first GL account number

    Description = Update this to say "Correcting inventory adjustment account"

    General posting Type = Blank

    Gen. Bus. Posting Group = Blank

    Gen. Prod. Posting Group = Blank

    Amount = the amount to move

    Bal. Account Type = GL Accout

    Bal. Account No. = The account to move it into

    Bal. Gen. Posting Type = Blank

    Bal. Gen. Bus. Posting Group = Blank

    Bal. Gen. Prod. Posting Group = Blank

    Depending on weather you want to debit or credit the accounts is affected by having a negative pr positive number in the amount column

    To ensure that you get it right i would suggest that you make a fresh copy of the system as a test system and try it in test first

    Cheers

    Nev

  • ahmed barbary Profile Picture
    ahmed barbary 4,548 on at
    RE: Reverse or Correct transaction releated to item in g/l entry table(wrong account as inventory adjustment)

    if i want to correct these transactions from general journal how i do

  • ahmed barbary Profile Picture
    ahmed barbary 4,548 on at
    RE: Reverse or Correct transaction releated to item in g/l entry table(wrong account as inventory adjustment)

    suppose i want to make the result of these transactions is 0 how make this .because this extra account so that i don't need amount in it. i want to make result of transaction as 0

  • Neville Foyn Profile Picture
    Neville Foyn 4,320 on at
    RE: Reverse or Correct transaction releated to item in g/l entry table(wrong account as inventory adjustment)

    Hi Ahmed,

    As this is a adjustment in the GL just move the GL transactions with a General Journal from this account where you don't want it to a different account

    Cheers

    Nev

  • ahmed barbary Profile Picture
    ahmed barbary 4,548 on at
    RE: Reverse or Correct transaction releated to item in g/l entry table(wrong account as inventory adjustment)

    Can you reply for me in this question as soon as possible can i make correct or reverse to this transaction if it is how.tell me how i make correction to transaction go to by wrong it another account.

  • Suggested answer
    Neville Foyn Profile Picture
    Neville Foyn 4,320 on at
    RE: Reverse or Correct transaction releated to item in g/l entry table(wrong account as inventory adjustment)

    Hi

    It is never recommended to delete a GL account that has financial transactions in it from the current financial year

    The process however to do the deleting is:

    -Use a general journal to transfer the balance out of the GL account that you want to delete

    -Go to your "General Ledger Setup" and fill in the "Allow G/L Acc Deletion before" date with a date after the date on which you zero'd the account

    -Tick the "Check G/L Account Usage" tick (To ensure that the account is not in use on a posting group when you remove it

    The system will now allow you do delete the GL account, if it finds that the account is used on a posting group, go to that posting group and remove it from there before you delete it

    Dont forget to remove the deletion date and tick again when you finished to prevent accidental deletions

    Cheers

    Nev

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans