RE: Export of Sales Order Details
Yes, I started looking at this, then realised I can do it a different way.
We have already written our own despatch program in php. It records despatches and weights of order, tells the warehouse how to pack goods into boxes, and links up with our transport carriers to print the address labels.
We export orders from our current program as a csv file and then I have made an import order script to read it file and create the order.
With Weberp, I can add a new sales order save it and then our program can just look in the database tables and read the order straight in.
We tend to follow a set routine for orders:
ie, Quote -> Order -> Pick Ticket -> Delivery Note -> Invoice
After the warehouse pick the goods, they will back order and products not being delivered and then print the delivery note. Our customer would sign the delivery note for goods received and we then pass that delivery note to our accounts who raise the invoice.
Goods are orderd by the purchasing department, and when the balance of goods arrive the warehouse take them off back order, the pick ticked can be filed as complete, print a new delivery note and then invoice the remaining goods.
weberp seems to create the back order at invoice stage, which for us isnt quite right.
Long term using your APIs to go the other way maybe a better option though.
|