Solved

Manually enter Allocation Amounts for Landed Cost

  • 15 September 2022
  • 5 replies
  • 164 views
Connor Morse
Rank
Userlevel 5
Badge

We are looking to manually enter (ideally import/upload) allocation amounts for a Landed Cost entry. Does anyone know if this is possible?

We have been unable to identify a method to enable the field through a Customization Project, or utilize an import scenario to bring in the externally calculated allocation amounts. 

 

icon

Best answer by Kandy Beatty 15 September 2022, 23:05

View original
Connor Morse, Kensium - Please *Like* if our support has helped. Please mark it as *Best Answer* if we have provided an answer to your question.

5 replies

Kandy Beatty
Rank
Userlevel 7
Badge +16

Hi @cmorse26 

What is your Landed Cost Allocation Method? I don’t know if a customization will allow that field to be opened to manually update. 

The system will automatically allocate based on that. 

 

Kandy ~ If a member helped you, please *Like* their post, and if a member provided an answer to your question, please mark it as *Best Answer*.
Kandy Beatty
Rank
Userlevel 7
Badge +16

Have you tried to Override the Data Field? Clear the Value. 

 

Kandy ~ If a member helped you, please *Like* their post, and if a member provided an answer to your question, please mark it as *Best Answer*.
Connor Morse
Rank
Userlevel 5
Badge

@kbeatty21  - Thanks for the response.

You are correct in that it will only automatically allocate the amounts for each allocation method (except for “None”, in which it will automatically assign 0.00)

 

After discussing with Acumatica…

  1. An import scenario will not work since it is a calculated field by the framework. 
  2. An override of the field throw off the Total Allocated Amount calculation and the screen will not function properly. 
  3. There is potential, via customization project, to manipulate the Allocated Amount at the line level and the Total Allocated Amount calculation together.

We are going to further explore a customization that utilizes a newly assigned “Custom” Allocation Method Type on the Landed Cost Code and opens up the ability to manually upload and/or assign the allocation amounts at the Details line level.

 

Thanks for your attention. 

Connor Morse, Kensium - Please *Like* if our support has helped. Please mark it as *Best Answer* if we have provided an answer to your question.
S
Rank

@cmorse26  Hi you have solution to how to assign “Custom” Allocation Method Type on the Landed Cost Code and opens up the ability to manually upload and/or assign the allocation amounts at the Landed cost screen Landed cost Tab  line level. Can share with me

 

 

After discussing with Acumatica…

  1. An import scenario will not work since it is a calculated field by the framework. 
  2. An override of the field throw off the Total Allocated Amount calculation and the screen will not function properly. 
  3. There is potential, via customization project, to manipulate the Allocated Amount at the line level and the Total Allocated Amount calculation together.

We are going to further explore a customization that utilizes a newly assigned “Custom” Allocation Method Type on the Landed Cost Code and opens up the ability to manually upload and/or assign the allocation amounts at the Details line level.

 

Thanks for your attention. 

 

S
Rank

@cmorse26  Hi you have solution to how to assign “Custom” Allocation Method Type on the Landed Cost Code and opens up the ability to manually upload and/or assign the allocation amounts at the Landed cost screen Landed cost Tab  line level. Can share with me

Reply


Terms & ConditionsCookie settings
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