web
You’re offline. This is a read only version of the page.
close
Skip to main content
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)
  • Verified answer
    WCL Profile Picture
    WCL 140 on at
    RE: What does the 'REMPRICE' field in the SOP30300 table really mean?

    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)

  • Jen Kuntz Profile Picture
    Jen Kuntz 3,220 on at
    RE: What does the 'REMPRICE' field in the SOP30300 table really mean?

    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

  • SteveWhyte Profile Picture
    SteveWhyte 583 on at
    RE: What does the 'REMPRICE' field in the SOP30300 table really mean?

    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

  • Verified answer
    Tim Wappat Profile Picture
    Tim Wappat 5,703 on at
    RE: What does the 'REMPRICE' field in the SOP30300 table really mean?

    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.

  • Jen Kuntz Profile Picture
    Jen Kuntz 3,220 on at
    RE: What does the 'REMPRICE' field in the SOP30300 table really mean?

    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

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

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Our Community Code of Conduct has been updated!

Quick Links

Responsible AI policies

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

Andrés Arias – Community Spotlight

We are honored to recognize Andrés Arias as our Community Spotlight honoree for…

Congratulations to the August Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans