Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Daniel Szura]

Hello All,

We have done tons of research on WH entries and Item Ledger entries being out of sync, but we still have not been able to resolve this with out the help of a developer. Our thought is we can go right into the SQL and zero out the out of sync entry so everything matches up. We are concerned that this will impact other areas of the system.

Is anyone aware of other areas we would also need to adjust? 

Please let me know what I can provide that would assist.

Thank You,

——————————
Daniel Szura
Business Operations Analyst
American Labelmark Company (Labelmaster)
Chicago IL
——————————

[Lewis Rosenberg]

We have seen a lot of this over the years and I believe in our case they were a result of buggy development work.  I think and hope that we finally have everything repaired.  Bad data lingered for a long time before we identified and fixed it mostly with the help of our partner.  I haven’t seen any issues now for three months.

The first thing to do, however, is to run the Item Journal Calculate Whse Adjustments function.  If someone completed a Warehouse entry (ie. Whse Item Journal) without running the Item Journal Calculate function, then your Whse Entries will not match Item Ledger entries.  If this is not the case, you may want to speak to your partner about creating a report to identify all of the bad data (not easy) and discuss any inventory modifications that might be causing the problem.

——————————
Lewis Rosenberg
IT Manager
Mars Fishcare
Chalfont PA

NAVUG Board of Advisors, Programming
NAVUG Programming Committee
NAVUG Membership Committee
——————————
——————————————-

[Holly Kutil]

We are on NAV 15 and our partner went to Microsoft about this and we were advised to do Cumulative update 27.  Just completed it this week.  I will let you know if we are in the clear down the road.

The update took about 12 hours beginning to end, plus department testing.

——————————
Holly Kutil
American Ring/NAV Admin
Solon, OH 44139
**Great Lakes Chapter**
?? Women In Dynamics ??
——————————
——————————————-

[Gregory Alford]

Hi Lewis – We do not have an Item Journal Calculate function. Is this a processing report written for you by your developers?

——————————
Gregory Alford
ERP Manager
Tri Star Metals LLC
Carol Stream IL
——————————
——————————————-

[John Bellinger]

We saw this also in NAV 2015, if I remember right, it was something to do with inventory pick for a transfer order when the pick was for a bin that no longer had an availability to cover the pick quantity.  Before we discovered that issue, our VAR built us a custom report that would let us make positive/negative adjustments to warehouse entries to get warehouse in sync with item ledger entries.  Your VAR should be able to do the same.  Even after we applied the fix for the transfer / pick issue I mentioned, we’ve still seen this from time to time and have continued to use the custom report to get back in synch.  Our report only touches warehouse entries; you could probably go the SQL route.

 

John Bellinger | ERP Manager | Activar, Inc.
9700 Newton Ave. S. | Bloomington, MN 55431
Office: 952-392-3912 | Cell: 612-719-0289 | Fax: 952-837-1221
jbellinger@activar.com | http://www.activar.com

 

——Original Message——

Hello All,

We have done tons of research on WH entries and Item Ledger entries being out of sync, but we still have not been able to resolve this with out the help of a developer. Our thought is we can go right into the SQL and zero out the out of sync entry so everything matches up. We are concerned that this will impact other areas of the system.

Is anyone aware of other areas we would also need to adjust? 

Please let me know what I can provide that would assist.

Thank You,

——————————
Daniel Szura
Business Operations Analyst
American Labelmark Company (Labelmaster)
Chicago IL
——————————

[Dave Cintron]

Lewis is correct. This is from the NAV 2016 help:

Calculate Whse. Adjustment Batch Job
 
Sums up item by item all the quantity adjustments found in the warehouse adjustment bin. If the sum of the adjustments for an item is a positive or negative quantity, the program creates a line in the item journal for posting. When you post the adjustment lines, the item ledger and the warehouse records for the items, variants and locations that you selected in the batch job correspond exactly. To run this batch job, open the Shortcut iconItem Journal window and click Actions, point to Functions, and then click Calculate Whse. Adjustment.

Fill in the fields on the Options FastTab as follows:
•Posting Date: Enter the date for the posting of this batch job. The program automatically enters the work date in this field, but you can change it.

•Document No.: Here you must manually enter a document number that will be entered in the Document No. field on the journal lines created by the batch job. Because no number series has been set up for this batch job, use the number scheme set up by the warehouse, or enter the date (year-month-date) followed by your initials.

——————————
Dave Cintron
Dynamics West
Ventura CA
——————————
——————————————-

[Alex Apodaca]

Daniel,

If you have a competent Database Administrator in-house, then see my previous post on this. A paid-for report would be an alternate method of accomplishing the same thing as what I have described here:

https://www.navug.com/communities/community-home/digestviewer/viewthread?MID=7386

——————————
If my response has helped you please mark the answer.

Alex A
Sr. NAV Consultant
Irvine, CA United States
——————————
——————————————-