Easy On Boarding Logistics Accounting Objectives Understand the

Easy On Boarding Logistics Accounting

Objectives • Understand the benefits of Logistics Accounting • Learn to set up and use the Logistics Accounting functionality in QAD Enterprise Applications AF-LA-020

Overview • Introduction to Logistics Accounting - Definitions - Process overview - Benefits • Setup - General setup - Setup for inbound logistics accounting - Setup for outbound logistics accounting • Logistics charges accrual process - Inbound - Outbound • Logistics charges processing • Reporting AF-LA-030

Definitions • Logistics Accounting Define and track logistics charges for any inbound and outbound transportation costs payable to third-party suppliers • Logistics charges Individual costs payable to third-party suppliers for the transportation of goods AF-LA-040

Inbound versus Outbound Logistics sales orders shipments Supplier nd ou tb ou in bo un d purchase order receipts Company Customer AF-LA-050

Logistics Charge Accruals Process AF-LA-060

Logistics Charge Accruals Process Highlights • Pending invoices = logistics charge accruals • Automatic pending invoice creation - during PO receipts, SO and DO shipments • Match during receiver matching • Internal vs external references • Additional fields and frames AF-LA-070

Benefits • Improved efficiency - Complete tracking, monitoring, accruing and invoicing of all costs associated with freight and duty • Improved margin visibility - Include all transportation-related expenses in standard cost of product • Improved planning and budgeting - Provide planned vs actual performance analysis of logistics providers • Improved control - Match accrued logistics charges against supplier invoices • Two types of logistic charges - Inbound, outbound AF-LA-080

General Setup AF-LA-090

EOB Logistics Accounting Set Up Flow 2009 -AF-LA-

Setting Up GL Accounts AF-LA-100

Setting Up NRM Sequence Numbers • Number Range Maintenance (36. 2. 21. 1) • For sales order shipments and distribution order shipments AF-LA-110

Setting Up the Control Programs • Logistics Accounting Control - Activation - Assign NRM sequence codes AF-LA-120

Setting Up the Control Programs • Logistics Operational Accounting Control - Pending invoices and third-party logistics supplier • Receiver matching - GL accrual, expense and variance • Default AF-LA-130

Defining Logistics Charge Codes • Logistics Charge Code Maintenance AF-LA-140

Defining Detailed Logistics Accounts • Inbound Account Maintenance (2. 15. 13) • Outbound Accrual Account Maint (2. 15. 16) • Outbound Expense Account Maint (2. 15. 19) AF-LA-150

Setting Up Inbound Logistics Accounting Define Cost Elements Update logistics charge Define terms of trade Assign terms of trade to item supplier Update item cost with logistics charges AF-LA-160

Creating Cost Elements • Cost Element Maintenance AF-LA-170

Updating Logistics Charge Code • Logistics Charge Code Maintenance AF-LA-180

Updating Item Costs • Four menu options - Item-Element Cost Maintenance Item-Site Cost Maintenance Item Master Maintenance AF-LA-190

Defining Terms of Trade • Terms of Trade Maintenance AF-LA-200

Assigning Terms of Trade to Suppliers • Supplier Data Maintenance AF-LA-210

Setting Up Outbound Logistics Accounting Update freight terms Set up default customer freight data Define item ship weights Define trailer codes Optional AF-LA-220

Updating Freight Terms • Freight Term Maintenance AF-LA-230

Setting Up Default Customer Freight Data AF-LA-240

Set Up Freight Lists AF-LA-245

Defining Item Ship Weight AF-LA-250

Setting Up Trailer Codes Select to use freight list trailer default instead AF-LA-260

Inbound Logistics Charges Accrual Purchase Order Or PO Shipper PO Receipt Or PO Shipper Receipt Logistics Charge Pending Invoice AF-LA-270

Inbound Logistics Charges Accrual • Purchase Order Maintenance AF-LA-280

Inbound Logistics Charges Accrual • PO Shipper Maintenance AF-LA-290

Inbound Logistics Charges Accrual • PO / PO shipper receipts Pending invoice external reference Pending invoice internal reference AF-LA-300

Inbound Logistics Charges Accrual • GL effect Inventory Acct DR 1, 000 CR Inbound Accrual Acct DR CR 1, 000 AF-LA-310

Outbound Logistics Charges Accrual Sales Order Shipment Logistics Charge Pending Invoice AF-LA-320

Outbound Logistics Charges Accrual • Sales Order Maintenance AF-LA-330

Outbound Logistics Charges Accrual • Sales Order Maintenance Logistics accounting details Pending invoice external reference AF-LA-340

Outbound Logistics Charges Accrual • Sales Order Shipments Internal reference AF-LA-350

Outbound Logistics Charges Accrual • SO shippers Internal reference External reference AF-LA-360

Outbound Logistics Charges Accrual • GL effect SO Expense Acct DR 1, 000 CR Sales Order Accrual Acct DR CR 1, 000 AF-LA-370

Processing Logistics Charges Pending Invoice Maintenance Logistics Supplier Invoice Receiver Matching Optional AF-LA-380

Processing Logistics Charges • Logistics Charge Pending Invoice AF-LA-390

Processing Logistics Charges • Logistics supplier invoice PO number is blank Invoice status code enabled for receiver matching AF-LA-400

Processing Logistics Charges • Receiver Matching - Logistics tab Separate frame for Logistics Accounting pending invoices AF-LA-410

Processing Logistics Charges • GL effect (inbound) Inbound Accrual Acct DR CR Accounts Payable DR 1, 000 CR 1, 000 • GL effect (outbound) SO Accrual Acct DR 1, 000 CR Accounts Payable DR CR 1, 000 AF-LA-420

Logistics Accounting Reporting Matching Logistic Charge Variance Report Logistics Charge Variance Report Open Logistics Charge Report AF-LA-430

Logistics Accounting Reporting AF-LA-440

Easy On-Boarding Questions?