ผมต้องการให้สร้างคลิปสั้นประมาณ 1 นาที 9ซีน, ~60–90 วินาที, 16:9, 1080p ในการบอกตัวตนของบริษัท TMT รูปที่1 คือ Storyboard ว่าในวิดีโอหน้าตาประมาณนี้ บทของเรื่อง: ใช้รูปที่ 2 เป็น Reference [Opening Scene – Airplane taking off / Cargo loading] Text on screen: “Worldwide Freight Solutions” Voice Over: “Looking for a reliable international freight forwarder?” [Scene – Fresh flowers / frozen food / chilled cargo] Text on screen: “Perishable Cargo Specialist” Voice Over: “We specialize in perishable shipments including flowers, chilled products, frozen foods, and temperature-sensitive cargo.” [Scene – Air freight, sea freight, trucks moving] Text on screen: “Air • Sea • Road” Voice Over: “We provide import and export services for general cargo, dangerous goods, and perishable products by air, sea, and road — locally and internationally.” [Scene – Staff monitoring shipment / customer service] Text on screen: “Professional Supervision” Voice Over: “Every shipment is carefully supervised by experienced professionals to ensure smooth and secure transportation.” [Scene – Customer support answering phone late at night] Text on screen: “24/7 Support” Voice Over: “Our support team is always ready to assist you — anytime, even outside working hours.” [Scene – Reefer truck and dry truck on the road] Text on screen: “Thailand Transportation Solutions” Voice Over: “We also provide reefer trucks and dry trucks throughout Thailand.” [Scene – Map showing Chiang Mai, Bangkok, Suvarnabhumi] Text on screen: “Branches Across Thailand” Voice Over: “With branches in Chiang Mai, Bangkok, and Suvarnabhumi, we are ready to connect your business to the world.” [Closing Scene – Company logo with global background] Text on screen: “Reliable • Competitive • Sustainable” Voice Over: “Professional logistics solutions with competitive pricing and long-term commitment.” Final Text: “Contact us today for a quotation.” เสียง: Female, neutral international English, professional and warm — ElevenLabs V3. Music: Calm, luxurious classical underscore. Certifications: Sprinkled in Scene 4, then all together in the closing. Contact Info: Final card with website, Line QR, address, and phone number. Global Style (ใช้กับทุก Scene) Style Prompt Premium corporate logistics commercial, cinematic photography, luxury business advertisement, global freight forwarding company, warm golden hour lighting, realistic people, realistic vehicles, ultra detailed, professional color grading, blue and gold brand identity, shallow depth of field, cinematic camera movement, 4K, HDR, realistic reflections, high-end commercial production, smooth motion, no text, no watermark, no subtitles. Scene 1 — Opening (8 sec) Prompt Massive cargo aircraft with blue and gold airline branding taxiing and taking off during golden hour at an international airport. Ground crew loading cargo pallets and containers beside the aircraft. Warm sunrise light reflecting on the tarmac. Cinematic drone shot slowly rising as the aircraft begins takeoff. Premium logistics commercial style, realistic aviation operations, highly detailed cargo handling, smooth camera movement, luxury corporate advertisement. Camera Drone push forward + slow rise Duration 8 seconds Voice-over Looking for a reliable international freight forwarder? Scene 2 — Perishable Cargo (8 sec) Prompt Close-up cinematic shots of fresh purple orchids, chilled products, frozen premium meat with visible frost, temperature-controlled logistics environment. Cold mist and refrigeration details. Smooth macro camera movement showcasing freshness and careful handling. Premium perishable cargo logistics advertisement, realistic textures, luxurious food export visuals. Camera Macro slider movement Duration 8 seconds Voice-over We specialize in perishable shipments including flowers, chilled products, frozen foods, and temperature-sensitive cargo. Scene 3 — Air Freight (6 sec) Prompt Large cargo aircraft flying above clouds during sunrise. Global air freight logistics concept. Containers being loaded into aircraft. Dynamic cinematic aerial shots. Premium corporate aviation advertisement, realistic aircraft operations, global transportation network. Camera Aerial tracking shot Duration 6 seconds Voice-over Air freight solutions connecting Thailand to global markets. Scene 4 — Sea Freight (6 sec) Prompt Massive container ship crossing the ocean at sunset carrying colorful shipping containers. Port cranes operating in the background. Ocean reflections, cinematic shipping logistics commercial, realistic maritime freight operations, global trade concept. Camera Slow cinematic orbit Duration 6 seconds Voice-over Reliable sea freight services for international import and export. Scene 5 — Road Transportation (8 sec) Prompt Modern refrigerated reefer truck and dry cargo truck driving on a scenic Thai highway during golden hour. Beautiful mountains and tropical landscape. Smooth drone tracking shot following the convoy. Premium logistics transport commercial, realistic vehicles, cinematic road transportation. Camera Drone tracking Duration 8 seconds Voice-over Comprehensive transportation solutions across Thailand. Scene 6 — Professional Supervision (10 sec) Prompt Professional logistics operations center. Experienced freight specialists monitoring shipment tracking systems, temperature monitoring dashboards, global logistics maps and transportation data. Modern office environment with blue and gold corporate branding. Professional teamwork and supervision. Premium business commercial, realistic office operations. Camera Slow dolly movement Duration 10 seconds Voice-over Every shipment is carefully supervised by experienced professionals to ensure smooth and secure transportation. Scene 7 — 24/7 Support (8 sec) Prompt Professional customer service representative answering client calls in a modern office at night. City skyline lights visible through large windows. Friendly and confident support team assisting international customers. Premium corporate service advertisement, warm and trustworthy atmosphere. Camera Slow push-in Duration 8 seconds Voice-over Our support team is always ready to assist you — anytime, even outside working hours. Scene 8 — Thailand Network (10 sec) Prompt Glowing digital map of Thailand with animated logistics routes connecting Chiang Mai, Bangkok, and Suvarnabhumi Airport. Global network visualization expanding outward from Thailand to the world. Modern corporate animation style blended with realistic satellite imagery. Premium logistics network commercial. Camera Zoom-out from Thailand to globe Duration 10 seconds Voice-over With branches in Chiang Mai, Bangkok, and Suvarnabhumi, we are ready to connect your business to the world. Scene 9 — Closing (10 sec) Prompt Elegant blue and gold global logistics background. Corporate elephant logo appearing with glowing world network lines. Premium luxury business branding animation. Professional logistics company identity reveal. Sophisticated cinematic ending, global freight forwarding excellence, corporate prestige. Camera Slow logo reveal Duration 10 seconds Voice-over Professional logistics solutions with competitive pricing and long-term commitment. End Screen Text T.M.T Cargo Co., Ltd. Reliable • Competitive • Sustainable Tel: +66 (0)2-690-8060 Email: sales@tmtcargo.com www.tmtcargo.com Negative Prompt (ใส่ทุก Scene) low quality, blurry, cartoon, illustration, CGI look, distorted vehicles, deformed people, extra fingers, duplicate objects, incorrect logos, text artifacts, subtitles, watermark, noisy image, unrealistic lighting, oversaturated colors, low resolution, fake airport equipment, unrealistic trucks, poor anatomy
GRPO DATA EXTRACTION & POPULATION RULES Applicable Document: Generate Goods Receipt PO (GRPO) only. -------------------------------------------------- Rule 1 – GRPO Dates Populate: | SAP Table | Field | Value | | OPDN | DocDate | Clearing Agent/Freight Forwarder Invoice Date | | OPDN | DocDueDate | Clearing Agent/Freight Forwarder Invoice Date | | OPDN | TaxDate | Clearing Agent/Freight Forwarder Invoice Date | Business Rules • Use the invoice date issued by the Clearing Agent, Freight Forwarder or Logistics Company (e.g. P. Kelepeshis, Hellenic Cargo Freight Logistics, Blue Ice or similar). • Use the same date for all three fields. • Do not use Supplier Invoice Date, Bill of Lading Date, Posting Date, Scan Date, Email Date or System Date. • If the date cannot be identified with confidence, flag Manual Review. -------------------------------------------------- Rule 2 – Product Line Validation Compare every Purchase Order (Base Document) line against the Supplier Invoice. Compare: Item Code, Description, Quantity, Unit Price, Line Total. Business Rules • GRPO lines must always be created from the Base Document (Purchase Order). • Supplier Invoice values are for validation only and validation must always be performed. • Never overwrite Purchase Order values with Supplier Invoice values. • Before comparing Quantity, Unit Price or Line Total, convert both documents to the same Unit of Measure using the Purchase Order UoM. • Convert both Quantity and Unit Price before validation. • Standard conversion: 1 MT (TON)=1,000 KG. • Example: 17 MT @ €2,010/MT = 17,000 KG @ €2.01/KG. • Use packaging information (e.g. 68 Drums × 250 KG) to validate converted quantities. • Never compare values with different Units of Measure. • If Quantity, Unit Price or Line Total differs after conversion, display the differences and flag Manual Review. • If the Invoice contains items not on the Purchase Order, flag Manual Review. • If the Purchase Order contains items not on the Invoice, flag Manual Review. • If the UoM or conversion factor cannot be determined, flag Manual Review. -------------------------------------------------- Rule 3 – Batch Number Validation For batch-managed items extract the Batch Number from the CoA, Supplier Invoice, Packing List and other supporting documents. Business Rules • Use the CoA Batch Number as the default SAP Batch Number. • Compare the CoA Batch Number with all other documents. • If any Batch Number differs, still populate the CoA Batch Number but flag Manual Review and display the conflicting document(s). • Ignore spaces, hyphens, slashes and letter case when comparing Batch Numbers. • Compare each item independently. • Support multiple Batch Numbers per item and preserve quantities. • If no CoA exists, use the next highest priority document and flag Manual Review. • If no Batch Number is found, flag Manual Review. -------------------------------------------------- Rule 4 – Manufacturing & Expiry Dates Extract Manufacturing Date and Expiry Date for every batch-managed item from the CoA. Recognize labels: Manufacturing: Date of Manufacture, Manufacturing Date, MFG Date, Production Date, Produced On, Manufactured On. Expiry: Expiry Date, Expiration Date, Exp Date, Best Before, Use Before, Valid Until, Shelf Life Until, Retest Date. Business Rules • If no Expiry Date exists but a Retest Date exists, use the Retest Date as the Expiry Date. • Return all dates in DD/MM/YYYY format. • If only Month and Year are available, use the first day of the month. • Example: May 2026 = 01/05/2026, November 2027 = 01/11/2027. • Compare Manufacturing and Expiry/Retest Dates with all supporting documents. • If dates differ, flag Manual Review. -------------------------------------------------- Rule 5 – Freight Charges Condition When invoice lines contain Freight, Freight Surcharge, Fuel Charge, Fuel Surcharge, Transport Charge, Shipping Charge, Logistics Charge or freight-related Sundries. Action • Remove these lines from the product lines. • Populate SAP Business One Additional Expenses. • SAP Table: PDN3. • Expense Code: FREIGHT. • PDN3.LineTotal (Net Amount)=Total Freight Charges. • Preserve VAT Code. Business Rules • Freight charges are NOT discounts. • Populate ONLY PDN3.LineTotal. • Never populate Document Discount. • Never populate Line Discount. • Never reduce Item Unit Price. • Never reduce Item Line Total. • Never use Freight Charges to balance the invoice. • Product lines must contain inventory goods only. • Combine multiple freight-related charges into one PDN3.LineTotal value. • If a Sundries line cannot be identified as freight-related, flag Manual Review. Validation Invoice Total = Product Total + PDN3.LineTotal ± Taxes. -------------------------------------------------- Rule 6 – Product Cost Surcharges Condition When invoice lines contain Energy Surcharge, Energy Cost Adjustment, Raw Material Surcharge, Alloy Surcharge, Metal Surcharge, Environmental Surcharge, Manufacturing Surcharge or similar product cost surcharges. Action • Do NOT populate PDN3.LineTotal. • Allocate the surcharge to the related product line(s). • Increase the Product Unit Price. Business Rules • These surcharges form part of the acquisition cost. • They must not remain as separate invoice lines. • They must never create Freight Charges. • If the surcharge relates to one product, allocate 100% to that product. • If it relates to multiple products, distribute proportionally based on line value unless another allocation method is specified. • Recalculate the Unit Price after allocation. Formula New Unit Price=(Product Line Value+Allocated Surcharge)/Quantity. Example Qty=10, Unit Price=€100, Energy Surcharge=€20. New Unit Price=(1000+20)/10=€102. • If the affected products cannot be determined, flag Manual Review. -------------------------------------------------- Validation Rules • Never guess or invent values. • Always compare the Purchase Order against the Supplier Invoice before creating the GRPO. • Flag all Quantity, Unit Price and Line Total differences. • Batch Number defaults to the CoA and must match supporting documents. • Manufacturing and Expiry Dates default to the CoA. • Freight, Fuel, Transport, Shipping and Logistics charges populate PDN3.LineTotal only. • Product Cost Surcharges (e.g. Energy Surcharge) must increase the Product Unit Price and must never populate PDN3.LineTotal. • Freight Charges must never populate Document Discount or Line Discount. • If confidence is below 80%, flag Manual Review.
ผมต้องการให้สร้างคลิปสั้นประมาณ 1 นาที 9ซีน, ~60–90 วินาที, 16:9, 1080p ในการบอกตัวตนของบริษัท TMT รูปที่1 คือ Storyboard ว่าในวิดีโอหน้าตาประมาณนี้ บทของเรื่อง: ใช้รูปที่ 2 เป็น Reference [Opening Scene – Airplane taking off / Cargo loading] Text on screen: “Worldwide Freight Solutions” Voice Over: “Looking for a reliable international freight forwarder?” [Scene – Fresh flowers / frozen food / chilled cargo] Text on screen: “Perishable Cargo Specialist” Voice Over: “We specialize in perishable shipments including flowers, chilled products, frozen foods, and temperature-sensitive cargo.” [Scene – Air freight, sea freight, trucks moving] Text on screen: “Air • Sea • Road” Voice Over: “We provide import and export services for general cargo, dangerous goods, and perishable products by air, sea, and road — locally and internationally.” [Scene – Staff monitoring shipment / customer service] Text on screen: “Professional Supervision” Voice Over: “Every shipment is carefully supervised by experienced professionals to ensure smooth and secure transportation.” [Scene – Customer support answering phone late at night] Text on screen: “24/7 Support” Voice Over: “Our support team is always ready to assist you — anytime, even outside working hours.” [Scene – Reefer truck and dry truck on the road] Text on screen: “Thailand Transportation Solutions” Voice Over: “We also provide reefer trucks and dry trucks throughout Thailand.” [Scene – Map showing Chiang Mai, Bangkok, Suvarnabhumi] Text on screen: “Branches Across Thailand” Voice Over: “With branches in Chiang Mai, Bangkok, and Suvarnabhumi, we are ready to connect your business to the world.” [Closing Scene – Company logo with global background] Text on screen: “Reliable • Competitive • Sustainable” Voice Over: “Professional logistics solutions with competitive pricing and long-term commitment.” Final Text: “Contact us today for a quotation.” เสียง: Female, neutral international English, professional and warm — ElevenLabs V3. Music: Calm, luxurious classical underscore. Certifications: Sprinkled in Scene 4, then all together in the closing. Contact Info: Final card with website, Line QR, address, and phone number. Global Style (ใช้กับทุก Scene) Style Prompt Premium corporate logistics commercial, cinematic photography, luxury business advertisement, global freight forwarding company, warm golden hour lighting, realistic people, realistic vehicles, ultra detailed, professional color grading, blue and gold brand identity, shallow depth of field, cinematic camera movement, 4K, HDR, realistic reflections, high-end commercial production, smooth motion, no text, no watermark, no subtitles. Scene 1 — Opening (8 sec) Prompt Massive cargo aircraft with blue and gold airline branding taxiing and taking off during golden hour at an international airport. Ground crew loading cargo pallets and containers beside the aircraft. Warm sunrise light reflecting on the tarmac. Cinematic drone shot slowly rising as the aircraft begins takeoff. Premium logistics commercial style, realistic aviation operations, highly detailed cargo handling, smooth camera movement, luxury corporate advertisement. Camera Drone push forward + slow rise Duration 8 seconds Voice-over Looking for a reliable international freight forwarder? Scene 2 — Perishable Cargo (8 sec) Prompt Close-up cinematic shots of fresh purple orchids, chilled products, frozen premium meat with visible frost, temperature-controlled logistics environment. Cold mist and refrigeration details. Smooth macro camera movement showcasing freshness and careful handling. Premium perishable cargo logistics advertisement, realistic textures, luxurious food export visuals. Camera Macro slider movement Duration 8 seconds Voice-over We specialize in perishable shipments including flowers, chilled products, frozen foods, and temperature-sensitive cargo. Scene 3 — Air Freight (6 sec) Prompt Large cargo aircraft flying above clouds during sunrise. Global air freight logistics concept. Containers being loaded into aircraft. Dynamic cinematic aerial shots. Premium corporate aviation advertisement, realistic aircraft operations, global transportation network. Camera Aerial tracking shot Duration 6 seconds Voice-over Air freight solutions connecting Thailand to global markets. Scene 4 — Sea Freight (6 sec) Prompt Massive container ship crossing the ocean at sunset carrying colorful shipping containers. Port cranes operating in the background. Ocean reflections, cinematic shipping logistics commercial, realistic maritime freight operations, global trade concept. Camera Slow cinematic orbit Duration 6 seconds Voice-over Reliable sea freight services for international import and export. Scene 5 — Road Transportation (8 sec) Prompt Modern refrigerated reefer truck and dry cargo truck driving on a scenic Thai highway during golden hour. Beautiful mountains and tropical landscape. Smooth drone tracking shot following the convoy. Premium logistics transport commercial, realistic vehicles, cinematic road transportation. Camera Drone tracking Duration 8 seconds Voice-over Comprehensive transportation solutions across Thailand. Scene 6 — Professional Supervision (10 sec) Prompt Professional logistics operations center. Experienced freight specialists monitoring shipment tracking systems, temperature monitoring dashboards, global logistics maps and transportation data. Modern office environment with blue and gold corporate branding. Professional teamwork and supervision. Premium business commercial, realistic office operations. Camera Slow dolly movement Duration 10 seconds Voice-over Every shipment is carefully supervised by experienced professionals to ensure smooth and secure transportation. Scene 7 — 24/7 Support (8 sec) Prompt Professional customer service representative answering client calls in a modern office at night. City skyline lights visible through large windows. Friendly and confident support team assisting international customers. Premium corporate service advertisement, warm and trustworthy atmosphere. Camera Slow push-in Duration 8 seconds Voice-over Our support team is always ready to assist you — anytime, even outside working hours. Scene 8 — Thailand Network (10 sec) Prompt Glowing digital map of Thailand with animated logistics routes connecting Chiang Mai, Bangkok, and Suvarnabhumi Airport. Global network visualization expanding outward from Thailand to the world. Modern corporate animation style blended with realistic satellite imagery. Premium logistics network commercial. Camera Zoom-out from Thailand to globe Duration 10 seconds Voice-over With branches in Chiang Mai, Bangkok, and Suvarnabhumi, we are ready to connect your business to the world. Scene 9 — Closing (10 sec) Prompt Elegant blue and gold global logistics background. Corporate elephant logo appearing with glowing world network lines. Premium luxury business branding animation. Professional logistics company identity reveal. Sophisticated cinematic ending, global freight forwarding excellence, corporate prestige. Camera Slow logo reveal Duration 10 seconds Voice-over Professional logistics solutions with competitive pricing and long-term commitment. End Screen Text T.M.T Cargo Co., Ltd. Reliable • Competitive • Sustainable Tel: +66 (0)2-690-8060 Email: sales@tmtcargo.com www.tmtcargo.com Negative Prompt (ใส่ทุก Scene) low quality, blurry, cartoon, illustration, CGI look, distorted vehicles, deformed people, extra fingers, duplicate objects, incorrect logos, text artifacts, subtitles, watermark, noisy image, unrealistic lighting, oversaturated colors, low resolution, fake airport equipment, unrealistic trucks, poor anatomy
GRPO DATA EXTRACTION & POPULATION RULES Applicable Document: Generate Goods Receipt PO (GRPO) only. -------------------------------------------------- Rule 1 – GRPO Dates Populate: | SAP Table | Field | Value | | OPDN | DocDate | Clearing Agent/Freight Forwarder Invoice Date | | OPDN | DocDueDate | Clearing Agent/Freight Forwarder Invoice Date | | OPDN | TaxDate | Clearing Agent/Freight Forwarder Invoice Date | Business Rules • Use the invoice date issued by the Clearing Agent, Freight Forwarder or Logistics Company (e.g. P. Kelepeshis, Hellenic Cargo Freight Logistics, Blue Ice or similar). • Use the same date for all three fields. • Do not use Supplier Invoice Date, Bill of Lading Date, Posting Date, Scan Date, Email Date or System Date. • If the date cannot be identified with confidence, flag Manual Review. -------------------------------------------------- Rule 2 – Product Line Validation Compare every Purchase Order (Base Document) line against the Supplier Invoice. Compare: Item Code, Description, Quantity, Unit Price, Line Total. Business Rules • GRPO lines must always be created from the Base Document (Purchase Order). • Supplier Invoice values are for validation only and validation must always be performed. • Never overwrite Purchase Order values with Supplier Invoice values. • Before comparing Quantity, Unit Price or Line Total, convert both documents to the same Unit of Measure using the Purchase Order UoM. • Convert both Quantity and Unit Price before validation. • Standard conversion: 1 MT (TON)=1,000 KG. • Example: 17 MT @ €2,010/MT = 17,000 KG @ €2.01/KG. • Use packaging information (e.g. 68 Drums × 250 KG) to validate converted quantities. • Never compare values with different Units of Measure. • If Quantity, Unit Price or Line Total differs after conversion, display the differences and flag Manual Review. • If the Invoice contains items not on the Purchase Order, flag Manual Review. • If the Purchase Order contains items not on the Invoice, flag Manual Review. • If the UoM or conversion factor cannot be determined, flag Manual Review. -------------------------------------------------- Rule 3 – Batch Number Validation For batch-managed items extract the Batch Number from the CoA, Supplier Invoice, Packing List and other supporting documents. Business Rules • Use the CoA Batch Number as the default SAP Batch Number. • Compare the CoA Batch Number with all other documents. • If any Batch Number differs, still populate the CoA Batch Number but flag Manual Review and display the conflicting document(s). • Ignore spaces, hyphens, slashes and letter case when comparing Batch Numbers. • Compare each item independently. • Support multiple Batch Numbers per item and preserve quantities. • If no CoA exists, use the next highest priority document and flag Manual Review. • If no Batch Number is found, flag Manual Review. -------------------------------------------------- Rule 4 – Manufacturing & Expiry Dates Extract Manufacturing Date and Expiry Date for every batch-managed item from the CoA. Recognize labels: Manufacturing: Date of Manufacture, Manufacturing Date, MFG Date, Production Date, Produced On, Manufactured On. Expiry: Expiry Date, Expiration Date, Exp Date, Best Before, Use Before, Valid Until, Shelf Life Until, Retest Date. Business Rules • If no Expiry Date exists but a Retest Date exists, use the Retest Date as the Expiry Date. • Return all dates in DD/MM/YYYY format. • If only Month and Year are available, use the first day of the month. • Example: May 2026 = 01/05/2026, November 2027 = 01/11/2027. • Compare Manufacturing and Expiry/Retest Dates with all supporting documents. • If dates differ, flag Manual Review. -------------------------------------------------- Rule 5 – Freight Charges Condition When invoice lines contain Freight, Freight Surcharge, Fuel Charge, Fuel Surcharge, Transport Charge, Shipping Charge, Logistics Charge or freight-related Sundries. Action • Remove these lines from the product lines. • Populate SAP Business One Additional Expenses. • SAP Table: PDN3. • Expense Code: FREIGHT. • PDN3.LineTotal (Net Amount)=Total Freight Charges. • Preserve VAT Code. Business Rules • Freight charges are NOT discounts. • Populate ONLY PDN3.LineTotal. • Never populate Document Discount. • Never populate Line Discount. • Never reduce Item Unit Price. • Never reduce Item Line Total. • Never use Freight Charges to balance the invoice. • Product lines must contain inventory goods only. • Combine multiple freight-related charges into one PDN3.LineTotal value. • If a Sundries line cannot be identified as freight-related, flag Manual Review. Validation Invoice Total = Product Total + PDN3.LineTotal ± Taxes. -------------------------------------------------- Rule 6 – Product Cost Surcharges Condition When invoice lines contain Energy Surcharge, Energy Cost Adjustment, Raw Material Surcharge, Alloy Surcharge, Metal Surcharge, Environmental Surcharge, Manufacturing Surcharge or similar product cost surcharges. Action • Do NOT populate PDN3.LineTotal. • Allocate the surcharge to the related product line(s). • Increase the Product Unit Price. Business Rules • These surcharges form part of the acquisition cost. • They must not remain as separate invoice lines. • They must never create Freight Charges. • If the surcharge relates to one product, allocate 100% to that product. • If it relates to multiple products, distribute proportionally based on line value unless another allocation method is specified. • Recalculate the Unit Price after allocation. Formula New Unit Price=(Product Line Value+Allocated Surcharge)/Quantity. Example Qty=10, Unit Price=€100, Energy Surcharge=€20. New Unit Price=(1000+20)/10=€102. • If the affected products cannot be determined, flag Manual Review. -------------------------------------------------- Validation Rules • Never guess or invent values. • Always compare the Purchase Order against the Supplier Invoice before creating the GRPO. • Flag all Quantity, Unit Price and Line Total differences. • Batch Number defaults to the CoA and must match supporting documents. • Manufacturing and Expiry Dates default to the CoA. • Freight, Fuel, Transport, Shipping and Logistics charges populate PDN3.LineTotal only. • Product Cost Surcharges (e.g. Energy Surcharge) must increase the Product Unit Price and must never populate PDN3.LineTotal. • Freight Charges must never populate Document Discount or Line Discount. • If confidence is below 80%, flag Manual Review.
ผมต้องการให้สร้างคลิปสั้นประมาณ 1 นาที 9ซีน, ~60–90 วินาที, 16:9, 1080p ในการบอกตัวตนของบริษัท TMT รูปที่1 คือ Storyboard ว่าในวิดีโอหน้าตาประมาณนี้ บทของเรื่อง: ใช้รูปที่ 2 เป็น Reference [Opening Scene – Airplane taking off / Cargo loading] Text on screen: “Worldwide Freight Solutions” Voice Over: “Looking for a reliable international freight forwarder?” [Scene – Fresh flowers / frozen food / chilled cargo] Text on screen: “Perishable Cargo Specialist” Voice Over: “We specialize in perishable shipments including flowers, chilled products, frozen foods, and temperature-sensitive cargo.” [Scene – Air freight, sea freight, trucks moving] Text on screen: “Air • Sea • Road” Voice Over: “We provide import and export services for general cargo, dangerous goods, and perishable products by air, sea, and road — locally and internationally.” [Scene – Staff monitoring shipment / customer service] Text on screen: “Professional Supervision” Voice Over: “Every shipment is carefully supervised by experienced professionals to ensure smooth and secure transportation.” [Scene – Customer support answering phone late at night] Text on screen: “24/7 Support” Voice Over: “Our support team is always ready to assist you — anytime, even outside working hours.” [Scene – Reefer truck and dry truck on the road] Text on screen: “Thailand Transportation Solutions” Voice Over: “We also provide reefer trucks and dry trucks throughout Thailand.” [Scene – Map showing Chiang Mai, Bangkok, Suvarnabhumi] Text on screen: “Branches Across Thailand” Voice Over: “With branches in Chiang Mai, Bangkok, and Suvarnabhumi, we are ready to connect your business to the world.” [Closing Scene – Company logo with global background] Text on screen: “Reliable • Competitive • Sustainable” Voice Over: “Professional logistics solutions with competitive pricing and long-term commitment.” Final Text: “Contact us today for a quotation.” เสียง: Female, neutral international English, professional and warm — ElevenLabs V3. Music: Calm, luxurious classical underscore. Certifications: Sprinkled in Scene 4, then all together in the closing. Contact Info: Final card with website, Line QR, address, and phone number. Global Style (ใช้กับทุก Scene) Style Prompt Premium corporate logistics commercial, cinematic photography, luxury business advertisement, global freight forwarding company, warm golden hour lighting, realistic people, realistic vehicles, ultra detailed, professional color grading, blue and gold brand identity, shallow depth of field, cinematic camera movement, 4K, HDR, realistic reflections, high-end commercial production, smooth motion, no text, no watermark, no subtitles. Scene 1 — Opening (8 sec) Prompt Massive cargo aircraft with blue and gold airline branding taxiing and taking off during golden hour at an international airport. Ground crew loading cargo pallets and containers beside the aircraft. Warm sunrise light reflecting on the tarmac. Cinematic drone shot slowly rising as the aircraft begins takeoff. Premium logistics commercial style, realistic aviation operations, highly detailed cargo handling, smooth camera movement, luxury corporate advertisement. Camera Drone push forward + slow rise Duration 8 seconds Voice-over Looking for a reliable international freight forwarder? Scene 2 — Perishable Cargo (8 sec) Prompt Close-up cinematic shots of fresh purple orchids, chilled products, frozen premium meat with visible frost, temperature-controlled logistics environment. Cold mist and refrigeration details. Smooth macro camera movement showcasing freshness and careful handling. Premium perishable cargo logistics advertisement, realistic textures, luxurious food export visuals. Camera Macro slider movement Duration 8 seconds Voice-over We specialize in perishable shipments including flowers, chilled products, frozen foods, and temperature-sensitive cargo. Scene 3 — Air Freight (6 sec) Prompt Large cargo aircraft flying above clouds during sunrise. Global air freight logistics concept. Containers being loaded into aircraft. Dynamic cinematic aerial shots. Premium corporate aviation advertisement, realistic aircraft operations, global transportation network. Camera Aerial tracking shot Duration 6 seconds Voice-over Air freight solutions connecting Thailand to global markets. Scene 4 — Sea Freight (6 sec) Prompt Massive container ship crossing the ocean at sunset carrying colorful shipping containers. Port cranes operating in the background. Ocean reflections, cinematic shipping logistics commercial, realistic maritime freight operations, global trade concept. Camera Slow cinematic orbit Duration 6 seconds Voice-over Reliable sea freight services for international import and export. Scene 5 — Road Transportation (8 sec) Prompt Modern refrigerated reefer truck and dry cargo truck driving on a scenic Thai highway during golden hour. Beautiful mountains and tropical landscape. Smooth drone tracking shot following the convoy. Premium logistics transport commercial, realistic vehicles, cinematic road transportation. Camera Drone tracking Duration 8 seconds Voice-over Comprehensive transportation solutions across Thailand. Scene 6 — Professional Supervision (10 sec) Prompt Professional logistics operations center. Experienced freight specialists monitoring shipment tracking systems, temperature monitoring dashboards, global logistics maps and transportation data. Modern office environment with blue and gold corporate branding. Professional teamwork and supervision. Premium business commercial, realistic office operations. Camera Slow dolly movement Duration 10 seconds Voice-over Every shipment is carefully supervised by experienced professionals to ensure smooth and secure transportation. Scene 7 — 24/7 Support (8 sec) Prompt Professional customer service representative answering client calls in a modern office at night. City skyline lights visible through large windows. Friendly and confident support team assisting international customers. Premium corporate service advertisement, warm and trustworthy atmosphere. Camera Slow push-in Duration 8 seconds Voice-over Our support team is always ready to assist you — anytime, even outside working hours. Scene 8 — Thailand Network (10 sec) Prompt Glowing digital map of Thailand with animated logistics routes connecting Chiang Mai, Bangkok, and Suvarnabhumi Airport. Global network visualization expanding outward from Thailand to the world. Modern corporate animation style blended with realistic satellite imagery. Premium logistics network commercial. Camera Zoom-out from Thailand to globe Duration 10 seconds Voice-over With branches in Chiang Mai, Bangkok, and Suvarnabhumi, we are ready to connect your business to the world. Scene 9 — Closing (10 sec) Prompt Elegant blue and gold global logistics background. Corporate elephant logo appearing with glowing world network lines. Premium luxury business branding animation. Professional logistics company identity reveal. Sophisticated cinematic ending, global freight forwarding excellence, corporate prestige. Camera Slow logo reveal Duration 10 seconds Voice-over Professional logistics solutions with competitive pricing and long-term commitment. End Screen Text T.M.T Cargo Co., Ltd. Reliable • Competitive • Sustainable Tel: +66 (0)2-690-8060 Email: sales@tmtcargo.com www.tmtcargo.com Negative Prompt (ใส่ทุก Scene) low quality, blurry, cartoon, illustration, CGI look, distorted vehicles, deformed people, extra fingers, duplicate objects, incorrect logos, text artifacts, subtitles, watermark, noisy image, unrealistic lighting, oversaturated colors, low resolution, fake airport equipment, unrealistic trucks, poor anatomy
GRPO DATA EXTRACTION & POPULATION RULES Applicable Document: Generate Goods Receipt PO (GRPO) only. -------------------------------------------------- Rule 1 – GRPO Dates Populate: | SAP Table | Field | Value | | OPDN | DocDate | Clearing Agent/Freight Forwarder Invoice Date | | OPDN | DocDueDate | Clearing Agent/Freight Forwarder Invoice Date | | OPDN | TaxDate | Clearing Agent/Freight Forwarder Invoice Date | Business Rules • Use the invoice date issued by the Clearing Agent, Freight Forwarder or Logistics Company (e.g. P. Kelepeshis, Hellenic Cargo Freight Logistics, Blue Ice or similar). • Use the same date for all three fields. • Do not use Supplier Invoice Date, Bill of Lading Date, Posting Date, Scan Date, Email Date or System Date. • If the date cannot be identified with confidence, flag Manual Review. -------------------------------------------------- Rule 2 – Product Line Validation Compare every Purchase Order (Base Document) line against the Supplier Invoice. Compare: Item Code, Description, Quantity, Unit Price, Line Total. Business Rules • GRPO lines must always be created from the Base Document (Purchase Order). • Supplier Invoice values are for validation only and validation must always be performed. • Never overwrite Purchase Order values with Supplier Invoice values. • Before comparing Quantity, Unit Price or Line Total, convert both documents to the same Unit of Measure using the Purchase Order UoM. • Convert both Quantity and Unit Price before validation. • Standard conversion: 1 MT (TON)=1,000 KG. • Example: 17 MT @ €2,010/MT = 17,000 KG @ €2.01/KG. • Use packaging information (e.g. 68 Drums × 250 KG) to validate converted quantities. • Never compare values with different Units of Measure. • If Quantity, Unit Price or Line Total differs after conversion, display the differences and flag Manual Review. • If the Invoice contains items not on the Purchase Order, flag Manual Review. • If the Purchase Order contains items not on the Invoice, flag Manual Review. • If the UoM or conversion factor cannot be determined, flag Manual Review. -------------------------------------------------- Rule 3 – Batch Number Validation For batch-managed items extract the Batch Number from the CoA, Supplier Invoice, Packing List and other supporting documents. Business Rules • Use the CoA Batch Number as the default SAP Batch Number. • Compare the CoA Batch Number with all other documents. • If any Batch Number differs, still populate the CoA Batch Number but flag Manual Review and display the conflicting document(s). • Ignore spaces, hyphens, slashes and letter case when comparing Batch Numbers. • Compare each item independently. • Support multiple Batch Numbers per item and preserve quantities. • If no CoA exists, use the next highest priority document and flag Manual Review. • If no Batch Number is found, flag Manual Review. -------------------------------------------------- Rule 4 – Manufacturing & Expiry Dates Extract Manufacturing Date and Expiry Date for every batch-managed item from the CoA. Recognize labels: Manufacturing: Date of Manufacture, Manufacturing Date, MFG Date, Production Date, Produced On, Manufactured On. Expiry: Expiry Date, Expiration Date, Exp Date, Best Before, Use Before, Valid Until, Shelf Life Until, Retest Date. Business Rules • If no Expiry Date exists but a Retest Date exists, use the Retest Date as the Expiry Date. • Return all dates in DD/MM/YYYY format. • If only Month and Year are available, use the first day of the month. • Example: May 2026 = 01/05/2026, November 2027 = 01/11/2027. • Compare Manufacturing and Expiry/Retest Dates with all supporting documents. • If dates differ, flag Manual Review. -------------------------------------------------- Rule 5 – Freight Charges Condition When invoice lines contain Freight, Freight Surcharge, Fuel Charge, Fuel Surcharge, Transport Charge, Shipping Charge, Logistics Charge or freight-related Sundries. Action • Remove these lines from the product lines. • Populate SAP Business One Additional Expenses. • SAP Table: PDN3. • Expense Code: FREIGHT. • PDN3.LineTotal (Net Amount)=Total Freight Charges. • Preserve VAT Code. Business Rules • Freight charges are NOT discounts. • Populate ONLY PDN3.LineTotal. • Never populate Document Discount. • Never populate Line Discount. • Never reduce Item Unit Price. • Never reduce Item Line Total. • Never use Freight Charges to balance the invoice. • Product lines must contain inventory goods only. • Combine multiple freight-related charges into one PDN3.LineTotal value. • If a Sundries line cannot be identified as freight-related, flag Manual Review. Validation Invoice Total = Product Total + PDN3.LineTotal ± Taxes. -------------------------------------------------- Rule 6 – Product Cost Surcharges Condition When invoice lines contain Energy Surcharge, Energy Cost Adjustment, Raw Material Surcharge, Alloy Surcharge, Metal Surcharge, Environmental Surcharge, Manufacturing Surcharge or similar product cost surcharges. Action • Do NOT populate PDN3.LineTotal. • Allocate the surcharge to the related product line(s). • Increase the Product Unit Price. Business Rules • These surcharges form part of the acquisition cost. • They must not remain as separate invoice lines. • They must never create Freight Charges. • If the surcharge relates to one product, allocate 100% to that product. • If it relates to multiple products, distribute proportionally based on line value unless another allocation method is specified. • Recalculate the Unit Price after allocation. Formula New Unit Price=(Product Line Value+Allocated Surcharge)/Quantity. Example Qty=10, Unit Price=€100, Energy Surcharge=€20. New Unit Price=(1000+20)/10=€102. • If the affected products cannot be determined, flag Manual Review. -------------------------------------------------- Validation Rules • Never guess or invent values. • Always compare the Purchase Order against the Supplier Invoice before creating the GRPO. • Flag all Quantity, Unit Price and Line Total differences. • Batch Number defaults to the CoA and must match supporting documents. • Manufacturing and Expiry Dates default to the CoA. • Freight, Fuel, Transport, Shipping and Logistics charges populate PDN3.LineTotal only. • Product Cost Surcharges (e.g. Energy Surcharge) must increase the Product Unit Price and must never populate PDN3.LineTotal. • Freight Charges must never populate Document Discount or Line Discount. • If confidence is below 80%, flag Manual Review.
ผมต้องการให้สร้างคลิปสั้นประมาณ 1 นาที 9ซีน, ~60–90 วินาที, 16:9, 1080p ในการบอกตัวตนของบริษัท TMT รูปที่1 คือ Storyboard ว่าในวิดีโอหน้าตาประมาณนี้ บทของเรื่อง: ใช้รูปที่ 2 เป็น Reference [Opening Scene – Airplane taking off / Cargo loading] Text on screen: “Worldwide Freight Solutions” Voice Over: “Looking for a reliable international freight forwarder?” [Scene – Fresh flowers / frozen food / chilled cargo] Text on screen: “Perishable Cargo Specialist” Voice Over: “We specialize in perishable shipments including flowers, chilled products, frozen foods, and temperature-sensitive cargo.” [Scene – Air freight, sea freight, trucks moving] Text on screen: “Air • Sea • Road” Voice Over: “We provide import and export services for general cargo, dangerous goods, and perishable products by air, sea, and road — locally and internationally.” [Scene – Staff monitoring shipment / customer service] Text on screen: “Professional Supervision” Voice Over: “Every shipment is carefully supervised by experienced professionals to ensure smooth and secure transportation.” [Scene – Customer support answering phone late at night] Text on screen: “24/7 Support” Voice Over: “Our support team is always ready to assist you — anytime, even outside working hours.” [Scene – Reefer truck and dry truck on the road] Text on screen: “Thailand Transportation Solutions” Voice Over: “We also provide reefer trucks and dry trucks throughout Thailand.” [Scene – Map showing Chiang Mai, Bangkok, Suvarnabhumi] Text on screen: “Branches Across Thailand” Voice Over: “With branches in Chiang Mai, Bangkok, and Suvarnabhumi, we are ready to connect your business to the world.” [Closing Scene – Company logo with global background] Text on screen: “Reliable • Competitive • Sustainable” Voice Over: “Professional logistics solutions with competitive pricing and long-term commitment.” Final Text: “Contact us today for a quotation.” เสียง: Female, neutral international English, professional and warm — ElevenLabs V3. Music: Calm, luxurious classical underscore. Certifications: Sprinkled in Scene 4, then all together in the closing. Contact Info: Final card with website, Line QR, address, and phone number. Global Style (ใช้กับทุก Scene) Style Prompt Premium corporate logistics commercial, cinematic photography, luxury business advertisement, global freight forwarding company, warm golden hour lighting, realistic people, realistic vehicles, ultra detailed, professional color grading, blue and gold brand identity, shallow depth of field, cinematic camera movement, 4K, HDR, realistic reflections, high-end commercial production, smooth motion, no text, no watermark, no subtitles. Scene 1 — Opening (8 sec) Prompt Massive cargo aircraft with blue and gold airline branding taxiing and taking off during golden hour at an international airport. Ground crew loading cargo pallets and containers beside the aircraft. Warm sunrise light reflecting on the tarmac. Cinematic drone shot slowly rising as the aircraft begins takeoff. Premium logistics commercial style, realistic aviation operations, highly detailed cargo handling, smooth camera movement, luxury corporate advertisement. Camera Drone push forward + slow rise Duration 8 seconds Voice-over Looking for a reliable international freight forwarder? Scene 2 — Perishable Cargo (8 sec) Prompt Close-up cinematic shots of fresh purple orchids, chilled products, frozen premium meat with visible frost, temperature-controlled logistics environment. Cold mist and refrigeration details. Smooth macro camera movement showcasing freshness and careful handling. Premium perishable cargo logistics advertisement, realistic textures, luxurious food export visuals. Camera Macro slider movement Duration 8 seconds Voice-over We specialize in perishable shipments including flowers, chilled products, frozen foods, and temperature-sensitive cargo. Scene 3 — Air Freight (6 sec) Prompt Large cargo aircraft flying above clouds during sunrise. Global air freight logistics concept. Containers being loaded into aircraft. Dynamic cinematic aerial shots. Premium corporate aviation advertisement, realistic aircraft operations, global transportation network. Camera Aerial tracking shot Duration 6 seconds Voice-over Air freight solutions connecting Thailand to global markets. Scene 4 — Sea Freight (6 sec) Prompt Massive container ship crossing the ocean at sunset carrying colorful shipping containers. Port cranes operating in the background. Ocean reflections, cinematic shipping logistics commercial, realistic maritime freight operations, global trade concept. Camera Slow cinematic orbit Duration 6 seconds Voice-over Reliable sea freight services for international import and export. Scene 5 — Road Transportation (8 sec) Prompt Modern refrigerated reefer truck and dry cargo truck driving on a scenic Thai highway during golden hour. Beautiful mountains and tropical landscape. Smooth drone tracking shot following the convoy. Premium logistics transport commercial, realistic vehicles, cinematic road transportation. Camera Drone tracking Duration 8 seconds Voice-over Comprehensive transportation solutions across Thailand. Scene 6 — Professional Supervision (10 sec) Prompt Professional logistics operations center. Experienced freight specialists monitoring shipment tracking systems, temperature monitoring dashboards, global logistics maps and transportation data. Modern office environment with blue and gold corporate branding. Professional teamwork and supervision. Premium business commercial, realistic office operations. Camera Slow dolly movement Duration 10 seconds Voice-over Every shipment is carefully supervised by experienced professionals to ensure smooth and secure transportation. Scene 7 — 24/7 Support (8 sec) Prompt Professional customer service representative answering client calls in a modern office at night. City skyline lights visible through large windows. Friendly and confident support team assisting international customers. Premium corporate service advertisement, warm and trustworthy atmosphere. Camera Slow push-in Duration 8 seconds Voice-over Our support team is always ready to assist you — anytime, even outside working hours. Scene 8 — Thailand Network (10 sec) Prompt Glowing digital map of Thailand with animated logistics routes connecting Chiang Mai, Bangkok, and Suvarnabhumi Airport. Global network visualization expanding outward from Thailand to the world. Modern corporate animation style blended with realistic satellite imagery. Premium logistics network commercial. Camera Zoom-out from Thailand to globe Duration 10 seconds Voice-over With branches in Chiang Mai, Bangkok, and Suvarnabhumi, we are ready to connect your business to the world. Scene 9 — Closing (10 sec) Prompt Elegant blue and gold global logistics background. Corporate elephant logo appearing with glowing world network lines. Premium luxury business branding animation. Professional logistics company identity reveal. Sophisticated cinematic ending, global freight forwarding excellence, corporate prestige. Camera Slow logo reveal Duration 10 seconds Voice-over Professional logistics solutions with competitive pricing and long-term commitment. End Screen Text T.M.T Cargo Co., Ltd. Reliable • Competitive • Sustainable Tel: +66 (0)2-690-8060 Email: sales@tmtcargo.com www.tmtcargo.com Negative Prompt (ใส่ทุก Scene) low quality, blurry, cartoon, illustration, CGI look, distorted vehicles, deformed people, extra fingers, duplicate objects, incorrect logos, text artifacts, subtitles, watermark, noisy image, unrealistic lighting, oversaturated colors, low resolution, fake airport equipment, unrealistic trucks, poor anatomy
GRPO DATA EXTRACTION & POPULATION RULES Applicable Document: Generate Goods Receipt PO (GRPO) only. -------------------------------------------------- Rule 1 – GRPO Dates Populate: | SAP Table | Field | Value | | OPDN | DocDate | Clearing Agent/Freight Forwarder Invoice Date | | OPDN | DocDueDate | Clearing Agent/Freight Forwarder Invoice Date | | OPDN | TaxDate | Clearing Agent/Freight Forwarder Invoice Date | Business Rules • Use the invoice date issued by the Clearing Agent, Freight Forwarder or Logistics Company (e.g. P. Kelepeshis, Hellenic Cargo Freight Logistics, Blue Ice or similar). • Use the same date for all three fields. • Do not use Supplier Invoice Date, Bill of Lading Date, Posting Date, Scan Date, Email Date or System Date. • If the date cannot be identified with confidence, flag Manual Review. -------------------------------------------------- Rule 2 – Product Line Validation Compare every Purchase Order (Base Document) line against the Supplier Invoice. Compare: Item Code, Description, Quantity, Unit Price, Line Total. Business Rules • GRPO lines must always be created from the Base Document (Purchase Order). • Supplier Invoice values are for validation only and validation must always be performed. • Never overwrite Purchase Order values with Supplier Invoice values. • Before comparing Quantity, Unit Price or Line Total, convert both documents to the same Unit of Measure using the Purchase Order UoM. • Convert both Quantity and Unit Price before validation. • Standard conversion: 1 MT (TON)=1,000 KG. • Example: 17 MT @ €2,010/MT = 17,000 KG @ €2.01/KG. • Use packaging information (e.g. 68 Drums × 250 KG) to validate converted quantities. • Never compare values with different Units of Measure. • If Quantity, Unit Price or Line Total differs after conversion, display the differences and flag Manual Review. • If the Invoice contains items not on the Purchase Order, flag Manual Review. • If the Purchase Order contains items not on the Invoice, flag Manual Review. • If the UoM or conversion factor cannot be determined, flag Manual Review. -------------------------------------------------- Rule 3 – Batch Number Validation For batch-managed items extract the Batch Number from the CoA, Supplier Invoice, Packing List and other supporting documents. Business Rules • Use the CoA Batch Number as the default SAP Batch Number. • Compare the CoA Batch Number with all other documents. • If any Batch Number differs, still populate the CoA Batch Number but flag Manual Review and display the conflicting document(s). • Ignore spaces, hyphens, slashes and letter case when comparing Batch Numbers. • Compare each item independently. • Support multiple Batch Numbers per item and preserve quantities. • If no CoA exists, use the next highest priority document and flag Manual Review. • If no Batch Number is found, flag Manual Review. -------------------------------------------------- Rule 4 – Manufacturing & Expiry Dates Extract Manufacturing Date and Expiry Date for every batch-managed item from the CoA. Recognize labels: Manufacturing: Date of Manufacture, Manufacturing Date, MFG Date, Production Date, Produced On, Manufactured On. Expiry: Expiry Date, Expiration Date, Exp Date, Best Before, Use Before, Valid Until, Shelf Life Until, Retest Date. Business Rules • If no Expiry Date exists but a Retest Date exists, use the Retest Date as the Expiry Date. • Return all dates in DD/MM/YYYY format. • If only Month and Year are available, use the first day of the month. • Example: May 2026 = 01/05/2026, November 2027 = 01/11/2027. • Compare Manufacturing and Expiry/Retest Dates with all supporting documents. • If dates differ, flag Manual Review. -------------------------------------------------- Rule 5 – Freight Charges Condition When invoice lines contain Freight, Freight Surcharge, Fuel Charge, Fuel Surcharge, Transport Charge, Shipping Charge, Logistics Charge or freight-related Sundries. Action • Remove these lines from the product lines. • Populate SAP Business One Additional Expenses. • SAP Table: PDN3. • Expense Code: FREIGHT. • PDN3.LineTotal (Net Amount)=Total Freight Charges. • Preserve VAT Code. Business Rules • Freight charges are NOT discounts. • Populate ONLY PDN3.LineTotal. • Never populate Document Discount. • Never populate Line Discount. • Never reduce Item Unit Price. • Never reduce Item Line Total. • Never use Freight Charges to balance the invoice. • Product lines must contain inventory goods only. • Combine multiple freight-related charges into one PDN3.LineTotal value. • If a Sundries line cannot be identified as freight-related, flag Manual Review. Validation Invoice Total = Product Total + PDN3.LineTotal ± Taxes. -------------------------------------------------- Rule 6 – Product Cost Surcharges Condition When invoice lines contain Energy Surcharge, Energy Cost Adjustment, Raw Material Surcharge, Alloy Surcharge, Metal Surcharge, Environmental Surcharge, Manufacturing Surcharge or similar product cost surcharges. Action • Do NOT populate PDN3.LineTotal. • Allocate the surcharge to the related product line(s). • Increase the Product Unit Price. Business Rules • These surcharges form part of the acquisition cost. • They must not remain as separate invoice lines. • They must never create Freight Charges. • If the surcharge relates to one product, allocate 100% to that product. • If it relates to multiple products, distribute proportionally based on line value unless another allocation method is specified. • Recalculate the Unit Price after allocation. Formula New Unit Price=(Product Line Value+Allocated Surcharge)/Quantity. Example Qty=10, Unit Price=€100, Energy Surcharge=€20. New Unit Price=(1000+20)/10=€102. • If the affected products cannot be determined, flag Manual Review. -------------------------------------------------- Validation Rules • Never guess or invent values. • Always compare the Purchase Order against the Supplier Invoice before creating the GRPO. • Flag all Quantity, Unit Price and Line Total differences. • Batch Number defaults to the CoA and must match supporting documents. • Manufacturing and Expiry Dates default to the CoA. • Freight, Fuel, Transport, Shipping and Logistics charges populate PDN3.LineTotal only. • Product Cost Surcharges (e.g. Energy Surcharge) must increase the Product Unit Price and must never populate PDN3.LineTotal. • Freight Charges must never populate Document Discount or Line Discount. • If confidence is below 80%, flag Manual Review.
ผมต้องการให้สร้างคลิปสั้นประมาณ 1 นาที 9ซีน, ~60–90 วินาที, 16:9, 1080p ในการบอกตัวตนของบริษัท TMT รูปที่1 คือ Storyboard ว่าในวิดีโอหน้าตาประมาณนี้ บทของเรื่อง: ใช้รูปที่ 2 เป็น Reference [Opening Scene – Airplane taking off / Cargo loading] Text on screen: “Worldwide Freight Solutions” Voice Over: “Looking for a reliable international freight forwarder?” [Scene – Fresh flowers / frozen food / chilled cargo] Text on screen: “Perishable Cargo Specialist” Voice Over: “We specialize in perishable shipments including flowers, chilled products, frozen foods, and temperature-sensitive cargo.” [Scene – Air freight, sea freight, trucks moving] Text on screen: “Air • Sea • Road” Voice Over: “We provide import and export services for general cargo, dangerous goods, and perishable products by air, sea, and road — locally and internationally.” [Scene – Staff monitoring shipment / customer service] Text on screen: “Professional Supervision” Voice Over: “Every shipment is carefully supervised by experienced professionals to ensure smooth and secure transportation.” [Scene – Customer support answering phone late at night] Text on screen: “24/7 Support” Voice Over: “Our support team is always ready to assist you — anytime, even outside working hours.” [Scene – Reefer truck and dry truck on the road] Text on screen: “Thailand Transportation Solutions” Voice Over: “We also provide reefer trucks and dry trucks throughout Thailand.” [Scene – Map showing Chiang Mai, Bangkok, Suvarnabhumi] Text on screen: “Branches Across Thailand” Voice Over: “With branches in Chiang Mai, Bangkok, and Suvarnabhumi, we are ready to connect your business to the world.” [Closing Scene – Company logo with global background] Text on screen: “Reliable • Competitive • Sustainable” Voice Over: “Professional logistics solutions with competitive pricing and long-term commitment.” Final Text: “Contact us today for a quotation.” เสียง: Female, neutral international English, professional and warm — ElevenLabs V3. Music: Calm, luxurious classical underscore. Certifications: Sprinkled in Scene 4, then all together in the closing. Contact Info: Final card with website, Line QR, address, and phone number. Global Style (ใช้กับทุก Scene) Style Prompt Premium corporate logistics commercial, cinematic photography, luxury business advertisement, global freight forwarding company, warm golden hour lighting, realistic people, realistic vehicles, ultra detailed, professional color grading, blue and gold brand identity, shallow depth of field, cinematic camera movement, 4K, HDR, realistic reflections, high-end commercial production, smooth motion, no text, no watermark, no subtitles. Scene 1 — Opening (8 sec) Prompt Massive cargo aircraft with blue and gold airline branding taxiing and taking off during golden hour at an international airport. Ground crew loading cargo pallets and containers beside the aircraft. Warm sunrise light reflecting on the tarmac. Cinematic drone shot slowly rising as the aircraft begins takeoff. Premium logistics commercial style, realistic aviation operations, highly detailed cargo handling, smooth camera movement, luxury corporate advertisement. Camera Drone push forward + slow rise Duration 8 seconds Voice-over Looking for a reliable international freight forwarder? Scene 2 — Perishable Cargo (8 sec) Prompt Close-up cinematic shots of fresh purple orchids, chilled products, frozen premium meat with visible frost, temperature-controlled logistics environment. Cold mist and refrigeration details. Smooth macro camera movement showcasing freshness and careful handling. Premium perishable cargo logistics advertisement, realistic textures, luxurious food export visuals. Camera Macro slider movement Duration 8 seconds Voice-over We specialize in perishable shipments including flowers, chilled products, frozen foods, and temperature-sensitive cargo. Scene 3 — Air Freight (6 sec) Prompt Large cargo aircraft flying above clouds during sunrise. Global air freight logistics concept. Containers being loaded into aircraft. Dynamic cinematic aerial shots. Premium corporate aviation advertisement, realistic aircraft operations, global transportation network. Camera Aerial tracking shot Duration 6 seconds Voice-over Air freight solutions connecting Thailand to global markets. Scene 4 — Sea Freight (6 sec) Prompt Massive container ship crossing the ocean at sunset carrying colorful shipping containers. Port cranes operating in the background. Ocean reflections, cinematic shipping logistics commercial, realistic maritime freight operations, global trade concept. Camera Slow cinematic orbit Duration 6 seconds Voice-over Reliable sea freight services for international import and export. Scene 5 — Road Transportation (8 sec) Prompt Modern refrigerated reefer truck and dry cargo truck driving on a scenic Thai highway during golden hour. Beautiful mountains and tropical landscape. Smooth drone tracking shot following the convoy. Premium logistics transport commercial, realistic vehicles, cinematic road transportation. Camera Drone tracking Duration 8 seconds Voice-over Comprehensive transportation solutions across Thailand. Scene 6 — Professional Supervision (10 sec) Prompt Professional logistics operations center. Experienced freight specialists monitoring shipment tracking systems, temperature monitoring dashboards, global logistics maps and transportation data. Modern office environment with blue and gold corporate branding. Professional teamwork and supervision. Premium business commercial, realistic office operations. Camera Slow dolly movement Duration 10 seconds Voice-over Every shipment is carefully supervised by experienced professionals to ensure smooth and secure transportation. Scene 7 — 24/7 Support (8 sec) Prompt Professional customer service representative answering client calls in a modern office at night. City skyline lights visible through large windows. Friendly and confident support team assisting international customers. Premium corporate service advertisement, warm and trustworthy atmosphere. Camera Slow push-in Duration 8 seconds Voice-over Our support team is always ready to assist you — anytime, even outside working hours. Scene 8 — Thailand Network (10 sec) Prompt Glowing digital map of Thailand with animated logistics routes connecting Chiang Mai, Bangkok, and Suvarnabhumi Airport. Global network visualization expanding outward from Thailand to the world. Modern corporate animation style blended with realistic satellite imagery. Premium logistics network commercial. Camera Zoom-out from Thailand to globe Duration 10 seconds Voice-over With branches in Chiang Mai, Bangkok, and Suvarnabhumi, we are ready to connect your business to the world. Scene 9 — Closing (10 sec) Prompt Elegant blue and gold global logistics background. Corporate elephant logo appearing with glowing world network lines. Premium luxury business branding animation. Professional logistics company identity reveal. Sophisticated cinematic ending, global freight forwarding excellence, corporate prestige. Camera Slow logo reveal Duration 10 seconds Voice-over Professional logistics solutions with competitive pricing and long-term commitment. End Screen Text T.M.T Cargo Co., Ltd. Reliable • Competitive • Sustainable Tel: +66 (0)2-690-8060 Email: sales@tmtcargo.com www.tmtcargo.com Negative Prompt (ใส่ทุก Scene) low quality, blurry, cartoon, illustration, CGI look, distorted vehicles, deformed people, extra fingers, duplicate objects, incorrect logos, text artifacts, subtitles, watermark, noisy image, unrealistic lighting, oversaturated colors, low resolution, fake airport equipment, unrealistic trucks, poor anatomy
GRPO DATA EXTRACTION & POPULATION RULES Applicable Document: Generate Goods Receipt PO (GRPO) only. -------------------------------------------------- Rule 1 – GRPO Dates Populate: | SAP Table | Field | Value | | OPDN | DocDate | Clearing Agent/Freight Forwarder Invoice Date | | OPDN | DocDueDate | Clearing Agent/Freight Forwarder Invoice Date | | OPDN | TaxDate | Clearing Agent/Freight Forwarder Invoice Date | Business Rules • Use the invoice date issued by the Clearing Agent, Freight Forwarder or Logistics Company (e.g. P. Kelepeshis, Hellenic Cargo Freight Logistics, Blue Ice or similar). • Use the same date for all three fields. • Do not use Supplier Invoice Date, Bill of Lading Date, Posting Date, Scan Date, Email Date or System Date. • If the date cannot be identified with confidence, flag Manual Review. -------------------------------------------------- Rule 2 – Product Line Validation Compare every Purchase Order (Base Document) line against the Supplier Invoice. Compare: Item Code, Description, Quantity, Unit Price, Line Total. Business Rules • GRPO lines must always be created from the Base Document (Purchase Order). • Supplier Invoice values are for validation only and validation must always be performed. • Never overwrite Purchase Order values with Supplier Invoice values. • Before comparing Quantity, Unit Price or Line Total, convert both documents to the same Unit of Measure using the Purchase Order UoM. • Convert both Quantity and Unit Price before validation. • Standard conversion: 1 MT (TON)=1,000 KG. • Example: 17 MT @ €2,010/MT = 17,000 KG @ €2.01/KG. • Use packaging information (e.g. 68 Drums × 250 KG) to validate converted quantities. • Never compare values with different Units of Measure. • If Quantity, Unit Price or Line Total differs after conversion, display the differences and flag Manual Review. • If the Invoice contains items not on the Purchase Order, flag Manual Review. • If the Purchase Order contains items not on the Invoice, flag Manual Review. • If the UoM or conversion factor cannot be determined, flag Manual Review. -------------------------------------------------- Rule 3 – Batch Number Validation For batch-managed items extract the Batch Number from the CoA, Supplier Invoice, Packing List and other supporting documents. Business Rules • Use the CoA Batch Number as the default SAP Batch Number. • Compare the CoA Batch Number with all other documents. • If any Batch Number differs, still populate the CoA Batch Number but flag Manual Review and display the conflicting document(s). • Ignore spaces, hyphens, slashes and letter case when comparing Batch Numbers. • Compare each item independently. • Support multiple Batch Numbers per item and preserve quantities. • If no CoA exists, use the next highest priority document and flag Manual Review. • If no Batch Number is found, flag Manual Review. -------------------------------------------------- Rule 4 – Manufacturing & Expiry Dates Extract Manufacturing Date and Expiry Date for every batch-managed item from the CoA. Recognize labels: Manufacturing: Date of Manufacture, Manufacturing Date, MFG Date, Production Date, Produced On, Manufactured On. Expiry: Expiry Date, Expiration Date, Exp Date, Best Before, Use Before, Valid Until, Shelf Life Until, Retest Date. Business Rules • If no Expiry Date exists but a Retest Date exists, use the Retest Date as the Expiry Date. • Return all dates in DD/MM/YYYY format. • If only Month and Year are available, use the first day of the month. • Example: May 2026 = 01/05/2026, November 2027 = 01/11/2027. • Compare Manufacturing and Expiry/Retest Dates with all supporting documents. • If dates differ, flag Manual Review. -------------------------------------------------- Rule 5 – Freight Charges Condition When invoice lines contain Freight, Freight Surcharge, Fuel Charge, Fuel Surcharge, Transport Charge, Shipping Charge, Logistics Charge or freight-related Sundries. Action • Remove these lines from the product lines. • Populate SAP Business One Additional Expenses. • SAP Table: PDN3. • Expense Code: FREIGHT. • PDN3.LineTotal (Net Amount)=Total Freight Charges. • Preserve VAT Code. Business Rules • Freight charges are NOT discounts. • Populate ONLY PDN3.LineTotal. • Never populate Document Discount. • Never populate Line Discount. • Never reduce Item Unit Price. • Never reduce Item Line Total. • Never use Freight Charges to balance the invoice. • Product lines must contain inventory goods only. • Combine multiple freight-related charges into one PDN3.LineTotal value. • If a Sundries line cannot be identified as freight-related, flag Manual Review. Validation Invoice Total = Product Total + PDN3.LineTotal ± Taxes. -------------------------------------------------- Rule 6 – Product Cost Surcharges Condition When invoice lines contain Energy Surcharge, Energy Cost Adjustment, Raw Material Surcharge, Alloy Surcharge, Metal Surcharge, Environmental Surcharge, Manufacturing Surcharge or similar product cost surcharges. Action • Do NOT populate PDN3.LineTotal. • Allocate the surcharge to the related product line(s). • Increase the Product Unit Price. Business Rules • These surcharges form part of the acquisition cost. • They must not remain as separate invoice lines. • They must never create Freight Charges. • If the surcharge relates to one product, allocate 100% to that product. • If it relates to multiple products, distribute proportionally based on line value unless another allocation method is specified. • Recalculate the Unit Price after allocation. Formula New Unit Price=(Product Line Value+Allocated Surcharge)/Quantity. Example Qty=10, Unit Price=€100, Energy Surcharge=€20. New Unit Price=(1000+20)/10=€102. • If the affected products cannot be determined, flag Manual Review. -------------------------------------------------- Validation Rules • Never guess or invent values. • Always compare the Purchase Order against the Supplier Invoice before creating the GRPO. • Flag all Quantity, Unit Price and Line Total differences. • Batch Number defaults to the CoA and must match supporting documents. • Manufacturing and Expiry Dates default to the CoA. • Freight, Fuel, Transport, Shipping and Logistics charges populate PDN3.LineTotal only. • Product Cost Surcharges (e.g. Energy Surcharge) must increase the Product Unit Price and must never populate PDN3.LineTotal. • Freight Charges must never populate Document Discount or Line Discount. • If confidence is below 80%, flag Manual Review.
ผมต้องการให้สร้างคลิปสั้นประมาณ 1 นาที 9ซีน, ~60–90 วินาที, 16:9, 1080p ในการบอกตัวตนของบริษัท TMT รูปที่1 คือ Storyboard ว่าในวิดีโอหน้าตาประมาณนี้ บทของเรื่อง: ใช้รูปที่ 2 เป็น Reference [Opening Scene – Airplane taking off / Cargo loading] Text on screen: “Worldwide Freight Solutions” Voice Over: “Looking for a reliable international freight forwarder?” [Scene – Fresh flowers / frozen food / chilled cargo] Text on screen: “Perishable Cargo Specialist” Voice Over: “We specialize in perishable shipments including flowers, chilled products, frozen foods, and temperature-sensitive cargo.” [Scene – Air freight, sea freight, trucks moving] Text on screen: “Air • Sea • Road” Voice Over: “We provide import and export services for general cargo, dangerous goods, and perishable products by air, sea, and road — locally and internationally.” [Scene – Staff monitoring shipment / customer service] Text on screen: “Professional Supervision” Voice Over: “Every shipment is carefully supervised by experienced professionals to ensure smooth and secure transportation.” [Scene – Customer support answering phone late at night] Text on screen: “24/7 Support” Voice Over: “Our support team is always ready to assist you — anytime, even outside working hours.” [Scene – Reefer truck and dry truck on the road] Text on screen: “Thailand Transportation Solutions” Voice Over: “We also provide reefer trucks and dry trucks throughout Thailand.” [Scene – Map showing Chiang Mai, Bangkok, Suvarnabhumi] Text on screen: “Branches Across Thailand” Voice Over: “With branches in Chiang Mai, Bangkok, and Suvarnabhumi, we are ready to connect your business to the world.” [Closing Scene – Company logo with global background] Text on screen: “Reliable • Competitive • Sustainable” Voice Over: “Professional logistics solutions with competitive pricing and long-term commitment.” Final Text: “Contact us today for a quotation.” เสียง: Female, neutral international English, professional and warm — ElevenLabs V3. Music: Calm, luxurious classical underscore. Certifications: Sprinkled in Scene 4, then all together in the closing. Contact Info: Final card with website, Line QR, address, and phone number. Global Style (ใช้กับทุก Scene) Style Prompt Premium corporate logistics commercial, cinematic photography, luxury business advertisement, global freight forwarding company, warm golden hour lighting, realistic people, realistic vehicles, ultra detailed, professional color grading, blue and gold brand identity, shallow depth of field, cinematic camera movement, 4K, HDR, realistic reflections, high-end commercial production, smooth motion, no text, no watermark, no subtitles. Scene 1 — Opening (8 sec) Prompt Massive cargo aircraft with blue and gold airline branding taxiing and taking off during golden hour at an international airport. Ground crew loading cargo pallets and containers beside the aircraft. Warm sunrise light reflecting on the tarmac. Cinematic drone shot slowly rising as the aircraft begins takeoff. Premium logistics commercial style, realistic aviation operations, highly detailed cargo handling, smooth camera movement, luxury corporate advertisement. Camera Drone push forward + slow rise Duration 8 seconds Voice-over Looking for a reliable international freight forwarder? Scene 2 — Perishable Cargo (8 sec) Prompt Close-up cinematic shots of fresh purple orchids, chilled products, frozen premium meat with visible frost, temperature-controlled logistics environment. Cold mist and refrigeration details. Smooth macro camera movement showcasing freshness and careful handling. Premium perishable cargo logistics advertisement, realistic textures, luxurious food export visuals. Camera Macro slider movement Duration 8 seconds Voice-over We specialize in perishable shipments including flowers, chilled products, frozen foods, and temperature-sensitive cargo. Scene 3 — Air Freight (6 sec) Prompt Large cargo aircraft flying above clouds during sunrise. Global air freight logistics concept. Containers being loaded into aircraft. Dynamic cinematic aerial shots. Premium corporate aviation advertisement, realistic aircraft operations, global transportation network. Camera Aerial tracking shot Duration 6 seconds Voice-over Air freight solutions connecting Thailand to global markets. Scene 4 — Sea Freight (6 sec) Prompt Massive container ship crossing the ocean at sunset carrying colorful shipping containers. Port cranes operating in the background. Ocean reflections, cinematic shipping logistics commercial, realistic maritime freight operations, global trade concept. Camera Slow cinematic orbit Duration 6 seconds Voice-over Reliable sea freight services for international import and export. Scene 5 — Road Transportation (8 sec) Prompt Modern refrigerated reefer truck and dry cargo truck driving on a scenic Thai highway during golden hour. Beautiful mountains and tropical landscape. Smooth drone tracking shot following the convoy. Premium logistics transport commercial, realistic vehicles, cinematic road transportation. Camera Drone tracking Duration 8 seconds Voice-over Comprehensive transportation solutions across Thailand. Scene 6 — Professional Supervision (10 sec) Prompt Professional logistics operations center. Experienced freight specialists monitoring shipment tracking systems, temperature monitoring dashboards, global logistics maps and transportation data. Modern office environment with blue and gold corporate branding. Professional teamwork and supervision. Premium business commercial, realistic office operations. Camera Slow dolly movement Duration 10 seconds Voice-over Every shipment is carefully supervised by experienced professionals to ensure smooth and secure transportation. Scene 7 — 24/7 Support (8 sec) Prompt Professional customer service representative answering client calls in a modern office at night. City skyline lights visible through large windows. Friendly and confident support team assisting international customers. Premium corporate service advertisement, warm and trustworthy atmosphere. Camera Slow push-in Duration 8 seconds Voice-over Our support team is always ready to assist you — anytime, even outside working hours. Scene 8 — Thailand Network (10 sec) Prompt Glowing digital map of Thailand with animated logistics routes connecting Chiang Mai, Bangkok, and Suvarnabhumi Airport. Global network visualization expanding outward from Thailand to the world. Modern corporate animation style blended with realistic satellite imagery. Premium logistics network commercial. Camera Zoom-out from Thailand to globe Duration 10 seconds Voice-over With branches in Chiang Mai, Bangkok, and Suvarnabhumi, we are ready to connect your business to the world. Scene 9 — Closing (10 sec) Prompt Elegant blue and gold global logistics background. Corporate elephant logo appearing with glowing world network lines. Premium luxury business branding animation. Professional logistics company identity reveal. Sophisticated cinematic ending, global freight forwarding excellence, corporate prestige. Camera Slow logo reveal Duration 10 seconds Voice-over Professional logistics solutions with competitive pricing and long-term commitment. End Screen Text T.M.T Cargo Co., Ltd. Reliable • Competitive • Sustainable Tel: +66 (0)2-690-8060 Email: sales@tmtcargo.com www.tmtcargo.com Negative Prompt (ใส่ทุก Scene) low quality, blurry, cartoon, illustration, CGI look, distorted vehicles, deformed people, extra fingers, duplicate objects, incorrect logos, text artifacts, subtitles, watermark, noisy image, unrealistic lighting, oversaturated colors, low resolution, fake airport equipment, unrealistic trucks, poor anatomy
GRPO DATA EXTRACTION & POPULATION RULES Applicable Document: Generate Goods Receipt PO (GRPO) only. -------------------------------------------------- Rule 1 – GRPO Dates Populate: | SAP Table | Field | Value | | OPDN | DocDate | Clearing Agent/Freight Forwarder Invoice Date | | OPDN | DocDueDate | Clearing Agent/Freight Forwarder Invoice Date | | OPDN | TaxDate | Clearing Agent/Freight Forwarder Invoice Date | Business Rules • Use the invoice date issued by the Clearing Agent, Freight Forwarder or Logistics Company (e.g. P. Kelepeshis, Hellenic Cargo Freight Logistics, Blue Ice or similar). • Use the same date for all three fields. • Do not use Supplier Invoice Date, Bill of Lading Date, Posting Date, Scan Date, Email Date or System Date. • If the date cannot be identified with confidence, flag Manual Review. -------------------------------------------------- Rule 2 – Product Line Validation Compare every Purchase Order (Base Document) line against the Supplier Invoice. Compare: Item Code, Description, Quantity, Unit Price, Line Total. Business Rules • GRPO lines must always be created from the Base Document (Purchase Order). • Supplier Invoice values are for validation only and validation must always be performed. • Never overwrite Purchase Order values with Supplier Invoice values. • Before comparing Quantity, Unit Price or Line Total, convert both documents to the same Unit of Measure using the Purchase Order UoM. • Convert both Quantity and Unit Price before validation. • Standard conversion: 1 MT (TON)=1,000 KG. • Example: 17 MT @ €2,010/MT = 17,000 KG @ €2.01/KG. • Use packaging information (e.g. 68 Drums × 250 KG) to validate converted quantities. • Never compare values with different Units of Measure. • If Quantity, Unit Price or Line Total differs after conversion, display the differences and flag Manual Review. • If the Invoice contains items not on the Purchase Order, flag Manual Review. • If the Purchase Order contains items not on the Invoice, flag Manual Review. • If the UoM or conversion factor cannot be determined, flag Manual Review. -------------------------------------------------- Rule 3 – Batch Number Validation For batch-managed items extract the Batch Number from the CoA, Supplier Invoice, Packing List and other supporting documents. Business Rules • Use the CoA Batch Number as the default SAP Batch Number. • Compare the CoA Batch Number with all other documents. • If any Batch Number differs, still populate the CoA Batch Number but flag Manual Review and display the conflicting document(s). • Ignore spaces, hyphens, slashes and letter case when comparing Batch Numbers. • Compare each item independently. • Support multiple Batch Numbers per item and preserve quantities. • If no CoA exists, use the next highest priority document and flag Manual Review. • If no Batch Number is found, flag Manual Review. -------------------------------------------------- Rule 4 – Manufacturing & Expiry Dates Extract Manufacturing Date and Expiry Date for every batch-managed item from the CoA. Recognize labels: Manufacturing: Date of Manufacture, Manufacturing Date, MFG Date, Production Date, Produced On, Manufactured On. Expiry: Expiry Date, Expiration Date, Exp Date, Best Before, Use Before, Valid Until, Shelf Life Until, Retest Date. Business Rules • If no Expiry Date exists but a Retest Date exists, use the Retest Date as the Expiry Date. • Return all dates in DD/MM/YYYY format. • If only Month and Year are available, use the first day of the month. • Example: May 2026 = 01/05/2026, November 2027 = 01/11/2027. • Compare Manufacturing and Expiry/Retest Dates with all supporting documents. • If dates differ, flag Manual Review. -------------------------------------------------- Rule 5 – Freight Charges Condition When invoice lines contain Freight, Freight Surcharge, Fuel Charge, Fuel Surcharge, Transport Charge, Shipping Charge, Logistics Charge or freight-related Sundries. Action • Remove these lines from the product lines. • Populate SAP Business One Additional Expenses. • SAP Table: PDN3. • Expense Code: FREIGHT. • PDN3.LineTotal (Net Amount)=Total Freight Charges. • Preserve VAT Code. Business Rules • Freight charges are NOT discounts. • Populate ONLY PDN3.LineTotal. • Never populate Document Discount. • Never populate Line Discount. • Never reduce Item Unit Price. • Never reduce Item Line Total. • Never use Freight Charges to balance the invoice. • Product lines must contain inventory goods only. • Combine multiple freight-related charges into one PDN3.LineTotal value. • If a Sundries line cannot be identified as freight-related, flag Manual Review. Validation Invoice Total = Product Total + PDN3.LineTotal ± Taxes. -------------------------------------------------- Rule 6 – Product Cost Surcharges Condition When invoice lines contain Energy Surcharge, Energy Cost Adjustment, Raw Material Surcharge, Alloy Surcharge, Metal Surcharge, Environmental Surcharge, Manufacturing Surcharge or similar product cost surcharges. Action • Do NOT populate PDN3.LineTotal. • Allocate the surcharge to the related product line(s). • Increase the Product Unit Price. Business Rules • These surcharges form part of the acquisition cost. • They must not remain as separate invoice lines. • They must never create Freight Charges. • If the surcharge relates to one product, allocate 100% to that product. • If it relates to multiple products, distribute proportionally based on line value unless another allocation method is specified. • Recalculate the Unit Price after allocation. Formula New Unit Price=(Product Line Value+Allocated Surcharge)/Quantity. Example Qty=10, Unit Price=€100, Energy Surcharge=€20. New Unit Price=(1000+20)/10=€102. • If the affected products cannot be determined, flag Manual Review. -------------------------------------------------- Validation Rules • Never guess or invent values. • Always compare the Purchase Order against the Supplier Invoice before creating the GRPO. • Flag all Quantity, Unit Price and Line Total differences. • Batch Number defaults to the CoA and must match supporting documents. • Manufacturing and Expiry Dates default to the CoA. • Freight, Fuel, Transport, Shipping and Logistics charges populate PDN3.LineTotal only. • Product Cost Surcharges (e.g. Energy Surcharge) must increase the Product Unit Price and must never populate PDN3.LineTotal. • Freight Charges must never populate Document Discount or Line Discount. • If confidence is below 80%, flag Manual Review.