• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 301
  • Last Modified:

Pastel Partner Version 12 - Upload Purchase Orders from Excel

Hi

In Pastel Partner Version 12

Is it possible to upload Purchase Order information  from Excel?

Thanks
0
Murray Brown
Asked:
Murray Brown
  • 2
1 Solution
 
Rob HensonFinance AnalystCommented:
What format of data does Pastel Partner require?

Excel can export to .csv or .txt to name but two?

Thanks,
Rob H
0
 
Rob HensonFinance AnalystCommented:
See link below on how to import data into Pastel partner, looks like it needs to be in .csv format.

To create a .csv in Excel is relatively simple. Create a sheet in Excel that has the columns in the required order, either by copying and pasting from existing data or by linking to it with formulae. To get the correct column mapping, I suggest you do an export of existing PO data first and open in Excel, this will show the required column headers etc.

Then, with the required csv sheet active, use the Save As function in Excel to save this workbook and choose CSV from the dropdown box for file type. The resulting csv file will only have that sheet. You can then import into Pastel Partner.

Thanks
Rob H
0
 
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAuthor Commented:
Thanks very much
0

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now