AugForums.com

An Acumatica User Group

  • Free
    • Start Here
    • In-Person Gatherings
    • Power BI Workshop
    • Podcast
    • Rolodex
    • Blog
    • Forums
  • Paid
    • AugSQL
    • GI Course
    • GI Library
    • Consulting
  • Register
Acumatica Forums

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

Forums
AUG Forums
Everything Else
Import Scenario for...
 
Notifications
Clear all

Questions Import Scenario for Purchase Receipt with Serialized Stock

 
Everything Else
Last Post by eshahid 5 years ago
7 Posts
5 Users
3 Reactions
4,905 Views
RSS
Carl Brooks
Posts: 121
 Carl Brooks
Topic starter
December 11, 2018 10:05 pm
(@kingcarlos)
Estimable Member
Joined: 6 years ago

Sharing this for those who may need it, 

https://myobexo.custhelp.com/app/answers/detail/a_id/39297/kw/39297/session/L3RpbWUvMTU0NDU4MDEzNC9zaWQvLWZDYUoyMm8%3D

 


eshahid reacted
6 Replies
Tim Rodman
Posts: 3204
 Tim Rodman
Admin
December 12, 2018 9:32 am
(@timrodman)
Famed Member
Joined: 11 years ago

Thanks for sharing this Carl!

Attaching a screenshot of your Import Scenario here:


Reply
Royce Lithgo
Posts: 557
 Royce Lithgo
December 12, 2018 4:50 pm
(@roycelithgo)
Honorable Member
Joined: 6 years ago

We are importing Purchase Receipts with Lot numbers and it's a lot simpler than that and doesn't assume/require a Purchase Order either. Lot/Serial Nbr is a field on Document Details and can be directly assigned (well in our case anyway because each receipt line has one Lot Nbr). Multiple lots per receipt line would require use of Allocations but what's weird in the above is that there's no Receipt Qty assigned anywhere in the IS.


Reply
Carl Brooks
 Carl Brooks
(@kingcarlos)
Joined: 6 years ago

Estimable Member
Posts: 121
December 12, 2018 5:14 pm
Reply toRoyce LithgoRoyce Lithgo

Hi Royce, that's because it is serialised stock so therefore the receipt quantity will always be defaulting to a quantity of one.


Reply
Royce Lithgo
Posts: 557
 Royce Lithgo
December 12, 2018 5:36 pm
(@roycelithgo)
Honorable Member
Joined: 6 years ago

Is that something specific to Serial Tracked items? Lot Tracked items always default zero on Allocations.

For me personally I never rely on defaults, but prefer to include additional lines wherever a default is assumed. 


Reply
Shawn P Slavin
 Shawn P Slavin
(@shawn-p-slavin)
Joined: 6 years ago

Estimable Member
Posts: 196
December 12, 2018 7:36 pm
Reply toRoyce LithgoRoyce Lithgo

Royce, by definition, there can only be one of a specific item / serial number combination. It must always be a unique identifier. With lotted items, lot sizes vary, especially once we start selling or consuming items from a particular lot.


Reply
Tim Rodman reacted
eshahid
Posts: 3
 eshahid
May 26, 2021 12:10 pm
(@eshahid)
New Member
Joined: 6 years ago

Thank you for sharing this Carl. This saved me a ton of time. I had to make some adjustments to the Allocations section, screenshot below. 
For everyone who might need this, this is tested in 2020R2 and works great. 
It lets you import Purchase Receipts against a PO with serialized items. 

Here's the mapping:

image

Reply
Tim Rodman reacted
Forum Jump:
  Previous Topic
Next Topic  
Forum Information
Recent Posts
Unread Posts
Tags
  • 12 Forums
  • 2,532 Topics
  • 11 K Posts
  • 43 Online
  • 2,418 Members
Our newest member: Chad Treadwell
Latest Post: Limited or no support from Acumatica?
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

  • Rafie Schwartz
Acumatica Forums

Terms of Use & Disclaimers :: Privacy Policy

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

‹›×

    ‹›×