Sage MAS 90 and 200 Product Update 7 (4.40.0.7)
Article Index
Page 6 of 15
Inventory Management
- On the Inventory Sales History Report, the Quantity Sold column for the Month the Sales Order Invoice was entered now reflects the negative Sales Order Invoice.
- In Physical Count Update, Count of Zero for Standard Cost and Tiered valuation methods The TotalWarehouseValue is now cleared.
- The Inventory Turnover Report’s calculation no captures all periods including the periods that don’t have any activity.
- Sales Journal Update for for a FIFO item when the shipped qty exceeds the Tier Qty is now clearing the CostCalcCostCommitted and CostCalcQtyCommitted fields.
- Quantity On Hand and Over/Short Variances no longer change when using Count Card Entry
- Serial numbers are now correctly updated when receiving multiple serialized items in Receipt type Transaction Entry.
- Lot/Serial valuations now correctly display the actual Receipt No. and Receipt date of the cost tier transferred.
- The Balance Qty on Hand utility now assigns correct TierType and TierGroup when the condition requires a new IM_ItemCost OVERDIST tier to be created.
- Inventory item Quantity on Sales Order is no longer incremented after adding cost code information to an existing sales order without changing line quantities
- The vendor item code is no longer removed when a different alias item code is deleted from alias item maintenance.
- A new utility is available to check your ItemWarehouse and ItemCost tables for orphaned CostCalcCostCommitted and CostCalcQtyCommitted fields. A comma separated value file is updated with a list of the items found and the values.
To verify if orphaned values, this utility should be run after all registers and updates have been completed. If run during a register print and update the values found may be valid.
To run the utility:
- Select File/Run
- Type syzcon
- Click Accept
- at the > prompt type run "IM_CommitCheck_utl
- press Enter key
A message with an OK button will appear with the location of the report when utility has completed. The default location of the report is found in ../home/textout/IM_CommitCheck001.csv. Every time the utility is run, the sequence number will increment by one, i.e. CommitCheck002.csv. If the report has entries listed for items please contact Customer Support.
The Inventory Detail Transaction Report Beginning Balance is now correct when a transaction has been posted to the future period/year while im options Base Inventory Periods On is set to Calendar.
Tags: Product Update v4.40