Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Best way to create an ...
Microsoft Dynamics GP (Archived)

Best way to create an invoice in GP without the inventory actually being available

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

Hello,

 

We had customer recently ask "is there a way to create an invoice in GP without the inventory actually being available?  Here is the situation, we need to invoice a customer for inventory they have purchased (we order raw materials and then manufacture an item for them) but we are "holding" their inventory until each of their stores requests qty of this item.  The corporate account is paying for the whole PO at once but wants us to warehouse the product until their stores need it.  I am stuck at how to create the invoice without the actual items being made up.  We need to create the invoice, recognize the revenue and cost of the inventory items, BUT we are not shipping the inventory so we do not want inventory relieved. "

 

 

Any help would be greatly appreciate

 

*This post is locked for comments

  • Imad Kassoumah Profile Picture
    Imad Kassoumah 3,235 on at
    RE: Best way to create an invoice in GP without the inventory actually being available

    Hi,

    I have the following suggestion:-

    1. Issue a sales order invoice and select  Drop Shipment box

    2. Post the invoice

    3. All the accounts will be affected (Receivables, Sales, Inventory and cost of sales) plus  

           the customer account.

    4. By selecting the Drop Shipment box, the inventory quantity will not be affected. This

           will result that Inventory Stock value will not tally with Inventory G/L.

    5. Create an inventory site called cccc_CONSIGN where ‘cccc’ is the customer number

    6. Make an inventory transfer from the issuing site to cccc_CONSIGN and qty type from

           ON Hand to In Use.

    7. Doing the above will make Inventory Stock value to tally with G/L.

    8. Also, the above will give us the ability to know the stock qty per customer

           (cccc_CONSIGN).

    9. Once you deliver the qty to the customer; then we have to make a transfer with qty

           type from In Use to Damaged.

    Regards.

  • L Vail Profile Picture
    L Vail 65,271 on at
    RE: Best way to create an invoice in GP without the inventory actually being available

    Hi,

    I don't think this will allow them to recognize the COGS. I wonder, who owns the inventory at this point? Could it be treated more like a consignment item than owned inventory?

    Leslie

  • Suggested answer
    Rick Hollis Profile Picture
    Rick Hollis 495 on at
    RE: Best way to create an invoice in GP without the inventory actually being available

    Create an Invoice using the Invoicing module and make the items non inventoried items.  This will allow you to issue an invoice with out affecting inventory.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans