Skip to main content
Solved

Landed Cost Transaction updates Stock Item with $0 adjustment


Laura02
Captain II
Forum|alt.badge.img+19

Hello,

I’m configuring Landed Cost in Acumatica for the first time. (version 2022 R1)The process seems clear but the end result is $0 adjustment to my item.  What am I missing?

My example is applying insurance costs weighted by Cost Amount across 3 items on a PO Receipt.

Purchase Order (notice, 2 non-stock items on lines 1, 3 and one Stock Item is on line 2):

PO Receipt: All Items Received.

Landed Cost:

What I expect on Valuation:  Receipt line $13.30 and Adjustment line $13.30.

What I see on Valuation: Receipt line $13.30 and LC adjustment line = $0.

What mistake did I make?   Thank you in advance for your help!!

Best answer by Kandy Beatty

HI @laura01  

You may need to look at the item costing. Are you trying to add the Landed Cost to the items?

If so, here is help on that:

https://help-2022r1.acumatica.com/(W(2))/Help?ScreenId=ShowWiki&pageid=3fb8f768-a8ea-44a8-9a4f-8b78ecb947e8

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

7 replies

Kandy Beatty
Captain II
Forum|alt.badge.img+16
  • Captain II
  • 2209 replies
  • August 1, 2022

HI @laura01 

What is your allocation method on the Landed Cost code? This may need to be changed. 

Also, here is a very good article on Landed Cost processing:

https://www.dynamictechservices.com/acumatica-landed-cost-and-complex-calculations/


Laura02
Captain II
Forum|alt.badge.img+19
  • Author
  • Captain II
  • 3132 replies
  • August 1, 2022

Allocation method is by Cost. Can you explain in what circumstances, how will I know whether I need to change this?  Insurance will be higher on more costly items and that is why I chose cost in this case.


Kandy Beatty
Captain II
Forum|alt.badge.img+16
  • Captain II
  • 2209 replies
  • Answer
  • August 1, 2022

HI @laura01  

You may need to look at the item costing. Are you trying to add the Landed Cost to the items?

If so, here is help on that:

https://help-2022r1.acumatica.com/(W(2))/Help?ScreenId=ShowWiki&pageid=3fb8f768-a8ea-44a8-9a4f-8b78ecb947e8


dales50
Semi-Pro III
  • 68 replies
  • August 1, 2022

@laura01 I do not see that the Landed Cost document has been released in the screens above.  To see the adjustment you need to release.

 

 


Laura02
Captain II
Forum|alt.badge.img+19
  • Author
  • Captain II
  • 3132 replies
  • August 2, 2022

Thank you @kbeatty21:   I think you have led me to the answer: my testing item is set up as STANDARD cost and I likely need a layered costing method, in order to update the cost.  (Doh!)  Will try this  tomorrow.

Thank you @dales50: the landed cost adjustment batches are definitely released.

I have the PO preferences set to release automatically:

The adjustments batch I highlighted on the Valuation report  in the very first screen shot, # 000006, is the actual released Landed Cost adjustments batch. In the adjustments screen, it looks like this:

The cost is correct in the IN adjustments batch and yet, not updating the stock item’s value. (The other two items are non-stock so I wouldn’t expect any cost to update for them.)

Because…. it’s a standard cost item.  😐


  • Freshman I
  • 7 replies
  • October 17, 2024

@Kandy Beatty I can not view this help article that you posted and I am having the same issue. Please see screen shoots below. Any help would be appreciated.

 

Stock Item
PO Receipt
PO Receipt Landed Cost
​​​​​

 

Adjustments
Highlighted in yellow is the receipt and at the bottom is the adjustments

 

One of the Adjustments

 


Laura02
Captain II
Forum|alt.badge.img+19
  • Author
  • Captain II
  • 3132 replies
  • October 17, 2024

Try this link :

https://help-2023r1.acumatica.com/(W(2))/Help?ScreenId=ShowWiki&pageid=3fb8f768-a8ea-44a8-9a4f-8b78ecb947e8

 

I changed “2022” to 2023 in the URL and it takes me to a slightly newer help article about the same topic.  HTH.

 

Laura


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