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...

Sunday, September 13, 2015

Rule of Thumb | Corrupted Enter/Match Invoice

This would be considered as one of the FAQ's since it is raised up often either by some of the community members or by clients. A glitch in the system occurs rarely and result with having the shipment lost on the enter/match invoice form. 

This case applies to clients using the shipment - enter/match cycle in which two separate documents are entered in order to initially receive goods then invoice, as shown below:

Receiving Transaction Entry - Shipment Type

Now the process shall be proceeded by entering the invoice form the enter/match invoice window (Transactions > Purchasing > Enter/Match Invoice). 
 
Enter/Match Invoice


In very rare cases, while a user is entering the invoice, a glitch occurs for whatever reason, resulting with corrupted records, and eventually you may receive an error (No available QTY to match for this shipment). If you are faced with such a case, here are the rule of thumb to be considered as part of troubleshooting the root causes:

  • First of all, check the PO status. When you open to the Enter/Match invoice window and choose the vendor, the system will accordingly bring all "Active" Purchase Order for this specific vendors. This means, the system will check POP10100 for all active purchase order. To do so, there is a key field "STATGRP" which values are:
    • Voided - 0
    • Active - 1
    • Closed - 2
  • Second of all, there are key fields in POP10500 (receipt line quantity). Once you pick a receipt on the Enter/match invoice, this table get populated with data before posting, which is the reason why any glitch would result with corrupted data in the POP10500 and eventually with the ability to match the invoice to the original shipment. The key fields to check are:
    • QTYSHPPD | Quantity Shipped
    • QTYINVCD | Quantity Invoiced
    • QTYREJ | Quantity Rejected
    • QTYMATCH | Quantity Match
    • QTYRESERVED | Quantity Reserved
    • QTYINVRESERVE | Quantity in Reserve 
    • QTYINVAJ | Quantity Invoice Adjustment 
  • The records in POP10500 are flagged either as posted or saved. Check the "Status" field for this piece of information. So the table is designed to hold both types of data (saved and posted) and always gets populated on the run time while filling on data on the application level.
Best Regards,
Mahmoud M. AlSaadi

5 comments:

  1. Hi mahmood, I am looking at 10500 to pull inventory receipts for a report. I am not sure which feild to take . What is the difference between QTYSHPPD | Quantity Shipped QTYINVCD | Quantity Invoiced.; Which one actually hits inventory.

    Thanks Russ

    ReplyDelete
    Replies
    1. Hello Russl
      Quantity shipped hits the inventory, as a result of "Shipment or Shipment and invoiced"

      Then when an invoice is posted, the quantity invoiced is updated while the inventory is updated with any cost revaluation at this moment.

      Best Regards,
      Mahmoud M. AlSaadi

      Delete
  2. Salaam Mahmoud, what is the difference between QTYMATCH and QTYINVCD in POP10500?

    ReplyDelete
  3. Mahmoud M. AlSaadi, what is the difference between QTYMATCH and QTYINVCD in POP10500?

    ReplyDelete
  4. BE SMART AND BECOME RICH IN LESS THAN 3DAYS....It all depends on how fast 
    you can be to get the new PROGRAMMED blank ATM card that is capable of
    hacking into any ATM machine,anywhere in the world. I got to know about 
    this BLANK ATM CARD when I was searching for job online about a month 
    ago..It has really changed my life for good and now I can say I'm rich and 
    I can never be poor again. The least money I get in a day with it is about 
    $50,000.(fifty thousand USD) Every now and then I keeping pumping money 
    into my account. Though is illegal,there is no risk of being caught 
    ,because it has been programmed in such a way that it is not traceable,it 
    also has a technique that makes it impossible for the CCTVs to detect 
    you..For details on how to get yours today, email the hackers on : (
    atmmachinehackers1@gmail.com ). Tell your 
    loved once too, and start to live large. That's the simple testimony of how 
    my life changed for good...Love you all ...the email address again is ;
    atmmachinehackers1@gmail.com

    ReplyDelete