Sales Order Number The number or code identifying the sales order in the originating system. From the order_id in the CreateDSOrder message. Order Status Possible statuses are: • Cancelled: You have cancelled the entire purchase order. • Complete (multi-line purchase orders only): The...
ThePurchaseOrderDetailtable is contained in thePurchasingschema. Column Data type Nullability Description PurchaseOrderID int Not null Primary key. Foreign key toPurchaseOrderHeader.PurchaseOrderID. PurchaseOrderDetailID int Not null Primary key. A sequential number used to ensure data uniqueness. ...
The program copies the number from the Purchase Order No. field on the sales line.You cannot change the number because the shipment has already been posted.Tip For more information on how to work with fields and columns, see Work with Data. For assistance in finding specific pages, see ...
If the currency ID is not the company's functional currency, a rate type and associated exchange rate table is assigned to the transaction.Enter or select the number of the vendor item or item you're purchasing. If a vendor item or an item hasn't been set up in your inventory, see ...
Describes how to add the purchase order number to the Open Sales Order report in Microsoft Dynamics GP.
Table of Contents Purchase Orders: What Is a Purchase Order? Why Purchase Orders Are Important for Your Business Automating the Purchase Order Process Purchase Order Vs Invoice Definition What Is a PO Number? Purchase Order Template - 5 Things to Include Purchase Order Tracking Meaning What Is Pro...
• Date required: from the purchase order due date• Unit price: the unit price in the vendor’s unit of measure, including the primary discount, but excluding the trade, coop or special discounts defined in the Vendor Discount table. For example, if the unit of measure is 12, and ...
Open theAddress selectionform, where you can select another address for the selected purchase order. Fields Expand table Field Description One-time supplier Select this check box if this is a new vendor and you do not expect to buy from this vendor again. A record will be created in theVend...
For each purchase document, a purchase entry is created in the G/L Entry table. An entry is also created in the vendor's account in the Vendor Ledger Entry table and a G/L entry is created in the relevant payables account. In addition, posting the purchase can result in a value-added...
The purchase order update APIs integration point uses the PO_UPDATE_IFACE interface table. Multiple tables in the Purchasing module are updated by the Oracle API, PO_CHANGE_API1_S.UPDATE_PO. Refer to the Oracle Purchasing API documentation for details.