Create PO Receipt from PO? (6 replies)
David, what specifically are you trying to do? Are you trying to receive specific lines of the P/O or all lines?
FYI We haven't added a 'Receive All' function onto the P/O Receipt (like we Ship All on O/E Orders). If you wanted this we'd need to add it.
Thanks
In general a Receive All function would be ideal. Though I am open to another approach to wrap this job up today since it seems this function does not exist.
I am trying to:
- Insert the Receipt Number, Receipt Date, PO Date into the Header.
- Insert all lines from the PO into the Receipt details and insert the PO qty for each into the Qty Received.
- Post the Receipt.
I tried to do this via just setting the header fields I noted in (1) but it didn't work; as I said, the error is “Field [PORLSEQ] does not exist in transaction [PO0710].”
Unless you have another approach to suggest, I'm going to attempt to join in the PO table into my DB read from the external system to provide the PORLSEQ field and see if that will insert the lines.
I’ve reconfigured the job to specify the PO Sequence Key and PO Line Sequence which, I believe, should facilitate the lines inserting into the Receipt.
However, I’m now receiving this error which doesn’t give me anything to go on to try something different:
“Error occurred when opening view IC0310.”
“The Accpac data import incurred an unrecoverable error and is quitting. [Accpac API Error 2001 - Error occurred when opening view IC0310.]”
David, a couple of things:
a. We can provide you with an enhancement to 'Receive All', but it may take a couple of days.
b. I am assuming from the error, you don't have I/C activated? I.e. All P/Os will be non-inventory related? If so we'd need to provide you with a fix to handle this scenario.
Thanks
James and team -
For (a) that would be amazing - thank you. I have a project meeting in two hours so I will let the client know.
For (b) correct that I/C is not activated; this client uses only the PO module. We will be using PO Items to maintain an Item catalog and we will also have Allow Non-Inventory Items unchecked.
Let me know if you need a copy of the IMan job and/or a database backup to support your development. Thanks again.
David, thank you.
We will supply the patch & instructions via an internal support ticket.
I have built a two-step job that:
1) Inserts PO header and detail info … this works great.
2) Inserts the PO receipt against the PO … this is inserting the header detail only.
Based on the user experience in the UI, I was expecting only to have to indicate the Receipt Number, PO Number, and Receipt Date … and all of the PO lines would default in with values in the Qty Received field.
I am guessing that I need to invoke a value against another field in the Connector configuration to instruct Sage to insert all of the lines from the PO. Has anyone done this? I am not seeing something obvious in the select lists for either the Receipt Header or Receipt Lines.
It seems to be failing on “Field [PORLSEQ] does not exist in transaction [PO0710].”
I also tried to specify the lines to insert directly onto the Receipt but that didn’t work either. I must be missing something simple and pivotal here.