Skip to main content
Question

Landed Cost Vendor Question


Forum|alt.badge.img

When we receive bills from our vendors wiith fees such as shipping and handling on the bill itself and we are paying our vendor (not a trucking service) for those fees. I want to be able to link those fees to the items on that bill specifically. Does that mean I have to have all my vendors selected as “Landed Cost Vendors” as well?

Scenario 2 - we pay royalties on items to vendors and I want that fee to be reflected in the cost of goods for that 1 singular item (not all of the items on that PO)

 

Example:
Invoice from vendor:

Item A - Qty Purchased 5 - Unit Cost $2 - Extended Cost $10

Royalties Paid for Item A - $0.10 per unit - Extended Cost $0.50

Item B - Qty Purchased 5 - Unit Cost $5 - Extended Cost $25

Total Owed: $35.50

 

BUT I want the stock item to reflect that it’s last cost is actually $2.10 and not $2

From my understanding if I entered the royalties as a landed cost that $0.50 would be allocated to all of the items on purchase order?

5 replies

Forum|alt.badge.img
  • Author
  • Jr Varsity III
  • 63 replies
  • April 10, 2025

A second question is that I was testing the landed cost process. I created a PO for 1 pallet of goods that had a last cost of 431.60

I then received those goods and clicked “Enter Landed Cost”” and created an LC document for $68.40

I then created an AP bill for the pallet of goods, linked the existing LC document to it and the bill came to $500 which is what I expected.

The bill was paid and processed, but the the last cost for the item is still $431.60 where I was expecting it to now say $500. If this is acting how it should, then is there another field that we can be using to see what the true last cost of an item is, including landed costs?


Forum|alt.badge.img+1
  • Pro III
  • 106 replies
  • April 11, 2025

@SBaldwin - You should check that inventory adjustment for the landed cost transaction is released. Navigate to Adjustments (IN3030PL) and look to see if you have any balanced transactions that need to be released

 

Under Purchase Order Preferences you can select to “Release LC IN Adjustments Automatically” 


Forum|alt.badge.img
  • Author
  • Jr Varsity III
  • 63 replies
  • April 14, 2025

Hi ​@kyle90 that check box is already checked. I just tried another test. 


Created a new test item with a last cost of $10

Created a PO with 1 of those items and did not change cost.
Enter PO receipt in Full

Created LC document for $10 (in trucking)

Created a bill linking both LC document and purchase receipt (since the vendor is the one that charged us shipping)
Paid the bill.

No adjustments were created and the “last cost” is still $10 where now it should be $20


Forum|alt.badge.img
  • Author
  • Jr Varsity III
  • 63 replies
  • April 14, 2025

I got it! The landed cost code that I was using had an allocation method of “none” :)


Chris Hackett
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • 2787 replies
  • April 14, 2025

Thank you for sharing your solution with the community ​@SBaldwin!


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