Home » Categories » Solutions by Business Process » Profiler |
Generate Stock Transactions (9909) |
Article Number: 1261 | Rating: Unrated | Last Updated: Tue, Jun 20, 2023 at 5:14 PM
|
Datafile Software Generate Stock Transactions (9909) This feature allows the update of stock values and the generation of transactions from Profiler screens. This could be used, for example, in a Sales Order Processing front-end allowing the update of stock reserved values. Within the screen design select ‘Parameters’ and the option ‘Extra File / Record Lookup and Updating’ followed by ‘Custom Points’. Set the option number ‘9909’ as the custom point number, leave the suffix blank and you will be prompted to change the ‘Link to Stock Control’ definition – respond ‘Yes’ to this. Database (1-8) for Stock File – set the database number, as listed within the Profiler applications location for files, for the Stock file. Database (1-8) for Stock Trans – set the database number for the Stock Transaction file. Transaction Type to be Written – set the transaction type (1-7) for the transaction to be generated. Transaction types allowed are:
STA First TX – set the data item number on the Stock file that holds the first transaction pointer. STA Last TX – set the data item number on the Stock file that holds the last transaction pointer. STA First Active – set the data item number on the Stock file that holds the first active transaction pointer (i.e. first transaction this period) STA On-Order – set the data item number on the Stock file that holds the on-order quantity STA Physical – set the data item number on the Stock file that holds the physical quantity STA Reserved – set the data item on the Stock file that holds the reserved quantity. STT TX Type – set the data item on the Transaction file that holds the transaction type STT Stock Code – set the data item on the Transaction file that holds the stock code STT Stock Record No – set the data item on the Transaction file that holds the record number of the main stock code STT Next TX – set the data item on the Transaction file that holds the next transaction pointer STT Quantity – set the data item on the Transaction file that holds the transaction quantity DFD Stock Code – set the data item on the main file (the database the screen is based on) that holds the Stock Code DFD On-Order Quantity – set the data item on the main file (if any) that the on-order quantity is to be updated by. In addition you must set whether changes in this item are to be added or subtracted from the Stock On-Order quantity. DFD Physical Quantity – set the data item on the main file (if any) that the physical quantity is to be updated by. In addition you must set whether changes in this item are to be added or subtracted from the Stock Physical quantity. DFD Reserved Quantity – set the data item on the main file (if any) that the reserved quantity is to be updated by. In addition you must set whether changes in this item are to be added or subtracted from the Stock Reserved quantity. DFD Transfer Stock-To – only applicable if screen to transfer stock, set the data item on the main file that holds the stock code being transferred to. DFD STT Quantity – set the data item on the main file to be used as the stock transaction quantity. DFD TX Type – if screen doesn’t generate a set transaction type (as set in header of this screen) the type can be selected from the main file. After confirming the stock link details you are then given a further parameter screen allowing a series of copy items from the main file, the profiler constant file or the stock file to the Stock Transactions.Typically you would need to copy the transaction date and any references to the STT from the main file. Notes When adding/updating the main file the Stock record is exclusively locked. Only one transaction is generated – i.e. if screen set to update physical and reserved then can only generate either the sales issue or reserved transaction not both. Forward period values are not supported – all transactions are current. If Sales Issue then Demand, Costs and Sales Values for period are not updated.Similarly if goods received FIFO details are not updated. |
Attachments
![]() There are no attachments for this article.
|
EDI Message Log File
Viewed 1496 times since Thu, Jul 5, 2012
User and Installer Help Memos
Viewed 1566 times since Mon, Jun 11, 2012
Sales Ledger Extra Items - EDI Order Processing
Viewed 1461 times since Thu, Jul 5, 2012
Stock/Product File Extra Items - EDI Order Processing
Viewed 1464 times since Thu, Jul 5, 2012
Forecast Dates - Additional Options
Viewed 2261 times since Fri, May 27, 2016
A3 Datafile Application Extra Data Items - EDI Order Processing
Viewed 1502 times since Thu, Jul 5, 2012
Alternate F8-Zoom Link Item
Viewed 1824 times since Fri, Oct 26, 2012
W - W.P. Facility
Viewed 1307 times since Fri, Jun 29, 2012
Configuration - Defining the Ledger Link
Viewed 1467 times since Fri, Jun 29, 2012
X – Custom Point (if applicable)
Viewed 773 times since Fri, Jun 29, 2012
|