Re: Aged Inventory
"Simon Sherwood" <Simon-juV7kg0qJ37PydImBSVqg073wzpk4OL60Fzj8UutsXo@public.gmane.org>
| Newsgroups | gmane.comp.systems.as400.jbausers |
|---|---|
| Message-ID | <33F8A8E20B1E4C0AAD770D2459C28632@Simon> |
We developed a system based on the receipt dates and worked backwards until all of the stock was aged, like in an aged debt report. It was bespoke, but worked well and satisfied auditors. Simon Sherwood ----- Original Message ----- From: <[email protected]> To: "System 21 Users" <system21-Zwy7GipZuJhWk0Htik3J/[email protected]> Sent: Tuesday, May 20, 2008 5:11 PM Subject: Re: [SYSTEM21] Aged Inventory > Does anyone have to report inventory age by warehouse, part number and > receipt date? If so, how are you gathering the data? > > > > > > [email protected] > Sent by: system21-bounces-Zwy7GipZuJhWk0Htik3J/[email protected] > 05/13/2008 05:55 PM > Please respond to System 21 Users > > To: SYSTEM21-Zwy7GipZuJhWk0Htik3J/[email protected] > cc: > Subject: [SYSTEM21] Aged Inventory > > > For distribution order receipts, is there a way to get System 21 to > populate the original receipt date in inp83 in the receiving stockroom > (to) with the date the item was received in the issuing (from) stockroom ? > > Our inventory is a combination of STD and FIFO cost and we are using lot > control in version 3.5.1. The task at hand is to age our on hand > inventory by stockroom using the FIFO layers (because costs of the layers > can vary in a FIFO environment). But when it comes to distribution > orders, they want the date the original PO was received from the supplier > at the center for the network not the date the distribution order was > received into the DC supplied by the center. Anyone have any ideas on how > > that can be accomplished? > _______________________________________________ > This is the System 21 Users (SYSTEM21) mailing list > To post a message email: SYSTEM21-Zwy7GipZuJhWk0Htik3J/[email protected] > To subscribe, unsubscribe, or change list options, > visit: http://lists.midrange.com/mailman/listinfo/system21 > or email: SYSTEM21-request-Zwy7GipZuJhWk0Htik3J/[email protected] > Before posting, please take a moment to review the archives > at http://archive.midrange.com/system21. > > > _______________________________________________ > This is the System 21 Users (SYSTEM21) mailing list > To post a message email: SYSTEM21-Zwy7GipZuJhWk0Htik3J/[email protected] > To subscribe, unsubscribe, or change list options, > visit: http://lists.midrange.com/mailman/listinfo/system21 > or email: SYSTEM21-request-Zwy7GipZuJhWk0Htik3J/[email protected] > Before posting, please take a moment to review the archives > at http://archive.midrange.com/system21. > > > > > -- > No virus found in this incoming message. > Checked by AVG. > Version: 7.5.524 / Virus Database: 269.23.21/1457 - Release Date: > 20/05/2008 16:45 > > _______________________________________________ This is the System 21 Users (SYSTEM21) mailing list To post a message email: SYSTEM21-Zwy7GipZuJhWk0Htik3J/[email protected] To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/system21 or email: SYSTEM21-request-Zwy7GipZuJhWk0Htik3J/[email protected] Before posting, please take a moment to review the archives at http://archive.midrange.com/system21.