UlyssesCruz
Member
Dear Colleagues,
We are using OW XE on Windows 2000 with SQL 7 database and have problems in using the Issue Entry Program (P4112), for which I seek your help.
1. GL entries does not debit the business unit for which the stock
item issued to, instead it debit the branch/plant where item is
stored.
2. For each item issued, the user should enter branch/plant in the
grid. Can the system use the default business unit of the
user entering the transactions? In this way error will not be
encountered and provide ease of use.
The below are our setups:
Processing options:
Defaults = II, 1
Versions = blank, blank, blank
Process = 2, blank, 2, blank, blank, blank, 1
Interop = blank
Agreement = blank
Items are stored in branch/plant 7300.
AAI 4124 (Expense) for document type II and company 100. We are using presently 47 GL classification and are setup like:
GL Cat - 0176 (Hand Tools)
Branch/Plant - blank
Object - 3220
Subject - 6170
AAI 4122 (Inventory) for document type II and company 100
GL Cat - 0176 (Hand Tools)
Branch/Plant - 9000
Object - 7160
Subject - 5000
Item no. 00000-0001 is assigned to GL Category 0176
Item weighted average cost is BD 10.000
When Issue Transaction was entered:
Entries in header are:
Document type is II
Branch/Plant is 2110, requestor business unit
Entries in the grid are:
Item number is 00000-0001
Quantity is 1
Branch/plant is 7300 (no entry should be made in this column to
avoid error and provide ease of entry. It should use default
branch/plant assigned to the user)
Account number is blank, should not be entered manually except on
rare occasion. It will be tiresome and prone to error if
Storekeeper will enter this manually.
GL entries created due to Issue Entry are:
Inventory - charge to 9000.7160.5000 with an amount of -10.000
Expense - charge to 7300.3220.6170 with an amount of 10.000,
entry should be 2110.3220.6170 and branch/plant to be used
should be taken from the header.
Item Ledger created by Issue Entry is:
Branch/plant is charge to 7300 should be 2110
Thanks in advance.
Ulysses Cruz
Gulf Aluminium Rolling Mill Co.
XE SP13 SQL 7 NT 4.0
We are using OW XE on Windows 2000 with SQL 7 database and have problems in using the Issue Entry Program (P4112), for which I seek your help.
1. GL entries does not debit the business unit for which the stock
item issued to, instead it debit the branch/plant where item is
stored.
2. For each item issued, the user should enter branch/plant in the
grid. Can the system use the default business unit of the
user entering the transactions? In this way error will not be
encountered and provide ease of use.
The below are our setups:
Processing options:
Defaults = II, 1
Versions = blank, blank, blank
Process = 2, blank, 2, blank, blank, blank, 1
Interop = blank
Agreement = blank
Items are stored in branch/plant 7300.
AAI 4124 (Expense) for document type II and company 100. We are using presently 47 GL classification and are setup like:
GL Cat - 0176 (Hand Tools)
Branch/Plant - blank
Object - 3220
Subject - 6170
AAI 4122 (Inventory) for document type II and company 100
GL Cat - 0176 (Hand Tools)
Branch/Plant - 9000
Object - 7160
Subject - 5000
Item no. 00000-0001 is assigned to GL Category 0176
Item weighted average cost is BD 10.000
When Issue Transaction was entered:
Entries in header are:
Document type is II
Branch/Plant is 2110, requestor business unit
Entries in the grid are:
Item number is 00000-0001
Quantity is 1
Branch/plant is 7300 (no entry should be made in this column to
avoid error and provide ease of entry. It should use default
branch/plant assigned to the user)
Account number is blank, should not be entered manually except on
rare occasion. It will be tiresome and prone to error if
Storekeeper will enter this manually.
GL entries created due to Issue Entry are:
Inventory - charge to 9000.7160.5000 with an amount of -10.000
Expense - charge to 7300.3220.6170 with an amount of 10.000,
entry should be 2110.3220.6170 and branch/plant to be used
should be taken from the header.
Item Ledger created by Issue Entry is:
Branch/plant is charge to 7300 should be 2110
Thanks in advance.
Ulysses Cruz
Gulf Aluminium Rolling Mill Co.
XE SP13 SQL 7 NT 4.0