Difference between revisions of "Information Systems:Journal Entries"
Jump to navigation
Jump to search
(Replaced content with "* Generated Journal Entries * Journal in Error") |
|||
| Line 1: | Line 1: | ||
* [[Generated Journal Entries]] |
* [[Generated Journal Entries]] |
||
| + | * [[Journal in Error]] |
||
| − | |||
| − | G/L entries are automatically generated by sales, receiving, and transactions in the warehouse. To see how this is done, key 81 on an ASW command line, and press enter. |
||
| − | |||
| − | *PL/480B* Table maintenance program selection 12/02/14 17:48:36 ASGD0181 |
||
| − | ------------------------------------------------------------------------------- |
||
| − | Appl Table |
||
| − | _ AAC G/L transaction types |
||
| − | _ AAC Transaction origins |
||
| − | [[X]] DIS Transaction types |
||
| − | _ FIN Transaction enquiry sequences |
||
| − | _ GEN Nature of transactions |
||
| − | |||
| − | ------------------------------------------------------------------------------- |
||
| − | Appl Search argument |
||
| − | transaction |
||
| − | |||
| − | Key in a search argument of ‘transaction’, and press enter. Select ‘Transaction types’. |
||
| − | |||
| − | *PL/480B* Transaction type table maintenance 12/02/14 17:51:09 DMR0271 |
||
| − | ------------------------------------------------------------------------------- |
||
| − | Type Description |
||
| − | 350 RF adjustment up 350 |
||
| − | 351 RF adjustment down 351 |
||
| − | 800 Cost for goods sold 800 |
||
| − | 801 Cost for goods del. FOC 801 |
||
| − | 802 Coin adjustment 802 |
||
| − | 803 Accounts receivable 803 |
||
| − | 806 Surcharge 806 |
||
| − | 810 Purchase accounts(sys req) 810 |
||
| − | 811 Exchange rate diff invoices811 |
||
| − | 812 Quantity diff invoices 812 |
||
| − | 813 Price diff invoices 813 |
||
| − | 814 Invoiced purchases(sys req)814 |
||
| − | 840 Gross sales 840 |
||
| − | 841 Line discounts 841 |
||
| − | 842 Order discount no VAT 842 |
||
| − | 843 Sales val inv. n del no VAT843 |
||
| − | 844 Line disc inv. n del no VAT844 |
||
| − | 845 Order disc inv. n del 845 |
||
| − | 846 Freight no VAT 846 |
||
| − | 847 Postage no VAT 847 |
||
| − | 848 Insurance no VAT 848 |
||
| − | 849 Administration fee no VAT 849 |
||
| − | 850 Invoice fee no VAT 850 |
||
| − | 901 Stock value 901 |
||
| − | 902 Stock value-Drop-Transit 902 |
||
| − | 903 Stk val fict.item 903 |
||
| − | 904 "Stock" value direct del. 904 |
||
| − | 907 Goods in transfer-IRO 907 |
||
| − | 910 Manual average cost change 910 |
||
| − | 911 Manual av.cost chg.tran BtB911 |
||
| − | 912 Stock take difference pos 912 |
||
| − | 913 Stock take difference neg 913 |
||
| − | 915 Average cost change 915 |
||
| − | 916 Average cost chg. tran BtB 916 |
||
| − | 917 "Stock" value no stock upd 917 |
||
| − | 918 Stock supply diff. pos 918 |
||
| − | 919 Stock supply diff. neg 919 |
||
| − | 930 Reception from supplier 930 |
||
| − | 931 Return to supplier 931 |
||
| − | 936 Reception from supplier FOC936 |
||
| − | 944 Rnd diff - cost price calc 944 |
||
| − | 945 Gain/loss, returned goods 945 |
||
| − | 960 GST payable 960 |
||
| − | 961 GST payable on hd fees 961 |
||
| − | 962 GST payable on surcharges 962 |
||
| − | 963 GST payable on kits 963 |
||
| − | 969 Invoice rounding difference969 |
||
| − | 1000 MAI Destroyed inv (int) 1000 |
||
| − | 1001 MAI Missing items (int) 1001 |
||
| − | 1002 MAI Precursor Destruction 1002 |
||
| − | 1010 MAI Destroyd inv(ext-narc)1010 |
||
| − | 1020 MAI Destroyed inv(ext-phx)1020 |
||
| − | 1030 MAI Destroyed inv(ext-oth)1030 |
||
| − | 1035 MAI Inventory transfers 1035 |
||
| − | 1040 MAI Cycle Count Adjustment1040 |
||
| − | 1043 MAI Unit of Measure Adj 1043 |
||
| − | 1045 DO NOT USE |
||
| − | 1050 PST payable 1050 |
||
| − | 1051 PST payable on hd fees 1051 |
||
| − | 1052 PST payable on surcharges 1052 |
||
| − | 1053 PST payable on kits 1053 |
||
| − | 1060 HST payable 1060 |
||
| − | 1061 HST payable on hd fees 1061 |
||
| − | 1062 HST payable on surcharges 1062 |
||
| − | 1063 HST payable on kits 1063 |
||
| − | 1100 CGY Destroyed inv (int) 1100 |
||
| − | 1101 CGY Missing items (int) 1101 |
||
| − | 1110 CGY Destroyd inv(ext-narc)1110 |
||
| − | 1120 CGY Destroyed inv(ext-phx)1120 |
||
| − | 1130 CGY Destroyed inv(ext-oth)1130 |
||
| − | 1135 CGY Inventory transfers 1135 |
||
| − | 1140 CGY Cycle Count Adjustment1140 |
||
| − | 1143 CGY Unit of Measure Adj 1143 |
||
| − | 1145 CGY Returns to Main 1145 |
||
| − | 1997 test |
||
| − | ------------------------------------------------------------------------------- |
||
| − | Type |
||
| − | |||
| − | |||
| − | This is a list of all the transaction types that can be automatically generated by activity. ‘Types’ of 1000 and more are ones that we have created. |
||
| − | |||
| − | To see how the G/L entries are generated, select a transaction type. |
||
| − | |||
| − | *PL/480B* Transaction type table maintenance 12/02/14 18:19:33 DMR0273 |
||
| − | ------------------------------------------------------------------------------- |
||
| − | Type................ 800 |
||
| − | Description......... Cost for goods sold 800 |
||
| − | Valid tables |
||
| − | Summarise trans..... N 01 Item account group |
||
| − | VAT handling code... USST 02 Item group |
||
| − | Account part 1...... 01 03 Customer account group |
||
| − | Account part 2...... DI 04 Customer group |
||
| − | Account part 3...... OP 07 Warehouse |
||
| − | Account part 4...... WA 08 Area |
||
| − | Account part 5...... 09 Salesman |
||
| − | Account part 6...... 10 Handler |
||
| − | Account part 7...... 11 VAT |
||
| − | Account part 8...... 12 Currency |
||
| − | VAT override........ N 13 Sales order type |
||
| − | VAT account......... N 15 Acc. group, item/parent |
||
| − | Balance type........ 16 Item group, item/parent |
||
| − | Trans cost calc code 23 Project cost code 1 |
||
| − | Transaction cost.... 28 Project |
||
| − | 45 Project cost code 2 |
||
| − | 99 Cost center |
||
| − | F8=Accounting information |
||
| − | |||
| − | This shows how each account part is constructed. The two character alpha codes are ‘fixed accounts’. These point to ‘pseudo accounts’, which in turn point to the G/L master file. Pointers are used here instead of the actual G/L numbers, so that the G/L structure itself can be changed without having to change all of the ‘transaction types’. However, the way we have implemented it does not support this functionality. We have named our pseudo accounts as the account part number, then the account number itself. For example, the pseudo account for pharmaceutical cost of goods sold is ‘1410000’. For pseudo accounts to actually work as designed, it would have to be something like ‘RXCOGS’. |
||
| − | |||
| − | If the code is a number, then ‘Valid Tables’ indicates criteria. Press F8 for more information on this. |
||
| − | |||
| − | *PL/480B* Accounting information 12/02/14 18:22:55 DMR0411 |
||
| − | ------------------------------------------------------------------------------- |
||
| − | Type................ 800 Cost for goods sold 800 |
||
| − | ------------------------------------------------------------------------------- |
||
| − | Acc.p Code Description |
||
| − | X 1 01 Item account group |
||
| − | 2 DI Distribution |
||
| − | 3 OP Operations |
||
| − | 4 WA Warehouse - Main |
||
| − | ------------------------------------------------------------------------------- |
||
| − | |||
| − | Select Account Part 1. Because this is code 01, every item account group shows, and allows a pseudo account to be entered against it. |
||
| − | |||
| − | *PL/480B* Accounting information 12/02/14 18:24:26 DMR0413 |
||
| − | ------------------------------------------------------------------------------- |
||
| − | Type................ 800 Cost for goods sold 800 |
||
| − | Account part........ 1 Item account group |
||
| − | ------------------------------------------------------------------------------- |
||
| − | Code Description Pseudo |
||
| − | C100 Customer _______ |
||
| − | C200 Vendor _______ |
||
| − | I100 Pharmaceuticals 1410000 |
||
| − | I200 Home Health Care 1410100 |
||
| − | I300 OTC 1410200 |
||
| − | I400 Health & Beauty 1410300 |
||
| − | I500 Sundries 1410400 |
||
| − | I600 Tobacco 1410500 |
||
| − | I700 Non-Stocked & Seasonal 1410600 |
||
| − | Z001 Dropshipment (1120) _______ |
||
| − | Z002 Drop Shipment Admin Fee (1120) _______ |
||
| − | Z004 Enclosure Admin Fee (1120) _______ |
||
| − | ------------------------------------------------------------------------------- |
||
| − | |||
| − | By looking at the fixed account and pseudo account tables, we can that when an OTC item is sold, cost of goods sold will be posted to 410200 1000 1100 1120. |
||