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

Notifications

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... / Cost of goods sold for...
Small and medium business | Business Central, N...
Answered

Cost of goods sold for license sales company

(0) ShareShare
ReportReport
Posted on by Carlos Reyes G 20

A client came in with this requirement recently. I greatly appreciate any guidance you can give me.

  • They sell licenses for which they bill their customers monthly.
  • They pay a vendor once a year according to the consumption they have had in the year, the vendor generates a single invoice for all clients they have, each line of the invoice is what they must pay for the consumption of each one of your clients.

How can I register the COGS in this scenario?

They need to be able to see the customer sales statistics report.

Categories:
Dynamics 365 Business Central
I have the same question (0)
  • Suggested answer
    Dallefeld Profile Picture
    Dallefeld 211 User Group Leader on at

    I would use Dimensions to capture the information. Maybe call it customer dimension or license dimension. Assign to each customer so that the monthly invoices get the sales amount. And then when the vendor invoice is processed, enter a seperate line assigned the applicable customer to each line.

    This will not update the customer sales statistics report but you can pull the information from the general ledger.

    Option2 - generate a separate invoice to each customer for zero dollars, manually enter the unit cost from the vendor invoice. This seems more labor intensive.

  • Suggested answer
    MahGah Profile Picture
    MahGah 15,529 on at

    Hi

    Once I was working with smaller company but similar situation. They had separate part number of each client. Then they invoice the client for the same part number and when they received the invoice they created PO (from invoice) for each part number. But as I said they had a few hundred customers and they could use Excel file to convert vendor invoice to part numbers.  

  • Suggested answer
    Dallefeld Profile Picture
    Dallefeld 211 User Group Leader on at

    MahGah, I really like this option!

  • Suggested answer
    MahGah Profile Picture
    MahGah 15,529 on at

    Thanks Kim.

  • Carlos Reyes G Profile Picture
    Carlos Reyes G 20 on at

    Hi Kim, thank you very much for your answer option 2 sounds great, with code we can automate the creation of sales invoices.

  • Carlos Reyes G Profile Picture
    Carlos Reyes G 20 on at

    Hi MahWah, thank you very much for your answer, it is a good option but due to the size of this client I find it very difficult to maintain.

    Thank you

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,917

#2
Jainam M. Kothari Profile Picture

Jainam M. Kothari 1,161 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 1,025 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans