Update Most Recent Cost in Location Detail

By | February 18, 2020

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.

In this blog, we will discuss about customization done on the “IC location detail screen” for one of our clients to update the Most Recent cost in Location details In Sage 300.

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 ”0” then the system picks Most Recent Cost (MRC) and get an update to the field of Unit cost for the respective location.

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 “0”. 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.

New Stuff: – Migrate Receive Payment from QuickBooks to Sage 300 ERP

We have done the below configuration along with the customization.

we will create the Optional field =” DEFLOC”, Type: -” Text” and we will map to the IC item master and the Optional field value will be “Location code” and the description will be “Location Name”. (Refer below Screen)

Optional Field
Sage 300 (Desktop)- Common Services -Optional field Screen

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).

I/C Item Master Screen
Sage 300 (Desktop)- I/C Item Master Screen

That means” 01” is the default location for the item Number” A1-103/0”.

Let’s understand and identify the condition when we need to update MRC in the Location Details screen.

  • If Most Recent Cost (MRC) > 0 in DEFLOC, update this Cost in IC Location Details MRC Field for remaining Locations that means if the system found most Recent cost is greater than “0” from location details screen for the default location (as per above screenshot default location is “1”) then the same value will get updated in other Reaming Location. (Refer below Location details screenshot that illustrates the MRC is greater than “0”)
IC Location Details
Sage 300 (Desktop)- I/C Location Details Screen

  • If any Location is not available for an Item in IC Location Details, Location needs to be inserted and MRC updated as per above logic that means if System found location created from Location master screen but not present in the IC Location Details screen then the same location get inserted and value should be updated based on the above logic.
  • If DEFLOC is not available in Items or DEFLOC is not a Valid Location, skip the Item.

For the reference purpose, we will maintain Log file which includes details of item Number, DEFLOC, DEFLOC Avg Cost, DEFLOC MRC, MRC Updated status (Successful/ Unsuccessful)

The purpose of this blog, system always pick Most Recent Cost (MRC) and get update to the field of Unit cost for the respective location in case the system found Average Cost ”0” from the Location detail screen in Sage 300.

About Us:-

Greytrix – a globally recognized and one of the oldest Sage Gold Development Partner is a one-stop solution provider for Sage ERP and Sage CRM organizational needs. Being acknowledged and rewarded for multi-man years of experience, we bring complete end-to-end assistance for your technical consultations, product customizations, data migration, system integrations, third party add-on development and implementation competence.

Greytrix offers unique GUMU™ integrated solutions of  Sage 300 with Sage CRM, Salesforce.com, Dynamics 365 CRM and Magento eCommerce along with Sage 300 Migration from Sage 50 US, Sage 50 CA, Sage PRO, QuickBooks, Sage Business Vision and Sage Business Works. We also offer best-in-class Sage 300 customization and development services and integration services for applications such as POS | WMS | Payroll | Shipping System | Business Intelligence | eCommerce for Sage 300 ERP and for Sage 300c development services we offer, upgrades of older codes and screens to new web screens, latest integrations using Data and web services to Sage business partners, end users and Sage PSG worldwide. Greytrix offers 20+ addons for Sage 300 to enhance productivity such as GreyMatrixDocument AttachmentDocument NumberingAuto-Bank ReconciliationPurchase Approval SystemThree way PO matchingBill of Lading and VAT for Middle East. The GUMU™ integration for Dynamics 365 CRM – Sage ERP is listed on Microsoft Appsource with easy implementation package.

For more details on Sage 300 and Sage 300c Services, please contact us at accpac@greytrix.com, We will like to hear from you.