Landed Cost is confusing, so I apologize if this is a foolish question.
We have been using the Landed Cost functionality to allocate Incoming Freight across Inventory Items when we pay the shipping cost on the same Vendor Bill. That works well.
Recently, we started trying to use the Landed Cost functionality to allocate the Incoming Freight costs of 3rd party shippers for Inventory Items. But we cannot get it to work.
Our primary 3rd party shipper is United Parcel Service (”UPS”)
Based on the way that the UPS invoicing system works, we treat our UPS account as if it were a credit card.
When we receive a notification that a vendor purchase will have UPS Incoming Freight, Accounting enters the UPS cost as a Credit Card Transaction. It is simple and fast. It also allows us to easily assign the cost to the proper project.
Each Monday, UPS sends us their weekly Invoice/Statement. We reconcile the UPS “credit card” account and enter the UPS Invoice as a one-line Bill in NetSuite. The workflow is fast and easy.
Here’s the problem.
When Accounting enters the Credit Card Transaction, they first choose our “Landed Cost-Incoming Inventory Freight” Other Charge item. However, on the Credit Card Transaction form, there is no column to enter the LANDED COST CATEGORY like there is on the Bill Transaction form. Therefore, when Accounting goes to the Item Receipt, there is no UPS charge to select from the LANDED COST sublist (because the UPS credit card charge was not assigned to a Landed Cost Category.
For the life of me, I cannot figure out how to add that LANDED COST CATEGORY column to the Credit Card Transaction form ITEMS sublist.
There is a Landed Cost Help screen
SuiteCloud Platform SuiteScript SuiteScript Records Guide SuiteScript Supported Records Transactions-related Records Landed Cost
Says that “The landed cost subrecord can be used in conjunction with several transactions: check, credit card charge, item receipt, and vendor bill.”
But I cannot figure out the trick to make that work.
Our Credit Card Transaction form has a “Landed Cost” column, but it is grayed out and nothing seems to make that column active.
I thought maybe I had to figure out how Landed Cost Templates work and somehow use that capability. But the Help for that functionality specifically lists Credit Card Transactions as not being supported.
What am I missing?
Thank you.