Results 1 to 6 of 6

Thread: Short Item Number

  1. #1
    Senior Member
    Join Date
    Nov 2002
    Location
    Canada
    Posts
    119

    Short Item Number

    Hi List,

    How is field RPITM populated in F0311 after Sales Update? It looks to me like this comes from some link b/w items and tax… Most of the time, RPITM is different from the short item number on the SO in F4211, but sometimes it’s blank and it’s causing me some issues in A/R…

    Thank you,
    J.


    A7.3 Cume 11

  2. #2
    New Member
    Join Date
    Mar 2003
    Location
    Singapore
    Posts
    5

    Re: Short Item Number

    Hi Jeff,

    This field is populated when the item from a particular SO Line exists in Tax Area file F4008 (SDITM=TAITM) Most of the time the field in F4008 is blank (zero), meaning, tax rate is the same for all items in the Tax Area, so RPITM is blank.
    In fact in our environment (A7.3 Cum 7), RPITM is blank for all F0311 records. We did not define Tax Area by Item.

    Regards,

    AKC

    PS. Do you have problem with out-of-balance GL for Foreign Currency Invoices after Sales Update?

  3. #3
    Senior Member
    Join Date
    Nov 2002
    Location
    Canada
    Posts
    119

    Re: Short Item Number

    Thanks for your response.

    I have enquired on F4008, and it turns out you're right about most of it having blank TAITM. Actually, all records in this file have their TAITM either blank or =3. However, in F0311, I have tons of other items (<>3), which result in non-blank RPITM...

    My problem with AR is that the invoices generated by the Sales Update program are split into many pay items even though they're set up to be summarized. I ran across a white paper that says there are 8 fields that need to be the same on 2 SO lines for those to be summarized on the RI. My enquiries have shown that in all "split" cases, the only field that is not the same on an SO lines was that ITM. Hence, my post...

    Thanks again,
    J.
    A7.3 Cume 11

  4. #4
    Senior Member
    Join Date
    Jan 2001
    Location
    St. Louis, Missouri
    Posts
    408

    RE: Short Item Number

    May have something to do with tax calculations. We do not have any tax
    things setup here, and my RPITM field is all 0. However I see in subroutine
    S008 in P42800 that information is being moved into RPITM, including
    possibly the true JDE short item number (or some kind of tax code). That is
    the calculate tax subroutine. Do you have taxes of some kind being
    calculated on your sales?

    John Dickey
    JDE Financial Systems
    Administrator/Programmer/Analyst
    White-Rodgers, Division of Emerson
    St. Louis, MO
    314-577-1466


  5. #5
    New Member
    Join Date
    Mar 2003
    Location
    Singapore
    Posts
    5

    Re: Short Item Number

    We do not have this problem (we are on A7.3 C 7), and the occasional split pay item we have is when there is a particular line (in the order) with negative Qty/Value. (this happens when we had to reverse out a stock-updated line before invoicing step, where we replace a substitute item)

    Do check your processing options (for your final P42800 run version), as this should not happen normally. There might be a rogue (sleeper?) version running without the summarization flag on.

  6. #6
    Senior Member
    Join Date
    Nov 2002
    Location
    Canada
    Posts
    119

    Re: Short Item Number

    Thanks for your response. Are you using Vertex, too?
    A7.3 Cume 11

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
The legal restrictions and terms of use applicable to this site are available here.
Use of this site signifies your agreement to the terms of use.
JDELIST is NOT affiliated with JD Edwards® & Company, Oracle or Peoplesoft. Contents of this site are neither endorsed nor approved by JD Edwards® & Company and, or Oracle.