Incorrect Item Quantities

(0) Share

Report

Posted on by Community Member Microsoft Employee

I'm having an inconsistent item quantities situation (GP2010) which goes like this:-

Cause: Inventory Adjustment Posting Interruption (Batch Posting)

Impact:

1. Adjustment (stock out) posted partially to Inventory Trx History table, IV Purchase Receipts table, and HITB table. Hence, HITB will have item balance, different from Item Stock Inquiry quantities, and Item Quantities in SmartList. There were at least 4 items having this situation.

2. A few Adjustment trx showed up in both Work and History tables.

Repair Attempts:

1. Tried running Inventory Reconcile utility, some quantities were corrected, but still don't tally with HITB.

2. Running Check Links returned no error.

Anybody has further idea where / what else can be checked / done to resolve this matter?

Thank you, and with best regards,

Ivan

*This post is locked for comments

All responses (8)

Answers (1)

Suggested answer

Mahmoud Saadi 32,738 on at

Like (0)

Report

RE: Incorrect Item Quantities

Just for the record, here are some notes to be considered when filling the SEE30303. The script below, retrieves the next sequence number for the item above

SELECT ITEMNMBR,
       MAX(SEQNUMBR)+1 AS Next_SEQNUMBR
       FROM SEE30303
       WHERE ITEMNMBR = 'SPFH2502080COILL'
       GROUP BY ITEMNMBR

Hope this helps,
Mahmoud Saadi 32,738 on at

Like (0)

Report

RE: Incorrect Item Quantities

Ivan,

I have just checked your mail, I will forward you the details by today hopefully.
Community Member Microsoft Employee on at

Like (0)

Report

RE: Incorrect Item Quantities

Hi Mahmoud,

i've emailed you the query results in spreadsheet. Would really appreciate your help on building the missing records in SEE30303.
Verified answer

Mahmoud Saadi 32,738 on at

Like (0)

Report
RE: Incorrect Item Quantities

Your posting corruption is represented with the HITB table and GL primarily. There is missing records in both tables;

GL20000

SEE30303

This will result with inconsistency between IV inquiries. Although, no variance will be encountered between IV and GL since inventory and General Ledger are reconciled by considering the HITB (which already has no records for this transaction) and GL (which has no corresponding journal entry as well)

To get this corrected, you need to do the following;

Manually post corrective journal entry with the transaction "extended cost" as credit.

Insert three records the missing records into SEE30303 as derived from (IV10201, IV10200 and IV30300)

If you want further help on how to build the missing records in SEE30303, please e-mail me the result above in a spreadsheet to.
Community Member Microsoft Employee on at

Like (0)

Report

RE: Incorrect Item Quantities

Hi Mahmoud,

here you go with the complete query results, including the IV10201 table.

dl.dropboxusercontent.com/.../QueryResults_201312231054.png
Mahmoud Saadi 32,738 on at

Like (0)

Report

RE: Incorrect Item Quantities

Apparently, this is an adjustment out document and the "Override" is allowed in your inventory setup. I would still want to see the result of the statement below to provide you with my final recommendation on how to get this solved out simply.

SELECT * FROM IV10201 WHERE ITEMNMBR = '#ItemNo' AND ORIGINDOCID = '#DocumentNo'

Your feedback is highly appreciated,
Community Member Microsoft Employee on at

Like (0)

Report

RE: Incorrect Item Quantities

Hi Mahmoud,

Thanks for the details. Just rounded up few (unrelated) issues so got to reply only now.

I've got the query results as below.

dl.dropboxusercontent.com/.../QueryResults_20131223.png

Thanks and best regards,

Ivan
Suggested answer

Mahmoud Saadi 32,738 on at

Like (0)

Report
RE: Incorrect Item Quantities

Inventory posting interruption occurs and there is nothing to worry about as long as you can limit down the corruption to certain documents and items.

First of all, you need to check the inventory tables in order to determine how to get your documents corrected,inventory tables that need to be checked primarily are;

IV30300 | Inventory History Table

IV10200 | Inventory Purchase Receipt Layer

IV10201 | Inventory Purchase Receipt Layer Details

SEE30303 | Historical Inventory Trial Balance

Run the following SQL statements and post back the results in order to proceed with the correction criteria;

SELECT * FROM IV30300 WHERE ITEMNMBR = '#ItemNo' AND DOCNUMBR = '#DocumentNo'
SELECT * FROM IV10200 WHERE ITEMNMBR = '#ItemNo' AND RCPTNMBR= '#DocumentNo'
SELECT * FROM SEE30303 WHERE ITEMNMBR = '#ItemNo' AND RCPTNMBR= '#DocumentNo'
SELECT * FROM GL20000 WHERE JRNENTRY
IN
( SELECT DISTINCT JRNENTRY FROM SEE30303
WHERE ITEMNMBR = '#ItemNo' AND
DOCNUMBR = '#DocumentNo'
)

Your feedback is highly appreciated,