Sage 500 Transaction Types

1 minute read time.

Each Sage 500 transaction is associated with a unique  transaction type number. This number follows the transaction in module’s transaction tables as well as in GL posting tables. Here is the list of all transaction types loaded when Sage 500 database is created:

 

General Ledger:

301  GL Beginning Balance

302  Allocation Journal

303  General Journal

 

Accounts Payable:

400  Voucher

401  AP Invoice

402  AP Debit Memo

403  AP Credit Memo

411  AP Check

412  Vendor Write Off

 

415  BACS

416  EFT

417  Other

420  AP Payment Application

 

Accounts Receivable:

501  AR Invoice

502  AR Credit Memo

503  AR Debit Memo

504  Invoice-Refund

505  Finance Charge

511  Cust Pmt - Cash Receipt

512  Cust Pmt - Write Off

513  Cust Pmt - Bad Debt

514  Cust Pmt - Reversal

515  Cust Pmt - Refund

520  AR Payment Application

521  Sales Commission

 

Inventory Management:

701  IM Sale

702  IM Sale Return

703  IM Purchase

704  IM Purchase Return

705  Transfer In

 

706  Transfer Out

707  Issue

708  Physical Count

709  Cost Tier Adjustment

710  Adjustment

711  Kit Assembly

712  Kit Assembly (Component)

713  Kit Disassembly

714  Kit Disassembly (Component)

715  Three Step Transfer

716  Bin Transfer

717 Physical Count Bin Transfer Out

718 Physical Count Bin Transfer In

749  IM Beginning Balance

 

Sales Order:

801  Sales Order (Standard)

802  Sales Order (Blanket)

804  SO Change Order

810  Customer Shipment

811  Customer Return

 

812  Transfer Shipment

813  Transfer In (Transit Warehouse)

814  Drop Shipment

820  Packing List

830  Bill of Lading

835  RMA

840  SO Quote

 

Cash Management:

901  CM Check

902  Deposit

903  Withdrawal

904  Bank Transfer From

905  Bank Transfer To

906  Bank Charge

907  Interest Earned

908  Misc Credit

909  Misc Debit

910  CM Beginning Balance

 

Multi-Currency:

1001  Revaluation Gain (GL)

1002  Revaluation Loss (GL)

1003  Revaluation Gain (AP)

1004  Revaluation Loss (AP)

 

1005  Revaluation Gain (AR)

1006  Revaluation Loss (AR)

1011  Realized Gain

1012  Realized Loss

 

Purchase Order:

1101  Purchase Order (Standard)

1102  Purchase Order (Blanket)

1110  Receipt from Vendor

1111  PO Return

1112  Receipt from Warehouse

1113  Transfer Out (Transit Warehouse)

1120  PO Voucher

1130  Requisition

1150  PO Change Order

 

Project Accounting:

1900  Timesheet

1901  Project

1902  Expense Claim

1903  Project Debit

1904  Project Credit

 

 

Manufacturing:

9000  Material WIP

9001  Labor WIP

9002  Progress WIP

9003  Job Close WIP

9004  Cost Rollup

9100  Reverse Material WIP

 

For third party modules please contact the developer for the transaction type numbers.