Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Sales Order - allocating, shipping and invoicing

Posted on by 475

We are implementing right now. I would like to understand:

1. In what screen is lot-controlled inventory allocated?

2. In what screen are packing lists created and inventory actually decremented?

3. In What screen are sales invoices created?

4. Is there an easy way of inquiring on running general ledger activity for specific accounts?

Thank you.

*This post is locked for comments

  • Suggested answer
    Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at
    RE: Sales Order - allocating, shipping and invoicing

    Hello Grocknkr

    Lot number tracking process in Dynamics GP starts with the configuration of the item, when an item is set up to be tracked by "Lot Number", all inventory related transactions (in and out) will prompt a window either to enter a new lot, or to withdraw from a specific lot. Therefore, any out transaction which leads to "IV Allocation" will prompt a lot-related window in order to specify the lot number from which to withdraw.

    Packing lists can be printed from Sales Transaction Entry window and has nothing to do with the decrement of inventory balance. When an inventory transaction is saved, inventory allocation is created to reserve the quantity. Once the transaction is posted, inventory balance is decreased accordingly.

    Entering sales transactions can be done either on the SOP or AR module. Sales Order Processing (SOP) is designed to manage the sales transactions of inventory-related items (Transactions > Sales > Sales Transaction Entry). As for service, Receivable Management module (Transactions > Sales > Transaction Entry)

    General Ledger activity have multiple reporting methods which are primarily divided among the following categories:

    • Inquiry: This window is transaction-like, it has the same fields of the transactions but inactive. For instance, Journal Entry inquiry, account summary balance, account detail balance.
    • Reports: GL has a variety of reports which can be used for archiving, documentation or official purposes such as audit. General Ledger trial balance report is the most common report to inquire for account transactions (Reports> Financial > Trial Balance)
    • Smart lists: which is Excel-like reporting tool with further more flexibility than the above, you can add columns, search for specific records and most importantly export to Excel. For GL, you have Smart lists> Account Transactions


    Please never hesitate to share any further inquiries,

  • Suggested answer
    soma Profile Picture
    soma 24,406 on at
    RE: Sales Order - allocating, shipping and invoicing

    1. While creating Sales Transaction for lot items, the Sales Lot Number Entry window will pop up to enter the inventory allocation for lot numbers.

    2. I think no separate window available for inventory picking list. But, you can view the report for sales inventory picking list after saved the Sales orders by clicking print button from SOP entry window or Sales Batch window.

    3. Sales Transaction Entry window(Transactions-->Sales-->Sales Transactions Entry)

    Note: This window is also used for creating Quote, Order, Fulfillment Order, BackOrder and Return. So, choose invoice as a SOP type while creating Sales invoices.

    4. Go Financial Trail Balance reports(Reports-->Financial-->Trail Balance)  and chose historical trail balance from option list and click new or modify to print the GL reports for specific account numbers.

    Hope this helps!!!

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,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans