Skip to main content

Notifications

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

Cost of carriage

(1) ShareShare
ReportReport
Posted on by 19
Hi everyone. We use a /non inventory/ item called CARRIAGE to charge our customers for delivery of their sales orders. We do not know the exact cost at the time we put the order on, so manually put the cost of each delivery on after it has been shipped but before invoicing. We can have 50-100 sales orders per day so this takes a reasonable amount of time. What I would like is a simple way of allocating the costs in bulk - either before invoicing or after invoicing. 
 
I have tried to use item(charge) but that doesn't seem to work.
 
Are we doing something wrong? Should we charge the carriage in a different way? 
 
Any advice much appreciated.
 
Duncan
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 76,948 Super User 2025 Season 1 on at
    Cost of carriage
    Hi, as several other experts mentioned, this should be done using item(charge).
    If your costs are not updating, please check the setting below. 
     
    Or manually run the following Batch and try again.
     
    Hope this can give you some hints.
    Thanks.
    ZHU
  • Suggested answer
    Cost of carriage
    Hi Ducan,
     
    Please try use Item charges in sale invoice and assign this carriage cost for multiple posted sale shipment if you want to charge this cost to the customer.
    Item charges in posted sale invoice will credit to Sale Account/ Sale Vat Account and Debit to Receivable Account.
     
    When you want to record the carriage cost as Direct Cost Applied account, you can use Item charges in Purchase invoice and assign to posted sale shipment lines.
     
    Hope that those information can help you.
     
    Lien Nguyen
  • Suggested answer
    Valentin Castravet Profile Picture
    Valentin Castravet 25,642 Super User 2025 Season 1 on at
    Cost of carriage
    In the Sales Invoice Statistics look at the Adjusted fields. Only Adjusted fields will get updated based on item charges:
     
     
    What table/fields is your Power BI Report based off? If its based off of the posted sales invoice lines, the item charge does not affect those. If the report is based off of the item ledger entries, then you would get correct updated numbers. 
     
     
  • DH-08051225-0 Profile Picture
    DH-08051225-0 19 on at
    Cost of carriage
    Hi Valentin,
     
    Thanks for the quick reply. I tried to use Item Charges by creating a Purchase Invoice for Carriage and assigning the cost to the relevant line on the sales order. However when I then look at the statistics of the sales invoice it doesn't show the cost and it doesn't show up in any Power BI report that I do to analyse the sales & costs for specific invoices or customers. 
     
    Where would BC show that cost on the invoice related to the shipment? 
     
    Apologies for my lack of knowledge!
  • Valentin Castravet Profile Picture
    Valentin Castravet 25,642 Super User 2025 Season 1 on at
    Cost of carriage
    Ideally you would use item charges, why doesn't that work for you? What specific problems have you had?
     

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,979 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,848 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans