The following NetSuite application is available to all active Prolecto Resources clients without license charge. Click here to get back to the bundle list.
Prolecto Landed Cost Header Applications
The Prolecto Landed Cost Header Applications represent a series of possible landed cost models applied to item receipts at header-level. This bundle starts with simplified landed costs. Buyers link freight Purchase Orders to one or more product Purchase Orders. Landed costs are automatically apportioned to item receipts based on pro-rata dollar value of the item receipt. Another mode uses more complex purchasing scenarios to indicate if landed costs, such as freight, are passed through to customers in dropship situations. Other automation can drive the creation of purchase orders for the use of third-party freight companies and others. Another mode drives line based landed cost automation based on quantity, flat amount, percentage amount and finally, an item consumption model to drive purchase order driven manufacturing (Deprecated in favor of the rule-based Rate Card system in the Prolecto Landed Cost Line Applications lab).
Bundle ID
Ask for Bundle ID: 395206.
Version History
20241112.RC
- Exposed the vendor name in the landed cost analysis sublist
20240918.RC
- Implemented support for Landed cost distribution and allocation by weight.
- Added warning under the Landed Cost subtab of product transactions regarding editing estimates after an LC PO has been generated. Also, updated verbiage for similar warning on the LC Estimate record.
20240712.RC
- Implemented support for background recomputation of landed costs. If enabled via an app.setting, the recomputation is enqueued and executed in the background for better user experience.
- Fixed an issue that could cause landed cost computation to run out of governance.
20240501.RC
- Fixed issue that the total product amount did not match the freight container amount if the same item got received multiple times at different rates.
- Implemented logic to support the current and previous transaction body field IDs for the PRI Container.
- Extended scope of the optional debug=t URL parameter to expose the otherwise hidden “PRL LC Ignore Edits” checkbox. Unchecking this will force the model to get updated even if there are existing item receipts i.e. it overrules the control logic. This can be useful for recovery.
20231221.RC
- Added support for Dynamic Percentage-Based Landed Cost Estimates.
- Implemented additional fallback mechanisms for determining the transfer order line item rate when the “Use Item Cost as Transfer Cost” option is enabled. Previously, we only could revert to the Costing Engine for the item cost which could be zero in some cases. With this enhancement, other rate sources are supported.
20230927.RC
- Moved logic to manage visibility of the landed costs tab to the Prolecto Utilities bundle to avoid having multiple scripts running on the base record (performance considerations). Before updating to this version of the bundle, update the utilities bundle to version 20230927.RC or later.
- Landed Cost PO Subsidiary - Enabled LC Estimate validation and selection of the Subsidiary on the Landed Cost PO based upon the source transaction Subsidiary (or in the case of Intercompany Transfer Orders, the To Subsidiary). Display error if the Subsidiary is not enabled for the given Vendor.
- Multiple refinements:
- Fixed an issue that LC model inconsistency was sometimes not flagged. The control mode flag is now evaluated centrally to cover all flows.
- Added a debug flag to help with diagnosing issues. When set, the LC model and control JSON fields are exposed on the product transaction and can be edited if needed.
- Implemented logic to clear out the LC model fields on a product transaction when it is no longer linked to any LC PO.
- Added guard to ensure a compatible version of PRI Utils is installed before attempting to verify the bundle update.
- Implemented feature to optionally exclude closed lines based on an app.setting.
- Fixed issue that LC PO generation was not evaluated upon approving an existing TO where an eligible LC Estimate sublist entry already existed.
- Fixed issue that product transactions did not get updated after unlinking manually from an LC PO. This caused the product transaction to still have landed costs applied to it even though it was no longer part of the model.
- Fixed issue that updating LC amounts on item receipts did not clean out any old values from previous updates. Now, if a landed cost category now has no amount but previously had one, it is reset as expected.
20230626.RC
- Resolved issue with logic to detect when receiving has started on TOs.
- Added option to manually override landed costs on item receipts. This allows users to make adjustments to the landed cost allocation without the algorithm overriding such changes.
- Added Verify Bundle installation routine.
20230119.RC
- Added an option to override logic to group landed cost estimates by vendor/cost category into a single PO.
- Fixed the issue that LC PO auto-generation did not trigger for product transactions in the “Pending Billing” state.
- Updated logic such that the LC PO generation respects control mode.
20221212.RC
- Added support for intercompany transfer orders
- Fixed bug that when one transfer order was linked to multiple landed costs POs, only the first PO got included in the landed cost computations.
20220916.RC
Migration of the line-based landed item version-based cost algorithms that were part of the Prolecto Freight Container system.
20220609.RC
- Added support for fulfillable landed cost items.
- Implemented custom LC Estimate sublist-based approach for auto-generation third-party landed cost POs from any cost category. Also extended algorithm to cover transfer orders.
- Implemented logic to flag model inconsistencies and capture the differences in the new LC details sublist. Also implemented a healing mechanism that recomputes the landed costs model and updates any prior item receipts (in non-closed periods).
- [Breaking change] In previous versions of the simplified freight model, the pro-rata costs during receipt were computed proportionally based on dollar amounts. Now, they are driven by the cost allocation method.
20220224.RC
Enhanced control stuctures:
- Excluded xedit as not all required data is available and added guard for non-item POs.
- Added check for output which will be null if an item receipt is not generated from a PO.
20211103.RC
Major revision to support complex purchasing and landed cost scenarios:
- Drive pass-through of purchased costs, such as freight, to customers via dropship scenarios; options to determine if costs are capitalized of passed through.
- Drive the creation of third-party purchase order scenarios, such as to freight companies, while capitalizing freight.
20210708.RC
First revision based on the simplified purchase landed cost (freight) model.
- Exposed the vendor name in the landed cost analysis sublist
- Implemented support for Landed cost distribution and allocation by weight.
- Added warning under the Landed Cost subtab of product transactions regarding editing estimates after an LC PO has been generated. Also, updated verbiage for similar warning on the LC Estimate record.
20240712.RC
- Implemented support for background recomputation of landed costs. If enabled via an app.setting, the recomputation is enqueued and executed in the background for better user experience.
- Fixed an issue that could cause landed cost computation to run out of governance.
20240501.RC
- Fixed issue that the total product amount did not match the freight container amount if the same item got received multiple times at different rates.
- Implemented logic to support the current and previous transaction body field IDs for the PRI Container.
- Extended scope of the optional debug=t URL parameter to expose the otherwise hidden “PRL LC Ignore Edits” checkbox. Unchecking this will force the model to get updated even if there are existing item receipts i.e. it overrules the control logic. This can be useful for recovery.
20231221.RC
- Added support for Dynamic Percentage-Based Landed Cost Estimates.
- Implemented additional fallback mechanisms for determining the transfer order line item rate when the “Use Item Cost as Transfer Cost” option is enabled. Previously, we only could revert to the Costing Engine for the item cost which could be zero in some cases. With this enhancement, other rate sources are supported.
20230927.RC
- Moved logic to manage visibility of the landed costs tab to the Prolecto Utilities bundle to avoid having multiple scripts running on the base record (performance considerations). Before updating to this version of the bundle, update the utilities bundle to version 20230927.RC or later.
- Landed Cost PO Subsidiary - Enabled LC Estimate validation and selection of the Subsidiary on the Landed Cost PO based upon the source transaction Subsidiary (or in the case of Intercompany Transfer Orders, the To Subsidiary). Display error if the Subsidiary is not enabled for the given Vendor.
- Multiple refinements:
- Fixed an issue that LC model inconsistency was sometimes not flagged. The control mode flag is now evaluated centrally to cover all flows.
- Added a debug flag to help with diagnosing issues. When set, the LC model and control JSON fields are exposed on the product transaction and can be edited if needed.
- Implemented logic to clear out the LC model fields on a product transaction when it is no longer linked to any LC PO.
- Added guard to ensure a compatible version of PRI Utils is installed before attempting to verify the bundle update.
- Implemented feature to optionally exclude closed lines based on an app.setting.
- Fixed issue that LC PO generation was not evaluated upon approving an existing TO where an eligible LC Estimate sublist entry already existed.
- Fixed issue that product transactions did not get updated after unlinking manually from an LC PO. This caused the product transaction to still have landed costs applied to it even though it was no longer part of the model.
- Fixed issue that updating LC amounts on item receipts did not clean out any old values from previous updates. Now, if a landed cost category now has no amount but previously had one, it is reset as expected.
20230626.RC
- Resolved issue with logic to detect when receiving has started on TOs.
- Added option to manually override landed costs on item receipts. This allows users to make adjustments to the landed cost allocation without the algorithm overriding such changes.
- Added Verify Bundle installation routine.
20230119.RC
- Added an option to override logic to group landed cost estimates by vendor/cost category into a single PO.
- Fixed the issue that LC PO auto-generation did not trigger for product transactions in the “Pending Billing” state.
- Updated logic such that the LC PO generation respects control mode.
20221212.RC
- Added support for intercompany transfer orders
- Fixed bug that when one transfer order was linked to multiple landed costs POs, only the first PO got included in the landed cost computations.
20220916.RC
Migration of the line-based landed item version-based cost algorithms that were part of the Prolecto Freight Container system.
20220609.RC
- Added support for fulfillable landed cost items.
- Implemented custom LC Estimate sublist-based approach for auto-generation third-party landed cost POs from any cost category. Also extended algorithm to cover transfer orders.
- Implemented logic to flag model inconsistencies and capture the differences in the new LC details sublist. Also implemented a healing mechanism that recomputes the landed costs model and updates any prior item receipts (in non-closed periods).
- [Breaking change] In previous versions of the simplified freight model, the pro-rata costs during receipt were computed proportionally based on dollar amounts. Now, they are driven by the cost allocation method.
20220224.RC
Enhanced control stuctures:
- Excluded xedit as not all required data is available and added guard for non-item POs.
- Added check for output which will be null if an item receipt is not generated from a PO.
20211103.RC
Major revision to support complex purchasing and landed cost scenarios:
- Drive pass-through of purchased costs, such as freight, to customers via dropship scenarios; options to determine if costs are capitalized of passed through.
- Drive the creation of third-party purchase order scenarios, such as to freight companies, while capitalizing freight.
20210708.RC
First revision based on the simplified purchase landed cost (freight) model.
- Implemented support for background recomputation of landed costs. If enabled via an app.setting, the recomputation is enqueued and executed in the background for better user experience.
- Fixed an issue that could cause landed cost computation to run out of governance.
- Fixed issue that the total product amount did not match the freight container amount if the same item got received multiple times at different rates.
- Implemented logic to support the current and previous transaction body field IDs for the PRI Container.
- Extended scope of the optional debug=t URL parameter to expose the otherwise hidden “PRL LC Ignore Edits” checkbox. Unchecking this will force the model to get updated even if there are existing item receipts i.e. it overrules the control logic. This can be useful for recovery.
20231221.RC
- Added support for Dynamic Percentage-Based Landed Cost Estimates.
- Implemented additional fallback mechanisms for determining the transfer order line item rate when the “Use Item Cost as Transfer Cost” option is enabled. Previously, we only could revert to the Costing Engine for the item cost which could be zero in some cases. With this enhancement, other rate sources are supported.
20230927.RC
- Moved logic to manage visibility of the landed costs tab to the Prolecto Utilities bundle to avoid having multiple scripts running on the base record (performance considerations). Before updating to this version of the bundle, update the utilities bundle to version 20230927.RC or later.
- Landed Cost PO Subsidiary - Enabled LC Estimate validation and selection of the Subsidiary on the Landed Cost PO based upon the source transaction Subsidiary (or in the case of Intercompany Transfer Orders, the To Subsidiary). Display error if the Subsidiary is not enabled for the given Vendor.
- Multiple refinements:
- Fixed an issue that LC model inconsistency was sometimes not flagged. The control mode flag is now evaluated centrally to cover all flows.
- Added a debug flag to help with diagnosing issues. When set, the LC model and control JSON fields are exposed on the product transaction and can be edited if needed.
- Implemented logic to clear out the LC model fields on a product transaction when it is no longer linked to any LC PO.
- Added guard to ensure a compatible version of PRI Utils is installed before attempting to verify the bundle update.
- Implemented feature to optionally exclude closed lines based on an app.setting.
- Fixed issue that LC PO generation was not evaluated upon approving an existing TO where an eligible LC Estimate sublist entry already existed.
- Fixed issue that product transactions did not get updated after unlinking manually from an LC PO. This caused the product transaction to still have landed costs applied to it even though it was no longer part of the model.
- Fixed issue that updating LC amounts on item receipts did not clean out any old values from previous updates. Now, if a landed cost category now has no amount but previously had one, it is reset as expected.
20230626.RC
- Resolved issue with logic to detect when receiving has started on TOs.
- Added option to manually override landed costs on item receipts. This allows users to make adjustments to the landed cost allocation without the algorithm overriding such changes.
- Added Verify Bundle installation routine.
20230119.RC
- Added an option to override logic to group landed cost estimates by vendor/cost category into a single PO.
- Fixed the issue that LC PO auto-generation did not trigger for product transactions in the “Pending Billing” state.
- Updated logic such that the LC PO generation respects control mode.
20221212.RC
- Added support for intercompany transfer orders
- Fixed bug that when one transfer order was linked to multiple landed costs POs, only the first PO got included in the landed cost computations.
20220916.RC
Migration of the line-based landed item version-based cost algorithms that were part of the Prolecto Freight Container system.
20220609.RC
- Added support for fulfillable landed cost items.
- Implemented custom LC Estimate sublist-based approach for auto-generation third-party landed cost POs from any cost category. Also extended algorithm to cover transfer orders.
- Implemented logic to flag model inconsistencies and capture the differences in the new LC details sublist. Also implemented a healing mechanism that recomputes the landed costs model and updates any prior item receipts (in non-closed periods).
- [Breaking change] In previous versions of the simplified freight model, the pro-rata costs during receipt were computed proportionally based on dollar amounts. Now, they are driven by the cost allocation method.
20220224.RC
Enhanced control stuctures:
- Excluded xedit as not all required data is available and added guard for non-item POs.
- Added check for output which will be null if an item receipt is not generated from a PO.
20211103.RC
Major revision to support complex purchasing and landed cost scenarios:
- Drive pass-through of purchased costs, such as freight, to customers via dropship scenarios; options to determine if costs are capitalized of passed through.
- Drive the creation of third-party purchase order scenarios, such as to freight companies, while capitalizing freight.
20210708.RC
First revision based on the simplified purchase landed cost (freight) model.
- Added support for Dynamic Percentage-Based Landed Cost Estimates.
- Implemented additional fallback mechanisms for determining the transfer order line item rate when the “Use Item Cost as Transfer Cost” option is enabled. Previously, we only could revert to the Costing Engine for the item cost which could be zero in some cases. With this enhancement, other rate sources are supported.
- Moved logic to manage visibility of the landed costs tab to the Prolecto Utilities bundle to avoid having multiple scripts running on the base record (performance considerations). Before updating to this version of the bundle, update the utilities bundle to version 20230927.RC or later.
- Landed Cost PO Subsidiary - Enabled LC Estimate validation and selection of the Subsidiary on the Landed Cost PO based upon the source transaction Subsidiary (or in the case of Intercompany Transfer Orders, the To Subsidiary). Display error if the Subsidiary is not enabled for the given Vendor.
- Multiple refinements:
- Fixed an issue that LC model inconsistency was sometimes not flagged. The control mode flag is now evaluated centrally to cover all flows.
- Added a debug flag to help with diagnosing issues. When set, the LC model and control JSON fields are exposed on the product transaction and can be edited if needed.
- Implemented logic to clear out the LC model fields on a product transaction when it is no longer linked to any LC PO.
- Added guard to ensure a compatible version of PRI Utils is installed before attempting to verify the bundle update.
- Implemented feature to optionally exclude closed lines based on an app.setting.
- Fixed issue that LC PO generation was not evaluated upon approving an existing TO where an eligible LC Estimate sublist entry already existed.
- Fixed issue that product transactions did not get updated after unlinking manually from an LC PO. This caused the product transaction to still have landed costs applied to it even though it was no longer part of the model.
- Fixed issue that updating LC amounts on item receipts did not clean out any old values from previous updates. Now, if a landed cost category now has no amount but previously had one, it is reset as expected.
20230626.RC
- Resolved issue with logic to detect when receiving has started on TOs.
- Added option to manually override landed costs on item receipts. This allows users to make adjustments to the landed cost allocation without the algorithm overriding such changes.
- Added Verify Bundle installation routine.
20230119.RC
- Added an option to override logic to group landed cost estimates by vendor/cost category into a single PO.
- Fixed the issue that LC PO auto-generation did not trigger for product transactions in the “Pending Billing” state.
- Updated logic such that the LC PO generation respects control mode.
20221212.RC
- Added support for intercompany transfer orders
- Fixed bug that when one transfer order was linked to multiple landed costs POs, only the first PO got included in the landed cost computations.
20220916.RC
Migration of the line-based landed item version-based cost algorithms that were part of the Prolecto Freight Container system.
20220609.RC
- Added support for fulfillable landed cost items.
- Implemented custom LC Estimate sublist-based approach for auto-generation third-party landed cost POs from any cost category. Also extended algorithm to cover transfer orders.
- Implemented logic to flag model inconsistencies and capture the differences in the new LC details sublist. Also implemented a healing mechanism that recomputes the landed costs model and updates any prior item receipts (in non-closed periods).
- [Breaking change] In previous versions of the simplified freight model, the pro-rata costs during receipt were computed proportionally based on dollar amounts. Now, they are driven by the cost allocation method.
20220224.RC
Enhanced control stuctures:
- Excluded xedit as not all required data is available and added guard for non-item POs.
- Added check for output which will be null if an item receipt is not generated from a PO.
20211103.RC
Major revision to support complex purchasing and landed cost scenarios:
- Drive pass-through of purchased costs, such as freight, to customers via dropship scenarios; options to determine if costs are capitalized of passed through.
- Drive the creation of third-party purchase order scenarios, such as to freight companies, while capitalizing freight.
20210708.RC
First revision based on the simplified purchase landed cost (freight) model.
- Resolved issue with logic to detect when receiving has started on TOs.
- Added option to manually override landed costs on item receipts. This allows users to make adjustments to the landed cost allocation without the algorithm overriding such changes.
- Added Verify Bundle installation routine.
- Added an option to override logic to group landed cost estimates by vendor/cost category into a single PO.
- Fixed the issue that LC PO auto-generation did not trigger for product transactions in the “Pending Billing” state.
- Updated logic such that the LC PO generation respects control mode.
20221212.RC
- Added support for intercompany transfer orders
- Fixed bug that when one transfer order was linked to multiple landed costs POs, only the first PO got included in the landed cost computations.
20220916.RC
Migration of the line-based landed item version-based cost algorithms that were part of the Prolecto Freight Container system.
20220609.RC
- Added support for fulfillable landed cost items.
- Implemented custom LC Estimate sublist-based approach for auto-generation third-party landed cost POs from any cost category. Also extended algorithm to cover transfer orders.
- Implemented logic to flag model inconsistencies and capture the differences in the new LC details sublist. Also implemented a healing mechanism that recomputes the landed costs model and updates any prior item receipts (in non-closed periods).
- [Breaking change] In previous versions of the simplified freight model, the pro-rata costs during receipt were computed proportionally based on dollar amounts. Now, they are driven by the cost allocation method.
20220224.RC
Enhanced control stuctures:
- Excluded xedit as not all required data is available and added guard for non-item POs.
- Added check for output which will be null if an item receipt is not generated from a PO.
20211103.RC
Major revision to support complex purchasing and landed cost scenarios:
- Drive pass-through of purchased costs, such as freight, to customers via dropship scenarios; options to determine if costs are capitalized of passed through.
- Drive the creation of third-party purchase order scenarios, such as to freight companies, while capitalizing freight.
20210708.RC
First revision based on the simplified purchase landed cost (freight) model.
- Added support for intercompany transfer orders
- Fixed bug that when one transfer order was linked to multiple landed costs POs, only the first PO got included in the landed cost computations.
Migration of the line-based landed item version-based cost algorithms that were part of the Prolecto Freight Container system.
20220609.RC
- Added support for fulfillable landed cost items.
- Implemented custom LC Estimate sublist-based approach for auto-generation third-party landed cost POs from any cost category. Also extended algorithm to cover transfer orders.
- Implemented logic to flag model inconsistencies and capture the differences in the new LC details sublist. Also implemented a healing mechanism that recomputes the landed costs model and updates any prior item receipts (in non-closed periods).
- [Breaking change] In previous versions of the simplified freight model, the pro-rata costs during receipt were computed proportionally based on dollar amounts. Now, they are driven by the cost allocation method.
20220224.RC
Enhanced control stuctures:
- Excluded xedit as not all required data is available and added guard for non-item POs.
- Added check for output which will be null if an item receipt is not generated from a PO.
20211103.RC
Major revision to support complex purchasing and landed cost scenarios:
- Drive pass-through of purchased costs, such as freight, to customers via dropship scenarios; options to determine if costs are capitalized of passed through.
- Drive the creation of third-party purchase order scenarios, such as to freight companies, while capitalizing freight.
20210708.RC
First revision based on the simplified purchase landed cost (freight) model.
- Added support for fulfillable landed cost items.
- Implemented custom LC Estimate sublist-based approach for auto-generation third-party landed cost POs from any cost category. Also extended algorithm to cover transfer orders.
- Implemented logic to flag model inconsistencies and capture the differences in the new LC details sublist. Also implemented a healing mechanism that recomputes the landed costs model and updates any prior item receipts (in non-closed periods).
- [Breaking change] In previous versions of the simplified freight model, the pro-rata costs during receipt were computed proportionally based on dollar amounts. Now, they are driven by the cost allocation method.
Enhanced control stuctures:
- Excluded xedit as not all required data is available and added guard for non-item POs.
- Added check for output which will be null if an item receipt is not generated from a PO.
20211103.RC
Major revision to support complex purchasing and landed cost scenarios:
- Drive pass-through of purchased costs, such as freight, to customers via dropship scenarios; options to determine if costs are capitalized of passed through.
- Drive the creation of third-party purchase order scenarios, such as to freight companies, while capitalizing freight.
20210708.RC
First revision based on the simplified purchase landed cost (freight) model.
- Drive pass-through of purchased costs, such as freight, to customers via dropship scenarios; options to determine if costs are capitalized of passed through.
- Drive the creation of third-party purchase order scenarios, such as to freight companies, while capitalizing freight.
First revision based on the simplified purchase landed cost (freight) model.
Obtain Access to Prolecto Landed Cost Header Applications Bundle
If this Prolecto Landed Cost Header Applications bundle has interest for you, make a request and let's have a conversation.