Dear all,
I have some invoices that went in with wrong units costs i.e. the unit costs is higher than the selling price.
I tried to adjust the unit costs on some invoices but i found it only adjusts inventory and cost of sales GL accounts but the sales invoices remain the same .Is there a way one can make it adjust the units cost of the respective invoice and update sop and receivable modules?
RomRyan
*This post is locked for comments
This is a short-coming to GP reporting if you ask me. There should be at minimum, an easily reportable field called 'Unit Cost - Adjusted & Extended Cost - Adjusted available in GP reports.
It's not uncommon in ANY business to sell an item & then have a change to those costs AFTER the fact (purchase invoice <> purchase shipment, landed cost invoice <> accrual, sales invoice was entered before purchase shipment thus purchase shipment causes adjustment, etc.).
Has anyone written this report? I'm sure it'll involve pulling from one of the IV table where the cost adjustment is stored.
Thanks you Frank and Leslie for that quick update
I have some questions,
If I change the unit cost for a particular invoice,what will be the effect on consecutive invoices and other inventory transactions e.g. (receipt) as far as unit costs is concerned?
secondly,now that its only GL accounts for inventory and cost of sales are updated after adjusting unit costs,do I need to do the sales returns and the repeat the invoices with the correct unit costs and make sure they dont hit GL?
RomRyan
No, once the invoices are posted, the system will not change the invoice record itself, even though COGS and inventory are adjusted.
#1
André Arnaud de Cal...
293,209
Super User 2025 Season 1
#2
Martin Dráb
231,923
Most Valuable Professional
#3
nmaenpaa
101,156
Moderator
Share
Report
All responses (
Answers (
