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).
Questions Import Scenario Purchase Receipts
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.
Perhaps a screenshot of your import scenario might 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)
@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!