Skip to main content



No record found.

Microsoft Dynamics SL forum

Reset last cost

Posted on by 60

 Is there a way to reset all the last costs fields to zero? We split our database into two. one for valued and one for zero value. All the information from the original (valued) was copied to the new (zero dollar) so there are values in the last cost field that are defaulting onto POs and SOs. We would like everything in the zero dollar data base to have cost of zero.





  • BikingDana Profile Picture
    BikingDana 60 on at
    Re: Re: Reset last cost

    We are going to try setting POs to look at Standard Costs, all the Standard Costs should be at zero as we used Average Cost in the original database.




  • pbrattin Profile Picture
    pbrattin 1,850 on at
    Re: Reset last cost

    This is two part answer. To my knowledge there is no way in the SL screens to set the last cost to zero. However, it is a fairly simple script to do it via SQL. The person who does it with SQL should be knowledgeable about SQL and the SL tables. Plus, a SQL backup of the DB should be made before running the script.

  • Re: Reset last cost


    Thanks for posting! Unfortunately, this is not possible. However, you can modify the way the cost defaults into the Purchase Order screen by changing the Default Unit Cost option in PO Setup. The Cost showing in Sales Orders is for reference only and is not actually used in the system.  Once you create the Shipper, run the Sales Journal, and release the IN Batch the Costing in the Shipper and on the Sales Journal is changed to reflect the actual cost.

    I hope this helps.  Please let me know if you have any other questions or concerns.

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .


André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,989 Super User

Martin Dráb Profile Picture

Martin Dráb 225,588 Super User

nmaenpaa Profile Picture

nmaenpaa 101,148


Featured topics

Product updates

Dynamics 365 release plans