Sage 100

 View Only
  • 1.  Client reports that when attempting to edit PO the

    Posted 05-01-2018 08:33
    Client reports that when attempting to edit PO they get a message that the PO is being received on xxxxx in batch (blank). I suspect client of having done something incorrectly in DFDM to attempt to correct the problem PO. There are no batches of ROG and I've confirmed there are no records in PO Receipt of Goods Header or Details. I've looked everywhere to find the file that holds this reference to no avail. Ideas?


  • 2.  RE: Client reports that when attempting to edit PO the

    Posted 05-01-2018 08:35
    PO_ReceiptReturnMatRqByPO


  • 3.  RE: Client reports that when attempting to edit PO the

    Posted 05-01-2018 08:38
    Awesome. Thanks! I did not look here.


  • 4.  RE: Client reports that when attempting to edit PO the

    Posted 05-01-2018 08:51
    There is also a case of stranded records in the PO_ReceiptVarianceCalculation that can cause this error.


  • 5.  RE: Client reports that when attempting to edit PO the

    Posted 05-01-2018 08:53
    Thanks for that too. I'll double check that.


  • 6.  RE: Client reports that when attempting to edit PO the

    Posted 05-03-2018 15:31
    For futures searches on this topic, the stranded PO receipt record was the only record in the PO_ReceiptReturnMatRqByPO file. Thanks @KevinMoyes for the assist.


  • 7.  RE: Client reports that when attempting to edit PO the

    Posted 05-03-2018 15:34
    The real credit should go to @RobertWhite since he's the one who originally found the problem data for a customer (with this recurring every few months).


  • 8.  RE: Client reports that when attempting to edit PO the

    Posted 05-03-2018 16:01
    Kudos to all. I'm just thankful someone solved this as I thought I'd looked everywhere.