importing Purchase Order shown as a RFQ

Question

I exported a existing PO and trying to fill up the relevant data, but I can't find total amount of PO as the import field on importing setting page. (can find line of quantity and unit price)  Then I skipped to the total field, the result show in RFQ with no any quantity and price information.

Cybrosys Techno Solutions Pvt.Ltd · Accepted Answer

Hi,
When you import data, include the quantity and unit
price fields. The total amount in the purchase order will be calculated
automatically, so there is no need to import the total field.

image [1]

Make sure to match the fields correctly while importing.

Image [2]

After
clicking the Import button, you will see a purchase order created in
draft state based on the imported data. You can also see the total
amount calculated automatically based on the quantity and unit price.

Image [3]

Hop

Chris TRINGHAM · Answer

Hi Leanne - there's a format here [1]  from this page [2]

[1] /documentation/17.0/_downloads/8dc6eb0b6495ef9a6b4c99d9db12e00a/o2m_purchase_order_lines.csv
[2] /documentation/17.0/applications/general/export_import_data.html

Related Posts	Odgovori	Prikazi
V18 PO changes price when changing quantity Solved purchase_order	1 jun. 26	880
how to set the whole form view to readonly based on state of the form purchase_order	3 apr. 26	2253
Bundle POs per vendor Solved purchase_order	2 apr. 26	1850
Purchase orders not directly added to Quantity on hand in Inventory Solved purchase_order	2 mar. 26	1836
Create a PO without adding products to stock purchase_order	3 dec. 24	11354

This question has been flagged

Enjoying the discussion? Don't just read, join in!