web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Manufacturing Big Problem "Hidden Quantity"

(0) ShareShare
ReportReport
Posted on by 375

Dear My all professional friends in this site , i wish if anyone could help me to resolve this problem about the Manufacturing module , when i make the steps of making Item , For example ( 1- Entry, 2-Picklist, 3- Component  TRX, 4-MO Receipt entry, 5-MO Close ) we have made everyday all this steps to make raise the quantities of the Items up , suddenly some items after making the MO CLOSE of the final step of MANUFACTURING ORDER , the quantity can't not appear in the available quantity of item , or the Transaction can't appear on the Item stock inquiry report ,  we have made Check Links many times but it not works , also we have made Reconcile for that item although this one has not any allocation quantity , could anyone know where's the defection step ? need the solution in the soonest time please because it makes for us a very bad headache from the representatives , they can not take them invoices for the reason of the hidden quantity , thanks for all friends who will collaborate in this issue , have a nice work for all 

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Richard Whaley Profile Picture
    25,195 on at

    Several things you can look at.

    First, of course is the list of Inventory Transactions for the item (inventory->inquiry->Item Transaction). Make sure to sort by date.  Do you see the MO Receipt posted (it will be a positive adjustment but the details will show the MO number.  Are there any transactions that consume the quantity?  

    Second, under Manufacturing->Inquiry->Manufacturing Orders, the MO Activity list.  This displays a list of all activity from the MO including Inventory, financial, et cetera.  Set the Show Document Type to IV Transactions to see all issues of components, receipts of finished goods, and potentially any reverse issues.

    Third, in the same menu group, the MO Receipt Inquiry.  Select the range of MO Number, uncheck the Don't show reversed entries, and then click Refresh.  Look for the MO Receipt transactions.  Are they there?  Are there any Reverse Receipts?

    Forth, is the part being manufactured a Sales Inventory Type?  Look in Inventory->Cards->Item and look up the part.  Check the setting in the Item Type field.

    I hope these help you chase down the problem.

    BTW, we have a nice selection of books on Manufacturing.  They are available from our web site or from Amazon.com if you are outside of the USA

  • Verified answer
    Bron Profile Picture
    4 on at

    Richard - good suggestions.

    May I ask if it appears all MO receipts are not updating Inventory or is it only a certain few? I'm wondering if Item history is turned off or if some inventory batches are not posted..........

    The MO activity inquiry screen should show everything for an MO - unfortunately lots of manufacturing clients don't know it or use it...........drill back capability as well.

    Good luck - let us know if it's a random thing or everything.............

  • Verified answer
    Zhigang Lu Profile Picture
    795 on at

    Please check what your Default Close Calculation Option is. (Microsoft Dynamics GP menu >> Tools >> Setup >> Manufacturing >> System Defaults >> Manufacturing Orders)

    If the manufacturing order end quantity doesn’t match the total received from the order and  you’re closing a manufacturing order for a standard cost finished good item and you need choose the Total Quantity Received calculation option.

    Also please check the component in bill of material. If the component has a fixed quantity on the bill of materials that hasn’t been consumed through earlier receipts,  that quantity will be backflushed when the manufacturing order is closed.

  • Mohammad Abou Aly Profile Picture
    375 on at

    At first i would like to thank you sooo much for sending my this suggested answer , in deed i have followed all your steps up very carefully step by step from first to fourth one ,

    first : all data on the items fine and well

    second : the same no interupption in data or any defection

    third : here this point i checked it very well and no any revesed receipts but i have noticed something wired in this window of " MO receipt Inquery " the option of the " create reverse receipt " was inactive on mostly of all items however 3 or 4 items only was active and i have clicked on it , was moved me to open new window to post the some items of this receipt and the botton of POST , it's something new for me after i have seen this new step , i stopped and not continue actually because maybe risky step to do , so i'm wondering you a gain MR to help me what's that exactly of this new window ?

  • Mohammad Abou Aly Profile Picture
    375 on at

    Actually i have done this step too , i have already opened the MO Activity and some of items kinda has all inquery of the data for example : Close MO , Complete MO , finished good post and raw matrials reliefs and the others things , the important thing here is some other items can't appear this data like the first , i don't know reasons , so could you help me how can i fix the issue to avoid happening it a gain on my system ? it's really necessary for me , thanks for all people who they are helping me and concerning to my bugs and errors , good luck for all

  • Mohammad Abou Aly Profile Picture
    375 on at

    May i ask qauestion please about the word of the BACKFLUSHED , what does it mean ? and what does it to use about ? would you mind if you told me what i should to mark the option on the MO Setup when i go to the System defaults please , sincerely : Mohammad Abou Aly

  • Zhigang Lu Profile Picture
    795 on at

    >May i ask qauestion please about the word of the BACKFLUSHED , what does it mean ? and what does it to use about ?

    Please review the following explanation from GP Manufacturing Help.

    Backflushing bill of materials components

    Backflushing is a method of accounting for the use of resources—labor, machine time, and items—based on standards you’ve defined. Transactions to account for the use of backflushed resources are created when finished goods are received.

    For example, your business might include a procedure for painting part numbers on items. The paint used for the procedure is minimal, so you estimate that 0.01 grams of paint are used per finished item. When you create the bill of materials for the finished item, you include the paint as a component of the finished item and you mark the item to be backflushed. Later, when you receive finished goods for a manufacturing order based on the bill of materials, inventory transactions will be created to account for the use of paint, according to the bill of materials and the manufacturing order quantity.

    Backflushing is typically used when a component is used in very small quantities—such as in the paint example—or when the cost of the component isn’t significant enough to warrant the expense of issuing and tracking components.

    You can backflush entire bills of materials or specific components. You must backflush items whose Item Type (from the Item Maintenance window) is Services, Flat Fee, or Miscellaneous, or if the item is floor stock. You also can backflush phantom parent items or components of phantom parent items.

    To backflush all components   Mark Backflush Components in the Bill of Materials Entry window (Cards >> Manufacturing >> Bill of Materials).

    To backflush only specific components   Mark the Backflush option in the Bill of Materials Entry window for all the components that should be backflushed.

    When an item is marked as backflushed in the Bill of Materials Entry window, the Backflush option in the Picklist window automatically will be marked.

    >would you mind if you told me what i should to mark the option on the MO Setup when i go to the System defaults.

    I think you need choose the Total Quantity Received calculation option. I guess you choosed the Start Quantity calculation option now, it caused a transaction was created when you close MO. For detail explanation, please review GP Manufacturing Help-How backflushed item quantities are calculated.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans