Post Reply 
 
Thread Rating:
  • 0 Votes - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Sales Order Item Import
03-09-2017, 02:40 AM
Post: #1
Sales Order Item Import
Hi is there anyway to import the items for a sales order from a .csv We have up to 100 items per sales order and what to speed up the process. We use the quick entry but its still takes to much time. Thank you in advance.
Find all posts by this user
Quote this message in a reply
03-09-2017, 08:00 AM
Post: #2
RE: Sales Order Item Import
The solution might depend on whether the import is one-time, or if you will do it often. Do you expect, for example, 10 orders per day with 100 different items and quantities in each order?

Also, where does the CSV file come from? If this type of sales is something that will be done often, and the order already exists as data (the CSV file), then using the API programmatically might be the ideal solution.

http://www.dalescott.net
Visit this user's website Find all posts by this user
Quote this message in a reply
03-09-2017, 12:28 PM
Post: #3
RE: Sales Order Item Import
There is no way currently ... would need additional code - would be a nice addition :-)


There are API methods to import orders ... and process into invoices too.
InsertSalesOrderHeader the repeated calls to InsertSalesOrderLine
Then InvoiceSalesOrder

Phil Daintree
webERP Admin
Logic Works Ltd
http://www.logicworks.co.nz
Visit this user's website Find all posts by this user
Quote this message in a reply
03-09-2017, 09:26 PM
Post: #4
RE: Sales Order Item Import
(03-09-2017 02:40 AM)miguelitrojop Wrote:  Hi is there anyway to import the items for a sales order from a .csv We have up to 100 items per sales order and what to speed up the process. We use the quick entry but its still takes to much time. Thank you in advance.

Hi Miguel,
It's actually quite easy. Attached is a new version of SelectOrderItems.php which offers you an option to upload a csv file for the order lines. the csv file should just contain 2 columns:

partcode,quantity

It needs some error checking adding in which I can do if this meets your needs. Please test it first

Tim
.


Attached File(s)
.php  SelectOrderItems.php (Size: 85.98 KB / Downloads: 4)
Visit this user's website Find all posts by this user
Quote this message in a reply
03-10-2017, 09:41 PM
Post: #5
RE: Sales Order Item Import
For those interested I attach the completed script

thanks
Tim


Attached File(s)
.php  SelectOrderItems.php (Size: 86.51 KB / Downloads: 6)
Visit this user's website Find all posts by this user
Quote this message in a reply
03-11-2017, 11:52 AM
Post: #6
RE: Sales Order Item Import
I've committed it for you
Thanks

Phil Daintree
webERP Admin
Logic Works Ltd
http://www.logicworks.co.nz
Visit this user's website Find all posts by this user
Quote this message in a reply
03-11-2017, 05:57 PM (This post was last modified: 03-11-2017 06:15 PM by falkoner.)
Post: #7
RE: Sales Order Item Import
Thanks Phil, shame about the stupid commit message though. The history of the project will now forever show you using the subversion commit messaging to pursue your personal vendettas. Childish Sad
Visit this user's website Find all posts by this user
Quote this message in a reply
03-12-2017, 07:50 AM
Post: #8
RE: Sales Order Item Import
>committed for Tim - not sure why he didnt commit it himself - improvment to selectorderitems.php to allow import of order line items from a CSV

Phil Daintree
webERP Admin
Logic Works Ltd
http://www.logicworks.co.nz
Visit this user's website Find all posts by this user
Quote this message in a reply
03-12-2017, 08:42 AM
Post: #9
RE: Sales Order Item Import
As I said, a childish commit message, as I'm sure everyone agrees.

https://github.com/erlang/otp/wiki/Writi...t-messages

Says nothing about using a commit message to further a personal vendetta. As I have said to you many times Phil, if you want me to commit to your project you need to start by making a proper public apology for the campaign of lies you have waged against me.
Visit this user's website Find all posts by this user
Quote this message in a reply
03-14-2017, 08:03 AM
Post: #10
RE: Sales Order Item Import
(03-10-2017 09:41 PM)falkoner Wrote:  For those interested I attach the completed script

thanks
Tim

Thank you for your answer that really helps me
Find all posts by this user
Quote this message in a reply
Post Reply 


Forum Jump:


User(s) browsing this thread: 1 Guest(s)