ADL

Entity AccountNum VendGroup Name Note

E1 10883 Import/PO Zhejiang Wangbin Decorative daily
E1 11384 Import/PO Chengpinyuan Articles Manufactory daily
E1 11188 Import/PO Dongguan City Caidu Industrial Co. daily
E1 11280 Mexico/PO Xpedx Sa De CV daily
E1 11346 Mexico/PO Triplay Y Laminados TJ S.A. de C.V. daily
E1 10545 Mexico/PO Packsize LLC daily
E1 11273 Non-PO Enterprise Logistics Solutions, Inc daily
E1 11545 Non-PO FedEx daily
E1 11637 Non-PO CDW Direct daily
E1 10160 Non-PO Fineline Technologies, Inc. daily
E1 11175 Non-PO C.H. Robinson Company, Inc. daily
E1 11103 Non-PO North American Production Sharing 2 invoices per week

ADC
Entity AccountNum VendGroup Name Note
E2 11512 Import/PO Zhejiang Wangbin Decorative (USD) daily
E2 11618 Import/PO Zhejiang Wangbin Decorative daily
E2 11647 Import/PO Chengpinyuan Articles Manufactory daily
E2 10610 Non-PO Omnitrans Inc. daily
E2 11379 Non-PO Metro Logistique/Logistics Inc. daily
E2 11552 Non-PO Cargo Cargo - ADC Inc (E2) daily
E2 10534 Non-PO Remco Forwarding Ltd. daily
E2 10216 Non-PO Inter Action Courrier Int'L Inc daily
E2 11403 Non-PO Staples Avantage/Bou daily
E2 11482 Non-PO Metro Canada Logistique daily
Area/Scenario Task (Tasks must be done in ADL and ADC as applicable)
Production Create representative BOMs and ADL
Cost Accounting Create and activate standard costs for items
Cost Accounting Update indirect costs in a costing sheet
Cost Accounting Perform a standard cost calculation and confirm component, indirect and FG costs
Production Create a production order
Production Pick a production order
Production Report a production as finished
Production End a production order
Cost Accounting Review overheads, indirect costs, variances are recorded in appropriate GL accounts
Cost Accounting Process inventory adjustment journals for items not in BOM
Cost Accounting Create and process a counting journal
Number/Count Department Responsible Due Date Status
3 Daily
3 Cost Accounting Daily
3 Weekly ?
3 Daily
3 Production Daily
3 Production Daily
3 Production Daily
3 Production Daily
3 Production Daily
3 Production Daily
3 Production Daily
Area/Scenario
Sales Order Processing
Sales Order Processing
Sales Order Processing
Sales Order Processing
Sales Order Processing
Sales Order Processing
Accounts Receivable
Accounts Receivable
Accounts Receivable
Accounts Receivable
Accounts Receivable
Accounts Receivable
Accounts Receivable
Accounts Receivable
Accounts Receivable
Accounts Receivable
Task (Tasks must be done in ADL and ADC as applicable)
Create sales orders for external customers via EDI
Create manual sales orders
Create sales order for intercompany customer (ADC)
Confirm tax amounts and tax groups default on sales order line
Ship sales orders (after purchase, production or from inventory)
Create sales invoices
Run AR aging, review customer account to confirm balances
Apply customer payments
Create customer chargebacks
Review and investigate chargeback
Create a credit note to resolve charge back
Resolve chargeback with customer repayment
Run AR aging, chargeback report, [add other reports list here] to confirm balances
Confirm other financial accounts are updated as desired - inventory, revenue, cost of goods sold etc.
Create a customer statement
Add notes to a customer invoice, account etc.
Number/Count Department Responsible Due Date Status
6 IT Daily
6 Customer Service Daily
6 Customer Service Daily
6 Customer Service Daily
6 Customer Service Daily
6 Customer Service Daily
6 Accounts Receivable Daily
3 Accounts Receivable Daily
3 Accounts Receivable Daily
3 Accounts Receivable Daily
3 Accounts Receivable Daily
3 Accounts Receivable Daily
3 Accounts Receivable Daily
3 General Ledger Daily
3 Accounts Receivable Daily
3 Accounts Receivable Daily
Area/Scenario Task (Tasks must be done in ADL and ADC as applicable)
Import PO Purchasing to pick 3 real PO of the day and enter in AX
Import PO Purchasing team to receive the purchase orders
Import PO Transactions to be verified - inventory, accruals
Import PO Invoices to be entered/created for the purchase orders
Import PO Run AP aging, review vendor account to confirm balances were updated
Import PO Confirm other financial accounts as desired - inventory, accrual is relieved etc.
Import PO Create and apply vendor payments - Check and non check payment types (ACH, Wire etc
Import PO Confirm aging, vendor accounts, bank accounts are updated after cash application
Import PO Create a credit memo
Number/Count Department Responsible Due Date Status
3 Purchasing Daily
3 Purchasing Daily
3 General Ledger Scott Daily
3 Accounts Payable Daily
3 Accounts Payable Christine Daily
3 General Ledger Daily
3 Accounts Payable Christine Daily
3 Accounts Payable Christine Daily
3 Accounts Payable Christine Daily
Area/Scenario Task (Tasks must be done in ADL and ADC as applicable)
Domestic PO Purchasing to pick 3 real PO of the day and enter in AX
Domestic PO Purchasing team to receive the purchase orders
Domestic PO Create a purchase order from ADL - (ADC buying items from ADL)
Domestic PO Receive purchase order for items purchased from ADL
Domestic PO Transactions to be verified - inventory, accruals etc.
Domestic PO Invoices to be entered/created for the purchase orders
Domestic PO Run AP aging, review vendor account to confirm balances were updated
Domestic PO Confirm other financial accounts as desired - inventory, accrual is relieved etc.
Domestic PO Create and apply vendor payments - Check and non check payment types (ACH, Wire etc
Domestic PO Confirm aging, vendor accounts, bank accounts are updated after cash application
Number/Count Department Responsible Due Date Status
3 Purchasing Daily
3 Purchasing Daily
3 Daily
3 Daily
3 General Ledger Daily
3 Accounts Payable Daily
3 Accounts Payable Christine Daily
3 General Ledger Daily
3 Accounts Payable Christine Daily
3 Accounts Payable Christine Daily
Area/Scenario
Expensed/Non Inventory Purchases
Expensed/Non Inventory Purchases
Expensed/Non Inventory Purchases
Expensed/Non Inventory Purchases
Expensed/Non Inventory Purchases
Expensed/Non Inventory Purchases
Expensed/Non Inventory Purchases
Expensed/Non Inventory Purchases
Expensed/Non Inventory Purchases
Expensed/Non Inventory Purchases
Expensed/Non Inventory Purchases
Expensed/Non Inventory Purchases
Expensed/Non Inventory Purchases
Expensed/Non Inventory Purchases
Expensed/Non Inventory Purchases
Task (Tasks must be done in ADL and ADC as applicable) Number/Count
Create 3 PO's using procurement categories for Mexico 3
Create purchase orders for fixed assets 3
Receive PO's with procurement categories 3
Create AP invoices for PO's above 3
Create AP invoices for rent, etc. 3
Run AP aging, review vendor account to confirm balances 3
Confirm other financial accounts as desired - inventory, accrual is relieved etc. 3
Create and apply vendor payments - Check and non check payment types (ACH, Wire etc)3
Confirm aging, vendor accounts, bank accounts are updated 3
Enter and book Mexico (NAPS?) invoices 3
Setup royalty agreements 3
Perform royalty calculation 3
Accrue royalties 3
Create royalty invoices per new AX process 3
Import invoices using Atlas journal upload 3
Department Responsible Due Date Status
Mexico Daily
Mexico
Mexico Daily
Accounts Payable Christine Daily
Accounts Payable Christine Daily
Accounts Payable Christine Daily
General Ledger Daily
Accounts Payable Christine Daily
Accounts Payable Christine Daily
Accounts Payable Daily
Royalty Aaron /Brad Daily
Royalty Aaron /Brad Daily
?? Daily
Accounts Payable Christine Daily
Accounts Payable Daily
Area/Scenario Task (Tasks must be done in ADL and ADC as applicable)
Cash and Banking Interbank transfer
Cash and Banking Reverse a check payment - wrong bank, double payment etc.
Cash and Banking Perform bank reconciliation - month end
Number/Count Department Responsible Due Date Status
3 Treasury/Cash Daily
3 Treasury/Cash Daily
3 Treasury/Cash Daily
Area/Scenario
General Ledger
General Ledger
General Ledger
General Ledger
General Ledger
General Ledger
General Ledger
General Ledger
General Ledger
General Ledger
Task (Tasks must be done in ADL and ADC as applicable)
Verify all AR, AP transactions in Trial Balance G/L accounts
Enter 5 journal entries, include payroll JE, accrue expenses JE (with auto-reverse in future period), prepaid JE, fixed asset additi
Maintain fixed asset module and to vallidate changes in G/L
Test royalty and validate G/L data changes (to be tested next week with Yens)
Create Income Statement report/template for analysis purposes
Create balance sheet report/template for reporting purposes
Practice running G/L analysis and download sub-schedules for research purposes
Currency revaluation - AP/AR open balances
Create month end closing check list
Create journals using Atlas journal upload
Number/Count Department Responsible Due Date Status
5 General Ledger Scott Lai Daily
5 General Ledger Daily
5 General Ledger Daily
5 General Ledger Daily
1 General Ledger Once
1 General Ledger
5 General Ledger Daily
5 General Ledger Daily
1 General Ledger Once
1 General Ledger Daily
Objective:
The goal of this exercise is to simulate Artissimo's daily operations in the AX environment. To do so, we

Areas of focus:
1 AP
2 AR
3 Inventory
4 G/L and F/S

Phase I Regular Sample Transactions

1 AP
Load 10 invoices daily, 6 PO (3 import/3domestic) and 4 non-PO
*

2 AR
Load 10 invoices daily
1

2
3
4
5

*
 3 Inventory

4 G/L & F/S

1
2
3
4
5
6

Phase II Special Situations - need members' brainstorming

AP

AR

G/L & F/S

Phase III Questions and Answers

of this exercise is to simulate Artissimo's daily operations in the AX environment. To do so, we need to input representing sample data bas

G/L and F/S

Regular Sample Transactions

Load 10 invoices daily, 6 PO (3 import/3domestic) and 4 non-PO

Import PO
1
2
3
4
5
6

Domestic PO
1
2
3
4

Non-PO
1
2
3

Load 10 invoices daily

Customer Service to create Sales Orders in AX for non EDI
EDI sales orders to be processed daily
Billing to complete EDI
Billing to verify data in AX
AR to run AR Aging report to see if the balances were updated
AR to create collection and apply cash
Create customer
Put and remove credit hold on customer
Out of the 10 invoices, practice chargeback on every invoice (every invoice being "short-paid")
Create free text invoice - for credit note
Create customer statement
 Run customer aging and other reports - chargeback, cash receipts etc.

(process pending due to incompleted implementation)

Verify all AR, AP transactions in Trial Balance G/L accounts

Enter 5 journal entries, include payroll JE, accrue expenses JE (with auto-reverse in future period), prepaid JE, fixed asset additi
Maintain fixed asset module and to vallidate changes in G/L
Test royalty and validate G/L data changes (to be tested next week with Yens)
Create Income Statement and Balance Sheet template for analysis purposes
Practice running G/L analysis and download sub-schedules for research purposes
Currency revaluation - AP/AR open balances

Special Situations - need members' brainstorming

Come up with 5 typical mistakes and practice corrections

Come up with 5 typical mistakes and practice corrections

Sales from ADL to ADC and vice versa - sell, ship, invoice, confirm pricing and accounting
Come up with 5 typical mistakes and practice corrections

Questions and Answers

ent. To do so, we need to input representing sample data base to simulate as much as possible.

Import department to pick 3 real PO of the day and enter in AX

Import department will receive
This will create Goods-in-Transit situations
Import department to verify the GIT transactions in AX
AP to run AP Aging report to see if the balances were updated
AP to pay and apply cash

Purchasing department to pick 3 real PO of the day and enter in AX

Purchase department will receive
Purchase department to verify the transactions in AX
AP to pay and apply cash

AP to enter invoices
AP to observe "workflow" for approval
AP to pay and apply cash

Rommel
Jason/Rommel

ry invoice being "short-paid")

th auto-reverse in future period), prepaid JE, fixed asset addition/disposal and depreciation, royalty

ek with Yens)

search purposes

pricing and accounting