Use the following table to see where unit codes come from when performing certain activities. For example, in the table you see that when performing an RMA Return Transaction with No End User Type, the Credit Cost Of Goods Sold unit codes come from Product Code Distribution Accounts.
Activity |
Account |
Where unit codes come from |
Customer Payments |
DR Cash |
Bank Rec of Bank Code |
|
CR Accounts Receivable |
Unit Code designated on artran record for type "Invoice" |
|
CR |
Unit Code designated on A/R Payment Distributions form for type "Open Credit", "Finance Charge" and "Non-A/R". The Unit Code defaults from Accounts Receivable Parameters form, but can be overwritten at A/R Payment Distribution level. |
Customer Shipment - No End User Type |
CR Inv. |
Item Stockroom Locations |
|
DR COGS |
Product Code Distribution Accounts |
Customer Shipment - With End User Type |
CR Inv. |
Item Stockroom Locations |
DR COGS |
End User Type, then Product Codes (Unit Code 2 only) |
|
Cycle Count and Physical Inventory |
DR or CR Inv. |
Item Stockroom Locations |
|
DR or CR Inv. Adj. |
Product Codes Misc, tab then Product Codes General Tab (Unit Code 2 only) |
Invoicing (with End User Type) |
DR Accounts Payable |
Unit Code 1,3,4 from End User Type, Unit Code 2 from Product Code General |
|
CR Sales |
Unit Code 1,3,4 from End User Types form, and Unit Code 2 from General tab on Product Codes form |
Invoicing (without End User Type) |
DR Accounts Receivable |
Unit Code from Accounts Receivable Parameters form, and Unit Code 2 from Product Codes form |
|
CR Sales |
Unit Code from Product Code Distribution Account, then General tab on Product Codes form |
JIT Transactions |
DR Inv. |
Item Stockroom Locations |
|
CR WIP |
Work Center WIP Accts, then Product Codes (Unit Code 2 only) |
Job Close |
DR or CR WIP |
Job Orders |
|
DR or CR Inv. Adj. Or Routing Variance |
Product Codes Variance tab for Standard Cost item or Product Codes Misc tab for Actual Cost item, then Product Codes General tab (Unit Code 2 only) |
Job Labor Transactions |
DR WIP |
Job Orders Cost Detail tab |
|
CR Exp. |
Unit Code 1 from Dept. UC field, all other codes from Dept. DL & OH applied defaults, then Product Codes (Unit Code 2 only) |
Job Material Issues |
DR WIP |
Job Orders |
|
CR Inv. |
Item Stockroom Locations |
Job Move to Inventory (includes Job Receipt |
DR Inv. |
Item Stockroom Locations |
|
CR WIP |
Job Orders |
Manual LIFO/FIFO Adjustment Utility |
DR or CR Inv. |
Item Stockroom Locations |
|
DR or CR Inv. Adj. |
Product Codes Misc, tab then Product Codes General Tab (Unit Code 2 only) |
Miscellaneous Issue |
CR Inv. |
Item Stockroom Locations |
|
DR Misc. |
Product Code Misc. tab Inventory Adjustment account |
Miscellaneous Receipt |
DR Inv. |
Item Stockroom Locations for existing locations; Inventory Distribution Accounts for new locations |
|
CR Misc. |
Product Code Misc. tab Inventory Adjustment account |
Payroll Transactions |
DR Labor Exp. |
Wage account on Employee General, then Departments (Unit Code 1 only), then Payroll Parameters for Unit Codes 2, 3, and 4 |
|
DR All Other Exp. |
Unit Code 1 from Employee Dept. UC Field, all other codes from Payroll Parameters and PR Tax Tables |
|
CR Tax Payable |
Unit Code 1 from Employee Dept. UC Field, all other codes from Payroll Parameters and PR Tax Tables |
|
CR Cash |
Unit Code 1 from Employee Dept. UC Field, all other codes from Payroll Parameters and PR Tax Tables |
Project Labor Transactions |
DR Proj Labor |
Unit Code 1 from Employee Dept. UC field, all other codes from Product Codes Project tab |
|
DR Proj Overhead |
Unit Code 1 from Employee Dept. UC field, all other codes from Product Codes Project tab |
|
DR Proj G & A |
Unit Code 1 from Employee Dept. UC field, all other codes from Product Codes Project tab |
|
CR Labor Exp. |
Unit Code 1 from Employee Dept. UC field, all other codes from DL & OH applied defaults |
|
CR Applied Ovhd |
Unit Code 1 from Employee Dept. UC field, all other codes from Project Default Parameters |
|
CR Applied G & A |
Unit Code 1 from Employee Dept. UC field, all other codes from Project Default Parameters |
Project Resource Transactions |
DR WIP |
Unit Code on Project Header (Defaults from Product Code associated with Project) |
|
CR Inv. |
Unit Code from Stockroom Location of item being issued |
|
CR |
Unit Code entered during Resource Transaction for "Non-Item Master" issues |
PS Complete Transactions |
DR Inv. |
Item Stockroom Locations |
|
CR WIP |
Work Center WIP Accts, then Product Codes (Unit Code 2 only) |
PS Scrap Transactions |
DR Scrap Exp. |
Product Codes Misc tab, then Product Codes General Tab (Unit Code 2 only) |
|
CR WIP |
Work Center WIP Accts, then Product Codes (Unit Code 2 only) |
Purchase Order Receiving |
DR Inv. |
Item Stockroom Locations |
|
CR Vouchers Payable |
Purchasing Parameters, then Product Codes (Unit Code 2 only) |
Purchase Order Variance |
DR or CR Vouchers Payable |
Purchasing Parameters, then Product Codes (Unit Code 2 only) |
|
DR or CR Inv. Adj. or PPV |
Product Codes Variance tab for Standard Cost item or Product Codes Misc tab for Actual Cost item, then Product Codes General tab (Unit Code 2 only) |
Quantity Adjustment Transactions |
DR or CR Inv. |
Item Stockroom Locations |
|
DR or CR Inv Adj |
Product Codes Misc, tab then Product Codes General Tab (Unit Code 2 only) |
RMA Return Transaction - No End User Type |
DR Inv. |
Item Stockroom Locations |
|
CR COGS |
Product Code Distribution Accounts |
RMA Return Transaction - With End User Type |
DR Inv. |
Item Stockroom Locations |
|
CR COGS |
End User Type, then Product Codes (Unit Code 2 only) |
Transfer Orders (Single Site) Quantity Move |
DR To Loc |
Transit account, then Item Stockroom Locations for existing locations; Inventory Distribution Accounts for new locations, then Product Codes (Unit Code 2 only) |
|
CR From Loc |
Transit account, then Item Stockroom Locations for existing locations; Inventory Distribution Accounts for new locations, then Product Codes (Unit Code 2 only) |
Transfer Orders (Multi-Site, Inter-Entity), MS Quantity Move |
(From Site) CR Inv. |
Item Stockroom Locations |
|
(From Site) DR I/E A/R |
Intersite Parameters, then Product Codes (Unit Code 2 only) |
|
(From Site) DR I/E COGS |
Intersite Parameters, then Product Codes (Unit Code 2 only) |
|
(From Site) CR I/E Sales |
Intersite Parameters, then Product Codes (Unit Code 2 only) |
|
(From Site) CR I/E Profit |
Intersite Parameters, then Product Codes (Unit Code 2 only) |
|
(To Site) DR Inv. |
Item Stockroom Locations |
|
(To Site) CR I/E A/P |
Intersite Parameters, then Product Codes (Unit Code 2 only) |
Transfer Orders (Multi-Site, Intra Entity |
(From Site) CR Inv. |
Item Stockroom Locations |
|
(From Site) DR I/E Clear Ship |
Intersite Parameters, then Product Codes (Unit Code 2 only) |
|
(To Site) DR Inv. |
Item Stockroom Locations |
|
(To Site) CR I/E A/P |
Intersite Parameters, then Product Codes (Unit Code 2 only) |
Vendor Payments |
CR Cash |
Bank Rec of Bank Code |
|
DR Accounts Payable |
Unit Code designated on aptrxp record for type "Voucher" |
|
DR |
Unit Code designated on A/P Payment Distributions form for type "Open Payment", "Commission" and "Non-A/P". The Unit Code defaults from Accounts Payable Parmeters form, but can be overwriteen at A/P Payment Distribution level. |
Voucher (with Vendor Category) |
DR Vouchers Payable |
Purchasing Parameters form, then Unit Code 2 from General tab on Product Codes form |
|
CR Accounts Payable |
Vendor Categories form |
Voucher (without Vendor Category) |
DR Vouchers Payable |
Purchasing Parameters form, then Unit Code 2 from General tab on Product Codes form |
|
CR Accounts Payable |
Purchasing Parameters form |
WC Labor Transactions |
DR WIP |
Work Center WIP Accts |
|
CR Labor Exp. |
Unit Code 1 from Dept. UC field, all other codes from Dept. DL & OH applied defaults |
WC Material Transactions |
CR Inv. |
Item Stockroom Locations |
|
DR WIP |
Work Center WIP Accts, then Product Codes (Unit Code 2 only) |