web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / What does the 'REM...
Microsoft Dynamics GP (Archived)

What does the 'REMPRICE' field in the SOP30300 table really mean?

(0) ShareShare
ReportReport
Posted on by SteveWhyte 583

Hi

I want to make sure I understand clearly.

What does the 'REMPRICE' field in the SOP30300 table really mean? Does it mean that this is the amount that is unpaid for the item?

Regards,

Steve

*This post is locked for comments

I have the same question (0)
  • Jen Kuntz Profile Picture
    Jen Kuntz 3,220 on at

    Hi Steve,

    I checked my data and my guess it isn't not really used. It wouldn't have anything to do with the document balance, that's for sure, as any payments are not applied at a line item level. In my data, I see the same amount in multiple price fields (XTNDPRCE, OXTNDPRC, REMPRICE, OREPRICE) etc.

    Someone like Leslie Vail may know better with her history with the distribution series + dexterity background!

    Jen

  • Verified answer
    Tim Wappat Profile Picture
    Tim Wappat 5,711 on at

    For SOP10200: QTYREMAI * UNITPRCE= REMPRICE

    Agree with Jen, it will be rarely found in the history table, but prevalent in the work table.

    I have 121 rows for SELECT  REMPRICE, * FROM SOP30300 WHERE REMPRICE!=0 and remprice != XTNDPRCE

    Out of total of 3,699,846 rows. 

    I'm guessing these are corrupt orders

    Seems to be linked to cancelling qtys that never made it from quote to order or order to invoice.

    Tim.

  • SteveWhyte Profile Picture
    SteveWhyte 583 on at

    Thanks Tim & Jen for your responses

    My problem is this.....is there any way I can find out how much is unpaid for a record in the SOP00300 Table? I an writing an SSRS report for someone and they need to know what amount is unpaid and based on the report structure I can't use the SOP30200 table. I need to find out the amount owing on each item sold as recorded in the SOP00300 table.

    Regards,

    Steve

  • Jen Kuntz Profile Picture
    Jen Kuntz 3,220 on at

    There is no direct link for that as any payments or credits aren't applied at a line item level. What you could do would a mathematical application linking to the RM20101 for instance if the invoice is not in history. CURTRXAM is the current transaction amount for any given document. You would have to prorate that proportionately against the line item values to "roughly" estimate the outstanding amount on each line. Unless you have customized something that has allowed you to apply at a line item level, that would the only obvious solution I can think of.

    The trick would be if the invoice is NOT in RM20101 (but is posted) then the assumption would be the current balance is zero so all lines could show as "paid" or at least have a zero balance. The timing of invoices moving from open tables to history is based on user input running the Paid Transaction Removal utility so your mileage may vary on if and how frequently your finance team does that with paid receivables.

    Hopefully that gives you an idea? Even the SOP30200 doesn't have this field because the "balance" of a document is purely a RM (receivables) function.

    Jen

  • Verified answer
    WCL Profile Picture
    WCL 140 on at

    Old post I know but for posterity:

    "I have 121 rows for SELECT  REMPRICE, * FROM SOP30300 WHERE REMPRICE!=0 and remprice != XTNDPRCE" .. .inerestingly I have 242 out of almost 700k records ... all were records were the quantity was >1 (most transaction in the system I am lookign at have single qty invoice lines) ... and except for slight 1 penny differences I see that "REMPRICE less TAXAMNT" is equal to the XTNDPRCE on these items.  So I suspect some bug perhaps in VAT calc on these (or someone has "fixed" rows in the past and not adjusted all the columns I guess)

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans