Procurement in Aluminium Food Packaging Manufacturing is driven by the demands of international sourcing. Shipments arrive with cost components beyond the invoiced price, including customs duties, freight charges, and currency exchange differences, that must be captured and applied to inventory valuation. Coordinating inbound shipments through a network of logistics intermediaries and port facilities adds further complexity to the supply chain before goods reach the facility.
The organization's manufacturing, procurement, and inbound supply chain processes were not supported by an integrated system prior to this engagement. Core workflows across production cost tracking, inbound receiving, vendor management, and logistics coordination relied on manual processes and fragmented records, making it difficult to maintain data consistency between functions.
These limitations had a direct impact on financial visibility and operational control. The absence of defined cost accumulation mechanisms meant that production economics could not be accurately assessed, and manual handling of inbound procurement processes limited the organization's ability to maintain accurate inventory valuations and procurement records.
International procurement carried a class of cost adjustments absent from domestic purchasing. When aluminium rolls were sourced from suppliers in Europe and Asia, each shipment arrived with associated charges, including customs duties, freight, insurance, and exchange rate differences, that were not reflected in the original purchase order value. The invoiced price of goods and the true cost of receipt were therefore different figures.
With no mechanism to capture landed costs, received inventory was recorded at the invoiced price. Customs duties, freight charges, and other landed cost components were not applied to inventory valuation. Production cost calculations and procurement cost reporting were based on understated material values, limiting the accuracy of financial reporting and making it difficult to assess the true economics of each sourcing decision.
The procurement and inventory modules within Apache OFBiz were enhanced to support landed cost management across international shipments. ASNs were configured to handle multi-currency values, with conversion applied during the receiving process. A mechanism was introduced to capture and allocate adjustment charges, including customs duties, freight, discounts, and logistics fees, at the shipment or line level. These adjustments were applied to the cost of receipt, ensuring that inventory valuation reflected the true landed cost of each procured shipment.
The organization maintained an international supplier base across domestic, European, and Asian markets, with different vendors supplying different categories of input materials under varying supply conditions. Each inbound shipment moved through a network of intermediaries including port facilities, logistics carriers, and freight agents before reaching the production facility, with party roles varying across trade lanes.
Without centralized system support for logistics coordination, supplier profiles were maintained in a generic format with no mechanism to capture material-specific supply conditions. High-value purchase orders were routed for approval through email coordination, without system control over whether authorization had been obtained. Shipment progress through the logistics network was tracked through unstructured communication, with no mechanism to record party responsibilities at each leg or flag exceptions in transit. Commission obligations owed to intermediaries were similarly untracked against individual shipment records.
The vendor, party, and procurement management features within Apache OFBiz were built out to address these gaps. Custom screens and forms were developed to capture vendor-specific attributes including material categories, supply conditions, and onboarding specifications. A threshold-based purchase order approval workflow was implemented within the procurement module, routing orders to the appropriate authority within procurement or accounting. Ports of lading, logistics service providers, freight carriers, and internal receiving facilities were defined as distinct entities in the system, with roles and contact details linked to inbound shipment records. A commission-based model was implemented to record and reconcile commission obligations for each intermediary against their participation in each shipment.
This case study demonstrated how procurement and inbound supply chain operations in the packaging industry were brought under a single system built to reflect the complexity of international sourcing. Procurement constructs within Apache OFBiz were extended to formalize ASN-based inbound receiving, manage landed costs across international shipments, and govern vendor relationships and purchase order authorization across an international supplier network.
The result was a procurement environment where inbound shipments were received against formally managed ASNs, inventory valuation reflected the true landed cost of each procured shipment, and logistics network coordination was governed within a single system from port of origin to receiving facility. The case also described the use of open-source technologies such as Apache OFBiz and Moqui to build custom procurement solutions, supporting organizations in aligning system architecture with the specific demands of international sourcing operations.