Skip to main content
Solved

How to show Deleted Dequest using Generic Inquiry


Forum|alt.badge.img
  • Freshman II
  • 15 replies

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 !!

 

Best answer by Naveen Boga

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

View original
Did this topic help you find an answer to your question?

5 replies

Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3393 replies
  • August 22, 2022

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.

 

 

 

 


Forum|alt.badge.img
  • Author
  • Freshman II
  • 15 replies
  • August 23, 2022

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.

 

 


DConcannon
Varsity II
Forum|alt.badge.img+2
  • Varsity II
  • 120 replies
  • August 23, 2022

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


Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3393 replies
  • Answer
  • August 24, 2022

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


Forum|alt.badge.img
  • Author
  • Freshman II
  • 15 replies
  • August 25, 2022

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

Thank you for all the effort guys..

 

 


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings