{"id":27835,"date":"2020-02-18T11:22:25","date_gmt":"2020-02-18T11:22:25","guid":{"rendered":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/?p=27835"},"modified":"2024-05-02T05:25:52","modified_gmt":"2024-05-02T05:25:52","slug":"update-most-recent-cost-in-location-details","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2020\/02\/18\/update-most-recent-cost-in-location-details\/","title":{"rendered":"Update Most Recent Cost in Location Detail"},"content":{"rendered":"\n

A unit cost is a price for one item \/ Product or measurement, such as a pound, a kilogram, or Ea. and as per the Business aspects sometimes that you have mentioned unit price while processing the Orders. <\/p>\n\n\n\n

In this blog, we will discuss about customization done on the \u201cIC location detail screen\u201d for one of our clients to update the Most Recent cost in Location details In Sage 300<\/a>.<\/strong><\/p>\n\n\n\n

As we are aware about the standard functionality of the transaction screen, once we insert the item number on the detail level of the Respective transaction screen then the value of unit cost will be display from the Location detail screen. (Average Cost). In case if the system found Average Cost \u201d0\u201d then the system picks Most Recent Cost (MRC) and get an update to the field of Unit cost for the respective location. <\/p>\n\n\n\n

Please note that the MRC is updated in a Location on the Creation of a PO Receipt or Inventory Transfer. If these Transactions have not taken place in a Location, MRC will be \u201c0\u201d. Therefore, in order to avoid transaction being costed at 0, we would like MRC for an Item to be updated in all locations other than the Main Location for that Item.<\/p>\n\n\n\n

New Stuff: –<\/strong> <\/code>Migrate Receive Payment from QuickBooks to Sage 300 ERP<\/a><\/p>\n\n\n\n

<\/p>\n\n\n\n

We have done the below configuration along with the customization. <\/p>\n\n\n\n

we will create the Optional field =\u201d DEFLOC\u201d, Type: -\u201d Text\u201d and we will map to the IC item master and the Optional field value will be \u201cLocation code\u201d and the description will be \u201cLocation Name\u201d. (Refer below Screen) <\/p>\n\n\n\n

\"Optional<\/a>
Sage 300 (Desktop)- Common Services -Optional field Screen<\/strong><\/figcaption><\/figure>\n\n\n\n

Now same Optional field, we will map to the IC item from IC Item master screen and value will be location code from the above list of locations. (Refer below screen).<\/p>\n\n\n\n

\"I\/C<\/a>
Sage 300 (Desktop)- I\/C Item Master Screen<\/strong><\/figcaption><\/figure>\n\n\n\n

That means\u201d 01\u201d is the default location for the item Number\u201d A1-103\/0\u201d.<\/p>\n\n\n\n

Let\u2019s understand and identify the condition when we need to update MRC in the Location Details screen.<\/p>\n\n\n\n