Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Purchase Orders/Re...
Microsoft Dynamics GP (Archived)

Purchase Orders/Receiving Inventory

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

I have an item that is purchased from one vendor, sent to another vendor for printing and then received at my warehouse.  We do a purchase order for both vendors.  Can someone tell me how to handle the receiving and invoicing?.  I cannot receive both PO's because it will double the quantity actually received and the cost would be off.  Also once I enter the invoice into the system it will change the cost.

 I am not sure how to receive the merchandise and enter the invoices in without messing up the actual quantity and cost.


Thank you!!!!

*This post is locked for comments

  • L Vail Profile Picture
    L Vail 65,271 on at
    Re: Re: Re: Re: Re: Re: Re: Re: Re: Purchase Orders/Receiving Inventory

    Hi,

    Current cost will update if you post an inventory transaction.

    Kind regards,

    Leslie

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Re: Re: Re: Re: Re: Re: Re: Purchase Orders/Receiving Inventory
    I don't know. Just zero out or cancel the PO? I guess I can try the landed cost way Leslie said. I am just not familiar with that. Is using inventory adjustment a problem in terms of costing or the GL. Will the current cost update based on an inventory adjustment? Thanks!!
  • Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 46,317 Super User 2025 Season 1 on at
    Re: Re: Re: Re: Re: Re: Re: Purchase Orders/Receiving Inventory
    Frank- My tube is set up as an inventory component item. Is it a problem to just enter the quantity received as an adjustment with the total tube and printing cost as the cost. Will I have a problem when the individual invoices are entered in relation to the item cost? Will the invoice costs override the cost that is shown due to the adjustment? Thanks
     
    Joanne, if you're not matching your vendor invoices to a receipt, i.e., using Transaction Entry instead of Enter/Match invoices, then no, the invoice will not affect the item cost.  However, if you use inventory adjustments instead of receiving transactions, how will you handle the open POs?
  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Re: Re: Re: Re: Re: Purchase Orders/Receiving Inventory
    Leslie, That is what I meant. I only have this situation with a handful of items. Everything else is easy or gets done via a BOM like Frank had mentioned earlier. Thanks
  • L Vail Profile Picture
    L Vail 65,271 on at
    Re: Re: Re: Re: Re: Purchase Orders/Receiving Inventory

    Hi,

    I do not understand what you mean by 'individual basis'. If you mean can you apply it to the item on one PO and not others then the answer is yes.

    Leslie

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Re: Re: Re: Purchase Orders/Receiving Inventory
    Leslie- I will have to look at that in the test system. Can landed cost be used on an individual basis? I have to read more about that to know if it is good for us or not. Thank you!!!
  • L Vail Profile Picture
    L Vail 65,271 on at
    Re: Re: Re: Purchase Orders/Receiving Inventory

    Joanne,

    We use Landed Costs to capitalize the true cost of an item. Commonly, total landed cost is the sum of all costs associated with making and delivering products to the point where they produce revenue. Items such as brokerage and logistics fees, shipping costs, customs duties, tariffs, taxes, insurance, currency conversion, crating costs, and handling fees are typical landed costs.

    On a PO line item hit the little blue arrow next to the item and it will open the Purchasing Item Detail Entry window. In the lower left quadrant of that window you will see a prompt for Landed Cost Group ID. If you zoom back on that prompt it will take you to the Landed Cost Group Maintenance window, from there you can zoom back to all of the places you need in order to set up landed costs. When you get to the Landed Cost Maintenance window you will see a checkbox for Invoice Match on the left side. By checking this box you will require invoices for this landed cost be matched to shipments. The landed cost is actually capitalized into the cost of the item so that your COGS number will not be understated.

    The process is pretty well documented in the user manual and in the help screens.

    Do you think this will help?

    Kind regards,

    Leslie

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Re: Re: Re: Re: Re: Purchase Orders/Receiving Inventory
    Frank- yes.
  • Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 46,317 Super User 2025 Season 1 on at
    Re: Re: Re: Re: Re: Purchase Orders/Receiving Inventory

    Joannre,

    Are you talking entering an inventory adjustment instead of a receiving transaction?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Re: Re: Re: Purchase Orders/Receiving Inventory
    Frank- My tube is set up as an inventory component item. Is it a problem to just enter the quantity received as an adjustment with the total tube and printing cost as the cost. Will I have a problem when the individual invoices are entered in relation to the item cost? Will the invoice costs override the cost that is shown due to the adjustment? Thanks

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,494 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,305 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans