Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics RMS (Archived) / Dealing Large PO Solut...
Microsoft Dynamics RMS (Archived)

Dealing Large PO Solution Help

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

I sometimes have Really Large PO's from suppliers but they have a habit of dividing the  orders into several to ten po's i have found a little trick to help me but not able to execute properly

In the OrderNumber Column (OrderNumberID) in the (POitem) PurchaseOrderEntry i placed * or + on items i would like to quickly move from one po to another

Used a command like Source PONumberID is 10000000 Destination PONumberID is 10000001

INSERT INTO PurchaseOrderEntry PONumberID = '10000001'

Where IN (Select * from PurchasePurchaseEntry

Where OrderNumberID = '+'  AND PONumber= '10000000' )

Technically i want to copy or move item to another purchase order by using symbol to mark then

Simply Concept just cant get the code right to execute it

I believe my code is wrong or missing something

*This post is locked for comments

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Dealing Large PO Solution Help

    Sorry,  I used your sql statement to fashion the example.  Not sure what you mean by OrderNumberID or PONumber

    You could always use the Built in mechanism or receiving a partial Purchase Order.  

    In the latest version of RMS, you can receive only the quantities you want on the original order.  Then commit.  When you commit RMS asks you how you want to handle the other items.  You have the following options.

    Close the Purchase Order

    Close the PO and open a new one containing the remaining items.

    Mark the Purchase Order as partially received.

    This is easier and less error prone than doing manual updates.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Dealing Large PO Solution Help

    Msg 207, Level 16, State 1, Line 1
    Invalid column name 'OrderNumberID'.
    Msg 207, Level 16, State 1, Line 1
    Invalid column name 'OrderNumberID'.
    Msg 207, Level 16, State 1, Line 1
    Invalid column name 'PONumber'.

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Dealing Large PO Solution Help

    BACKUP FIRST. 

    If all items already exist in the PurchaseOrderEntry table.  Simply update the PONumberID, like so.

    update PurchaseOrderEntry Set PONumberID = '10000001' Where ( OrderNumberID = '+' OR OrderNumberID = '*' ) AND PONumber= '10000000' 

    This will simply change the PONumberID for all entries that are marked OrderNumberID = '+'

    The where clause does the row level filtering so that you only get the rows that are marked and from the parent Purchase Order.  Below is are links to the insert and update tsql syntax.  

    www.w3schools.com/.../sql_insert.asp

    If they dont exist then add them to a Purchase Order first through RMS or do an insert in PurchaseOrderEntry,  Make sure to specify values for all columns.

    http://www.w3schools.com/sql/sql_update.asp

    BACKUP FIRST.  Then test your sql transaction.  

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans