INTERNET APPLICATION DEVELOPMENT
MID MARKET ERP DEVELOPMENT
Notice, there is a field called “Bucket Type.” It is only available for FIFO/LIFO items. You won’t have it in receipts and shipments because Sage 300 automatically generates new buckets for receipts, and in automatically selects which buckets to use in shipments. In Adjustments though, there is no way for the system to know which bucket we want to adjust. There are actually three options:
The Offset Bucket means you don’t know which bucket the adjustment should change, so you want to place the additional quantity (or cost), in a separate bucket, not linked to any receipt.
Specific Bucket allows you to select a specific receipt number that you want to adjust.
Prorate option prorates your adjustment to all existing buckets proportionately.
The offset bucket deserves a special mention. It is not stored in the ICCOST table, but rather in the ICILOC table. If you post a Quantity Increase adjustment for five, here is how the offset information looks in the database.
Sage 300 attempts to ship regular buckets first. If there is not enough quantity in the regular buckets, it ships whatever is in the offset bucket.