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
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
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,219 Super User 2024 Season 2
Martin Dráb 230,056 Most Valuable Professional
nmaenpaa 101,156