Ideas for SalesPad Desktop

Automatic allocation of inventory to oldest backorders

A feature where as inventory is received and posted to GP, this inventory then automatically allocates to sales documents with the oldest doc dates. Right now, everything is a manual process to allocate product to sales docs with backordered items.

  • Rebecca Jensen
  • Feb 14 2019
  • Attach files
  • Joe Alt commented
    20 Feb, 2019 06:24pm

    Yes Automation Agent could do that with a script.

  • Rebecca Jensen commented
    15 Feb, 2019 11:13pm

    Got it.  We don't own automation agent, but I can look into this more with our sales rep.  Thanks Jacob.

  • Admin
    Jacob Pegg commented
    15 Feb, 2019 07:07pm

    Rebecca,

    I would think so, but I'd have to defer to one of the developers to answer that for certain.  But we could essentially use Automation Agent to automate the batch processing piece that I mentioned previously and have it sort docs based on oldest date first.

  • Rebecca Jensen commented
    15 Feb, 2019 06:59pm

    Jacob, thanks for the quick response!  Is automation agent able to also take into account an order of operations where oldest orders are allocated first in the example of a 30 min schedule?  

  • Admin
    Jacob Pegg commented
    15 Feb, 2019 01:02pm

    Rebecca,

    There isn't a great way to automate this process, but there are a couple of options to make it easier.  One is to use batch processing after posting receipts which will allow you to allocate based on how you sort the documents on the screen.  The other option would be to use something like Automation Agent, which wouldn't be automatic per se, but you could have it run on a schedule (every 30 mins for example) to check for available inventory and allocate.