Featured Post

Dynamics GP 2019 is now Released

It is now released, Microsoft Dynamics GP 2019 which moves the system to the modern product life cycle   " Beginning with the October...

Saturday, October 19, 2013

HITB Essentials Series– HITB Reset Tool and SEE Tables

I have been recently searching the internet for details regarding the HITB Inventory Reset tool regarding specific information on the SEE tables; (SEE99997), (SEE99998) and (SEE99999) but in vain !  Therefore, I am taking this opportunity to include essential details on the HITB Inventory Reset Tool and the role of these tables throughout the process as part of the HITB Essentials Series.

HITB Inventory Reset Tool uses three primary tables throughout the process to manage the process and come up with the desired result of an Inventory Modules that is clean of errors, reconciled internally, free of integrity errors and tied to GL. In order to do so, each of the above three tables has a specific functionality that is highly essential.

First of all, it is worth to mention the basic four stored procedures that are used with the Inventory HITB Reset Tool, which are;

  • ivHITBBalanceQTYONHND
  • ivHitbRunDataIntegrityChecks
  • ivHitbDataInsert
  • ivHITBSiteSegment

 

SEE Tables:

1- SEE99999 | Data Integrity Checks

In order for the Reset tool to fill out the HITB table and provide the HITB report, inventory must be cleaned of any associated errors. In order to write in precise records in SEE30303, and tie the Inventory Module to General Ledger Correctly. Which is all comes under “Data Integrity Checks” function.

In this essence, this table; which might be the primary SEE table in HITB Reset Process, is responsible of the Data Integrity Checks Function. It uses the four procedures above in order to prepare and insert all the corrupted instances in Inventory and as related to GL.

Integrity Checks can be divided into two main levels (Inventory and GL), within each level, there are several errors that are recorded to be well.

Error Message Level Values:

  • Inventory = 2
  • GL = 1

 

Error Message Level

Error Message Description

Error Message Number

Comment

2

Receipt QTY's do not match IV QTY's

101

Quantity for specific Transaction Location in IV00102 (RCRDTYPE = 2)

2

Receipt QTY's do not match IV QTY's

102

Quantity for ALL Transaction Location in IV00102 (RCRDTYPE = 1)

2

Average Item receipt QTY on hand does not equal IV QTY on hand

103

2

Receipt layer QTY is 0, but not marked as sold

104

Incorrect RCPTSOLD field in IV10200.

QTYRECVD = QTYSOLD

and RCPTSOLD = 0

2

Receipt layer QTY is not 0, but is marked as sold

105

QTYRECVD <> (QTYSOLD + QTYRESERVED)

and RCPTSOLD =

and PCHSRCTY <> 4

2

Layer is not an override and QTY sold is greater than QTY received

106

QTYSOLD > QTYRECVD

and PCHSRCTY <> 4

2

Invalid purchase receipt type

107

PCHSRCTY not in (0,1,2,3,4,5,6,7,8)

2

Serial/Lot tracked item's receipt layer adjusted unit cost does not equal unit cost

108

b.VCTNMTHD in (1,2)

and b.ITMTRKOP <> 1

and a.RCPTSOLD = 0

and a.ADJUNITCOST <> a.UNITCOST

2

Item Type not "Sales/Invoice or Discontinued

111

ITEMTYPE not in (1,2)

2

Open layer exists in purchase receipts table where valuation method not stamped

112

QTYRECVD <> QTYSOLD

and VCTNMTHD = 0

and PCHSRCTY <> 4

2

Item is on open PO Return

113

Item is on an open po number in POP10300

WHERE POPTYPE in (4,5,6,7)

1

Account not found

109

ACTINDX = 0

1

Account type Profit and Loss

110

Account PSTNGTYP = 1 in GL00100

 

SEE99999 Fields:

  • ITEMNMBR: Item Number
  • LOCATNID: Location ID
  • ERMSGLVL: Error Message Level
  • ERRDESCR: Error Message Description
  • ERMSGNBR: Error Message Number
  • USERID: User ID
  • DATE1: Execution Date
  • TIME1: Time Stamp
  • DEX_ROW_ID: Dex Row ID

 

2- SEE99998 | HITB Staging Table

HITB reset tool will record the Inventory balance brought forward in this table as a staging area before being populated to SEE30303. The balances are primarily retrieved from Purchase Receipt Layer (IV10200) .

Therefore, all records will have a fixed value of "BBF" (Balance Brought Forward) within the HSMODUL (Host Module) field.

 

SEE99998 Fields:

  • ITEMNMBR
  • LOCNCODE
  • DOCDATE
  • GLPOSTDT
  • DOCTYPE
  • DOCNUMBR
  • RCTSEQNM
  • HSTMODUL
  • VCTNMTHD
  • QTYTYPE
  • PCHSRCTY
  • RCPTNMBR
  • VENDORID
  • TRXREFERENCE
  • IsOverrideReceipt
  • DECPLQTY
  • DECPLCUR
  • IVIVINDX
  • LOCIVIVINDX
  • TRXQTY
  • TRXQTYInBase
  • VARIANCEQTY
  • UOFM
  • UNITCOST
  • EXTDCOST
  • CRDTAMNT
  • DEBITAMT
  • DEX_ROW_ID

SEE99997 | HITB Reset Tool Steps

This table records the steps through which the HITB Reset Tool accomplishes. There are primarily six steps as shown below;

Helping Now:

One of the quality checks that are performed in order to ensure that the HITB Reset tool has been implemented correctly is to find all steps recorded in this table (as log details).

SEE99997 Fields

  • SEQNUMBR: Sequence Number
  • Step: Step
  • STRTDATE: Start Date
  • STRTTIME: Start Time
  • Status: Status
  • BACHNUMB: Bach Number
  • ReconStat: Reconciliation Status
  • ERRSTATE: Error Status
  • DEX_ROW_ID:Dex Row ID

Step    Step Description

10      Run Reconcile

20      Data Integrity Checks

30      Populate HITB Staging Table

40      Create GL Clearing Transactions

50      Create GL Transactions and HITB Records

60      Finalize IV Reset

 

Best Regards,

Mahmoud M. AlSaadi

18 comments:

  1. Hi Mahmood,
    thank you very much for the post. Can you please tell me how to solve this "Account not found" problem.I have many items with this warning.
    i am unable to populate table in HITB. on which table is this ACTCINDX=0 ?

    ReplyDelete
    Replies
    1. I was disorganized because i had a very small penis, about 2.0 inches soft and 4 inches hard not nice enough to satisfy my woman, i have been in so many relationship, but cut off because of my situation, i have used so many product which doctors prescribe for me, but none could offer me the help i searched for. i saw some few comments on the internet about this herbal doctor called Dr Aziba and decided to contact him on whatsApp with his mobile no (+2348100368288) i saw on the internet, I decided to give his herbal product a try. he gave me some comforting words with his herbal product for Penis Enlargement, Within 1 week of it, i began to feel the enlargement of my penis, " and now it just 3 weeks of using his products my penis is about 9 inches longer, and i had to settle out with my Ex girlfriend, i was surprised when she said that she is satisfied with my sex and i have got a large penis. Am so happy, thanks to Dr Aziba I also learn that Dr Aziba also help with Breast Enlargement Hips and Bums Enlargement, Low Sperm Count, If you are in any situation with a little Penis, weak ejaculation, small breast_hips_bums do get to Dr Aziba contact him now on his mobile no, or add him up on whatsApp (+2348100368288) Email ( Priestazibasolutioncenter@gmail.com)









      I was disorganized because i had a very small penis, about 2.0 inches soft and 4 inches hard not nice enough to satisfy my woman, i have been in so many relationship, but cut off because of my situation, i have used so many product which doctors prescribe for me, but none could offer me the help i searched for. i saw some few comments on the internet about this herbal doctor called Dr Aziba and decided to contact him on whatsApp with his mobile no (+2348100368288) i saw on the internet, I decided to give his herbal product a try. he gave me some comforting words with his herbal product for Penis Enlargement, Within 1 week of it, i began to feel the enlargement of my penis, " and now it just 3 weeks of using his products my penis is about 9 inches longer, and i had to settle out with my Ex girlfriend, i was surprised when she said that she is satisfied with my sex and i have got a large penis. Am so happy, thanks to Dr Aziba I also learn that Dr Aziba also help with Breast Enlargement Hips and Bums Enlargement, Low Sperm Count, If you are in any situation with a little Penis, weak ejaculation, small breast_hips_bums do get to Dr Aziba contact him now on his mobile no, or add him up on whatsApp (+2348100368288) Email ( Priestazibasolutioncenter@gmail.com)

      Delete
  2. Hi Mahmood,
    thank you very much for the post. Can you please tell me how to solve this "Account not found" problem.I have many items with this warning.
    i am unable to populate table in HITB. on which table is this ACTCINDX=0 ? -

    ReplyDelete
    Replies
    1. Would you please provide further explanation ?

      Best Regards,
      Mahmoud M. AlSaadi

      Delete
  3. hi mahmood,
    actually this is my issue:
    https://community.dynamics.com/gp/f/32/p/186201/467326#467326

    ReplyDelete
  4. I did check the account for items in cards->inventory--> items-->item account mainenance....
    -- Both inventory and inventory offset account exists for the items.
    :(

    ReplyDelete
    Replies
    1. I believe there is a specific transaction which is missing the correct inventory account. As an alternative, go to the posting setup window and provide a general inventory account to be used by the Reset utility temporarily.

      Best Regards,
      Mahmoud M. AlSaadi

      Delete
  5. Dear MOHAMMAD,
    please help me with this error, i have follow the steps and correct the errors but while Populate HITB Staging Table i have got this error.
    [Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot insert the value NULL into column 'VARIANCEQTY', table 'TLTST.dbo.SEE99998'; column does not allow nulls. INSERT fails.*/

    ReplyDelete
  6. hi Mohammad
    problem solved and finalized the process but i could not fined the report in reports>>inventory>>activity
    what could be the reason?

    ReplyDelete
    Replies
    1. It seems you have not completed the process successfully :)

      Best Regards,
      Mahmoud M. AlSaadi

      Delete
  7. dear Mohammad,
    you are right
    thanks

    ReplyDelete
  8. Hi Mahmood, thank you for the great post.
    Should we expect the data in SEE30303 table to be the same as in SEE99998 staging table? The reason I ask is in SEE99998 I have about 58K rows and the sum of ExtCost is reasonably close to GL. In SEE30303, after the reset, there are millions of rows and the totals are way off.
    Thank you!

    ReplyDelete
  9. I think I just answered my own question. Looks like SEE30303 needs to be truncated prior to creating a batch in HITB Reset tool!

    ReplyDelete
    Replies
    1. Thanks for the feedback

      Best Regards,
      Mahmoud M. AlSaadi

      Delete
  10. Hello everyone I was heartbroken because i had very small penis, not nice to satisfy a woman, i had so many relationship called off because of my situation, i have used so many product which i found online but none could offer me the help i searched for. i saw some few comments about this specialist called Dr omohan and decided to email him on so I decided to give his herbal product a try. i emailed him and he got back to me, he gave me some comforting words with his herbal cream for Penis enlargement cream , Enlargement Within 1 week of it, i began to feel the enlargement of my penis, and now it just 1 weeks of using his products my penis is about 9inches longer and am so happy feel free to contact DR omohan on email address dromohanherbalmedicine@gmail.com or whatsapp iom him this number +2348164816038  

    ReplyDelete
  11. I was disorganized because i had a very small penis, about 2.0 inches soft and 4 inches hard not nice enough to satisfy my woman, i have been in so many relationship, but cut off because of my situation, i have used so many product which doctors prescribe for me, but none could offer me the help i searched for. i saw some few comments on the internet about this herbal doctor called Dr Aziba and decided to contact him on whatsApp with his mobile no (+2348100368288) i saw on the internet, I decided to give his herbal product a try. he gave me some comforting words with his herbal product for Penis Enlargement, Within 1 week of it, i began to feel the enlargement of my penis, " and now it just 3 weeks of using his products my penis is about 9 inches longer, and i had to settle out with my Ex girlfriend, i was surprised when she said that she is satisfied with my sex and i have got a large penis. Am so happy, thanks to Dr Aziba I also learn that Dr Aziba also help with Breast Enlargement Hips and Bums Enlargement, Low Sperm Count, If you are in any situation with a little Penis, weak ejaculation, small breast_hips_bums do get to Dr Aziba contact him now on his mobile no, or add him up on whatsApp (+2348100368288) Email ( Priestazibasolutioncenter@gmail.com)









    I was disorganized because i had a very small penis, about 2.0 inches soft and 4 inches hard not nice enough to satisfy my woman, i have been in so many relationship, but cut off because of my situation, i have used so many product which doctors prescribe for me, but none could offer me the help i searched for. i saw some few comments on the internet about this herbal doctor called Dr Aziba and decided to contact him on whatsApp with his mobile no (+2348100368288) i saw on the internet, I decided to give his herbal product a try. he gave me some comforting words with his herbal product for Penis Enlargement, Within 1 week of it, i began to feel the enlargement of my penis, " and now it just 3 weeks of using his products my penis is about 9 inches longer, and i had to settle out with my Ex girlfriend, i was surprised when she said that she is satisfied with my sex and i have got a large penis. Am so happy, thanks to Dr Aziba I also learn that Dr Aziba also help with Breast Enlargement Hips and Bums Enlargement, Low Sperm Count, If you are in any situation with a little Penis, weak ejaculation, small breast_hips_bums do get to Dr Aziba contact him now on his mobile no, or add him up on whatsApp (+2348100368288) Email ( Priestazibasolutioncenter@gmail.com)

    ReplyDelete
  12. Are you having issues in your relationship, or finding it difficult to have a child of your own or are you the type having any diseases in your body. I will advice you to contact Dr. Abolo of Abolospell@gmail.com . The potency of his spell is so effective and can reunite broken relationship and can also make one get pregnant know matter the situation and not only that, he also has the power to cure all type of diseases within the period of 48hours.. Contact him today and thank me later.

    Contact details : Abolospell@gmail.com

    ReplyDelete
  13. HAVE YOU LOST YOUR MONEY TO BINARY OPTION SCAM OR ANY ONLINE SCAM WHATSOEVER?.DO YOUR DESIRE CREDIT REPAIR[EQUIFAX, EXPERIAN, TRANSUNION? WELL, YOU HAVE FOUND REDEMPTION IN ASORE CORP.
    asorehackcorp@gmail.com

    Asore Corp is a group of multinational Hacker's, an affiliate of Evil Corp. We make sure by all means necessary that our clients get the best of services on a🔐PAYMENT AFTER JOB IS DONE BASIS✅. Rather than send money and trust a criminal to fulfill your deal, you can make sure the job is done before WORKMANSHIP is paid for. You'll get excellent customer service.
    That's a 100% guarantee. Our Cyber security Technicians are on standby 24/7 to receive your job requests.

    ⚠️ BEWARE OF FRAUDSTARS looking to hoax.
    if you have been a VICTIM, contact : ✉️cyberprecinct@gmail.com for directives.
    Here, it's always a win for you.

    🔸OUR SERVICES🔸
    ➡️Binary Option funds recovery
    ➡️Social media hack
    ➡️Recovery of loan scam
    ➡️Credit repair (Equifax,Experian,Transunion)
    ➡️E mail hack
    ➡️College score upgrade
    ➡️Android & iPhone Hack
    ➡️Website design
    ➡️Website hack
    And lots more.

    DISCLAIMER: Asore Cyber Corp accepts no responsibility for any information,previously given to anybody by clients on as regarding the job. Asore Cyber Corp will not distribute contact information collected on any hacking job other than in the Asore corps Hacker's listings themselves, and will not sell contact information to third parties.

    CONTACT INFO:
    📧 asorehackcorp@gmail.com
    cyberprecinct@gmail.com

    Copyright ©️
    Asore Cyber Corp 2021.
    All rights reserved.

    ReplyDelete