x Want to participate? Join the group to interact
Options
  • State Verified Answer
  • Replies 3 replies
  • Subscribers 104 subscribers
  • Views 909 views
  • Users 0 members are here
Browse Forums
Announcements
289
topics
370
replies
Business Object Interface
1k
topics
7k
replies
Core Financial Modules
2k
topics
8k
replies
Customization and Productivity
3k
topics
12k
replies
Distribution, Manufacturing, and Applications
2k
topics
7k
replies
General Discussion
1k
topics
3k
replies
Partner Cloud
43
topics
90
replies
Payroll, Time Tracking, and Job Cost
775
topics
1k
replies
Reporting and Analytics
960
topics
3k
replies
Sage CRM for Sage 100
164
topics
357
replies
Technical and Installation
2k
topics
9k
replies
Year-end Forum
89
topics
237
replies
JHsu

Landed Cost Not Allocating to All Items on a Receipt

SOLVED
Posted By

We did a goods receipt and entered freight via landed cost.  However, the entire amount of the freight was allocated to only one of the 3 items on the receipt.  We are set up to allocate based on weight.  All three items have a weight set up in the item master Main tab and the Allocate Landed Cost button checked on Additional tab.

Landed cost allocations appear to work on other receipts with multiple items - but for some reason these items are not working.  

Suggestions on where to look first?  Other settings or conditions that would cause this?

Thanks.

  • +1
    verified answer

    Did you add the weights to the items after the PO was created?  I believe the effective values are stored as line data in the PO. 

    (I seem to remember having to script custom logic for the weighting, and I think I used the line Weight values in the receipt to do that).

    Edit:

    Technically the item Weight field is text, so be sure the value is purely numeric because that can easily cause problems.

  • 0 in reply to Kevin M

    Yes, the weights were added before the PO was created.  We've run into the situation you describe after change item master values and needed to remove and re-add items to a PO to update.

    Would copying a PO from an old PO cause the issue due to stored values at the line item level?

    Also, the weight is fractional at 2.2046 since the UOMs are all in KG - does this create problems?  My understanding is weight is not tied to any UOM and is in Lbs.

    Thanks. 

  • 0 in reply to Kevin M

    Discovered the current PO was copied from a prior PO where those items had not been set up for freight allocation at the time.  Thanks.

*Community Hub is the new name for Sage City