Skip to main content
Answer

Landed Cost without AP Bill

  • September 12, 2024
  • 5 replies
  • 170 views

Forum|alt.badge.img

We are using our own freight trucks to pick up inventory from manufacturers. We want to include the freight cost in the cost of those items that were purchased from the manufacturer but picked up by our trucks. We do not need an AP bill for this transaction since its not third party. Is there a way to use the landed cost process without creating an AP bill?

Just FYI, we come up the with the freight cost by using a home grown freight cost estimator tool. Takes the overhead cost, repairs, maintenance, fuel price and mileage to come up with the freight cost. We would like to use the landed cost screen to enter that information and distribute the freight cost to the items on the PO without ACU forcing an AP bill. Is anyone needing this functionality? 

 

Best answer by Laura03

Hello,

I think you can use Landed Cost without AP Bills. Please test this theory in your test environment and check with your CPA to make sure the GL posting I’m suggesting is correct.

The main concern will be choosing an account to use in place of Landed Cost Accrual.

Normal Landed Cost processes will

  1. Debit Inventory asset account (or COGS if the items are already sold) and credit the Landed Cost Accrual liability account upon entry of the Landed Cost amount.
  1. Debit Landed Cost Accrual account and credit Accounts Payable upon entry of the related AP Bill.

If you are never going to enter a bill to any vendor… step 2 won’t happen in your scenario, and the balance posted in step 1 will remain in the account that is credited in step 1.  

You’ll want to use an account that is not a liability for the credit in step 1, in place of Landed Cost Accrual.  I’m guessing an appropriate account to use in place of Landed Cost Accrual might be Vehicle expense.

 

The resulting entry will offset your vehicle expenses like gas/insurance/repairs with a credit while debiting COGS when the delivered items are sold. 

Will this work?

Laura

 

 

5 replies

Laura03
Captain II
Forum|alt.badge.img+19
  • Captain II
  • Answer
  • September 12, 2024

Hello,

I think you can use Landed Cost without AP Bills. Please test this theory in your test environment and check with your CPA to make sure the GL posting I’m suggesting is correct.

The main concern will be choosing an account to use in place of Landed Cost Accrual.

Normal Landed Cost processes will

  1. Debit Inventory asset account (or COGS if the items are already sold) and credit the Landed Cost Accrual liability account upon entry of the Landed Cost amount.
  1. Debit Landed Cost Accrual account and credit Accounts Payable upon entry of the related AP Bill.

If you are never going to enter a bill to any vendor… step 2 won’t happen in your scenario, and the balance posted in step 1 will remain in the account that is credited in step 1.  

You’ll want to use an account that is not a liability for the credit in step 1, in place of Landed Cost Accrual.  I’m guessing an appropriate account to use in place of Landed Cost Accrual might be Vehicle expense.

 

The resulting entry will offset your vehicle expenses like gas/insurance/repairs with a credit while debiting COGS when the delivered items are sold. 

Will this work?

Laura

 

 


Forum|alt.badge.img
  • Freshman I
  • May 27, 2025

@etrojan28 or ​@Laura02

Do you have a generic vendor assigned that you are using in the required vendor field or can we just use any landed cost vendor? Or would an adjustment be the optimal solution for adding fees associated with inventory items as we receive them in? Seems like Acumatica could make the vendor not required in some situations for landed cost.


Forum|alt.badge.img

Hello,

In my system, the Vendor is not required on Landed Cost Codes screen.

The Vendor will be required when the Bills for the landed costs are entered & paid.

 

Laura


Forum|alt.badge.img
  • Freshman I
  • May 27, 2025

I did not realize you were an acu employee...interesting.  thanks for all your community contributions!

so here is our situation, we buy goods that we need to apply freight costs, storage costs, and handling fees to.  We use avg cost as the valuation method and we were instructed to use landed costs to bake these costs/fees into our inventory item costs.  When we enter a landed cost record a vendor is required in order to progress with any type of entry.  Should we be handling these differently or a better way?
 

 


Forum|alt.badge.img

Hello ​@bwaldie ,

I became an Acumatica employee January 1 of this year - very exciting! (You’re welcome!)

I agree: 1) Landed Costs are the best way to accurately roll freight, handling charges, and storage costs in with inventory costs, and 2) Vendors are required in the Landed Cost Transactions.  

You could set up one “FREIGHT” or “HANDLING” Landed Cost code (with no Vendor in the Landed Cost code screen) and use these codes for as many vendors as needed. Or, you could configure separate LC Codes for UPS vs. FedEx vs. DHL, if you’d like to allocate the costs differently or post these to different GL’s based on the vendor. 

When the LC Bill is entered (to any Landed Cost vendor), and connected to a PO Receipt, the Landed cost is automatically distributed to the items that were in the shipment, based on the Allocation Method on the Landed Cost code screen.

Landed Costs look like Inventory Adjustments on Inventory reports.

If the items are still in stock when the Landed Cost is received, Landed Cost debits the Inventory Asset.  If the items have been sold before the Landed Cost bill arrives, the debit posts to COGS.  In both cases, the Credits post to the Landed Cost Accrual account from the LC Code screen.

 

HTH.

 

Laura