Skip to main content

Notifications

Announcements

No record found.

Small and medium business | Business Central, N...
Suggested answer

How to distribute a sales price over multiple revenue accounts

(1) ShareShare
ReportReport
Posted on by 207

Our sales rate consists of the components: covering freight costs and turnover. Is it possible to distinguish between these in the general ledger?

For example:
sales rate is €10.
€2 relates to cover the freight costs.
€8 is the turnover we have left over.

We would like to book €2 to the 'turnover freight' account and €8 to the 'turnover article' account. Is this possible?

further info:
- Freight costs differ for each article. It is therefore not possible to allocate a fixed percentage to transport costs.
- On our invoice we only want to show the selling price so not the distinction which part relates to freight costs.
- Customer insists on freight costs being included in the sales price

  • Suggested answer
    Valentin Castravet Profile Picture
    Valentin Castravet 24,925 Super User 2024 Season 2 on at
    RE: How to distribute a sales price over multiple revenue accounts

    You can achieve this using item charges and minor customizations to the sales order or invoice report.

    i.e. on your sales order enter 2 lines:

    line 1: item with €8 price

    line 2: item charge for freight applied to the 1st line, €2 price, or whatever price is required

    Each line would be tied to a different G/L account based on the posting groups. You would then customize your sales order or invoice report to consolidate the 2 lines in the order to 1 line in the report, so in the report you would have 1 line for €10

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 Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,445 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans