We make accounting easy. So you can focus on your business.
Simply Accounting Support Community
Search in

creating PO automatically from OE

Last post 11-18-2008 1:49 PM by ryng. 5 replies.
Page 1 of 1 (6 items)
Sort Posts: Previous Next
  • 09-18-2008 7:24 PM

    • ryng
    • Not Ranked
    • Joined on 09-18-2008
    • Posts 4

    creating PO automatically from OE

    anyone know of anything like this.

    put in an sales order, the system would automotically setup a PO for the items in OE.

    any third party developer listening or watching

    don't worry, be happy

    robert
  • 09-18-2008 8:26 PM In reply to

    Re: creating PO automatically from OE

    This is not an inexpensive option. I am only aware of it being a part of the program if the purchase cost is many times the cost of Simply.

    The best suggestion would be to review the MISys add on. This is  for a manufacturing company and it may include this option. There is a link to this add on currenty running on the Simply home page.

    Clyde

  • 09-19-2008 3:12 PM In reply to

    • ryng
    • Not Ranked
    • Joined on 09-18-2008
    • Posts 4

    Re: creating PO automatically from OE

    any third party developer watching ...

     

     

    don't worry, be happy

    robert
  • 11-17-2008 9:34 PM In reply to

    Re: creating PO automatically from OE

    Hi,

    This feature is only available in higher end systems - I'm sure there's a Sage product that will do what you need.

    You can filter the Inventory Reports menu - I.E. you could filter for 'Starts With' DEW or POR or DEL or B-D, open the report in Excel, copy, and paste into an Excel template.   You might even be able to copy and paste into the Purchase Order screen (I didn't try).   If you issue 1 purchase order a day to 2 or 3 suppliers this would be practical.

     What isn't in Simply to make this automatic is the sort of features where you would record primary and secondary vendors, prices, quantity discounts, package quantities, weight, cubage, freight rates, terms, etc. and it would automatically calculate the best mix for an order.  That's where SAP (or the Sage equivalent) comes in.

    It's probably not impossible to use one of the 5 'extra' data fields for an inventory item as your vendor if it's always the same vendor, and build an Excel report using ODBC that would feed the data into a purchase order.  I'm sure a third party vendor could put that together for you if you need it.

    Using TLAs in your part numbers to identify the manufacturer, building reports for each vendor, and putting all the reports into the Report Centre so you can run them with one click, then manual keying from these reports might be a good start too.  It may be best to keep a human in the loop.

    Randy

  • 11-17-2008 10:11 PM In reply to

    Re: creating PO automatically from OE

    As Clyde suggested in an earlier post, MiSYS will do this and it is not wildly expensive. I believe that Business Vision by Sage will also do it.

     

    Get more from your Simply Accounting software!
    Reports, data mining, etc. - ask me how
  • 11-18-2008 1:49 PM In reply to

    • ryng
    • Not Ranked
    • Joined on 09-18-2008
    • Posts 4

    Re: creating PO automatically from OE

     Veronique of tech support suggested an export/import solution.

     i have not tested this procedure extensively, so use it at your own risk.

    criteria includes the following

     1 access to local email

    2 identical item numbers -vendor and customer

    3 both vendor and customer must have local email as their email account.

    it is simple - however, if the invoice is a one-liner, you may not want to do it this way.

    PROCEDURE

    enter a sales order

    emal the sales order to the local account

    download the salesorder.imp file

    goto file/import/transaction and import the salesorder.imp file and choose the correct vendor for your PO.

     

     

    don't worry, be happy

    robert
Page 1 of 1 (6 items)