Home » Categories » Solutions by Business Process » Stock Control and Batch Tracking |
Goods Returns - Update FIFO Cost Table |
Article Number: 84 | Rating: Unrated | Last Updated: Thu, Jun 22, 2023 at 11:34 PM
|
Datafile Software Goods Returns - Update FIFO Cost Table The Stock record contains a FIFO table which can be used for stock valuation purposes and records the last n goods receipts (where nis a value from 1 to 9). When goods are sold but then returned by the customer these ‘receipts’ did not update the FIFO table which, on items with highly variable costs, could result in a valuation which isn’t representative. Release 6.4 introduces a new option to allow goods returns to update the FIFO table. Installation System Profiles A new option has been added to the Stock System
Profiles to enable goods returns throughout the system to update the FIFO
table. To update select Installation from the main menu
followed by Application Manager, then System Profiles before selecting the Stock Control application. Update FIFO for Returns– if set then goods returns (i.e. credits) will update the FIFO table on the stock record for the returned stock. Notes When returning stock via credits in Sales Ledger and Invoicer or through ‘negative’ stock issues in Stock Control if the system is set to update the FIFO table the system will prompt for the cost price of the return. When returning stock via Goods Return Notes in Sales Order Processing or Assembly De-Kits in Bill of Materials the system will use the cost price recorded on the order detail (although you can configure a confirm item to amend this if required). |
Attachments
![]() There are no attachments for this article.
|
System Profiles - Batch Tracking
Viewed 3503 times since Tue, Jun 19, 2012
Document Design Manager - Parameters - Stock Control
Viewed 1646 times since Tue, Jun 19, 2012
Save Demand and Sales Values for Previous Years
Viewed 1284 times since Fri, Jul 8, 2016
Security and User Manager - Stock Control
Viewed 1524 times since Tue, Jun 19, 2012
Goods Received - Stock Control
Viewed 1547 times since Mon, Jun 18, 2012
Additional Options for the Print & Value Assemblies Report
Viewed 1557 times since Fri, Oct 26, 2012
Compact & Audit Database - Batch Tracking
Viewed 1465 times since Tue, Jun 19, 2012
Batch Enquiry - Batch Tracking
Viewed 1511 times since Wed, Jun 20, 2012
Cost / Sale Price Changes - Stock Control
Viewed 3881 times since Mon, Jun 18, 2012
Matrix Factors - Batch Tracking
Viewed 1442 times since Wed, Jun 20, 2012
|