Transaction Information - SIUPTR
This page places transactions directly into the SI database or modifies transactions without using the normal processing procedures.
Product ID: Enter the Product ID or use the Lookup function to select from the product database. The Product ID must have been previously defined in the Person/Entity Database (PE) Product Information (PEUPPR) page.
Warehouse: Select the code representing the warehouse where this product is stored. The warehouse codes in the drop list have been defined on the SI Warehouse Information (SIUPWH) page.
Quantity: This field displays the quantity of this product for this transaction.
Units: Select the unit of measure for this product and this transaction. Units displaying in the drop-down are defined in the Nucleus (NU) Common Codes (NUUPCD) page, with a Category/Value of PEUN/xxxxxxxx(Unit). However, the unit selected must be compatible with the one defined for the Product ID in the PE Product Information page.
Total Amount: This field displays the total dollar amount of the transaction. For example, if you receive five units of a product at a unit cost of $100, the total amount would be $500.
Total Cost: This field indicates the total cost of the item.
Type: Select the best option from the drop-down list describing the type of transaction as being a receiving transaction "RC" or a demand (Order Entry) transaction "DM".
Reference: This field allows you to enter the reference number associated with the item.
Item: This field allows you to enter the item number associated with this item.
Vendor/Customer: Enter the Vendor/Customer ID (also known as the PE ID) or select from the database using the Lookup function. The PE ID must have been previously defined in the PE Information (PEUPPE) page.
Description: Enter up to 30 characters that describe the transaction.
Second Ref: Enter up to 16 characters of additional information regarding the transaction.
Transaction Code: Select the drop-down list to define the transaction (for example, "CR" for Credit Return). Default codes are selected on SI General Information (SIUPGN) page. Transaction Codes are defined in NU Common Codes, with a Code Category/Value of SITR/XX.
Set/Order ID: Enter up to sixteen characters that uniquely identify the order ID or set of transactions.
Posting Code: A two-character code used to direct automatic posting to the general ledger. The system would have generated this code based upon the defined Posting Preference at the time the transaction was originally entered. Caution is advised in changing the Posting Code.
Misc: Enter up to four characters associated with the transaction.
Prep ID: Enter up to 12 characters that identify the preparer of the entry.
Stock Qty: This field (read-only in Add and Update modes) indicates the quantity of this product for this transaction as it is held in inventory. For example, if this transaction is for GALLONS, but the product is stored in inventory in QUARTS, the quantity displayed here will be shown in QUARTS.
In Stock Qty: The quantity remaining for a given receive (RC) transaction. Each time stock is received, the quantity in stock equals the stocked quantity. As the product is sold, the quantity in stock is decreased, allowing the system to track the FIFO value of the goods.
Unit Value: This field (read-only in Add and Update modes) indicates the per-unit value per the stocked unit of this transaction.
Unit Balance: This field indicates the remainder of the amount divided by the stock quantity.
Remaining Balance: This field (read-only in Add and Update modes) indicates the amount of the balance remaining. The remaining amount will be distributed among the last items issued from this lot, one penny at a time.
GL Job Number: The GL Job # may be up to ten characters and indicates the job number under which the GL postings were made.
SI Job Number: This field displays the job number produced when this transaction was originally created. A fictitious job number, such as "000000" or "999999", must be entered if this entry is being used to enter the transaction directly into the Stores/Inventory database. This field is only used when the product was defined to require use of a Lot Number on the PE Product Information page.
Sequence: This field (read-only in Add and Update modes) indicates a system-generated sequence number.
Reference Date: A system-generated field displaying the date of the original transaction involving the particular Product ID.
GL Post Date: This field displays the date the GL postings were made.
Update Date: This field (read-only in Add and Update modes) indicates the last date that this transaction was updated. This value is only updated on receive-type transactions.
Time: This is the system time (hour, minute, second) when the SI transaction was created.
Account: Select the general ledger account to which the cost of this product should be posted. Typically, this will be the inventory control account. If the Job Ledger (JL) module is used and this transaction relates to an account in the JL, enter a JL account number, and/or Work Order. For ease of use, the account string supports a variety of data entry methods, including the Quick and Fully Qualified Account methods, for both the GL Account and/or the JL Account. To look up a ledger code, account part (key, object, fund, etc.), or work order, place the cursor in the field and press Ctrl+L key combination or click on the ellipsis (…) button, and select Lookup xx where xx is the field where the cursor is placed.
Additionally, the account field display can be altered by selecting the following options:
XX Org Key-Object or Fully Qualified (where XX=ledger code): Select this option or press Ctrl+K to display the ledger's organization key and object code input format. Use Ctrl+U to display the fully qualified account string, as shown on page two.
XX Quick (where XX=ledger code): The Ctrl+Q option allows changes the display and the lookup to accommodate quick key entry for account numbers that have been defined in the General Ledger (GL) Quick Account Numbers (GLUPQU) page.
Show Ledger: Selecting this option displays the general ledger code field before the account string field.
Show Job Ledger Side: Selecting this option displays the JL side ledger code and account string field associated with the active general ledger.
Show Work Order: Selecting this option displays the Work Order field. Entries in this field will validate to existing orders defined in the Work Order module.
Percent: This field displays the percentage of the expense to be charged to this account. If only one account number is defined, the percentage must be 100.00. If multiple account numbers are defined, their percentages must total 100.00.