• Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

Issue Entry (P4112)

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
 

Mike Dupaix

VIP Member
Ulysses,

Your issue is well documented. Thanks.

How are branch 7300 and BU 2110 related? If you desire all accounting entries for branch 7300 to be posted to BU 2110, you can put the BU 2110 in branch 7300's project field. If it's based on the product or type of issue, you will need to define your accounting process rules within the flex accounting setups. These are found in the inventory setup manual.


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



--------------------------
Visit the forum to view this thread at:
http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=&Board=OW&Number=17385
 

casatrey

Member
Ulysses,

There seems to be no problem in your setup.
Problem seems to be on your detail lines.
If you wish the expence to be debited to 2110.3220.6170 your branch plant
should be 2110 in the detail line which is the same as your header.

I may be a little confused.
If your issuing items in branch plant 2110 why would you place 7300 in
the detail line?
We dont usuallly alter the column branch plant in the detail line and
and let the system obtain it from its header file.

Hope this helps .

Goodluck.

Rey
Diwa Learning Systems Inc, Philippines
OW B7332 SP11.3 NT

----- Original Message -----
From: "UlyssesCruz" <uly@garmco.com>
To: <jdelistml@jdelist.com>
Sent: Wednesday, July 25, 2001 10:18 PM
Subject: Issue Entry (P4112)


in using the Issue Entry Program (P4112), for which I seek your help.
presently 47 GL classification and are setup like:
http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=&Board=OW&Number=1
7385


_________________________________________________________


Visual Basic, MS Access, SQL Server, One World B7332
 
Hi Rey,

Thank you for the reply you made.

The reason why we enter 7300 in the detail line is because 7300 represent the branch/plant or the the want that control this stock item.

In the case of 2110, this represent the business unit that is requesting the item from our Stores.

I think in your case each business unit has its own branch/plant.
In our case we have one branch/plant 7300 and business units (totaling 50 including business unit 7300) that is requesting items from our Stores.

At present, we are reviewing our system step up as to how it will work the way I presented the problem to you.

Thanks,

Uly
 
Re: re: Issue Entry (P4112)

Hi Mike,

Thank you for your reply.

We are reviewing our set-up in consideration with your suggestion about the use of project field or flex accounting setup.

Regarding your question, 7300 is our branch/plant which control the deliveries and issuance of items from our Stores.

Code 2110 represent a business unit that request items from branch/plant 7300. There are 50 business units like 2110 which are set-up in our system, our Stores whose business unit is 7300 can also request items from our branch/plant 7300.

We do not desire all accounting entries to be posted to business unit 2110. It can be any of the 50 business unit we setup say business unit 5300 who may request item "Mongol Pencil no. 5" from our Stores and can also be requested by any of our 50 business unit including 2110.

I'm in the process of reviewing your suggestion and I will get in touch about the progress.

Thanks again.

Uly
 
Top