You’re offline. This is a read only version of the page.
Announcements
20
A client came in with this requirement recently. I greatly appreciate any guidance you can give me.
How can I register the COGS in this scenario?
They need to be able to see the customer sales statistics report.
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
Hi Kim, thank you very much for your answer option 2 sounds great, with code we can automate the creation of sales invoices.
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.
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.
#1
André Arnaud de Cal...
294,125
Super User 2025 Season 1
#2
Martin Dráb
232,871
Most Valuable Professional
#3
nmaenpaa
101,158
Moderator
Share
Report
All responses (
Answers (
