How to distribute a sales price over multiple revenue accounts

(1) Share

Report

Posted on by Joel95

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

Categories:

Dynamics 365 Business Central

All responses (1)

Answers (0)

Suggested answer

Valentin Castravet 24,925 Super User 2024 Season 2 on at

Like (0)

Report

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