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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / 3rd Party Sales on the...
Small and medium business | Business Central, N...
Answered

3rd Party Sales on the Business Central

(2) ShareShare
ReportReport
Posted on by NO-04080236-0 12
Please I want you to be of help as to running the 3rd party sales on the BC, where it won't affect the financial of the client and still the client will make sales out and capture inventory movement...and then the commission posted against the good as his income
Categories:
Dynamics 365 Business Central
I have the same question (0)
  • Verified answer
    Sumit Singh Profile Picture
    Sumit Singh 11,795 Super User 2026 Season 1 on at

    Recommended Setup in Business Central
    1. Item Setup
    • Create items as usual, but do not assign inventory value.
    • Use Item Tracking if needed (e.g., serial or lot numbers).
    • Set Inventory Posting Group to a separate group like ThirdPartyStock.
    2. Location Setup
    • Create a dedicated Location (e.g., ThirdParty) to hold consigned inventory.
    • Set this location to not affect financial inventory:
      • Disable Expected Cost Posting to G/L.
      • Use non-financial inventory posting group.
    3. Inventory Movement
    • Use Item Journals to record physical receipt of goods into ThirdParty location.
    • Use Transfer Orders if goods move between locations.
    This allows tracking of inventory movement without affecting financials.

    4. Sales Order Processing
    • Create Sales Orders for third-party items.
    • Use Sales Line Type = Item but ensure:
      • No cost is posted (use zero cost or custom posting group).
      • Revenue is not recognized from item sale.

    5. Commission Income Posting
    • Create a G/L Account for Commission Income.
    • Use Resources or G/L lines on the Sales Order to post commission earned.
    • Alternatively, use a Service Item to represent commission.

    6. Reporting & Reconciliation
    • Use Item Ledger Entries and Location filters to track third-party stock.
    • Use Sales Analysis Reports to track commission earned.
    • Reconcile with third-party vendor periodically.

    Note: This response was created in collaboration with Microsoft Copilot to ensure clarity and completeness. I hope it helps to some extent.
    Mark the Answer as Verified if this is Helpful.
     
  • Verified answer
    DAnny3211 Profile Picture
    DAnny3211 11,421 Super User 2026 Season 1 on at

    Hi there,

    To manage 3rd party sales in Business Central without affecting the client's financials directly, while still capturing inventory movement and posting commission as income, you can consider the following approach:

    1. Use a Separate Customer or Vendor Record:

      • Create a dedicated customer or vendor to represent the 3rd party transactions. This helps isolate the financials from the client’s core operations.

    2. Inventory Movement via Transfer or Assembly Orders:

      • Use Transfer Orders or Assembly Orders to reflect inventory movement without triggering standard sales posting.
      • Alternatively, use Item Journals to manually adjust inventory levels.

    3. Record Commission as Income:

      • Create a Sales Invoice or General Journal Entry to post the commission earned as income.
      • Use a dedicated G/L Account for commission revenue to keep it separate from product sales.

    4. Avoid Financial Impact on Client:

      • Ensure that the 3rd party sales are not linked to the client’s main financial dimensions or posting groups.
      • You can use dimensions to track and report separately.

    5. Custom Extension (Optional):

      • If the process is complex, consider a small extension to automate the workflow and ensure compliance with your business rules.

    Let me know if you'd like help setting up the journals or designing a custom flow!

    Please verify if this response was helpful.

    Best regards!

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 1,909 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,145 Super User 2026 Season 1

#3
AndrewThomas81 Profile Picture

AndrewThomas81 974

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans