Welcome, Guest. Please Login.
05/11/25 at 11:59:21
News:
Home Help Search Login


Pages: 1
Send Topic Print
Reconcile Inventory Rounding Difference (Read 493 times)
rmh148
Member
**




Posts: 84
Reconcile Inventory Rounding Difference
12/01/05 at 08:14:33
 
It appear to me that one of the reasons that we are having rounding errors when you run SM-J-C is that the decimal precision in BKARINVI_B.BKAR_INVI_PCOGS is only 2 decimals.  This fields contains a per-unit-cogs-cost and should be 4 decimals to match the precision of the inventory transaction unit-cost.  
 
Additionally, quite some time ago I reported that the TOVAL on Type "N" items was being incremented and decremented. I do not believe that this has been fixed, yet.
Back to top
 
 
  IP Logged
rmh148
Member
**




Posts: 84
Re: Reconcile Inventory Rounding Difference
Reply #1 - 12/01/05 at 08:27:10
 
the previously reported incident was posted August 24, 2005.  Inventory Transaction Type "C" error.  It read,
"as part of the reconcilation of book value, I have discovered the reason that many Non-Inventory item's (item type "N") book value is wrong.  Non-inventory item, by nature should never have a book value in BKICMSTR.BKIC_PROD_TOTVL.  I have discovered that any time there is an inventory transaction type "C", $ Change, DBa is incrementing or decrementing the book value. "
Back to top
 
 
  IP Logged
Lynn_Pantic
Administrator
*****


evolution (n) -
gradual change to a
different form

Posts: 5663
Re: Reconcile Inventory Rounding Difference
Reply #2 - 12/01/05 at 09:22:26
 
SM-J-C does not look at the COGS in the Invoice files so I am not sure what you are referring to when you say it is causing rounding errors.  SM-J-C simply reconciles the inventory files to themselves in terms of total quantity and order status versus by Location.
 
As for the C transaction, what version are you on?  I just tested and a price change in AP-C does not touch the IN-A Book Value for type N part.  This is using the IS Tech 11/18 update.
Back to top
 
 

Lynn Pantic
IS Tech Support
lynn@istechsupport.com
Email   IP Logged
Pages: 1
Send Topic Print