Customer Hierarchy in JDE

Hi,

I wanted to learn how JDE deals with Customer Hierarchy. WE have the Address book table wherein the parent child relationship is not clearly defined. Can anybody give suggestions on this or is there an inbuilt JDE functionality or tables which can handle this

Thanks,
Mansi

from JDELIST - JD Edwards® EnterpriseOne Applications http://ift.tt/22wRvzl
via IFTTT

R3002Z1I - BOM interop. Has anyone used to process BOM Changes?

Hello -

We are interested in using the R3002Z1I for mass bill of material changes. Has anyone successfully used this, and what are the critical setup steps?

Thank you.

from JDELIST - JD Edwards® EnterpriseOne Applications http://ift.tt/1UnCniw
via IFTTT

Removing commited quantities from primary location.

Hi All,

Can any one please let me know how do I remove committed quantities from primary location?
I have 2 items and in their primary location,one item is having negative qty commit and other item positive qty commit.
How do I check what is driving the commit and how do I remove it?

from JDELIST - JD Edwards® EnterpriseOne Applications http://ift.tt/1Vgp3MC
via IFTTT

Item Restrictions for Drop Ship

Hello List,

We are working on using Advanced Preferences to prevent restricted items on sales orders. The process works great by looking at the state and country of the JDE Ship To Address Book record. However, we are seeing an increasing number of customers requesting that we drop ship to their customer.

The issue is that the ship address is on the Sales Order Override, not JDE A/B. Has anyone found a way to handle this at order entry? We are looking at putting checks in our shipping software in the warehouse as a final stop. However, that is awkwardly late in the process in terms of disappointing a customer.

Thanks for any insight,

Jer

from JDELIST - JD Edwards® EnterpriseOne Applications http://ift.tt/1LsBuCX
via IFTTT

New Location (CO) - Wants Costing at location/lot level

We are adding a new location (Company Level) that wants to do costing at the Lot/Level. All other locations are either Standard Cost or Weighted average.

I am use to one costing method company wide (usually Standard Cost).

The plant will be using Item Numbers that are common across multiple locations (Different companies) which means site(s) could have Standard while this location would be Lot/Level.

Is this even possible? We are currently on 9.0 and going to 9.2 later this year.

from JDELIST - JD Edwards® EnterpriseOne Applications http://ift.tt/1VdfBcA
via IFTTT

JDE One World System - Id Administrator has been disabled

Hello
Please, somebody could advise me how I can enable the JDE Administrator id?
Many Thanks

from JDELIST - JD Edwards® EnterpriseOne Applications http://ift.tt/1nP1KM9
via IFTTT

Entering Vacation Balances For Employees

can any one till me how to save and edit vacation balances on the Employees? i am using JDE 9.1 i know how to setup a vacation type and vacation restrictions, also i know how to submit a vacation, however i cant seem to find the right field to enter employee vacation balance.

from JDELIST - JD Edwards® EnterpriseOne Applications http://ift.tt/1VdfyxI
via IFTTT

P41202 - Item Availability - Find Committed Parts

Hi, i am not an inventory specialist so apologies in advance if my explanation is poor!

I have an item at a branch which is telling me that 3 parts are committed on Work Orders (i see this in P41202 - Detail Availability) and therefore are being deducted from the On-Hand stock at the Branch.

The branch is set-up in this way, which is fine.

But how do i a) find the work orders these parts are committed to and b)cancel the commitment

Thanks in advance for any help!

J

from JDELIST - JD Edwards® EnterpriseOne Applications http://ift.tt/1U5pSZw
via IFTTT

How to determine which Pay Codes are caluclated in Box 14 for Canadian Payroll T4's

Hi All,

Now that the T4 season has come and gone again for another year, my payroll team has asked if I can produce a report that shows which of their paycodes are mapped to Box 14 on the Canadian T4.

I know where to find the information for the Special handling boxes

My issue is trying to determine which codes are to be included with Box 14

So far in my invesitgation I have found if I meet any one of these criteria, then the pay code is not included
1) If F069116.CHCK = 1, 4 (Non-Taxable)
2) If F069116.NMTH(Effect on the GL) = H (hours Only) or Y ($'s only)
3) IF F069116.NMTH = M (No Effect) and F069116.CHCK = BLANK
4) IF F069116.TT01 = * (how would we query this as the asterisk is a wildcard)
5) IF F069116.TT01 or TT02 or TT03 or TT04 = 'CB' - Canadian Pension Plan -EE or 'CE' - Canadian Pension Plan - ER

Is there a business function that I can look at for the logic so that I can make sure that I use the same requirements.

I am hoping that there is a much easier way of doing this and I just can't see it

Thanks
Pam

from JDELIST - JD Edwards® EnterpriseOne Applications http://ift.tt/1QKAcSH
via IFTTT

Automated SO generation in E1 9.0

I have requirement to generate new Sales orders automatically from existing maybe template order. Any innovative ideas to generate them other then EDI/UBE or scripting tools?

Thanks,
Chan

from JDELIST - JD Edwards® EnterpriseOne Applications http://ift.tt/1UYsQOl
via IFTTT

Replenishment with only Inbound Quantity

Hi all,

when I try to create a replenishment suggestion (using R461601, normal replenishment point and economic method) from a location that has not quantity on hand but has quantity inbound, the system doesn't consider this location (but if there is quantity on hand, it consider also quantity inbound as available).
The same happen if I have the request and elaborate it with R46171.
If I try to do the same for the picking, It works (pick form location with only quantity inbound).

Does someone know if is a bug in the program, a lack in the set up or if there is no way to make a cross docking for the replenishment?

thank you
Alice

from JDELIST - JD Edwards® EnterpriseOne Applications http://ift.tt/1P2QvG7
via IFTTT

Converting security deposits as unapplied cash using R03B551

I am converting security deposits from a legacy system to JDE - Real Estate/Property mgmt module. Security deposits work just like unapplied cash except in place of "UC" we use "SECD" so it hits a security deposit balance sheet account instead of Open A/R when posting to the GL. I'm using the R03B551 program to read the F03B13Z to create the security deposit records. Everything works great except it places a "UC" in the GL Offset code based on the processing options. Outside of modifying this program or SQL, does anyone know of a way to do this?

E1 9.0
Tools release: 8.98

from JDELIST - JD Edwards® EnterpriseOne Applications http://ift.tt/1pbsMhL
via IFTTT

Issues with vocabulary overrides

Hi All.. There is one that is currently faced by one of our standalone's where labels of some forms of an application e.g. P1702 are not getting translated properly in Russian (RU) language while some get translated. There are many appliations in which we are facing this issue. But we are able to see it properly in shared server. We tried to resolve this by sending an ASU from shared server to standalone but still no success. The problem is when an ASU is made, we test it in our sandbox environment and we are able to find the entry of RU language for appl P1702 in F98750 table (DV811) but when we apply the same at standalone we are not able to see the entry in the same table. We always make an ASU from PD of shared server and apply it in Dv of standalone. Also, we use Boomerang tool for making an ASU. The objects which are sent through an ASU are getting successfully checked in DV of standalone but we are not able to find the entries in F98750 table. Can anyone help us on this?

from JDELIST - JD Edwards® EnterpriseOne Applications http://ift.tt/1nyrrjR
via IFTTT

Developing Loan Management System in JD Edwards E1

Have anyone developed, modules/functionalities for handling the Loan Management Cycle for Lending Industry (includes Disbursing a loan and collecting installments against the same over a fixed period) in JD Enterprise One?

Could you please suggest if any standard JDE module can be used as basis?

from JDELIST - JD Edwards® EnterpriseOne Applications http://ift.tt/1WZhvMl
via IFTTT

Will JDE 8.9 supports on windows server 2012?

Can anyone please suggest if JDE 8.9 supports on windows server 2012?

from JDELIST - JD Edwards® EnterpriseOne Applications http://ift.tt/1QqrMxd
via IFTTT

Keying UPCs in Item Master

We will soon be adding UPCs for a couple dozen items. I was looking at the Storage/Shipping row exit from Item Master, which is where Oracle told me the UPCs should be entered. This screen requires the manufacturer's prefix to be entered in UDC table 41/UC. Our manufacturer's prefix is 6 digits, so the UDC adds a zero to the front of it, because the UDC code is a 7 digit field.

When we enter our UPCs, this leading zero is retained. Is this correct, or am I missing something? At this time, we are not concerned with SCC128, just entering UPCs.

Our UPC format is 6+5+1, which I think is fairly typical. The 6-digit manufacturer's prefix, the 5-digit unique item identifier, and the check digit.

from JDELIST - JD Edwards® EnterpriseOne Applications http://ift.tt/1T6zNxd
via IFTTT

VAT rounding issues on invoices

Hi



We are having a problem with the rounding of VAT for our sales invoices. we use invoice consolidation and our orders are all multi line orders. JDE calculates the VAT at line level rather then invoice level, therefore sum of vat value on the invoice do not equal to 20% due to rounding issues which causes the invoice to go on dispute with the customer. the VAT calcuation on header level is not used as we are using invoice consolidation.


I have checked with Oracle and there are no fixes for this in E900 or later versions. just wondering if anyone else has experienced this issue and found a work around?I

I would really appreciate your feedback.



Thanks

JHL

from JDELIST - JD Edwards® EnterpriseOne Applications http://ift.tt/1QpGULe
via IFTTT

Question on upgraded Revision/Grade of stock on a Rework Work order

Hi all,

I am a developer and I've been asked to look at the following.
Say we have an item that is used to make kits. It was Rev A in 2015, now for some reason its Rev B in 2016.
We have a rework order in 2016 but the kit used the item when it was Rev A.

During a rework order, where there are co/by products going back into stock, we want the ability to actually put Rev A back into stock (because that's what it IS and what was used in the BOM) not what the item branch currently is, Rev B.

This is from the requester:


When we create rework workorders we use process items and have to add a co-product(this is what the item gets made into) and by-products (this is material we reclaim put into stock)

From the workorder file row exit to Co-product/By-product screen and we enter the items here this reads the F3111 file in here we want to show the standard grade field and have it editable (STDG field)

It should pull this value from the item branch F4102 STDG field for the item

However in doing the above we could have a situation where we have a co or a by product that now has rev B on the item branch but when we built this product these parts were actually rev A so I want the users to be able to change the standard grade to what is on the product.

When completions run I would then need whatever standard grade is on the co/by-product to populate onto the lot master and inventory file


Can anyone help me out here?
Can we do this in E1?

Thanks

John

from JDELIST - JD Edwards® EnterpriseOne Applications http://ift.tt/1TD6UHI
via IFTTT

9.1 Resources for a Newbie?

Hello,

I'm very new to JDE. I've been working in it for under a month.

I was wondering if anyone could recommend some good material with beginner items?

I'm trying to find a report that gives me work order variances and allows me to set a timeframe (date range). I was looking at R31804 and it seems to be what I'm looking for, but I've yet to find a way I can run it as a user.

My company has the report set to run nightly, but it doesn't help me if I want to find a month's worth of variances by work order. Am I looking at this the wrong way? Should I be more focused on finding the proper G/L account my variances are connected to and going about it that way?

Sorry if this is a really dumb question, I've been trying to Google, but been getting more advanced topics than what I am looking for.

Thank you for your time,
Tim

from JDELIST - JD Edwards® EnterpriseOne Applications http://ift.tt/21kTcPA
via IFTTT

Issue Lock on F03B11 vs R03B50A....R03B50A freezing

Hi,

In the automatic Cash Receipt, We are running R03B551, that call R03B50 and our execution list that has only R03B50A as part of the execution list.
We have frequently a high level of invoices to match.

E1, version 9.1, Tools 9.1.5

Ex: We have multiple customers that pays 200-300 invoices at the time (ex: 100-200$ an invoice) and send a 20-30K check.
When we have volume like this, the R03B50A simply freeze and loop.

We found this on oracle support:

In release 9.0, why does Invoice Selection Match (R03B50A) lock the database for the Customer Ledger (F03B11) table? ( Doc ID 2023712.1 ) and apply the workaround of: A workaround is to change the Rowset Size=1000 in the [DB SYSTEM SETTINGS] section of the Enterprise server jde.ini.

But the problem is instead of freezing at 80 invoices, we freeze at 160 invoices as per the statement

FINAL DISPOSITION ROLLING LETTER =====================
If the RowSet Size is 1000 or above, the Default Rowset Buffer length can be
doubled.So RowSet can go upto 160 records.This can be done by setting the
RowSet Size to 1000 in the JDE.ini.This resolved the issue.


We aren't getting anywhere. Our automatic cash receipts process down and the cash receipt department has to manually match the cash receipts. Creating crisis.
Anybody from this group faced that situation? We can't imagine 160 records is the maximum for large Customer.

Thanks to all.

from JDELIST - JD Edwards® EnterpriseOne Applications http://ift.tt/1QHDWra
via IFTTT