Best Of

Hi @User_9AUJK,

Good day! I believe we can do this by creating a Saved Search and a Custom Field.

Create the Saved Search:

Navigate to Reports > Saved Searches > All Saved Searches > New

On the Saved Search page, click on Location

On the Saved Location Search page, set the fields below:

• Search Title: <Set the name of your search here>

Results subtab:

• Field: System Notes: Date
• Summary Type: Maximum

Available Filters subtab:

• Filter: Internal ID
• Show in Filter Region: Yes

Create the Custom Field:

Navigate to Customization > Lists, Records, & Fields > Other Record Fields > New

On the Other Record Field page, set the fields below:

• Record Type: Location
• Label: <Set your label here>
• Type: Date/Time
• Store Value: Unchecked

Validation & Defaulting subtab:

• Search: <The search we created above>

Results:

Once done, it should reflect the latest date found in the System Notes. Please see my two examples below:

I hope this helps!
__
If you find this reply to your question as helpful, others with the same question might find it helpful as well. By marking “Yes” on the “Did this answer your question?”, you’ll be able to aid the community to find the solution much easier and faster without the need to read through all the replies, and you will also get closer to earning your next Answer Accepter badge.

Hi @emcee_uk

Check group by internal ID

you can see the last update value

Thank you @Eklon Eleuterio

Thanks @Tiru Chembeti!

It will help! Thanks a lot!

Hi @Bee Yook

From what I know, usually we don't have to configure for all the item location whenever new locations or new items record are created. Unless your company has a requirement to set specific reorder point or preferred stock level or any other stocktake or demand/supply related settings for each item + location pair.

Item cost are usually auto computed based on the stock in and stock out transactions posted in each location. If you are using inventory adjustment to add inventory balance then the unit cost field value should manually specify instead of taking the default value in the field.

May I know what costing method are you using ?

Regards,
Wee Ming

That's a great suggestion going forward, thanks Wee Ming!

Any suggestion/idea of what to do about all the rejected proposals still hanging out there causing a disconnect between FAMS and the General Ledger?

@Jervin Nicholas Teopengco-Oracle Thank you so much! I appreciate the detailed response and was able to get it to work on my end.

Hi User_KYOCJ

You can merge multiple asset proposals to generate one asset. The cost will be auto sum together.

So instead of rejecting the proposal for the shipping charges, edit the proposal and set the FA asset proposal id in the Parent Proposal field.

Then on the Fixed Assets > Transactions > Manager Asset Proposal page , select only the parent asset proposal to generate asset.

Once asset generated, you will see the same asset id populated in Asset field both the Parent and Child Asset Proposal record.

Regards,
Wee Ming

Hi,

I just added filter to the Generate Price Lists > Items tab.