Solved

Deleting Ship-To locations

  • 14 April 2022
  • 5 replies
  • 138 views

We need to delete some ship-to locations that are attached to a specific customer but I keep getting told that I don’t have permission to delete them. What do I do?

icon

Best answer by vkumar 19 April 2022, 06:28

View original

5 replies

Userlevel 7
Badge +3

@Cetylite could you please she us a screenshot?

When I try to delete the location I get the below message.

Our team has looked into this and cannot located any tables the location is referenced in. They found a work-around where I would try to view the Account location and I received this message.

 

Userlevel 7
Badge +17

Hi @Cetylite  I’m assuming that Location is NOT deleted from other referenced tables hence it is showing the error message (from the 1st screenshot).

 

By default Acumatica Location ID column is present in around 71 tables, you can review module-related tables that you are working on the verify whether it is properly deleted or not.

 

AMBomMatl
AMClockItem
AMClockTran
AMClockTranSplit
AMConfigurationOption
AMEstimateMatl
AMMTran
AMMTranSplit
AMOrderCrossRef
AMProdItem
AMProdItemSplit
AMProdMatl
AMProdMatlSplit
AMVendorShipLine
AMVendorShipLineSplit
AMWC
AMWrkMatl
APDiscountLocation
ARTran
BCLocations
Building
Contract
ContractBillingSchedule
CRCase
CROpportunityRevision
CustSalesPeople
EPEquipmentTimeSheetDetail
EPExpenseClaim
EPTimeSheetDetail
FALocationHistory
FSApptLineSplit
FSEquipment
FSServiceOrder
FSSODetSplit
GLTranDoc
INItemPlan
INItemSiteHist
INItemSiteHistDay
INLocation
INLocationStatus
INLotSerialStatus
INPIClassLocation
INPIDetail
INPILocationSelection
INPIStatus
INPIStatusLoc
INTran
INTranSplit
Location
LocationBranchSettings
PMProforma
PMTask
PMTran
POReceiptLine
POReceiptLineSplit
PRBranchLocation
PREarningDetail
PREmployeeClassWorkLocation
PREmployeeWorkLocation
PRLocation
PRPaymentEarning
PRYtdEarnings
RQRequest
SOLine
SOLineSplit
SOPickerListEntry
SOPickingWorksheetLine
SOPickingWorksheetLineSplit
SOShipLine
SOShipLineSplit
VendorPaymentMethodDetail 

 

Userlevel 7
Badge +11

Hi @Cetylite 

With regards to initial error, looks like the Ship-to location has been used on historical documents.

With regards to access rights issue, check if you have permission to access customer location screen i.e.,screenID: AR303020

Regards,

 

 

Userlevel 7
Badge

Hi @Cetylite have you been able to resolve your issue? Thank you!

Reply


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved