AUGForums.com

An Acumatica User Group

  • Free
    • Start Here
    • Rolodex
    • Podcast
    • Blog
    • Forums
  • Course
  • Consulting
  • Login
  • Register
Acumatica Forums

By using this website, you agree to our Terms of Use (click here)

  • Overview
  • Member List
  • All-Stars
  • Stats
  • Recent Posts
  • Help
Forums
AUG Forums
Everything Else
Import Scenario Pur...
 
Notifications
Clear all

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

Questions Import Scenario Purchase Receipts

Everything Else
Last Post by Michael Triffon 2 years ago
18 Posts
5 Users
1 Likes
2,158 Views
RSS
CharlesCRF
Posts: 9
 CharlesCRF
Topic starter
July 29, 2020 2:18 pm
(@charlescrf)
Member
Joined: 3 years ago

Hello All,

I'm trying to import purchase receipts and a post from this forum has given me a great start.

https://www.augforums.com/forums/acumatica-import-scenarios/import-scenario-for-purchase-receipt-with-serialized-stock/

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

17 Replies
Royce Lithgo
Posts: 552
 Royce Lithgo
August 4, 2020 12:15 am
(@roycelithgo)
Member
Joined: 3 years ago

Perhaps a screenshot of your import scenario might help.

Reply
CharlesCRF
 CharlesCRF
(@charlescrf)
Joined: 3 years ago

Member
Posts: 9
August 4, 2020 11:45 am
Reply toRoyce LithgoRoyce Lithgo

@roycelithgo Right!  Sorry about that.  Screenshots are below.

image

 

image
Reply
Royce Lithgo
 Royce Lithgo
(@roycelithgo)
Joined: 3 years ago

Member
Posts: 552
August 4, 2020 9:21 pm
Reply toCharlesCRFCharlesCRF
Royce Lithgo

@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.

Reply
CharlesCRF
 CharlesCRF
(@charlescrf)
Joined: 3 years ago

Member
Posts: 9
August 5, 2020 10:03 am
Reply toRoyce LithgoRoyce Lithgo
CharlesCRF
Royce Lithgo

@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?

Reply
Royce Lithgo
 Royce Lithgo
(@roycelithgo)
Joined: 3 years ago

Member
Posts: 552
August 6, 2020 1:00 am
Reply toCharlesCRFCharlesCRF
Royce Lithgo
CharlesCRF
Royce Lithgo

@charlescrf I just noticed a bug in your import scenario:

The field should be OrderNbr not OrderType.

Reply
CharlesCRF
 CharlesCRF
(@charlescrf)
Joined: 3 years ago

Member
Posts: 9
August 6, 2020 12:30 pm
Reply toRoyce LithgoRoyce Lithgo
CharlesCRF
Royce Lithgo
CharlesCRF
Royce Lithgo

@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.

image

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.

image

What am I missing?

 

Reply
Royce Lithgo
 Royce Lithgo
(@roycelithgo)
Joined: 3 years ago

Member
Posts: 552
August 6, 2020 1:32 pm
Reply toCharlesCRFCharlesCRF
Royce Lithgo
CharlesCRF
Royce Lithgo
Royce Lithgo

@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.

Reply
CharlesCRF
 CharlesCRF
(@charlescrf)
Joined: 3 years ago

Member
Posts: 9
August 10, 2020 10:52 am
Reply toRoyce LithgoRoyce Lithgo
CharlesCRF
Royce Lithgo
CharlesCRF
Royce Lithgo

@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?

Reply
Royce Lithgo
 Royce Lithgo
(@roycelithgo)
Joined: 3 years ago

Member
Posts: 552
August 10, 2020 5:29 pm
Reply toCharlesCRFCharlesCRF
Royce Lithgo
CharlesCRF
Royce Lithgo
Royce Lithgo

@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. 

Reply
CharlesCRF
 CharlesCRF
(@charlescrf)
Joined: 3 years ago

Member
Posts: 9
August 10, 2020 6:48 pm
Reply toRoyce LithgoRoyce Lithgo
CharlesCRF
Royce Lithgo
CharlesCRF
Royce Lithgo

@roycelithgo I haven't worked with general inquiries before.  I'll have to give it a try!  Appreciate all the help!

Reply
Noah
Posts: 21
 Noah
August 9, 2020 8:44 pm
(@nmri)
Member
Joined: 3 years ago

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!!

Reply
Noah
Posts: 21
 Noah
August 31, 2020 10:12 pm
(@nmri)
Member
Joined: 3 years ago

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):

 

PO Receipt Serial

 

The one that is cut off is <Action:Add PO Line>(AddPOOrderLine)

Reply
Tim Rodman
 Tim Rodman
Admin
(@timrodman)
Joined: 8 years ago

Member
Posts: 2969
October 6, 2020 11:20 pm
Reply toNoahNoah

@nmri Thanks so much for posting your solution.

Reply
Michael Triffon
 Michael Triffon
(@michaeltriffon)
Joined: 3 years ago

Member
Posts: 22
February 10, 2021 10:25 pm
Reply toNoahNoah

@nmri

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.

 

image
Reply
Michael Triffon
Posts: 22
 Michael Triffon
February 11, 2021 2:05 pm
(@michaeltriffon)
Member
Joined: 3 years ago

@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!

Reply
Tim Rodman
 Tim Rodman
Admin
(@timrodman)
Joined: 8 years ago

Member
Posts: 2969
February 11, 2021 4:27 pm
Reply toMichael TriffonMichael Triffon

@michaelpabian Sorry for the delay. You should be good to go now.

Reply
Michael Triffon
 Michael Triffon
(@michaeltriffon)
Joined: 3 years ago

Member
Posts: 22
February 11, 2021 5:07 pm
Reply toTim RodmanTim Rodman
Michael Triffon

@timrodman Thanks!

Reply
Tim Rodman reacted
Forum Jump:
  Previous Topic
Next Topic  
Forum Information
Recent Posts
Unread Posts
Tags
  • 11 Forums
  • 2,268 Topics
  • 9,982 Posts
  • 1 Online
  • 1,834 Members
Our newest member: Derek Wong
Latest Post: Change the number of rows in the check remittance field
Forum Icons: Forum contains no unread posts Forum contains unread posts
Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Online Members

 No online members at the moment

Acumatica Forums

Terms of Use & Disclaimers :: Privacy Policy

Copyright © 2023 · AUG Forums, LLC. All rights reserved. This website is not owned, affiliated with, or endorsed by Acumatica, Inc.

‹›×

    ‹›×