By using this website, you agree to our Terms of Use (click here)
In order to allow me to focus on Consulting (click here) and Courses (click here), I continue to review all posts here in the Forums, but, in general, I'm only personally responding to posts that I mark as #AcumaticaTnT (click here). For Questions (click here), others may respond, or you can post over at Community.Acumatica.com (click here).
Sincerely,
Tim Rodman
Hello All,
I'm trying to import purchase receipts and a post from this forum has given me a great start.
The link is for serialized inventory which doesn't apply to us. I've added quantity and description instead.
While trying to import by scenario I'm getting the following error message
"Error: The string value provided exceeds the field 'Type' length."
I've checked multiple times, I have it like it should be ='Receipt' and I don't have the column in my data provider.
Anybody have any ideas? Any help would be greatly appreciated. Thank you.
Charles
Perhaps a screenshot of your import scenario might help.
@charlescrf Is it possible it's the OrderType that has an issue? What values do you have in 'PO Type'? I would check all field values from the input file and make sure they are valid.
@roycelithgo Thank you for your help on this. I have column header as "PO Type", and the value as "Normal" in my excel file for data provider. My excel files doesn't have quotation marks but should I have this entered as something else?
@charlescrf I just noticed a bug in your import scenario:
The field should be OrderNbr not OrderType.
@roycelithgo Good eye! I can't believe I've overlooked such a simple thing. I've changed "Add Purchase Order" to "Add Purchase Order Line" as well. If you look at provided example in the link from my original post, that's the way it should be.
I've now gotten past that error message! Thanks!
The new error message is that it can't find the order number in the system.
I've censored some sensitive information. I'm surprised it can't find the order number because I've already imported a purchase order with that exact order number.
What am I missing?
@charlescrf That's really strange - the key for the PO is Order Type and Order Nbr and they look correct in your data. I can only suggest trying the data entry yourself. In other words, go to the PO Receipt page and add the Receipt manually assigning the fields in the same order as they are in your Import Scenario. Hopefully you should hit the same error and that might identify the issue.
@roycelithgo Excellent advice! I guess the problem was with the status of the PO. It's "Pending Printing". The system found the order number after I've printed the PO and the status changed to "Open". I have over a thousand PO's that I've imported and almost all have a status of "Pending Printing" or "On Hold". Is there a way I can change the status of all the PO's to "Open" without having to go into them manually and changing them one by one?
@charlescrf You'd need to create an Import Scenario to do it. Write a GI to export all the POs you want to update and then write an Import Scenario to do the updates.
@roycelithgo I haven't worked with general inquiries before. I'll have to give it a try! Appreciate all the help!
I'm having the same issue. Manually entering the PO number works fine, but I get that same error message as CharlesCRF...it can't find the Order Nbr.
If anyone has found a solution it would be greatly appreciated!
BTW, just found the forum and am so grateful for the all the knowledge and help so far!!
I know the CharlesCRF ended up having a different goal than I did, but I wanted to post the solution I found to adding serial or multiple lot numbers to a Purchase Receipt in case anyone else stumbles upon this thread. My partner actually warned me that this was a very difficult Import Scenario to accomplish.
Here is the screenshot of it (my data provider column key's are slightly different to what they are mapped to, but I think it's pretty obvious):
The one that is cut off is <Action:Add PO Line>(AddPOOrderLine)
I am desperate to get scenario working, my customer fubared his tenant.
I already imported all the POs and now need to import the receipts. Unfortunately the scenario will only work with non expiry lot goods. Even then, it does not import the lot number.
By the way, why is there an extra =-1?
Here is the scenario, the only thing I added was expiry because we are using lots.
@timrodman Hi, my post is awaiting moderation, probably because I never uploaded an avatar. Now that it's done can you approve my post please? I have a customer in the middle of go live and I'm hoping someone can help me out.
Thanks, the site is amazing!