Microsoft Dynamics NAV (Archived)

facing issue in reverse entries

(0) Share

Report

Posted on by Rajat walia

380

Hi,

There are some entries are going to inventory interim account because of posting setups.

In General posting setup in transfer order posting lines where gen bus posting group is not mentioned there is also COGS, Direct cost applied account, Overhead applied account and purchase variance account are not mentioned.

In Inventory posting setup in in-transit location in Inventory account code Interim account number is mentioned.

how to transfer all that entries into the relevant account from where it comes ?

How to understand that which entry comes from which account ?

One more thing reverse is not working.

will wait for your responses,

Thanks.

*This post is locked for comments

All responses (9)

Answers (0)

Rajat walia 380 on at

Like (0)

Report

RE: facing issue in reverse entries

ok

Thanks for your important time.
Suggested answer

RobertasR 5,002 on at

Like (1)

Report

RE: facing issue in reverse entries

It's a tough situation. I don't think reversal (of any kind) would solve the issue, and it needs a consultant on-site to go through entries to understand what has gone wrong (or into a wrong place). Sorry, not sure I can help more.

Robertas
Rajat walia 380 on at

Like (0)

Report

RE: facing issue in reverse entries

Yes sir,

I had already run this all but difference is still there .

One more thing value entry balance and inventory trading account balance is matching.
Suggested answer

RobertasR 5,002 on at

Like (1)

Report

RE: facing issue in reverse entries

I would recommend running 'Adjust Cost - Item Entries' job (that is a processing report called from the menu), with the 'Post to G/L' ticked. If the 'Post to G/L' is disabled (it depends on inventory setup) then after the adjustments run the 'Post Inventory Cost to G/L' with the 'Post' ticked.

After these please try your report again to see if the difference is still there.

Robertas
Rajat walia 380 on at

Like (0)

Report

RE: facing issue in reverse entries

-2458.36 is the difference between inventory trading and inventory total account.

please once check the snapshots

Thanks
RobertasR 5,002 on at

Like (1)

Report

RE: facing issue in reverse entries

Depends on what the type of difference, that is, what is the difference between?

Usually, NAV would lead you in a way of reversing documents (posting credit notes) but again, the key is to understand what the difference represents, and first look at the source.

Robertas
Rajat walia 380 on at

Like (0)

Report

RE: facing issue in reverse entries

actually there are some transactions with document type : Invoice and difference coming from invoice type of transaction.

and all invoices are related to posted transfer shipment and posted transfer receipts.

Sir now what is the solution for that difference amount ?

Thanks
Suggested answer

RobertasR 5,002 on at

Like (1)

Report

RE: facing issue in reverse entries

Hi Rajat,

good links provided by Suresh there, definitely worth reading.

To answer other questions - for in-transit location I would recommend having a separate Stock account if your transfers take more than 1 day to process or being processed (ship and receive) by different people. Now it mixes up with 'interim account' that might prove difficult to reconcile. Normally with transfers, when shipping it credits Stock of original location and Debits in-transit stock (that is no set as interim), and on receiving credits in-transit stock and debits destination Location stock.

To see the source of entries, just highlight the entry and hit 'Navigate'. That would give you all entries created with the same document number and posting date that usually indicates the source.

Also, on the Chart of Accounts, if you highlight the account and hit 'Where Used' it will show you where this particular account is used in the posting setups.

And the last one - reversing only works on entries posted via general journal.

Robertas
Suggested answer

Suresh Kulla 43,745 on at

Like (1)

Report

RE: facing issue in reverse entries

Rajat,

Please check these links

https://www.archerpoint.com/blog/Posts/understanding-interim-cogs-account-microsoft-dynamics-nav

http://dynamicsforbeginners.blogspot.com/2014/07/inventory-accounting-entries.html