Skip to main content

Hi Everyone,

I was trying to track all the deleted records on my request primary list. Using generic inquiry. I also enable the “Show deleted records” and yet upon adding on the results grid. I can't add the field name DeletedDatabaseRecord. Is there an additional need to set up to check or to add in order to include the DeletedDatabseRecord on the Results Grid ?

 

Please see attached photo for your reference :

 

Results Grid

 

Relations

 

 

Tables :

Thank you !!

 

Thank you !! Its seems that field is not available in the Standard Request Generic Inquiry.

Thank you for all the effort guys..

 

 


Yes @Alfie  As indicated by @DConcannon This field is available in the below 75 tables (22 R1 version).

You can check and add this field to your GI accordingly.

 

FSxPMTimeActivity
ExternalTransaction
VendorClass
PhotoLogSetup
RequestForInformation
FSLicenseType
InventoryItem
CRLead
FSxService
Batch
FSxServiceClass
EPAssignmentMap
DrawingLog
FSManufacturer
DailyFieldReport
CARecon
FSManufacturerModel
Currency
CAAdj
PRLocation
DrawingLogSetup
AUNotification
FSSkill
ProjectIssue
CurrencyList
FSxVendor
FSBranchLocation
DailyFieldReportHistory
CurrencyRateType
FSPostInfo
DailyFieldReportNote
CCProcTran
Sub
CRActivity
APRegister
AUSchedule
DailyFieldReportSubcontractorActivity
Ledger
PMTimeActivity
EPEmployee
SFSyncRecord
ARRegister
UPSnapshot
INItemClass
EMailAccount
Organization
BCSyncStatus
Contact
CRCase
CABatch
SMEmail
GLVoucher
Customer
FSxCRCase
Users
Contract
FSServiceContract
PaymentMethod
FSEquipment
FSxCustomer
FSxCustomerClass
RecognizedRecord
FSxEPEmployee
Vendor
CAEntryType
FSxEquipmentModel
Account
BAccount
HSSyncRecord
FSxEquipmentModelTemplate
Photo
CustomerPaymentMethod
CATransfer
PhotoLog
Branch


@Alfie Of the thousand+ tables in my Acumatica instance only 76 have the deleteddatatbaserecord field, of which, I spy only one detail table (Credit Cards).


Hi Sir Naveen, Thank you for your response. but my intention is to show the deleted request in the request primary list. Please see attached photo for your ref. Thank you so much.

 

 


Hi @Alfie  We can able to add if DeletedDatabaseRecord field is available in the database table.

As per the above screen, this field is available in the Branch table, you can able to know whether the Branch is deleted or not with this field.

 

 

 

 


Reply