Adjusting unit costs

(0) Share

Report

Posted on by Romryan

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

I have the same question (0)

All responses (4)

Answers (1)

Suggested answer

Frank Hamelly | MVP... 46,625 Super User 2025 Season 2 on at

Like (0)

Report

No, once the invoices are posted, the system will not change the invoice record itself, even though COGS and inventory are adjusted.

Was this reply helpful? Yes No
Verified answer

L Vail 65,271 on at

Like (0)

Report

Hi,

Frank's right.

Leslie

Was this reply helpful? Yes No
Romryan on at

Like (0)

Report

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

Was this reply helpful? Yes No
kmalone43 894 on at

Like (0)

Report

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.

Was this reply helpful? Yes No